musiccaps_details (view)
3 rows where musiccaps_aspects contains "bad audio quality" and musiccaps_names contains "Music of Latin America"
This data as json, CSV (advanced)
musiccaps_aspects (array) 54 ✖
- bad audio quality · 3 ✖
- keyboard accompaniment 3
- emotional 2
- steady drumming rhythm 2
- always with you 1
- ambient room noise 1
- autoharp accompaniment 1
- backup singers vocal harmony 1
- best day of my life 1
- brass band 1
- country love songs 1
- country music 1
- country romantic hits 1
- crying 1
- dance rhythm 1
- drug wars 1
- energetic 1
- explicit lyrics 1
- female singer 1
- gang fights 1
- ghetto boys 1
- groovy bass line 1
- groovy rhythm 1
- guitar rhythm 1
- guitar strumming 1
- gunshots 1
- happy cheerful positive 1
- latin dance band 1
- latin male singers 1
- latin medium tempo 1
- latin percussions 1
- latin rap singers 1
- latin super hits 1
- life is tough 1
- live studio performance 1
- machine gun sounds 1
- male latin singer 1
- passionate 1
- people talking 1
- reciting pain 1
- spirited 1
- story telling 1
- string section harmony 1
- struggles 1
- the hood 1
- together forever 1
- trombones 1
- trumpets blaring 1
- tubas 1
- violence 1
- vocal harmony 1
- wedding dance 1
- wedding dance song 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music of Latin America · 3 ✖
- Music 2
- Hip hop music 1
- Musical instrument 1
- Rapping 1
- Reggae 1
- Salsa music 1
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 | |
Suprise Thriller Wedding Dance!!! | A female singer sings this beautiful love song with backup singers in vocal harmony. The song is medium tempo with a steady drumming rhythm, percussive bass line, autoharp accompaniment, guitar rhythm and keyboard accompaniment. The song has poor audio quality and makes an excellent wedding dance song. | 2009-04-21T00:29:24Z | Jeffrey Brinkley | Me and my wife and kids suprised our guest with thriller!! | ["Music of Latin America"] | ["wedding dance", "female singer", "country music", "wedding dance song", "bad audio quality", "ambient room noise", "country love songs", "backup singers vocal harmony", "steady drumming rhythm", "keyboard accompaniment", "autoharp accompaniment", "guitar rhythm", "country romantic hits", "always with you", "together forever", "crying", "happy cheerful positive", "people talking", "emotional", "best day of my life"] | 1 | bPWbeWf5xNI | 3622 | |
Franco El Gorila Ft Ñengo Flow - La Muerte ★New Reggaeton★ORIGINAL 2010 Full Records★ | Make the singer sing this Latin rap song in vocal harmony. The song is medium tempo with a steady drum drumming rhythm, keyboard accompaniment, string section harmony, percussive bass line and machine gunshot sounds. The song is story telling and violent in nature. The song has bad audio quality. | 2010-10-20T08:13:45Z | Ricky40Flow | UNETE: ► http://facebook.com/DembowUrbano Official Song HQ★Escucha y Descarga aqui Lo nuevo de Franco el Gorila Junto a Ñengo Flow "La Muerte" Downloads http://flowhot.info/nusyqy1cgnpc ( Full Metal Enterprises, Millones Record, WY Records, By Sinfonico) New Reggaeton Octubre 20. Ricky40. (Ak-47) www.flowhot.net (La Pagina Mas Rankea). Franco El Gorila Ft Ñengo Flow - La Muerte Franco El Gorila Ft Ñengo Flow - La Muerte Franco El Gorila Ft Ñengo Flow - La Muerte Franco El Gorila Ft Ñengo Flow - La Muerte Franco El Gorila Ft Ñengo Flow - La Muerte Franco El Gorila Ft Ñengo Flow - La Muerte | ["Music", "Rapping", "Reggae", "Music of Latin America", "Hip hop music"] | ["latin male singers", "latin rap singers", "gunshots", "bad audio quality", "machine gun sounds", "vocal harmony", "explicit lyrics", "string section harmony", "keyboard accompaniment", "groovy bass line", "steady drumming rhythm", "violence", "struggles", "story telling", "gang fights", "drug wars", "life is tough", "energetic", "youthful", "the hood", "ghetto boys", "reciting pain"] | 1 | bSX5-VPL8rE | 3625 |
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;