musiccaps_details (view)
3 rows where musiccaps_aspects contains "keyboard accompaniment" and musiccaps_names contains "Salsa music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- keyboard accompaniment · 3 ✖
- emotional 2
- latin percussions 2
- passionate 2
- spirited 2
- animated 1
- bad audio quality 1
- bass kazoo 1
- brass band 1
- couples dancing 1
- dance rhythm 1
- energetic 1
- energetic drumming 1
- engaging 1
- fast tempo 1
- funky bass 1
- galloping rhtyhm 1
- groovy bass 1
- groovy bass line 1
- groovy rhythm 1
- guitar strumming 1
- kazoo lead 1
- keyboard harmony 1
- latin dance band 1
- latin folk music 1
- latin medium tempo 1
- latin romantic hits 1
- latin super hits 1
- live studio performance 1
- lively 1
- love songs 1
- male latin singer 1
- male singer 1
- male vocalist 1
- medium tempo 1
- mysterious 1
- passionate song 1
- poor audio quality 1
- romantic 1
- salsa 1
- spirited singing 1
- superimposed instrumental 1
- trombones 1
- trumpets blaring 1
- trumpets playing 1
- tubas 1
- various percussion hits 1
- vibrations 1
- vivacious 1
- vivacious electric guitar harmony 1
musiccaps_names (array) 5 ✖
- Music 3
- Salsa music · 3 ✖
- Middle Eastern music 1
- Music of Latin America 1
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SALSA CLASICA ROMANTICA MIX RONNY MUSIC | A male singer sings this Latin melody. The song is medium tempo with a groovy Latin percussive rhythm, keyboard accompaniment, brass band harmony and a groovy bass line. The song is romantic and emotional. The song is a salsa dance hit, but has poor audio quality issues.. | 2011-09-30T01:08:54Z | ronnymusic01 | BY DJ RONNY MUSIC | ["Music", "Middle Eastern music", "Salsa music"] | ["salsa", "latin folk music", "male singer", "spirited singing", "emotional", "couples dancing", "passionate song", "mysterious", "latin percussions", "trumpets playing", "medium tempo", "various percussion hits", "keyboard harmony", "romantic", "love songs", "latin romantic hits", "keyboard accompaniment", "poor audio quality", "passionate", "groovy bass line"] | 1 | DKflAAykh6A | 1464 | |
LA REVANCHA (en vivo) - ZAPEROKO LA RESISTENCIA SALSERA DEL CALLAO | Male singer sings this cool Latin melody. The song is medium tempo with various Latin percussion instruments and a brass band playing percussively in harmony. The song is energetic and has a cool dance rhythm. The audio quality of the song is average. | 2016-03-01T12:45:56Z | Orquesta Zaperoko La Resistencia Salsera del Callao | La Revancha Letra de Hugo Almanza Durand, se inició como compositor en 1965. Ha creado boleros, valses, cumbias y huaynos ayacuchanos. Entre los cantantes nacionales que han interpretado sus temas se encuentran Lucho Barrios, Ramón Avilés, Pedrito Otiniano, Los Morunos, Gaby Zevallos, Johnny Farfán, Los Kipus, Eddy Martínez, Agua Marina y otros. Además, se ha desempeñado como locutor en Radio La Crónica, Radio Lima y Radio Nacional del Perú. Otros temas del maestro Almanza Durand que han tenido éxito internacional son: «Disimula», «Ya te olvidé», «Acepto mi destino», «El Olvido», «Huye de mí» y «Resignación». «La revancha» tiene más de 70 versiones, «Disimula» 40 y «Acepto mi destino» no menos de 20. Ahora en la version de Salsa de Zaperoko La Resistencia Salsera del Callao, en la version del Dominicano Cuco Valoy y los arreglos de nuestro cantante compositor Diego Horacio Chuquitaype, Bajo la Direccion de Jhonny Peña, esta una version para RadioMar Plus, grabado en los Estudios de Company Music Zaperoko La Resistencia Salsera del Callao Contratos al 997329972 - 981168066 LA REVANCHA (SESIÓN MULTITRACK EN VIVO) FULL HD Presentamos la "PRIMERA EDICIÓN EN VIVO" de Orq. "ZAPEROKO" Productor Musical: GIANCARLOS ARROYO B. CHRISTIAN REY SANCHEZ. Edición, Mezcla y Mazterizaciòn: COMPANY MUSIC RECORDS - Dale LIKE a nuestra pagina (https://www.facebook.com/companymusicrecords/) Edicion AudioVisual: BASSET ESTUDIO. LIMA- PERU Visita nuestras instalaciones y se participe de nuestros vídeos en FULL HD. SOUNDCLOUD: https://soundcloud.com/company-music-records | ["Music", "Musical instrument", "Music of Latin America", "Salsa music"] | ["bad audio quality", "latin dance band", "latin super hits", "keyboard accompaniment", "male latin singer", "groovy rhythm", "live studio performance", "latin medium tempo", "brass band", "latin percussions", "trumpets blaring", "trombones", "tubas", "guitar strumming", "dance rhythm", "latin dance band", "emotional", "spirited", "passionate"] | 1 | F3uf_RleI3E | 1611 | |
Kazoo bass slap | a male vocalist sings this enthusiastic swing pop. The tempo is fast with an enthusiastic electric guitar harmony, energetic drumming, funky bass lines, keyboard harmony, emphatic vocals superimposed by an infectious Bass kazoo melody. The song is energetic, enthusiastic, youthful, fun , groovy, vivacious and chirpy. | 2011-02-26T17:39:54Z | Magublican TV | http://fraserdaley.com | ["Music", "Salsa music"] | ["male vocalist", "fast tempo", "energetic drumming", "keyboard accompaniment", "vivacious electric guitar harmony", "groovy bass", "galloping rhtyhm", "funky bass", "kazoo lead", "bass kazoo", "vibrations", "superimposed instrumental", "lively", "spirited", "animated", "vivacious", "engaging", "energetic"] | 7 | ZFimyfPWltk | 3354 |
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;