musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional" and musiccaps_aspects contains "trumpets blaring"
This data as json, CSV (advanced)
musiccaps_aspects (array) 54 ✖
- emotional · 3 ✖
- passionate 3
- spirited 3
- trumpets blaring · 3 ✖
- ambient crowd noise 1
- bad audio quality 1
- beachside party 1
- brass band 1
- brass band harmony 1
- brass instruments harmony 1
- caribbean music style 1
- caribbean percussions rhythm 1
- child singer 1
- classic reverse hits 1
- cowboys 1
- cymbals crashing 1
- dance groove 1
- dance rhythm 1
- enjoy life 1
- female singer 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar strumming 1
- inspiring 1
- keyboard accompaniment 1
- latin brass band 1
- latin country music 1
- latin dance band 1
- latin folk music 1
- latin medium tempo 1
- latin music 1
- latin percussions 1
- latin super hits 1
- life is a dance 1
- life is good 1
- live studio performance 1
- male latin singer 1
- medium tempo 1
- people dancing 1
- people talking 1
- reggae groove 1
- reggae hits 1
- romantic 1
- school concert 1
- slow tempo 1
- spirited singing 1
- steady bass line 1
- steady drumming rhythm 1
- traditional 1
- trombones 1
- tropical dance hit 1
- tubas 1
- yodelling music 1
musiccaps_names (array) 7 ✖
youtube_published (date) 3 ✖
- 2008-09-26 1
- 2009-12-04 1
- 2016-03-01 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 | |
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 | |
singing sandra crying | A female singer sings this passionate melody. The song is medium tempo with steady drumming rhythm, groovy bass line, Caribbean percussion, guitar accompaniment and a brass band playing percussively. The song is emotional and spirited. The song is a classic renege hit. | 2008-09-26T00:01:17Z | ANDY WONG KEE | music | ["Music", "/t/dd00003"] | ["female singer", "spirited singing", "reggae hits", "tropical dance hit", "caribbean music style", "trumpets blaring", "caribbean percussions rhythm", "medium tempo", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "brass band harmony", "emotional", "passionate", "reggae groove", "classic reverse hits", "spirited", "dance groove", "beachside party", "people dancing", "inspiring", "life is good", "enjoy life", "life is a dance"] | 1 | XXBVsNt2Qr8 | 3192 |
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;