musiccaps_details (view)
3 rows where musiccaps_aspects contains "flat female vocal" and musiccaps_aspects contains "groovy bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- flat female vocal · 3 ✖
- groovy bass · 3 ✖
- energetic 2
- low quality 2
- 4 on the floor kick 1
- baby goat bleating sound effect 1
- bagpipe melody 1
- claps 1
- drum roll 1
- folk 1
- fun 1
- groovy 1
- groovy acoustic rhythm guitar 1
- groovy piano melody 1
- happy 1
- harmonized male vocals 1
- live performance 1
- muffled drums 1
- offbeat shimmering open hats 1
- offbeat synth keys chords 1
- pop 1
- regional mexican 1
- short strings licks 1
- uptempo 1
- wide acoustic guitar chords 1
- wide background harmonizing vocals 1
- wooden percussive elements 1
musiccaps_names (array) 9 ✖
- Music 3
- Afrobeat 1
- Dance music 1
- Disco 1
- Goat 1
- Middle Eastern music 1
- Pop music 1
- Rhythm and blues 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Khin Su Su Naing အားလံုးေငးေမာသြားမယ္ From Water Party 3 | The Pop song features a flat female vocal, supported by wide harmonizing background vocals, singing over groovy acoustic rhythm guitar, offbeat shimmering open hats, claps, offbeat synth keys chords and a simple "4 on the floor" kick pattern that perfectly complements the groovy bass. Sounds energetic and uptempo, like something you would hear in clubs, or on a radio. | 2015-03-25T11:27:51Z | kaw thaung thar | From Water Party 3 | ["Afrobeat", "Disco", "Music", "Pop music", "Rhythm and blues", "Dance music"] | ["pop", "4 on the floor kick", "offbeat synth keys chords", "groovy bass", "claps", "offbeat shimmering open hats", "flat female vocal", "wide background harmonizing vocals", "groovy acoustic rhythm guitar", "uptempo", "energetic"] | 4 | 1PKxdTlquCA | 266 | |
حفل الدوحه | " نجوى كرم" عم يرجف | The low quality recording features a live performance of a folk song that consists of flat female vocals, harmonizing low male vocals, muffled drums, some wooden percussive elements, groovy bass and short strings licks. It sounds energetic and groovy, but the drums are really poorly recorded. | 2010-12-28T01:13:19Z | Tn7Tv1 | ["Singing", "Music", "Middle Eastern music"] | ["low quality", "live performance", "folk", "short strings licks", "muffled drums", "harmonized male vocals", "flat female vocal", "groovy bass", "groovy", "energetic", "wooden percussive elements"] | 4 | Grtmre_r9yI | 1757 | ||
Parto de un cabra murciana|MrSaravillo|. | The low quality recording features a baby goat bleating sound effects and regional Mexican song, that consists of wide acoustic guitar chords, groovy piano melody, drum roll, bagpipe melody and groovy, playing in the background. It sounds fun and happy and it seems like it is some kind of animal related TV show. | 2013-03-29T17:31:44Z | Mr Saravillo | Os invitamos a ver cómo pare una cabra en la cuadra del Queso de Saravillo. Cabritos para el Queso de Saravillo. www.quesodesaravillo.com info@quesodesaravillo.com | ["Goat", "Music"] | ["baby goat bleating sound effect", "regional mexican", "wide acoustic guitar chords", "groovy bass", "drum roll", "bagpipe melody", "flat female vocal", "groovy piano melody", "fun", "happy", "low quality"] | 4 | hTNKYJ6suII | 4108 |
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;