musiccaps_details (view)
3 rows where musiccaps_aspects contains "piano" and musiccaps_names contains "Afrobeat"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- piano · 3 ✖
- african/dance/pop/r&b 1
- backing voices 1
- bass 1
- bass guitar 1
- brass section 1
- busy percussion 1
- clave 1
- digital drums 1
- energetic 1
- euphoric 1
- fast tempo 1
- fun 1
- group male vocals 1
- joyful singing 1
- latin 1
- latin acoustic drums 1
- latin dance 1
- latin percussion 1
- lively 1
- male vocals 1
- male voice singing 1
- medium to uptempo 1
- salsa 1
- shaker 1
- upbeat 1
- vibrant 1
musiccaps_names (array) 6 ✖
- Afrobeat · 3 ✖
- Music 3
- Music of Africa 3
- Flamenco 1
- Salsa music 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 |
---|---|---|---|---|---|---|---|---|---|---|
M.Trill - "Beautiful" Official Video | A digital drum is playing a groove that motivates to dance with a kick on every beat along with a shaker. Male backing voices are singing a melody in harmony and adlips that are panned to the right side of the speakers. A piano is playing a simple repeating melody and a soft bass sound is rounding the recording up. On top of that a male voice is singing phrases. This song may be playing at home dancing. | 2009-01-14T18:29:17Z | Jachimma | Ghana-Nigeria collaboration feat.FIRE MTrill describes his ideal woman | ["Afrobeat", "Music of Africa", "Music"] | ["african/dance/pop/r&b", "digital drums", "shaker", "piano", "bass", "male voice singing", "backing voices", "medium to uptempo"] | 6 | 3JYQgXudiH8 | 455 | |
"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 | |
flamenco remix 2013 | Energetic, fun latin salsa music with a fast tempo that includes busy percussion, a brass section, piano, group male vocals. | 2012-12-22T20:33:22Z | ole la gitaneria | ["Afrobeat", "Music of Africa", "Flamenco", "Music"] | ["latin", "busy percussion", "brass section", "piano", "group male vocals", "energetic", "fun", "fast tempo"] | 8 | q9Gh-zh-5Ig | 4758 |
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;