musiccaps_details (view)
2 rows where musiccaps_aspects contains "latin dance", musiccaps_aspects contains "male vocals" and musiccaps_names contains "Afrobeat"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- latin dance · 2 ✖
- male vocals · 2 ✖
- bass guitar 1
- clave 1
- dizzying 1
- electronic percussion 1
- energetic 1
- euphoric 1
- high tempo 1
- joyful singing 1
- keyboard 1
- latin acoustic drums 1
- latin percussion 1
- lively 1
- maraca 1
- piano 1
- repeated theme 1
- salsa 1
- trumpet 1
- upbeat 1
- vibrant 1
musiccaps_names (array) 7 ✖
- Afrobeat · 2 ✖
- Music 2
- Music of Africa 2
- Maraca 1
- Salsa music 1
- Song 1
- Soundtrack music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"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 | |
Jucafri maraca | This is a latin dance piece. There are two vocals taking turns singing the same line repeatedly. There is a keyboard and a trumpet playing the main melody. A fast-paced electronic percussion is playing in the rhythmic background. This is a dizzyingly high tempo song. It is very danceable. This piece can be played in latin nightclubs and latin dance courses. | 2008-03-05T03:25:33Z | 2redrose22 | Jucafri dale maraca | ["Afrobeat", "Music of Africa", "Music", "Song", "Maraca"] | ["maraca", "latin dance", "male vocals", "repeated theme", "trumpet", "keyboard", "electronic percussion", "high tempo", "energetic", "dizzying"] | 9 | _yXtw_z2xf4 | 3506 |
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;