musiccaps_details (view)
3 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "latin pop" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- cheerful · 3 ✖
- latin pop · 3 ✖
- fast tempo 2
- happy 2
- perky 2
- regional music 2
- rhythmic acoustic guitar 2
- spanish guitar 2
- spirited 2
- upbeat 2
- world music 2
- animated 1
- animated piano 1
- banjo 1
- bongos 1
- bright drumming 1
- buoyant 1
- clarinet 1
- concert 1
- congas 1
- enthusiastic 1
- female singer 1
- funky bass lines 1
- groovy bass line 1
- instrumental 1
- keyboard harmony 1
- latin folk 1
- latin instrumental music 1
- latin music 1
- latin song 1
- light 1
- live performance 1
- lively tambourine beats 1
- lively trumpet 1
- male vocalist 1
- medium fast tempo 1
- pandeireta 1
- peppy 1
- playful 1
- pleasant 1
- sunny 1
- ukele 1
- vibrant 1
- vic latin dance 1
- vivacious 1
- vocal backup 1
- warm 1
- wind instrument 1
musiccaps_names (array) 11 ✖
- Music 3
- 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
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SOUL VIBRATION - Frequenza reggae | A male vocalist sings this vivacious latin pop song. The tempo is fast with rhythmic Spanish guitar,keyboard harmony, bright drumming, mandolin harmony, groovy bass line and lively pandeira beats. The song is melodic, simple, happy, cheerful, bouncy, peppy , warm and joyful. | 2010-08-30T17:45:36Z | AstonBarret | SOUL VIBRATION - Frequenza reggae - REGGAE MATERA | ["Music", "Soul music"] | ["male vocalist", "fast tempo", "latin pop", "latin song", "banjo", "spanish guitar", "keyboard harmony", "bright drumming", "world music", "regional music", "happy", "cheerful", "enthusiastic", "warm", "sunny", "upbeat", "pleasant", "funky bass lines", "pandeireta", "rhythmic acoustic guitar"] | 7 | CP3phqztym0 | 1360 | |
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;