musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "low quality" and musiccaps_names contains "Reggae" sorted by musiccaps_names
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 31 ✖
- groovy bass 3
- low quality · 3 ✖
- punchy kick 2
- reggae 2
- 4 on the floor kick 1
- accordion melody 1
- addictive 1
- bouncy wooden percussions 1
- brass melody 1
- chill 1
- claps 1
- easygoing 1
- echoing brass melody 1
- energetic 1
- energetic open hats 1
- flat echoing male vocal 1
- folk 1
- fun 1
- funky electric guitar chords 1
- happy 1
- offbeat electric guitar chords 1
- offbeat wide electric guitar chords 1
- passionate male vocal 1
- passionate male vocals 1
- percussive elements 1
- punchy snare 1
- shimmering hi hats 1
- shimmering shakers 1
- snappy snare 1
- uplifting 1
- wide piano chords 1
musiccaps_names (array) 7 ✖
- Music 3
- Reggae · 3 ✖
- Afrobeat 1
- Funk 1
- Music of Africa 1
- Salsa music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
villa maipu en bus | The Folk song features a flat, echoing male vocal talking over addictive accordion melody, wide piano chords, groovy bass, "4 on the floor" kick pattern, tinny percussive elements, energetic open hats, shimmering shakers and offbeat electric guitar chords. It sounds uplifting and low quality. | 2009-12-20T01:34:44Z | 14Juampa | ["Afrobeat", "Music of Africa", "Music", "Reggae", "Salsa music"] | ["folk", "flat echoing male vocal", "accordion melody", "wide piano chords", "groovy bass", "4 on the floor kick", "percussive elements", "shimmering shakers", "energetic open hats", "offbeat electric guitar chords", "uplifting", "addictive", "low quality"] | 4 | b4FomUpNaJE | 3600 | ||
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 | |
Pinoy Reggae | The low quality recording features a reggae song that consists of passionate male vocal singing over offbeat, widely spread guitar chords, groovy bass, punchy kick hits, punchy snare hits layered with claps, bouncy wooden percussions and echoing brass melody. It gives off happy and fun vibes - as every reggae song should. | 2013-09-18T04:27:38Z | j baunsit | Basilyo,Brownman Revival,The Youth,The Weeddz,Enchi | ["Music", "Reggae"] | ["low quality", "reggae", "passionate male vocal", "offbeat wide electric guitar chords", "groovy bass", "punchy kick", "punchy snare", "claps", "bouncy wooden percussions", "echoing brass melody", "energetic", "happy", "fun"] | 4 | v1EDTMRmJlY | 5147 |
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;