musiccaps_details (view)
3 rows where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "punchy snare" and musiccaps_aspects contains "shimmering shakers"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- energetic 3
- flat male vocal · 3 ✖
- punchy snare · 3 ✖
- shimmering shakers · 3 ✖
- groovy bass 2
- low quality 2
- sizzling triangle 2
- acoustic rhythm guitar 1
- addictive 1
- afrobeats 1
- disco 1
- electro 1
- exciting 1
- fun 1
- groovy bass guitar 1
- harmonizing wide male vocals 1
- male barking onomatopoeia 1
- punchy kick 1
- repetitive 1
- short synth melody 1
- simple kick patter 1
- soft kick hits 1
- sustained synth lead melody 1
- syncopated toms 1
- tinny cowbell 1
- wide electric guitar chord progression 1
- wide tinny percussive elements 1
musiccaps_names (array) 7 ✖
- Music 3
- Music of Africa 2
- Reggae 2
- /m/05zppz 1
- Disco 1
- Exciting music 1
- Rhythm and blues 1
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 | |
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 | |
70´s Music Disco Samba Two man sound | The Disco song features a widely spread electric guitar chord progression, acoustic rhythm guitar, shimmering shakers, tinny percussive elements, followed by simple kick pattern, punchy snare and groovy bass guitar, over which sings the flat male vocal. It sounds energetic, fun and exciting, as it is something you would definitely hear in clubs during 70s and 80s. | 2010-07-19T01:10:27Z | StarsMoon14 | ["Disco", "Music", "/m/05zppz", "Rhythm and blues"] | ["disco", "wide electric guitar chord progression", "acoustic rhythm guitar", "shimmering shakers", "simple kick patter", "punchy snare", "groovy bass guitar", "wide tinny percussive elements", "sizzling triangle", "flat male vocal", "fun", "exciting", "energetic"] | 4 | wZopmfXTtxw | 5275 |
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;