musiccaps_details (view)
1 row where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "punchy "4 on the floor" kick pattern", musiccaps_aspects contains "shimmering shakers" and musiccaps_names contains "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 --~-- ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ : 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 |
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;