musiccaps_details (view)
4 rows where musiccaps_aspects contains "bongos", musiccaps_aspects contains "congas" and musiccaps_aspects contains "keyboard harmony"
This data as json, CSV (advanced)
musiccaps_aspects (array) 78 ✖
- bongos · 4 ✖
- congas · 4 ✖
- keyboard harmony · 4 ✖
- bachata 2
- dance groove 2
- latin dance music 2
- male singer 2
- male vocalist 2
- medium tempo 2
- salsa 2
- upbeat 2
- youthful 2
- acousitc guitar 1
- ambient 1
- bass guitar 1
- bright steel drumming 1
- buoyant 1
- catchy 1
- catchybeat 1
- club music 1
- congas rhythm 1
- crowd chatter 1
- cymbal ride 1
- dance hits 1
- dance music 1
- elegant 1
- emotional 1
- energetic 1
- enthusiastic 1
- fast tempo 1
- female backup 1
- foreign language 1
- funk pop 1
- funk soul 1
- funky electric guitar 1
- groovy 1
- groovy bass line 1
- groovy bass lines 1
- guiro 1
- inferior sound quality 1
- intense drumming 1
- latin hits 1
- latin influence 1
- latin music 1
- latin percussion 1
- latin song 1
- latin urbano 1
- loud siren like sound 1
- loud sound superimposed on song 1
- man laughing 1
- medium fast 1
- melodic 1
- movie soundtrack 1
- muffled sounds 1
- muffled vocals 1
- noisy background 1
- party music 1
- passionate 1
- punchy 1
- r&b 1
- regional pop 1
- rhythmic bongos 1
- rhythmic spanish guitar 1
- romantic 1
- salsa music 1
- shakers 1
- siren 1
- slick 1
- slick drumming 1
- smooth 1
- soft pop 1
- soul 1
- spanish music 1
- spirited 1
- synthesiser arrangements 1
- tambourine beats 1
- trombone 1
- vocal backup 1
musiccaps_names (array) 7 ✖
- Music 4
- Flamenco 1
- Music of Latin America 1
- Reggae 1
- Salsa music 1
- Singing 1
- Wedding music 1
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 | |
Dan Nguyen va Cat Tien hat Loi To Tinh De Thuong | A male vocalist sings this pop song. The tempo is medium with keyboard accompaniment ,steady drumming, groovy bass, congas and bongos percussion and acoustic guitar accompaniment with vocal backup. The sound quality of the audio is inferior and there is the sound of chatter in the background .The song is fresh, simple, breezy, romantic, passionate, sentimental and youthful with a dance groove. This song is Regional Pop. | 2015-07-28T01:31:19Z | Oanh Nguyen | ["Singing", "Music", "Wedding music"] | ["male vocalist", "medium tempo", "female backup", "soft pop", "dance groove", "dance music", "muffled sounds", "crowd chatter", "salsa music", "keyboard harmony", "congas", "bongos", "bass guitar", "intense drumming", "acousitc guitar", "muffled vocals", "inferior sound quality", "foreign language", "regional pop", "passionate", "emotional", "romantic", "enthusiastic"] | 7 | JWNWCKdfpzM | 2015 | ||
Edwin Starr - Easin' In (1973) | A male vocalist sings this smooth Soul song. The tempo is medium with a groovy bass line, trombone harmony, electric guitar rhythm, slick drumming, vocal backup, congas and tambourine beats with smooth vocal backup. The song is soft, rich, elegant, ambient and smooth. This music is a Funk pop/Soul. | 2008-01-28T22:17:08Z | veewee | from the album "Hell Up in Harlem" | ["Music", "Reggae"] | ["male singer", "medium tempo", "man laughing", "tambourine beats", "groovy bass line", "congas", "elegant", "smooth", "slick", "bongos", "funky electric guitar", "vocal backup", "slick drumming", "keyboard harmony", "trombone", "funk pop", "soul", "r&b", "funk soul", "movie soundtrack", "ambient"] | 7 | kOBh4NZ4wZQ | 4313 | |
flamenco salsero 2017 - SALSA CHOKE - CHOKECHACHE - los chaches | A male vocalist sings this spirited song. The tempo is fast with a fast keyboard harmony, boomy bass line, rhythmic drums, steel drums,congas and bongos, cymbal ride and sound of clapping. The song is upbeat, punchy, buoyant, spirited, energetic and youthful with a dance groove. This song is Latin Urbano. | 2015-04-21T18:31:13Z | Los Chaches Record | flamenco salsero 2017 - rap 2017 - salsa choke 2017 - chokechache 2017 - flamenco 2017 - maketas flamencas 2017 - perreo 2017 - rumba 2017 - rap flamenco 2017 - video bailando riko de los chaches - moncho chavea - el vaka los chaches record | ["Flamenco", "Music"] | ["male singer", "fast tempo", "latin song", "latin dance music", "bright steel drumming", "youthful", "energetic", "congas", "bongos", "cymbal ride", "buoyant", "club music", "party music", "dance hits", "latin urbano", "punchy", "spirited", "upbeat", "catchy", "spanish music", "latin hits", "salsa", "bachata", "groovy bass lines", "keyboard harmony", "congas rhythm", "rhythmic bongos", "synthesiser arrangements"] | 7 | m3uiITzeM70 | 4442 |
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;