musiccaps_details (view)
2 rows where musiccaps_aspects contains "digital drums", musiccaps_names contains "Afrobeat" and musiccaps_names contains "Hip hop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- digital drums · 2 ✖
- backing voices 1
- bass 1
- digital bass 1
- male voice rapping 1
- male voice singing 1
- male voices rapping/talking 1
- medium tempo 1
- medium to uptempo 1
- pop 1
- reggeaton 1
- uplifting mood 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dj Chuckie - Party Bounce | This audio contains a digital reggaeton beat that uses some acoustic samples. In the background you can hear a soft bass playing along with the kick. A lot of male voices are rapping/speaking providing backing vocals that are spread across both sides of the speakers. This song may be playing at a party outside on the streets. | 2010-06-23T22:40:03Z | abtotdec | Enjoy the Song Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use | ["Afrobeat", "Singing", "Music", "Rapping", "Hip hop music"] | ["reggeaton", "male voices rapping/talking", "bass", "digital drums", "medium to uptempo"] | 6 | ou3LJpAM4mk | 4663 | |
Ding Dong Holiday Official Video | This song contains digital drums playing a hiphop kinda feel along with a bassline. The most energy comes from the male voice singing with autotune and a lot of backing voices cheering and singing along: Then a male voice starts rapping. The backing voices are spread across the both sides of the speakers. This song may be playing outside chilling with your friends. | 2012-02-02T21:54:29Z | Teonray Chichester | ["Afrobeat", "Music of Africa", "Music", "Hip hop music"] | ["pop", "digital bass", "digital drums", "male voice singing", "backing voices", "male voice rapping", "medium tempo", "uplifting mood"] | 6 | w6MtzUCl4vM | 5241 |
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;