musiccaps_details (view)
2 rows where musiccaps_aspects contains "keyboard harmony", musiccaps_aspects contains "male vocalist" and musiccaps_aspects contains "rhythmic patter"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- fast tempo 2
- hip-hop 2
- keyboard harmony · 2 ✖
- male vocalist · 2 ✖
- rap 2
- rhythmic patter · 2 ✖
- bouncy 1
- chaotic 1
- club music 1
- confusing 1
- dance groove 1
- dance music 1
- digital drum arrangement 1
- dj 1
- drum machine 1
- energetic 1
- energetic drumming 1
- engaging 1
- enthusiastic 1
- female backup 1
- funk rap 1
- groovy bass line 1
- hip-hop hits 1
- inferior sound quality 1
- muffle audio 1
- passionate 1
- punchy 1
- punk rap 1
- recurring beat 1
- rhythmic speech 1
- scratching sound 1
- synth articulation 1
- unpleasant sound 1
- vocal backup 1
- youthful 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SKREW MSK AWR ARTIST WRITING | A male vocalist sings a lively hip hop. The tempo is fast with energetic drumming, groovy bass lines and keyboard accompaniment with female backup vocals. The song is incoherent and muffled with a loud scratching like sound dominating the audio. The audio is chaotic, confusing, incoherent and unpleasant to the ears. | 2008-11-26T23:03:40Z | Eddie Donaldson | GUERILLAONE.COM IS A TEN YEAR OLD GRAFFITI SITE THAT HAS BEEN AROUND FOR TEN YEARS, IF YOU DONT KNOW ASK SOMEBODY OR VISIT http://www.guerillaone.com/ OR http://blog.guerillaone.com/ | ["Scratching (performance technique)", "Music", "Scratch", "Writing"] | ["male vocalist", "fast tempo", "rap", "hip-hop", "keyboard harmony", "unpleasant sound", "female backup", "groovy bass line", "energetic drumming", "rhythmic patter", "muffle audio", "inferior sound quality", "scratching sound", "chaotic", "confusing"] | 7 | IlUcHzBzZvg | 1936 | |
Hadiya Deville..Make it Ping Pong...mpg | A male vocalist sings this spirited hip-hop. The tempo is fast with synthesiser articulation, digital drum arrangements and vocal backup. The music is a youthful , enthusiastic, bouncy, punchy rhythmic patter with a dance groove. This song is contemporary Hip-Hop/ Rap. | 2011-11-26T16:20:24Z | Loc Deville | This is a Must See Video..2 Year old Hadiya Shaheed..aka Hadiya Deville..Rocks Out, to her Fathers New Single ''Make it Ping Pong''.. ---Talent is in the D.N.A..--SEE FOR YOUR SELF :) | ["Music", "Rapping", "Hip hop music"] | ["male vocalist", "fast tempo", "hip-hop", "rap", "bouncy", "punchy", "funk rap", "punk rap", "rhythmic patter", "rhythmic speech", "engaging", "passionate", "energetic", "enthusiastic", "vocal backup", "recurring beat", "youthful", "keyboard harmony", "digital drum arrangement", "drum machine", "synth articulation", "vocal backup", "dance groove", "dj", "club music", "dance music", "hip-hop hits"] | 7 | QBMM1ocXkhY | 2602 |
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;