musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance groove", musiccaps_aspects contains "vocalisation" and musiccaps_names contains "Music of Africa"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- dance groove · 2 ✖
- dance music 2
- fast tempo 2
- vocalisation · 2 ✖
- alternative hip-hop 1
- animated trumpets 1
- buoyant 1
- catchy 1
- cheerful 1
- cheerful drumming 1
- club music 1
- congas 1
- dance pop 1
- dj 1
- dj mixer 1
- festivities 1
- funky 1
- funky bass lines 1
- funky basslines 1
- groovy 1
- happy 1
- harmonica 1
- hip-hop 1
- hip-hop hits 1
- infectious drumming 1
- interactive 1
- joyful 1
- keyboard harmony 1
- lively backup vocals 1
- lively keyboard harmony 1
- male singer 1
- male vocals 1
- merry 1
- minimalist instrumentation 1
- party song 1
- party whistle 1
- peppy 1
- perky 1
- plethora of instruments 1
- portugal 1
- punchy 1
- rap 1
- reggae fusion 1
- salsa 1
- spirited drumming 1
- tambourine beat 1
- trumpets animated trumpet 1
- upbeat 1
- vocal backup 1
musiccaps_names (array) 5 ✖
- Music 2
- Music of Africa · 2 ✖
- Afrobeat 1
- Exciting music 1
- Rattle (instrument) 1
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 | |
K'Naan ABC's | Male vocalist sings this upbeat Hip-Hop song. The tempo is fast with minimal instrumentation of a lively infectious, punchy drumming and enthusiastic vocal backup and incessant, vigorous vocalisation. The song is buoyant, catchy, punchy, funky, youthful,groovy, engaging, vibrant and vivacious. This song is contemporary Hip-Hop/Rap. | 2009-01-23T20:28:16Z | K'naan Warsame | The new video for "ABC's" from K'NAAN's upcoming release "Troubador"; featuring Chubb Rock | ["Afrobeat", "Music of Africa", "Music", "Exciting music"] | ["male singer", "lively backup vocals", "alternative hip-hop", "reggae fusion", "interactive", "vocalisation", "fast tempo", "infectious drumming", "keyboard harmony", "hip-hop", "rap", "hip-hop hits", "minimalist instrumentation", "upbeat", "catchy", "buoyant", "punchy", "peppy", "perky", "dj", "dj mixer", "dance pop", "dance music", "dance groove", "club music", "groovy", "funky"] | 7 | Ovk5EfFj7Ws | 2482 |
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;