musiccaps_details (view)
3 rows where musiccaps_aspects contains "bad audio quality", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "guitar strumming"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- bad audio quality · 3 ✖
- emotional · 3 ✖
- guitar strumming · 3 ✖
- dance rhythm 2
- groovy rhythm 2
- instrumental music 2
- passionate 2
- spirited 2
- accordion harmony 1
- accordion players 1
- accordion virtuosos 1
- banjo 1
- blues 1
- brass band 1
- chaotic harmonies 1
- cheerful 1
- child performers 1
- country bluegrass 1
- country dance music 1
- country folk music 1
- country music 1
- fiddlers 1
- groovy music 1
- gypsy music 1
- improvisational music 1
- keyboard accompaniment 1
- latin dance band 1
- latin medium tempo 1
- latin percussions 1
- latin super hits 1
- live music 1
- live performance 1
- live studio performance 1
- loud ambient room noise 1
- male latin singer 1
- medium fast tempo 1
- medium tempo 1
- never give up 1
- percussions playing rhythmically 1
- positive 1
- spirited exciting 1
- the country life 1
- the wild west 1
- traditional music 1
- trombones 1
- trumpets blaring 1
- tubas 1
- violinists 1
- walking bass style 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
sleepy man banjo boys vs mountain rhythm | The song is instrumental. The tempo is medium with a prolific fiddler playing melody and a banjo and guitar accompaniment. The song is adventurous and exciting. The song is a classic country instrumental. The song has poor audio quality. | 2011-05-15T21:20:57Z | RubenProducciones | blatle of banjos. read the description: friends can go to this link and give it a like, would help me a lot to back up videos like this :) http://www.youtube.com/watch?v=g1I7seXs6O4 | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["violinists", "country music", "fiddlers", "child performers", "instrumental music", "guitar strumming", "country folk music", "live performance", "groovy rhythm", "country dance music", "the country life", "the wild west", "dance rhythm", "passionate", "emotional", "spirited", "never give up", "cheerful", "positive", "traditional music", "bad audio quality", "country bluegrass", "banjo", "medium tempo"] | 1 | O84YjlJ_Qw4 | 2402 | |
Taraful George Ness & Costel de la Bolintin 1.mp4 | The song is an instrumental. The tempo is medium fast with three accordions playing in harmony and virtuoso style , guitar strumming and other percussion instruments. The song is highly improvisational and has a bad audio quality with ambient room noises. | 2011-11-23T21:01:09Z | Taraful George Ness | tel :0768 174 804 George Ness | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["live music", "accordion players", "accordion harmony", "percussions playing rhythmically", "blues", "guitar strumming", "chaotic harmonies", "loud ambient room noise", "bad audio quality", "medium fast tempo", "walking bass style", "groovy music", "gypsy music", "improvisational music", "emotional", "spirited exciting", "instrumental music", "accordion virtuosos"] | 1 | t6XtW3SHQNE | 5006 |
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;