musiccaps_details (view)
4 rows where musiccaps_aspects contains "addictive" and musiccaps_names contains "Salsa music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- addictive · 4 ✖
- low quality 4
- groovy bass 2
- passionate 2
- shimmering shakers 2
- 4 on the floor kick 1
- accordion melody 1
- addictive accordion melody 1
- addictive female vocal 1
- distorted 1
- electric guitar melody 1
- emotional 1
- energetic 1
- energetic open hats 1
- flat echoing male vocal 1
- folk 1
- groovy piano melody 1
- harsh 1
- live performance 1
- male vocal 1
- messy 1
- metallic buzzing 1
- mono 1
- noisy 1
- offbeat electric guitar chords 1
- percussive elements 1
- percussive wooden elements 1
- punchy kick 1
- punchy snare 1
- salsa 1
- shimmering chime bells 1
- smooth bass 1
- snare roll 1
- soulful 1
- string melody 1
- traditional 1
- traditional pop 1
- uplifting 1
- wide piano chords 1
- wooden percussion 1
- wooden percussions 1
musiccaps_names (array) 7 ✖
- Music 4
- Salsa music · 4 ✖
- Music of Africa 2
- Afrobeat 1
- Music of Asia 1
- Music of Latin America 1
- Reggae 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
villa maipu en bus | The Folk song features a flat, echoing male vocal talking over addictive accordion melody, wide piano chords, groovy bass, "4 on the floor" kick pattern, tinny percussive elements, energetic open hats, shimmering shakers and offbeat electric guitar chords. It sounds uplifting and low quality. | 2009-12-20T01:34:44Z | 14Juampa | ["Afrobeat", "Music of Africa", "Music", "Reggae", "Salsa music"] | ["folk", "flat echoing male vocal", "accordion melody", "wide piano chords", "groovy bass", "4 on the floor kick", "percussive elements", "shimmering shakers", "energetic open hats", "offbeat electric guitar chords", "uplifting", "addictive", "low quality"] | 4 | b4FomUpNaJE | 3600 | ||
salsa cubana musica cubana inoel regeaton | The low quality recording features a salsa song that consists of a passionate male vocal singing over shimmering chime bells, wooden percussion, shimmering shakers and groovy piano melody. It sounds passionate, emotional and addictive. | 2008-08-02T01:08:58Z | InoelQuiros | New song by Inoel Quiros for the "Pura Salsa Na Ma" CD. Visit Inoel on MySpace @ www.myspace.com/inoelquiros. | ["Music of Africa", "Music", "Salsa music"] | ["low quality", "salsa", "groovy piano melody", "shimmering chime bells", "wooden percussion", "shimmering shakers", "passionate", "male vocal", "passionate", "emotional", "addictive"] | 4 | bTlp5Qr99RY | 3628 | |
Fatima Tuz Zahra Oyshee-De De pal Tule de - Live on RTV MUSIC STATION | The low quality recording features a live performance of a traditional pop song and it consists of an addictive female vocal singing over punchy kick and snare hits, groovy bass, electric guitar melody, strings melody and wooden percussion. There is a short snare roll, right before the bass drops. It sounds messy, a bit harsh, distorted, but also passionate, addictive and energetic. | 2015-11-15T15:01:18Z | Oyshee Express | Singer- Fatima Tuz zahra Oyshee Lyric & Tune: Abdur Rahman Boyati Produced by Khoshru Anchored by Liza Bass Guitar- Sohel Rana Flute: Kamrul Lead Guitar: Roman Keyboard: Nadim Pad: Sakib Percussion: Ujjol | ["Music of Asia", "Music", "Salsa music"] | ["live performance", "low quality", "traditional pop", "addictive female vocal", "punchy snare", "wooden percussions", "snare roll", "groovy bass", "string melody", "electric guitar melody", "punchy kick", "messy", "distorted", "harsh", "passionate", "addictive", "energetic"] | 4 | eISYX9koocM | 3855 | |
LA CUMBIA DE LAS MADRES{LA NEGRITA DE LA SALSA Y KIKE MARACAS EL JR} | The low quality recording features a traditional song that consists of wooden percussive elements, addictive accordion melody, smooth bass and some metallic buzzing sounds. Even though it is mono and noisy, it still sounds soulful and addictive. | 2010-07-25T21:05:36Z | sonido guacharaca la voz ronca | ELLOS SON HIJOS DE SONIDO GUACHARACA CD NEZA ELLA ES SONIDO LA NEGRITA DE LA SALSA Y EL ES SONIDO KIKE MARACAS EL JR SALUDOS PARA LA GENTE DE CD NEZA MEXICO.................... | ["Music", "Music of Latin America", "Salsa music"] | ["low quality", "mono", "noisy", "percussive wooden elements", "addictive accordion melody", "smooth bass", "metallic buzzing", "soulful", "addictive", "traditional"] | 4 | hVPQu1UJ2N8 | 4112 |
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;