musiccaps_details (view)
4 rows where musiccaps_aspects contains "boomy", musiccaps_aspects contains "flat male vocal" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- boomy · 4 ✖
- flat male vocal · 4 ✖
- low quality 3
- muddy 2
- noisy 2
- 4 on the floor kick 1
- background male ad libs 1
- boomy bass 1
- bouncy snare 1
- easygoing 1
- groovy 1
- heavy bass 1
- hip hop 1
- mono 1
- organ keys 1
- poor mix 1
- punchy kick 1
- reggae 1
- reverberant vocal chant 1
- shimmering cymbals 1
- shimmering hi hats 1
- slap snare 1
- tinny percussive elements 1
- traditional 1
- tutorial 1
- uptempo 1
- weird funny repetitive percussion 1
- wide sustained synth lead 1
- wooden percussion 1
musiccaps_names (array) 13 ✖
- Music 2
- Afrobeat 1
- Drum 1
- Hammond organ 1
- Hip hop music 1
- Keyboard (musical) 1
- Music of Africa 1
- Organ 1
- Percussion 1
- Piano 1
- Reggae 1
- Rhythm and blues 1
- Tabla 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mridanga Lessons Pt. 4 | The low quality recording features a traditional song sung by flat male vocals over wooden, boomy percussion. The recording is in mono, a bit noisy and it sounds muddy, as the bass frequencies are overwhelming. | 2008-11-22T07:37:17Z | abhijitb1 | New Rhythm: Dha - Ge - Ti - Kha Na - Ge - Dhi - Na | ["Tabla", "Drum", "Percussion"] | ["low quality", "boomy", "wooden percussion", "flat male vocal", "noisy", "traditional", "muddy"] | 4 | 6PquRVe1Wa4 | 752 | |
Merciless - Dorothy - HQ High Quality - Reggae Music | The Reggae song features a flat male vocal rapping over shimmering cymbals, heavy bass, bouncy snare, wide sustained synth lead and "4 on the floor" kick pattern. Even though the song is uptempo, it sounds easygoing and like something you would listen to in a car, or while chilling. | 2011-06-14T09:41:48Z | PSiLOmusik | Merciless - Dorothy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Reggae Music Reggae Sound Best Reggae Raggae Track Free Reggae Free Reggae Party Reaggae raeggae ragge ragga jah rasta jah rastafahri jah rastafari jah rasta rastafari rasta man rastafahri music sound party hit hits ganjaman ganja smoke coffeeshop album soundsystem system France French Spanish Spain Jamaica Jamaican Kingston Town | ["Afrobeat", "Music of Africa", "Music", "Reggae"] | ["reggae", "boomy", "flat male vocal", "shimmering cymbals", "heavy bass", "bouncy snare", "wide sustained synth lead", "4 on the floor kick", "easygoing", "uptempo"] | 4 | C4-mZ1jGQ-E | 1325 | |
Learn FREE Gospel Organ Lessons Shouting Chords on Hammond B3 :: Gospel-Organ.com | The low quality recording features a tutorial on boomy organ keys narrated by flat male vocals. It is noisy and the recording is in mono. | 2006-10-04T18:10:16Z | Gospel Musicians | http://GospelMusicians.com/ FREE Gospel Organ Lessons Shouting Chords on the Hammond B3 | ["Organ", "Hammond organ", "Keyboard (musical)", "Piano"] | ["low quality", "flat male vocal", "tutorial", "organ keys", "mono", "boomy", "noisy"] | 4 | DU3Vlaa8rU0 | 1480 | |
Edo Maajka Feat Alejuandro Buendija - Boing | The low quality recording features a hip hop song that consists of flat male vocals, alongside background male ad libs, rapping over boomy bass, punchy kick, slap snare, shimmering hi hats, tinny percussive elements and weird, funny and repetitive percussion. It sounds groovy and boomy, but also muddy and poorly mixed. | 2009-03-24T12:32:06Z | interist89 | Edo Maajka Feat Alejuandro Buendija - Boing | ["Music", "Rhythm and blues", "Hip hop music"] | ["low quality", "hip hop", "reverberant vocal chant", "boomy bass", "punchy kick", "slap snare", "flat male vocal", "shimmering hi hats", "tinny percussive elements", "weird funny repetitive percussion", "groovy", "background male ad libs", "poor mix", "boomy", "muddy"] | 4 | GOujNXEtDmg | 1716 |
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;