musiccaps_details (view)
3 rows where musiccaps_aspects contains "male vocals" and musiccaps_names contains "Afrobeat" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- male vocals · 3 ✖
- electronic percussion 2
- latin dance 2
- bass guitar 1
- bravado 1
- clave 1
- dance-rap 1
- dizzying 1
- electronic drums 1
- energetic 1
- euphoric 1
- groovy 1
- high tempo 1
- joyful singing 1
- keyboard 1
- latin acoustic drums 1
- latin percussion 1
- lively 1
- maraca 1
- piano 1
- pop-rap 1
- rapping 1
- repeated theme 1
- salsa 1
- strong bass 1
- trumpet 1
- upbeat 1
- vibrant 1
musiccaps_names (array) 10 ✖
- Afrobeat · 3 ✖
- Music 3
- Music of Africa 2
- Hip hop music 1
- Maraca 1
- Reggae 1
- Rhythm and blues 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Teach Me How To Dougie FAIL | This is a pop-rap/dance-rap piece. There is a male vocal rapping joined by the occasional samples of other rappers. The electronic drums and the electronic percussion are providing the rhythmic background. There is a strong 808-style syncopated bass. The atmosphere has a groovy feeling to it. This song could be used in nightclubs and sports venues. | 2010-08-10T15:29:43Z | Luckyy Irish | Guy dances into the street... Song: Cali Swag District - Teach Me How To Dougie | ["Afrobeat", "Music", "Reggae", "Rhythm and blues", "Hip hop music"] | ["pop-rap", "dance-rap", "male vocals", "rapping", "strong bass", "electronic drums", "electronic percussion", "bravado", "groovy"] | 9 | KB79k456DhI | 2063 | |
"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;