musiccaps_details (view)
4 rows where musiccaps_aspects contains "latin music" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 71 ✖
- latin music · 4 ✖
- spirited · 4 ✖
- world music 3
- bongos 2
- celebratory 2
- cheerful 2
- congas 2
- female singer 2
- guiro 2
- happy 2
- steady bass line 2
- acordion melody 1
- acoustic guitar accompaniment 1
- ambient crowd noise 1
- ambient outdoor sounds 1
- animated 1
- animated piano 1
- brass instruments harmony 1
- buoyant 1
- child singer 1
- classic latin songs 1
- cowboys 1
- cymbals crashing 1
- distorted music 1
- emotional 1
- fast tempo 1
- festive 1
- foreign language 1
- groovy bass line 1
- guiro accompaniment 1
- inferior audio quality 1
- instrumental 1
- joyful 1
- latin brass band 1
- latin country music 1
- latin dance music 1
- latin folk 1
- latin folk music 1
- latin folk songs 1
- latin percussions 1
- latin pop 1
- latin regional music 1
- live music 1
- live performance 1
- lively 1
- lively acordion 1
- lively trumpet 1
- male backup 1
- medium fast tempo 1
- medium tempo 1
- muddled audio 1
- passionate 1
- people talking 1
- peppy 1
- perky 1
- regional music 1
- romantic 1
- school concert 1
- scraper instrument 1
- simple 1
- slow tempo 1
- spanish music 1
- spirited congas 1
- static 1
- traditional 1
- trumpets blaring 1
- vibrant 1
- vic latin dance 1
- vivacious 1
- vocal backup 1
- yodelling music 1
musiccaps_names (array) 12 ✖
- Music 4
- Musical instrument 2
- Singing 2
- Accordion 1
- Christian music 1
- Christmas music 1
- Jazz 1
- Maraca 1
- Rattle (instrument) 1
- Salsa music 1
- Song 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sebastien De La Cruz, EL CHARRO DE ORO, EL PASTOR | A child singer sings this passionate Latin melody. The song is slow tempo with steady drumming, tambourine percussions, a strong bass line and brass instruments playing countermelody. The song is spirited and passionate. The song has poor audio quality and has ambient crowd noises. | 2009-12-04T04:56:07Z | Juan De La Cruz | MARIACHI VARGAS EXTRAVAGANZA 2009 EL PASTOR, 7YR OLD WOW, THIRD PLACE VOCAL FINALIST | ["Singing", "Music", "Musical instrument", "Vocal music"] | ["child singer", "latin music", "ambient crowd noise", "steady bass line", "cymbals crashing", "people talking", "trumpets blaring", "school concert", "latin folk music", "latin folk music", "traditional", "cowboys", "latin country music", "yodelling music", "spirited", "passionate", "romantic", "emotional", "brass instruments harmony", "slow tempo", "latin brass band"] | 1 | 6C0HoQe4Y-Y | 734 | |
Perfume De Salsa - Dame Un Traguito (Music Video Latin Jazz/Salsa) | A female vocalist sings this spirited latin song.the tempo is medium fast with an animated piano accompaniment, rhythmic congas and bongos, funky bass line and bright trumpet harmony. The song is lively, spirited, upbeat, catchy, vivacious;vibrant and peppy with a salsa dance groove. This song is Latin Pop. | 2015-10-21T16:12:43Z | Sam Sam Music | Fabulous all women Latin Jazz / Salsa band Perfume de Salsa: On disc and download: http://www.samsammusic.com/Perfume-De-Salsa https://itunes.apple.com/us/album/solo-ella/id369866081 https://play.spotify.com/album/4Uhhl8qh5YiIibzNku0wpf http://www.amazon.com/Solo-Ella-Perfume-Salsa/dp/B003JJUJWS https://play.google.com/store/music/album/Perfume_de_Salsa_Solo_Ella?id=Bmu4rc6lk6hmr4ohcqoufeqbooa&hl=en http://www.rdio.com/artist/Perfume_De_Salsa/album/Solo_Ella/ http://www.deezer.com/album/543046 Subscribe to Sam Sam Music ➤https://bit.ly/34fRMti Great New Music Videos ➤ https://bit.ly/34fXevV Rock’n Roll Sixties ➤ http://bit.ly/RocknRollSixties Follow us on Social Media: Website ► https://bit.ly/2NGpfHJ Facebook ► http://bit.ly/2NJztas Twitter► http://bit.ly/32KMt3A Instagram► http://bit.ly/2NKdUXh #latin #salsa #jazzmusic | ["Singing", "Jazz", "Music", "Song", "Salsa music"] | ["female singer", "medium fast tempo", "vivacious", "animated", "spirited", "buoyant", "perky", "peppy", "cheerful", "vibrant", "latin music", "latin pop", "vic latin dance", "latin folk", "regional music", "world music", "animated piano", "lively trumpet", "groovy bass line", "bongos", "congas", "vocal backup"] | 7 | fPYeqTFc3IQ | 3944 | |
LUIS E.MARTINEZ EL CANTOR DE FONSECA | This music is a spirited Latin music instrumental. The tempo is fast with a lively accordion harmony, spirited congas beat and guiro accompaniment. The music is happy, vivacious, upbeat, vigorous, cheerful , celebratory and cheerful with ambient outdoor sounds like wind, people talking, clapping and a lot of static indicating that this is a live performance. The audio quality is inferior and this looks like an amateur home recording. | 2008-06-20T18:46:59Z | ALVARO VILLA FONTALVO | INTERPRETA EL CANTOR DE FONSECA EN COMPAÑIA DE SU AUTOR CARLOS HUERTAS EL CANTOR DE FONSECA- LUIS ENRIQUE INTERPRETA MAGISTRALMENTE SU ACORDEON, ENTRE LOS ASISTENTES ESTABA GABO, FUE EN EL AÑO 1993 EN B/QUILLA | ["Music", "Musical instrument", "Accordion", "Maraca"] | ["instrumental", "fast tempo", "distorted music", "static", "guiro accompaniment", "scraper instrument", "world music", "latin regional music", "latin dance music", "lively acordion", "spirited congas", "guiro", "latin music", "latin dance music", "happy", "spirited", "live performance", "live music", "ambient outdoor sounds", "inferior audio quality", "celebratory", "festive", "joyful"] | 7 | kpsYSXR1wao | 4360 | |
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;