musiccaps_details (view)
2 rows where musiccaps_aspects contains "latin pop", musiccaps_aspects contains "perky" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- cheerful 2
- latin pop · 2 ✖
- perky · 2 ✖
- spirited 2
- animated 1
- animated piano 1
- bongos 1
- buoyant 1
- clarinet 1
- concert 1
- congas 1
- fast tempo 1
- female singer 1
- groovy bass line 1
- happy 1
- instrumental 1
- latin folk 1
- latin instrumental music 1
- latin music 1
- light 1
- live performance 1
- lively tambourine beats 1
- lively trumpet 1
- medium fast tempo 1
- peppy 1
- playful 1
- regional music 1
- rhythmic acoustic guitar 1
- spanish guitar 1
- ukele 1
- upbeat 1
- vibrant 1
- vic latin dance 1
- vivacious 1
- vocal backup 1
- wind instrument 1
- world music 1
musiccaps_names (array) 10 ✖
- Music · 2 ✖
- Acoustic guitar 1
- Guitar 1
- Jazz 1
- Music of Latin America 1
- Musical instrument 1
- Plucked string instrument 1
- Salsa music 1
- Singing 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Roda de Choro | Chorinho pra Você (Severino Araujo) | Instrumental SESC Brasil | This music is a lively instrumental. The tempo is fast with an animated clarinet lead, lively spanish guitar rhythm, ukulele accompaniment and bright tambourine /pandeireta beats. The music is upbeat, buoyant, peppy, cheerful, happy, playful and fun Latin Clarinet Instrumental. | 2010-10-07T06:57:12Z | Instrumental Sesc Brasil | A Roda de Choro nasceu na Virada Cultural de 2007, no Auditório Ibirapuera, sob organização de Danilo Brito. Desde sua criação, já aconteceu em diversos teatros e recebeu convidados como Carlos Malta, Laércio de Freitas, Toninho Ferragutti, Ricardo Herz, Danilo Brito, Alessandro Penezzi, Nelson Ayres, Oswaldinho do Acordeon e Gabriel Grossi, entre outros. No repertório, choros clássicos, passando por Pixinguinha, Jacob do Bandolim e algumas composições próprias. Formação: Alexandre Ribeiro - clarinete Léo Rodrigues - pandeiro Milton Mori - cavaquinho Luizinho 7 Cordas - violão 7 cordas Nelson Ayres - piano Toninho Ferragutii - acordeon Gênero: Choro Show que ocorreu no Teatro do Sesc Paulista dia 13/09/2010 • site oficial: https://www.instrumentalsescbrasil.org.br/ • assista aos shows ao vivo pelo https://www.youtube.com/instrumentalsescbrasil Inscreva-se no canal http://www.youtube.com/sescsp e fique por dentro de toda a programação que acontece nas unidades do Sesc no estado de São Paulo. Basta ter uma conta gratuita no Google. | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument", "Music of Latin America"] | ["instrumental", "fast tempo", "spirited", "clarinet", "ukele", "cheerful", "light", "perky", "happy", "playful", "latin instrumental music", "live performance", "concert", "wind instrument", "spanish guitar", "cheerful", "upbeat", "latin pop", "lively tambourine beats", "rhythmic acoustic guitar"] | 7 | c5NGOcNyF4g | 3678 | |
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 |
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;