musiccaps_details (view)
3 rows where musiccaps_aspects contains "congas" and musiccaps_names contains "Rattle (instrument)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- congas · 3 ✖
- bongos 2
- cheerful 2
- happy 2
- acordion melody 1
- acoustic drums 1
- acoustic guitar accompaniment 1
- amateur recording 1
- animated trumpets 1
- celebratory 1
- cheerful drumming 1
- classic latin songs 1
- dance groove 1
- dance music 1
- djembe 1
- e-guitar 1
- fast tempo 1
- female singer 1
- festivities 1
- foreign language 1
- funky bass lines 1
- funky basslines 1
- guiro 1
- harmonica 1
- joyful 1
- latin folk songs 1
- latin music 1
- latin percussions 1
- lively 1
- lively keyboard harmony 1
- male backup 1
- male vocals 1
- medium tempo 1
- medium to uptempo 1
- merry 1
- muddled audio 1
- party song 1
- party whistle 1
- plethora of instruments 1
- portugal 1
- reggae 1
- salsa 1
- shaker 1
- simple 1
- spanish music 1
- spirited 1
- spirited drumming 1
- steady bass line 1
- tambourine beat 1
- trumpets animated trumpet 1
- vocal backup 1
- vocalisation 1
- world music 1
musiccaps_names (array) 6 ✖
- Music 3
- Rattle (instrument) · 3 ✖
- Christian music 1
- Christmas music 1
- Music of Africa 1
- Percussion 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
reggae.avi | People are playing the same groove on a lot of percussive instruments. In the background you can hear shakers. Someone is strumming chords with an effect on an e-guitar and someone is playing fill-ins on acoustic drums. This song may be playing at a local live concert from a music school. | 2010-09-10T18:11:18Z | pchedy | Primer contacto en la composicion de un reggae de la escuela de percusion de Santa Ursula bajo la direccion de Chedy Perera | ["Music", "Rattle (instrument)", "Percussion"] | ["amateur recording", "reggae", "shaker", "bongos", "djembe", "congas", "bongos", "acoustic drums", "e-guitar", "medium to uptempo"] | 6 | 9Tl2l3bsLpE | 1011 | |
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 | |
LLEGO DICIEMBRE CON SU ALEGRIA | A female vocalist sings this classic Spanish song. The tempo is medium with a lively accordion harmony, guiro , congas and bongos rhythm, steady bass line, and acoustic guitar accompaniment. The music is simple, light, happy, joyful, cheerful, celebratory and spirited with vocal backup.There are sounds of people cheering in the background. This is a Classic Latin Folk Song. | 2012-12-02T02:33:13Z | max pardo | LLEGO DICIEMBRE | ["Christmas music", "Christian music", "Music", "Rattle (instrument)"] | ["female singer", "medium tempo", "cheerful", "happy", "spirited", "celebratory", "simple", "classic latin songs", "lively", "latin folk songs", "latin percussions", "latin music", "spanish music", "guiro", "acordion melody", "foreign language", "world music", "congas", "bongos", "acoustic guitar accompaniment", "steady bass line", "male backup", "muddled audio"] | 7 | wQN7fRaPl2A | 5264 |
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;