musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "latin percussion" and musiccaps_aspects contains "upbeat" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- latin percussion · 2 ✖
- salsa 2
- upbeat · 2 ✖
- bachata 1
- bass guitar 1
- bongos 1
- catchybeat 1
- clave 1
- congas 1
- dance groove 1
- euphoric 1
- groovy 1
- guiro 1
- joyful singing 1
- keyboard harmony 1
- latin acoustic drums 1
- latin dance 1
- latin dance music 1
- latin influence 1
- latin music 1
- lively 1
- loud siren like sound 1
- loud sound superimposed on song 1
- male vocalist 1
- male vocals 1
- medium fast 1
- melodic 1
- noisy background 1
- piano 1
- rhythmic spanish guitar 1
- shakers 1
- siren 1
- vibrant 1
- youthful 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
SALSA--SALSA EN INGLES | A male vocalist sings this enthusiastic latin melody. The tempo is medium with keyboard harmony, rhythmic Spanish guitar,percussive congas, bongos and guiro with tambourine beats. There is a loud siren-like sound superimposed over the song. The song is lively, simple,emotional, youthful, rhythmic, catchy with a latin dance grove. | 2009-06-02T15:53:15Z | tocadiscos11 | SALSA DE COLECCION | ["Music", "Music of Latin America", "Salsa music"] | ["male vocalist", "medium fast", "latin music", "latin percussion", "latin influence", "loud siren like sound", "siren", "shakers", "congas", "bongos", "rhythmic spanish guitar", "groovy", "dance groove", "guiro", "catchybeat", "salsa", "bachata", "latin dance music", "upbeat", "youthful", "melodic", "noisy background", "loud sound superimposed on song", "keyboard harmony"] | 7 | 06IU9WsEp3s | 120 | |
"QUIERO SALSA" DE "GERLEY" (VIDEO LYRIC) GMM MUSIC www.Gerleysalsa.com | This is a salsa music piece. There is a male vocal in the lead joined by another as a back vocal. All the vocals are singing joyfully. There is a piano playing the main melody while a bass guitar is playing in the background. In the rhythmic background, there is an acoustic latin drum beat with percussion playing syncopations all over. There is a lively, upbeat atmosphere. This piece could be played at dance clubs and it could also be used as an accompaniment piece for latin dance courses. | 2015-05-15T10:21:16Z | GERLEY SALSA | Gerley - Quiero Salsa Official Videoclip Gerley´s New Album "EMERGIENDO" is available on these digital platforms: iTunes: https://itunes.apple.com/co/album/emergiendo/id1181906219 Google Play: https://play.google.com/store/music/album/GERLEY_Emergiendo?id=B2qmufwnmfr74h4flrkccjxylau Amazon: https://www.amazon.com/Emergiendo-Gerley/dp/B01N0LJ1G7 Spotify: https://open.spotify.com/artist/7ad8MLg65Z452CyrzhljOR www.Gerleysalsa.com Twitter: @Gerleysalsa Mail: Gerleysalsa@gmail.com Manager: Gilberto Cardenas: Cel: (57) - 3105444575 Colombia 🇨🇴 Cali - Colombia... CRISTO VIVE...!! Vídeo Lyric Del Nuevo Sigle de GERLEY Para el 2015, "QUIERO SALSA" Grabado en Cali Colombia, con Un Grupo De Talentosos Y Reconocidos Músicos De Latinoamérica, Bajo El Sello Independiente GMM MUSIC. Disponible Ya En Todas Las Tiendas Virtuales, Para Que Lo Descarguen Y De Paso Respaldar La Carrera De Este Salsero Colombiano. (Video Lyric Realizado Por HR2 FILMS - HUGO ANDRES RINCON) CREDITOS: Lead: GERLEY Compositor: Gerley Arreglo: Andres Gomez - Gerley Producción y Dirección Musical: Andrés Gómez Coros: Jerry Rivas, Wichy Camacho y Diego Galindo Congas: William "Kachiro" Thompson Timbal y Bongó: Caliche Sabogal Batería: Julio Ramirez Güiro: Carlos Guerrero Bajo: Alex Stella Piano y Teclados: Andres Gomez Trompetas: Jose Javier Aponzá Trombones: Alex Zapata y Richard Stella Ingeniero de Grabación: Edwin Lozano Mezcla: Juan Mario Aracil "Mayito" Fotografía: Hugo Rincón Montaño | ["Afrobeat", "Music of Africa", "Music", "Soundtrack music", "Salsa music"] | ["salsa", "male vocals", "joyful singing", "piano", "bass guitar", "latin acoustic drums", "latin percussion", "clave", "latin dance", "vibrant", "lively", "upbeat", "euphoric"] | 9 | 4b8gTARnmVE | 588 |
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;