musiccaps_details (view)
11 rows where musiccaps_aspects contains "groovy bass", musiccaps_author = 4 and musiccaps_names contains "Reggae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| KAF MALBAR & DJ JIZZY Ils veulent ma peau MADA VOICE SOUND PRODUCTION PSK MUSIC | The low quality recording features an afrobeats song that consists flat male vocal, alongside wide harmonizing male vocals, rapping over sustained synth lead melody, short synth melody, groovy bass, soft kick hits, punchy snare, shimmering shakers and syncopated toms. The mix is bad, thus it sounds kind of unprofessional, but still energetic. | 2009-06-02T21:02:37Z | Mada Voice | KAF MALBAR & DJ JIZZY Ils veulent ma peau REUNION MARTINIQUE CONNEXION MADA VOICE SOUND SYSTEM LE CHAUDRON CITE COWBOY ST DENIS LE PORT ST PIERRE ST ANDRE DMX PROD REUNION MARTINIQUE CONNEXION DJ JIZZY & PSK PROD | ["Music of Africa", "Music", "Reggae", "Exciting music"] | ["afrobeats", "low quality", "shimmering shakers", "syncopated toms", "sustained synth lead melody", "short synth melody", "groovy bass", "flat male vocal", "harmonizing wide male vocals", "punchy snare", "soft kick hits", "energetic"] | 4 | 71KE7B1vvdI | 803 | |
| 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 | |
| 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 | ||
| danger in your eyes riddim dj divinity | The low quality recording features a reggae song that consists of a flat male vocal, alongside harmonizing background male vocals, singing over shimmering shakers, offbeat piano chords, brass melody, wide toms, tinny echoing snare and punchy kick layered with it. It sounds upbeat and easygoing. | 2010-09-15T14:18:53Z | Big Poppa Funko AKA DJ Divinity | pure chunage is all i'm gona say, by these reggae legends https://twitter.com/deejaydivinity https://www.facebook.com/pages/DJ-divinity/161626630517139 download link below https://soundcloud.com/lee-divinity-neal/danger-in-your-eyes-riddim-dj | ["Music", "Reggae", "Maraca"] | ["low quality", "harmonizing background male vocal", "groovy bass", "brass melody", "offbeat piano chords", "shimmering shakers", "wide toms", "tinny echoing snare", "punchy kick", "flat male vocal", "upbeat", "easygoing"] | 4 | cOsm3r-xKEE | 3703 | |
| Bilog na naman ang Buwan | The Reggae song features harmonizing male vocals singing over wooden percussion, punchy snare and kick hits, claps, groovy bass, offbeat piano chords, followed by flat male vocals. It sounds energetic, happy, fun, groovy and funky. | 2007-08-15T07:41:19Z | convoyfollowsiyot | adik sa ganja reggae man | ["Music", "Reggae"] | ["reggae", "wooden percussions", "punchy snare", "claps", "punchy kick", "groovy bass", "offbeat piano chords", "harmonizing male vocals", "flat male vocal", "energetic", "groovy", "funky", "happy", "fun"] | 4 | gz-4W-uEzhc | 4071 | |
| Vandal - Mr Politician (Kaotik 02) | The low quality recording features a reggae song that consists of flat male vocals, alongside filtered, echoing male vocal and doubling background vocals, singing over punchy kick and snare hits, energetic crash cymbals, tinny wooden percussions, groovy bass and synth keys chords. It sounds energetic, as it is upbeat and addictive, thanks to the cadence. | 2011-05-10T11:54:19Z | Vandal Kaotik UK | New track by VANDAL, part of the mighty Kaotik Soundsystem. Ragga Hardtek Available on vinyl on Kaotik 02 in June | ["Music", "Reggae"] | ["low quality", "reggae", "upbeat", "synth keys chords", "punchy snare", "punchy kick", "tinny wooden percussions", "filtered echoing male vocal", "flat male vocal", "doubling background male vocal", "groovy bass", "energetic crash cymbal", "echoing pitch bend riser", "energetic", "addictive"] | 4 | r5xTmK2Fq1w | 4850 | |
| D.B. - Limit (Keinerechte / KR003) | The Electro song features a harmonizing passionate male vocals, with widely spread and dynamic echo effect on it, singing over groovy bass, groovy piano chords, synth keys and filtered "4 on the floor" kick pattern. It sounds exciting, easygoing and addictive - like something you would hear in a DJ set as a warm up. | 2011-08-09T10:08:55Z | Keinerechte | Vinyl Only! Audio is only 128 kBit/s | ["Music", "Reggae"] | ["electro", "groovy piano chords", "synth keys", "wide echoing effect", "harmonizing passionate male vocals", "groovy bass", "filtered \"4 on the floor\" kick pattern", "easygoing", "exciting", "addictive"] | 4 | sIItIq_W3eE | 4940 | |
| who let the dog sound | The low quality recording features an electro song that consists of flat male vocals, alongside widely spread male barking onomatopoeia, singing over shimmering shakers, sizzling triangle, tinny cowbell, punchy kick, punchy snare and groovy bass. It sounds energetic and addictive, even though it is a bit repetitive. | 2009-04-24T18:13:35Z | kaustubh18tyagi | who let the dog sound | ["Music of Africa", "Music", "Reggae"] | ["low quality", "electro", "punchy snare", "punchy kick", "groovy bass", "flat male vocal", "male barking onomatopoeia", "shimmering shakers", "sizzling triangle", "tinny cowbell", "energetic", "addictive", "repetitive"] | 4 | sZuhztdaFYA | 4961 | |
| 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 | |
| ~Lord of the Rings Parody~ ~Truth or Dare~ | The low quality recording features a flat male lead vocal, alongside harmonizing background vocals, singing over, staccato background vocals, groovy bass, wooden percussion, shimmering shakers and "4 on the floor" kick pattern. At the very end of the loop, there is a dark arpeggiated bell melody. Overall, it sounds happy and fun. | 2006-10-18T00:36:05Z | Jacinta12 | Parody. I mixed it but i DID NOT make the video. | ["Music", "Reggae"] | ["low quality", "harmonizing background vocals", "staccato background vocals", "groovy bass", "wooden percussion", "flat male lead vocal", "shimmering shakers", "4 on the floor kick pattern", "dark arpeggiated bells", "happy", "fun"] | 4 | vNZ3JS1LjDc | 5177 | |
| Echo Sound System - Echo Sound (None A Jah Jah Children Riddim) | The low quality recording features a reggae song that consists of wide harmonizing low male vocals singing over groovy bass, muffled snare, shimmering hi hats, tinny percussive elements and offbeat piano chords. The recording is noisy and it sounds easygoing and chill. | 2009-06-18T03:20:15Z | Voxcesar Selektah | Album:Tempo Vai Dizer, Artist: Echo Sound System & General Smiley Year: 2005 , Label: Phantom , Tracks: 21 | ["Echo", "Music", "Reggae"] | ["reggae", "low quality", "wide harmonizing low male vocals", "offbeat piano chords", "groovy bass", "muffled snare", "tinny percussive elements", "shimmering hi hats", "noisy", "easygoing", "chill"] | 4 | yVWk3yq3Abc | 5415 |
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;