musiccaps_details (view)
1 row where musiccaps_author = 6, musiccaps_names contains "Rock music" and musiccaps_names contains "Swing music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
THE SIMS 4 BLUES OFFICIAL SOUNDTRACK - ALL BLUES MUSIC + DOWNLOAD LINK | This song contains acoustic drums holding a steady groove with a complex fill in at the end of the phrase. An e-bass and e-guitar are playing the same notes, just the e-guitar is strumming a chord. The male voice is singing loud and in a higher register. This song may be playing in a garage workshop. | 2015-02-03T00:36:16Z | MrZillaBR | DOWNLOAD MUSIC: https://onedrive.live.com/redir?resid=1DDADEE1D681434%21110 List: Nooboo Neeb - Amber Revival 00:07 Cell Hafta no Hast - Ben Ward 04:42 Gee Manray - Blind Snorty Warhouse 07:18 High Headed Woman - Captive 10:48 That Evil - Cys Matters 14:12 I'm Gone - Luther LeCriox 17:54 Main Theme: https://www.youtube.com/watch?v=wlxOygk8Beo&feature=youtu.be Electronic: https://www.youtube.com/watch?v=gbMaV6eJxe4&feature=youtu.be Pop: https://www.youtube.com/watch?v=KyURzKwzkiY&feature=youtu.be Romance: https://www.youtube.com/watch?v=mAY8QQKDTYI&feature=youtu.be Alternative: https://www.youtube.com/watch?v=niAvySwjk3g&feature=youtu.be Blues: https://www.youtube.com/watch?v=C7WAx3n57Hk&feature=youtu.be Classic: Spooky: | ["Swing music", "Music", "Rock music", "Ska", "Rock and roll"] | ["rock&roll/blues", "e-guitar", "e-bass", "acoustic drums", "male voice singing", "higher register", "uptempo"] | 6 | C7WAx3n57Hk | 1334 |
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;