musiccaps_details (view)
1 row where musiccaps_aspects contains "camera shuttering sound effect", musiccaps_aspects contains "energetic", musiccaps_author = 4 and musiccaps_names contains "Saxophone"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Making the Mclaren P1 - Lego StopMotion | The low quality recording features some camera shuttering sound effects and a jazz song playing in the background. The song consists of a cool saxophone solo melody over groovy bass, easygoing electric guitar chords in the left channel of the stereo image and energetic drums. It sounds easygoing and energetic at the same time. | 2015-09-03T19:10:35Z | Eton | Used 5042 Pictures! *21 FPS Thanks for Watching! Music _ Get Back(Youtube Audio library) | ["Brass instrument", "Saxophone"] | ["low quality", "camera shuttering sound effect", "jazz", "energetic drums", "groovy bass", "easygoing electric guitar chords", "cool saxophone solo melody", "easygoing", "energetic"] | 4 | eSsadT6mh7g | 3864 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;