musiccaps_details (view)
1 row where musiccaps_aspects contains "reggae" and "youtube_published" is on date 2009-08-13
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- audio crackles 1
- crowd noises 1
- distorted 1
- easygoing 1
- emotional male vocal 1
- groovy bass 1
- low quality 1
- offbeat electric guitar chords 1
- offbeat organ chords 1
- percussive elements 1
- reggae · 1 ✖
musiccaps_names (array) 2 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;