musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "uptempo", musiccaps_author = 6 and musiccaps_names contains "Swing music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- acoustic drums 2
- e-bass 2
- uptempo · 2 ✖
- acoustic guitars 1
- e-guitar 1
- higher register 1
- male backing voices 1
- male voice singing 1
- male voice singing/rapping 1
- rock&roll/blues 1
- shaker 1
- ska 1
musiccaps_names (array) 8 ✖
- Music 2
- Ska 2
- Swing music · 2 ✖
- Funk 1
- Music of Africa 1
- Music of Latin America 1
- Rock and roll 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DEUX ZACH SKA SKA apres une histoir vrais ... | This song sounds lightly uplifting. An e-bass is playing a repeating melody along with a guitar playing an almost melody at a higher key. Another acoustic guitar is strumming chords. The male voice is singing almost rapping/talking while backing voices are singing repeating the melody and phrases. This song may be playing outside on a bike on a sunny day. | 2010-08-06T23:42:32Z | zach deux | ["Swing music", "Music of Africa", "Funk", "Music", "Ska", "Music of Latin America"] | ["ska", "acoustic guitars", "shaker", "e-bass", "acoustic drums", "male voice singing/rapping", "male backing voices", "uptempo"] | 6 | 0OYlHvyfNk4 | 158 | ||
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;