musiccaps_details (view)
1 row where musiccaps_aspects contains "easygoing", musiccaps_names contains "Funk" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- brass melody 1
- chill 1
- easygoing · 1 ✖
- funky electric guitar chords 1
- groovy bass 1
- low quality 1
- passionate male vocals 1
- punchy kick 1
- reggae 1
- shimmering hi hats 1
- snappy snare 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Roots Reggae Mix | The low quality recording features a reggae song that consists of passionate male vocals singing over shimmering hi hats, snappy snare, punchy kick, groovy bass, brass melody and funky electric guitar chords. It sounds chill and easygoing. | 2009-01-22T20:42:39Z | lessofslack | A roots reggae mix with horace andy, meditations, congos max romeo, hugh mundell, king tubby! Enjoy Reggae Roots! THE PLAYLIST IS HERE!!!! 1.The Meditations - Rasta Shall Conquer(Greatest Hits 197X)--- 2. Dr Alimantado - Born For a Purpose 3.Dennis Brown - Black Liberation(Words Of Wisdom1979)--- 4.Max Romeo & The Upsetters - My Jamaican Collie(The Coming Of Jah 1967-76)--- 5.Horace Andy - If I(In The Light/In The Light Dub 1977)--- 6.Hugh Mundell - Jah Will Provide(Africa Must Be Free 1983)--- 7.i forgot - update in a few weeks--- 8.The Terrors - Assemble Not Thyself(The Chantells & Friends-Children Of Jah 1977-79)--- 9.Horace Andy - Do You Love My Music(In The Light/In The Light Dub 1977)--- Thanks to all supporters of good old Reggae Tunes! -peace- | ["Funk", "Music", "Reggae", "Song"] | ["low quality", "reggae", "passionate male vocals", "shimmering hi hats", "snappy snare", "groovy bass", "brass melody", "funky electric guitar chords", "punchy kick", "easygoing", "chill"] | 4 | L0-l1LIa22g | 2141 |
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;