musiccaps_details (view)
1 row where musiccaps_aspects contains "palm muted electric guitar" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Jazz Funk - The Scratch - Surface Noise | The clip is an upbeat, groovy funk song with jazzy elements. The retro vintage electric piano chords add an old school jazzy feel to the song. The bassline is intricate and bouncy and enables easy dancing. | 2011-06-30T21:59:36Z | Herecomesmongo79 | The Scratch - Surface Noise - 1980 | ["Jazz", "Music"] | ["funk", "jazzy funk", "groovy bassline", "upbeat", "dance", "fun", "vibrant brass melody", "palm muted electric guitar", "rhythmic groovy drumline", "disco funk", "retro electric piano"] | 3 | TPYNIc_M1ng | 2835 |
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;