musiccaps_details (view)
5 rows where musiccaps_aspects contains "salsa", musiccaps_author = 7 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 93 ✖
- salsa · 5 ✖
- bachata 4
- congas 4
- latin dance music 4
- bongos 3
- fast tempo 3
- male vocalist 3
- congas rhythm 2
- dance groove 2
- dance hits 2
- dance music 2
- energetic 2
- happy 2
- keyboard harmony 2
- latin percussion 2
- latin song 2
- spirited 2
- upbeat 2
- vocal backup 2
- youthful 2
- animated trumpets 1
- bongos beat 1
- bright steel drumming 1
- buoyant 1
- catchy 1
- catchybeat 1
- celebration 1
- cheerful 1
- cheerful drumming 1
- cheering 1
- clinking 1
- club music 1
- cymbal ride 1
- enthusiastic 1
- enthusiastic vocals 1
- festivities 1
- funky bass lines 1
- funky basslines 1
- groovy 1
- groovy bass lines 1
- guiro 1
- harmonica 1
- joyful 1
- lain pop 1
- latin hits 1
- latin influence 1
- latin music 1
- latin pop 1
- latin urbano 1
- lively 1
- lively keyboard harmony 1
- loud siren like sound 1
- loud sound superimposed on song 1
- low audio quality 1
- male singer 1
- male vocals 1
- medium fast 1
- medium tempo 1
- melodic 1
- merry 1
- mexican 1
- muddled audio 1
- noisy background 1
- pandeireta beats 1
- party music 1
- party song 1
- party whistle 1
- passionate 1
- people talking 1
- plethora of instruments 1
- portugal 1
- punchy 1
- rhythmic bongos 1
- rhythmic spanish guitar 1
- rumba 1
- scuffling 1
- shakers 1
- siren 1
- spanish 1
- spanish guitar 1
- spanish music 1
- spirited drumming 1
- steady bass lines 1
- steady beat 1
- super imposing background 1
- syncopated piano 1
- synthesiser arrangements 1
- tambourine beat 1
- tapping sound 1
- trumpets 1
- trumpets animated trumpet 1
- vocalisation 1
- world music 1
musiccaps_names (array) 7 ✖
- Music · 5 ✖
- Music of Latin America 3
- Salsa music 3
- Flamenco 1
- Music of Africa 1
- Rattle (instrument) 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SALSA--SALSA EN INGLES | A male vocalist sings this enthusiastic latin melody. The tempo is medium with keyboard harmony, rhythmic Spanish guitar,percussive congas, bongos and guiro with tambourine beats. There is a loud siren-like sound superimposed over the song. The song is lively, simple,emotional, youthful, rhythmic, catchy with a latin dance grove. | 2009-06-02T15:53:15Z | tocadiscos11 | SALSA DE COLECCION | ["Music", "Music of Latin America", "Salsa music"] | ["male vocalist", "medium fast", "latin music", "latin percussion", "latin influence", "loud siren like sound", "siren", "shakers", "congas", "bongos", "rhythmic spanish guitar", "groovy", "dance groove", "guiro", "catchybeat", "salsa", "bachata", "latin dance music", "upbeat", "youthful", "melodic", "noisy background", "loud sound superimposed on song", "keyboard harmony"] | 7 | 06IU9WsEp3s | 120 | |
Lluvia - Gilberto Sta Rosa, Charlie Aponte, Jerry Rivas by www.latarimadelasalsa.tk | A male vocalist sings this spirited Latin song. The tempo is fast with a syncopated piano harmony, spanish guitar accompaniment ,Congas and bongos percussion, pandeira beats , keyboard harmony and vocal backup. The music is a lively, energetic, enthusiastic, passionate, spirited and vital Latin Pop with a dance groove. | 2009-09-27T16:38:48Z | latarimadelasalsa | Saludos Salseros y Salseras del Perú y del mundo este es un espacio dedicado a la Salsa, donde podras encontrar ultimas noticias, musica, videos y todo lo relacionado con el genero que nos apasiona. La Tarima de la Salsa - Perú www.latarimadelasalsa.tk | ["Music", "Music of Latin America", "Salsa music"] | ["male vocalist", "fast tempo", "latin pop", "world music", "happy", "celebration", "enthusiastic vocals", "syncopated piano", "congas rhythm", "bongos beat", "spanish guitar", "steady bass lines", "vocal backup", "lively", "spirited", "energetic", "enthusiastic", "passionate", "lain pop", "latin dance music", "salsa", "rumba", "bachata", "latin percussion", "pandeireta beats"] | 7 | 68XchGI6H-4 | 730 | |
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 | |
flamenco salsero 2017 - SALSA CHOKE - CHOKECHACHE - los chaches | A male vocalist sings this spirited song. The tempo is fast with a fast keyboard harmony, boomy bass line, rhythmic drums, steel drums,congas and bongos, cymbal ride and sound of clapping. The song is upbeat, punchy, buoyant, spirited, energetic and youthful with a dance groove. This song is Latin Urbano. | 2015-04-21T18:31:13Z | Los Chaches Record | flamenco salsero 2017 - rap 2017 - salsa choke 2017 - chokechache 2017 - flamenco 2017 - maketas flamencas 2017 - perreo 2017 - rumba 2017 - rap flamenco 2017 - video bailando riko de los chaches - moncho chavea - el vaka los chaches record | ["Flamenco", "Music"] | ["male singer", "fast tempo", "latin song", "latin dance music", "bright steel drumming", "youthful", "energetic", "congas", "bongos", "cymbal ride", "buoyant", "club music", "party music", "dance hits", "latin urbano", "punchy", "spirited", "upbeat", "catchy", "spanish music", "latin hits", "salsa", "bachata", "groovy bass lines", "keyboard harmony", "congas rhythm", "rhythmic bongos", "synthesiser arrangements"] | 7 | m3uiITzeM70 | 4442 | |
Palladium Salsa Social | 13 Marzo | Music by Dj Rumbero | A male vocalist sings this peppy Latin pop song.the tempo is medium with animated trumpets, keyboard harmony and percussions rhythms of bongos, congas and subtle drums. The song is muffled and there are sounds in the background of people talking, cheering, the sound of clinking, scuffling and tapping. The song is super imposed by the background sounds. This song is a latin pop song. | 2015-03-14T07:40:22Z | Jorge Rodriguez | Palladium Salsa Social music by Dj Rumbero a través de YouTube Capture | ["Singing", "Music", "Music of Latin America", "Salsa music"] | ["male vocalist", "medium tempo", "latin song", "super imposing background", "mexican", "cheering", "dance music", "latin dance music", "dance hits", "spanish", "dance music", "congas", "bongos", "trumpets", "steady beat", "salsa", "bachata", "people talking", "clinking", "tapping sound", "scuffling", "low audio quality", "muddled audio"] | 7 | sOyHkcK_lOA | 4947 |
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;