musiccaps_details (view)
2 rows where musiccaps_aspects contains "lively", musiccaps_names contains "Music of Latin America" and musiccaps_names contains "Salsa music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- latin dance music 2
- latin percussion 2
- lively · 2 ✖
- salsa 2
- bachata 1
- bass guitar 1
- bongos beat 1
- celebration 1
- congas rhythm 1
- cowbell 1
- energetic 1
- enthusiastic 1
- enthusiastic vocals 1
- fast tempo 1
- happy 1
- lain pop 1
- latin pop 1
- loud singing 1
- male vocalist 1
- male vocals 1
- pandeireta beats 1
- passionate 1
- rumba 1
- spanish 1
- spanish guitar 1
- spirited 1
- steady bass lines 1
- syncopated piano 1
- vibrant 1
- vocal backup 1
- world music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
CON EL ( HOMERO ) SALSA VIEJA | This is a Latin salsa dance music piece. There are male vocals singing loudly in the Spanish language. There is a groovy bass line. The rhythmic background is provided by the cowbell strokes. The atmosphere is lively. This piece could be used as an accompaniment piece for a Latin dance course. | 2011-03-28T18:31:20Z | noe montiel | ["Music", "Music of Latin America", "Salsa music"] | ["latin dance music", "salsa", "male vocals", "loud singing", "spanish", "bass guitar", "latin percussion", "cowbell", "lively", "vibrant"] | 9 | LWLLN9INTII | 2196 |
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;