musiccaps_details (view)
2 rows where musiccaps_aspects contains "latin american music", musiccaps_aspects contains "upbeat" and musiccaps_names contains "Music of Latin America"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- latin american music · 2 ✖
- upbeat · 2 ✖
- bongo drums 1
- bongos 1
- brass instruments 1
- complex upbeat bassline 1
- dance 1
- fiesta 1
- group male vocalists 1
- harmonies 1
- live performance 1
- low quality audio 1
- male hispanic vocal group 1
- maracas 1
- party 1
- passionate tenor male vocal 1
- piano 1
- salsa dancing 1
- salsa music 1
- spanish singing 1
musiccaps_names (array) 5 ✖
- Music 2
- Music of Latin America · 2 ✖
- Salsa music 2
- Musical instrument 1
- Percussion 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Los Blancos (en vivo) | This is a traditional Latin American song which would be suitable for salsa dancing. There are layers of percussion including bongo drums and snare drums. The pianist plays intricate melodies and the brass section plays vibrant and punchy motifs. It's a live performance with a relatively poor audio quality. There is a male group of singers performing energetically. | 2008-07-14T19:10:04Z | juandog2000 | en concierto (el Rey del timbal) Leopoldo Blanco en los timbales | ["Music", "Musical instrument", "Music of Latin America", "Percussion", "Salsa music"] | ["latin american music", "upbeat", "brass instruments", "bongo drums", "piano", "male hispanic vocal group", "salsa dancing", "live performance", "low quality audio"] | 3 | DAX9uKYlDvw | 1449 | |
amo mi soledad - la rebelion | This is a Latin American dance song in the salsa style. We hear layers of upbeat, rhythmic percussion that's suitable for dancing. Maracas, bongos, and a groovy and complex bassline coupled with a melodic instrument make for a vibrant and fun party/dance song. | 2010-09-14T00:59:18Z | salsasanta | bajo la dirección de fernando martinez nace en 1986 en medellin, colombia orquesta la rebelión, aqui tenemos su mayor exito en la voz de marco vinicio. | ["Music", "Music of Latin America", "Salsa music"] | ["latin american music", "spanish singing", "salsa music", "dance", "fiesta", "party", "upbeat", "passionate tenor male vocal", "group male vocalists", "harmonies", "complex upbeat bassline", "maracas", "bongos"] | 3 | vByuZEzCZJg | 5162 |
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;