musiccaps_details (view)
2 rows where musiccaps_aspects contains "happy", musiccaps_author = 4 and musiccaps_names = "["Afrobeat", "Music of Africa", "Music"]"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
NIGERIAN GOSPEL MUSIC - DIS KIND GOD | CHUKS CHIDUBE | AFRICAN MEGA PRAISE SONGS | The low quality recording features a flat male vocal singing over tinny wooden percussions, punchy "4 on the floor" kick pattern, groovy bass, long crash cymbal, shimmering shakers, syncopated snare hits and electric guitar melody. In the first half of the loop, there is a short snippet of crowd cheering and clapping over brass melody. It sounds fun, happy and energetic. | 2016-03-03T18:41:37Z | AFRoSCENE.TV | Please watch: "UK TOP 40 AFROBEATS MIX | NIGERIA MUSIC 2020 | NAIJA 2020 | AFROBEATS 2020 | UK AFROBEATS CHART" https://www.youtube.com/watch?v=eo0WjIvtjjQ --~-- LIKE | COMMENT | SHARE | SUBSCRIBE : https://www.youtube.com/channel/UCjQV6ESXh2lJ8jfPgJRFAVw?sub_confirmation=1 Afroscene TV - https//:www.afroscene.tv is a Afrobeat promotional channel and website based in London United Kingdom. It is currently one of the biggest promotional Afrobeats channel in the United Kingdom with over 30,320 subscribers and 6,802,822 views and growing fast. AfroScene TV has announced its plans to provide the latest videos, events and industry news from the Afrobeat music genre. Dedicated to becoming an industry source for the world’s top Afrobeats talent as well as the unsigned community, AfroScene is an effort to bring both awareness and further artist exposure inside this tightly knit genre. Both the listening community and aspiring artists will have a platform on the website, and they encourage artists to get involved in the community as a means of promoting their own unique sound. Whether you are new to the genre and looking to explore its musical offerings or a dedicated listener seeking a single solution for all your daily industry fix, Afroscene TV provides unparalleled coverage of all aspects of the genre. Never before has a site so fully and effectively covered the ins and outs of the unique musical impact of afrobeat. Our Stats: 6,823,894 channel views with 30,360 subscribers and growing 1.675,808 million watch time last time in 28 days and growing 668,283 views in 28 days and growing fast Latest Nigerian Music is taking the industry by storm. #Africanmusic #Nigerianmusic #Afroebats Nigerian Gospel Music 2018 praise and worship songs present Naija Gospel Music 2018, Evang Chuks Chidube.T he Nigerian Praise and Worship songs are best of Church praise. This is one of the latest African gospel music presented by Afroscene TV for 2018. DIS KIND GOD African Mega Praise Album by Chuks Chidube. The most popula… | ["Afrobeat", "Music of Africa", "Music"] | ["low quality", "tinny wooden percussion", "crowd cheering", "crowd clapping", "flat male vocal", "punchy \"4 on the floor\" kick pattern", "groovy bass", "long crash cymbal", "shimmering shakers", "syncopated snare", "electric guitar melody", "brass melody", "fun", "happy", "energetic"] | 4 | X0MN34Us6eE | 3156 | |
kizomba 2015 Elji Beatzkilla Feat Saaphy_NOBODY (benji & cibel) | The Latin Urban song features an echoing male lead vocal, alongside wide harmonizing harmonizing background vocals and echoing ad libs, rapping over "4 on the floor kick" pattern, smooth bass, syncopated snare, shimmering cymbals and wide shimmering shakers, followed by arpeggiated synth keys melody. It sounds uplifting, happy and like something you would dance to with your friends. | 2014-11-17T21:48:52Z | yannick delgado | KIZOMBA DANCE BAILARINOS benji Ds e cibel delgado REALIZAÇAO Yannick Delgado MUSICAS -Cirus Raskil Touch Me [2013] -Elji Beatzkilla - Nobody (feat. Saaphy) | ["Afrobeat", "Music of Africa", "Music"] | ["latin urban", "arpeggiated synth keys melody", "shimmering cymbals", "syncopated snare", "wide shimmering shakers", "echoing lead male vocal", "wide harmonizing bakcground vocals", "echoing ad libs", "4 on the floor kick", "smooth bass", "uplifting", "happy"] | 4 | sXwa1Akj1t0 | 4957 |
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;