musiccaps_details (view)
1 row where musiccaps_aspects contains "filter modulated acid synth bass", musiccaps_aspects contains "mono", musiccaps_names contains "Music" and musiccaps_names contains "Speech"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Kayak Trip - Kayaking Killarney, Georgian Bay, Canada | The low quality recording features a filter modulated synth bass, after which there is a short snippet of flat male vocals talking over sea waves sounds in the background. The recording is mono and noisy. | 2008-08-07T18:10:53Z | 3ringstudios | This is a video of our kayak trip in the Fox Islands near Killarney Canada. This is on the northern tip of Georgian Bay, north of Manitoulin Island. Check out the various rock formations caused by millions of years of erosion. I had the best day of my life on this trip.... Music by Alpinestars - "Burning Up". | ["Didgeridoo", "Music", "Speech"] | ["low quality", "noisy", "mono", "flat male vocal", "sea waves sound", "filter modulated acid synth bass"] | 4 | bPYbRSI16IY | 3623 |
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;