musiccaps_details (view)
2 rows where musiccaps_aspects contains "r&b" and musiccaps_names contains "Afrobeat" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- r&b · 2 ✖
- electronic bass 1
- electronic drum kit 1
- electronic drums 1
- female singer 1
- female vocalist 1
- four chord 1
- fuzzy synth 1
- guitar 1
- hip hop 1
- hip-hop 1
- kick 1
- minor key 1
- modern production 1
- smooth 1
- synthesizer pad 1
musiccaps_names (array) 6 ✖
- Afrobeat · 2 ✖
- Hip hop music 2
- Music 2
- Funk 1
- Jingle (music) 1
- Rapping 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
My Big Chop | The music contains an energetic female voice which is sharp and clear. It is between rapping and singing. In the background are electronic music effects, at medium to high pitch. The atmosphere is smooth and confident. A drum kit plays a mid tempo pattern and It is very digital sounding. | 2010-07-11T06:19:47Z | yaboyhip | ["Afrobeat", "Funk", "Jingle (music)", "Music", "Rapping", "Hip hop music"] | ["female singer", "r&b", "hip-hop", "fuzzy synth", "kick", "guitar", "electronic bass", "smooth", "electronic drum kit"] | 5 | cbq6Q2htPRM | 3723 | ||
#Thanimayile - Africa Tamizhan (Prince Dave Ft Havoc Mathan) - Music Produced By Lucburn [OFFICIAL] | A four chord modern hip hop/ R&B production featuring synthesizer pads, electronic drums, a female vocalist in a minor key. | 2014-09-24T13:12:32Z | switch in music | Premier singles From Prince Dave's debut album "Africa Tamizhan" follow PRINCE DAVE ON INSTAGRAM : Princedave_international 1 MILLION is counting!! Based on True Story Vocals - Prince Dave Ft Havoc Mathan Music - Lucburn Singh Lyrics - Prince Dave & Havoc Brothers Mix & Mastered - Renjith (C) 2014 Switch In Music Records Follow Us @ Prince Dave - Vocals insta Princedave_international https://www.facebook.com/AfricaTamizhan Lucburn Singh - Music https://www.facebook.com/Iamlucburn Dcynerds - NME/Dcynerds https://www.facebook.com/Dcynerds | ["Afrobeat", "Music", "Hip hop music"] | ["r&b", "synthesizer pad", "electronic drums", "female vocalist", "hip hop", "minor key", "modern production", "four chord"] | 8 | 4QES-SJ7mP0 | 568 |
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;