musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "4 on the floor kick" and musiccaps_names contains "Afrobeat" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 22 ✖
- 4 on the floor kick · 2 ✖
- groovy bass 2
- accordion melody 1
- addictive 1
- claps 1
- energetic 1
- energetic open hats 1
- flat echoing male vocal 1
- flat female vocal 1
- folk 1
- groovy acoustic rhythm guitar 1
- low quality 1
- offbeat electric guitar chords 1
- offbeat shimmering open hats 1
- offbeat synth keys chords 1
- percussive elements 1
- pop 1
- shimmering shakers 1
- uplifting 1
- uptempo 1
- wide background harmonizing vocals 1
- wide piano chords 1
musiccaps_names (array) 9 ✖
- Afrobeat · 2 ✖
- Music 2
- Dance music 1
- Disco 1
- Music of Africa 1
- Pop music 1
- Reggae 1
- Rhythm and blues 1
- Salsa music 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 | ||
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 |
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;