musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "percussive elements"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- groovy bass · 3 ✖
- low quality 3
- percussive elements · 3 ✖
- offbeat electric guitar chords 2
- 4 on the floor kick 1
- accordion melody 1
- addictive 1
- audio crackles 1
- crowd cheering 1
- crowd clapping 1
- crowd noises 1
- distorted 1
- easygoing 1
- emotional male vocal 1
- energetic 1
- energetic crash cymbal 1
- energetic open hats 1
- exciting 1
- flat echoing male vocal 1
- flat male vocal 1
- folk 1
- groovy piano melody 1
- live performance 1
- loud 1
- offbeat organ chords 1
- reggae 1
- salsa music 1
- shimmering shakers 1
- uplifting 1
- wide piano chords 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Salsa Colombiana al ritmo de la Sonora Carruseles [HQ].mp4 | The low quality recording features a live performance of salsa music and it consists of flat male vocal talking over microphone, followed by groovy piano melody, some percussive elements, groovy bass and energetic crash cymbals. There are some loud crowd cheering noises and claps. It sounds exciting and energetic. | 2010-06-30T17:32:30Z | SAMBABODY | Fransini from Sambabody dancing Salsa w/ Sonora Carruseles at Colombian Festival in Los Angeles. check class schedule at meetup.com/sambabody | ["Music", "Salsa music"] | ["low quality", "live performance", "salsa music", "percussive elements", "groovy piano melody", "energetic crash cymbal", "flat male vocal", "crowd cheering", "crowd clapping", "exciting", "energetic", "groovy bass", "loud"] | 4 | OQz8reoVQEI | 2438 | |
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 | ||
TROJAN SOUND SYSTEM "PART 1" REGGAE SUN SKA FESTIVAL 2009 (12ème EDITION) | The low quality recording features a reggae song sung by emotional male vocalists, followed by percussive elements, groovy bass, offbeat electric guitar and organ chords. There are some crowd noises in the background. The audio is crackling, making it low quality, but regardless it sounds easygoing. | 2009-08-13T00:26:24Z | jamastyleFR | Trojan Sound System / Selectors : Earl Gateshead & Daddy Ad Vocalists : Superfour & Chucky Banton - http://jamastyle.fr Support your fest ! ****************************************** Programmation Festival Reggae Sun Ska 2014, 17ème édition : Jeudi 31 juillet : - Midnite - Clinton Fearon - Kanka - Kabaka Pyramid - Weeding Dub - Legal Shot Sound System ft. YT - Jah Gaïa - Dub Addict - Reggae Sun's Clash : Irie Crew vs. Heartical sound system vs. Guiding Star - Païaka - Jr Yellam - Reggaesta Vendredi 1er août : - Madness - Shaggy - Danakil - Busy Signal - Pablo Moses - Flavia Coelho - Raging Fyah - Mo'Kalamity - Rootwords - Mishka - Ackboo ft. S'Kaya - Dubmatix - Legal Shot Sound System ft. Murray Man - Black Chiney - Sentinel Sound - Bass Odissey - Train's Tone - Saritah - Soul Revolution - Djanta - Mystical Faya - Maya Vibes - Ilements ft. Guiding Star Samedi 2 août : - Bunny Wailer - Beenie Man - Natty Will Fly Again (Ashanti Roy + Pablo Moses + Winston Jarrett) - The Skatalites - Easy Star All Stars - Naâman - The Jolly Boys - Hollie Cook - Gappy Ranks - Randy Valentine - Panda Dub - Stone Love - Symbiz - Mista Savona - Mr Williamz - Legal Shot Sound System ft. Peter Youthman & Ghostrider - D-Bangers - Resonators - Elisa Do Brasil - Carte Blanche à Génération H : (Mr Lézard, Volodia, LMK, Leah Rosier, Kateb, Mardjenal, Sir Jean, Patko, Karma & Tchong, Scars) Dimanche 3 août : - Patrice - U-Roy - Tiken Jah Fakoly - Protoje - The Cat Empire - Chronixx - The Skints - Ester Rada - DJ Vadim & Sena - Illbilly Hitec - Ward 21 ft. Marcy Chin - Wailing Trees - Alam - Legal Shot Sound System ft. Al Campbell & Echo Minott - Dubkasm ft. Solo Banton - Jesse Royal - Massive B - King Rula - Dub Silence - Dusale Sound System - Africa'N'Percu - Les Lacées Des Fées - Rockin' Preachers ****************************************** | ["Music", "Middle Eastern music"] | ["low quality", "reggae", "crowd noises", "distorted", "emotional male vocal", "percussive elements", "groovy bass", "audio crackles", "offbeat electric guitar chords", "offbeat organ chords", "easygoing"] | 4 | icomsHXY8YA | 4207 |
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;