musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance groove", musiccaps_aspects contains "fast tempo" and musiccaps_aspects contains "happy"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- cheerful 2
- dance groove · 2 ✖
- fast tempo · 2 ✖
- happy · 2 ✖
- afro beats 1
- akuba 1
- animated trumpets 1
- bright drumming 1
- carefree 1
- catchy 1
- cheerful drumming 1
- clave 1
- conga 1
- congas 1
- dance music 1
- dominant music 1
- festivities 1
- foreign language 1
- funky bass lines 1
- funky basslines 1
- harmonica 1
- inspirational 1
- joyful 1
- lively keyboard harmony 1
- male singer 1
- male vocals 1
- merry 1
- nigerian music 1
- party song 1
- party whistle 1
- pleasant 1
- plethora of instruments 1
- portugal 1
- propulsive percussion 1
- reflective 1
- reggae 1
- salsa 1
- spirited drumming 1
- tambourine beat 1
- trumpets animated trumpet 1
- ugandan song 1
- upstroke rhythm guitar 1
- vocal backup 1
- vocalisation 1
- world music 1
- youthful 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hora Quente com Vencedores Conc. Inter. Kizomba Angola 2012 | A male vocalist sings this high spirited Portugal song. The tempo is fast with keyboard harmony, punchy drumming, groovy bass lines, animated trumpets, backed with harmonica, party whistles, lively vocalisation and vocal backup, tambourine beats and congas. This song is a sonic treat with a plethora of instruments in perfect sync and harmony. It is happy, joyful and merry with a dance groove. | 2012-04-21T00:28:34Z | Samir Gomes | Hora Quente | ["Music of Africa", "Music", "Rattle (instrument)"] | ["male vocals", "fast tempo", "cheerful", "cheerful drumming", "funky basslines", "animated trumpets", "harmonica", "plethora of instruments", "congas", "dance groove", "party song", "festivities", "happy", "joyful", "merry", "tambourine beat", "congas", "party whistle", "trumpets animated trumpet", "vocalisation", "vocal backup", "portugal", "dance music", "salsa", "spirited drumming", "funky bass lines", "lively keyboard harmony"] | 7 | FDO5BekX478 | 1624 | |
Sitya Loss Remix - Eddy Kenzo | A male vocalist sings this energetic Nigerian song. The tempo is fast and upbeat with keyboard harmony and Afro beats of conga, clave, drums and akuba. The music is upbeat, catchy, spirited, energetic, youthful and pulsating with a dance groove. This song is a Reggae song. | 2014-02-20T13:25:19Z | Eddy Kenzo | big talent young managment | ["Afrobeat", "Music of Africa", "Music", "Dance music"] | ["male singer", "fast tempo", "nigerian music", "world music", "propulsive percussion", "upstroke rhythm guitar", "dominant music", "pleasant", "catchy", "youthful", "dance groove", "happy", "cheerful", "carefree", "conga", "clave", "akuba", "bright drumming", "reggae", "ugandan song", "foreign language", "afro beats", "reggae", "inspirational", "reflective"] | 7 | Xaq-segSEsQ | 3200 |
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;