musiccaps_details (view)
2 rows where musiccaps_aspects contains "clapping", musiccaps_names contains "Afrobeat" and musiccaps_names contains "Music of Africa"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- clapping · 2 ✖
- energetic 2
- groovy bass 2
- 4 on the floor kick 1
- addictive 1
- echoing male vocal 1
- exotic 1
- exotic steel pan melody 1
- groovy piano melody 1
- low quality 1
- mono 1
- punchy kick 1
- shimmering shaker 1
- synth flute melody 1
- synth keys melody 1
- tropical 1
- uptempo 1
- urban latin 1
- wide reverberant percussive elements 1
musiccaps_names (array) 4 ✖
- Afrobeat · 2 ✖
- Music 2
- Music of Africa · 2 ✖
- Electronic dance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
farmer Nappy- My House ( Steel Pan Instrumental) | The low quality recording features an instrumental cover that consists exotic steel pan melody, punchy kick hits layered with claps, groovy piano chord progression and groovy bass. It is in mono and it sounds a bit harsh, but energetic, tropical and exotic. | 2015-01-29T02:08:36Z | astra desuza | Noel La Pierre | ["Afrobeat", "Music of Africa", "Music", "Electronic dance music"] | ["low quality", "exotic steel pan melody", "punchy kick", "clapping", "groovy piano melody", "groovy bass", "tropical", "exotic", "energetic", "mono"] | 4 | GYCfrx0ruz4 | 1734 | |
Davido -Skelewu lyrics | The Urban Latin song features an echoing male vocal singing repetitive lyrics over wide reverberant percussive elements, synth flute melody, claps, "4 on the floor" kick pattern, shimmering shaker, groovy bass and synth keys melody. It is uptempo and it sounds energetic and addictive, like something you would hear in clubs a lot. | 2013-10-25T20:55:09Z | Tai Kenny | I DO NOT CLAIM TO OWN ANY OF THE AUDIO USED IN THIS VIDEO. NO COPYRIGHT INTENDED!!!! | ["Afrobeat", "Music of Africa", "Music"] | ["urban latin", "wide reverberant percussive elements", "echoing male vocal", "synth flute melody", "clapping", "4 on the floor kick", "shimmering shaker", "groovy bass", "synth keys melody", "uptempo", "energetic", "addictive"] | 4 | ax8hXst_b5g | 3588 |
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;