musiccaps_details (view)
2 rows where musiccaps_names contains "Rapping" and "youtube_published" is on date 2011-11-26
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- energetic 2
- addictive 1
- bouncy 1
- club music 1
- dance groove 1
- dance music 1
- digital drum arrangement 1
- distorted bass 1
- dj 1
- drum machine 1
- emotional 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- filtered background male vocal 1
- flat male vocal 1
- funk rap 1
- hip-hop 1
- hip-hop hits 1
- keyboard harmony 1
- low quality 1
- male vocalist 1
- messy 1
- passionate 1
- punchy 1
- punchy kick 1
- punchy snare 1
- punk rap 1
- r&b 1
- rap 1
- recurring beat 1
- repetitive synth lead melody 1
- rhythmic patter 1
- rhythmic speech 1
- shimmering cymbals 1
- synth articulation 1
- uptempo hi hats 1
- vocal backup 1
- youthful 1
musiccaps_names (array) 4 ✖
- Hip hop music 2
- Music 2
- Rapping · 2 ✖
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Wale - Focused clean version | The low quality recording features a R&B song that consists of flat male vocals, alongside filtered background male vocals, singing over punchy kick and snare hits, shimmering cymbals, uptempo hi hats, distorted bass and repetitive synth lead melody. It sounds messy, as the frequencies are clashing with each other, but also energetic, emotional and addictive - like something you would quickly learn to sing along. | 2011-11-26T16:53:06Z | DjDrewskie | I was Really Feeiling His Albm But There Was No Clean Version Anywhere So You KNow I Had To Do It! if want anymore songs done comment nd ill get to it I DO NOT OWN ANY RIGHTS TO THIS SONG RML | ["Music", "Rapping", "Zing", "Hip hop music"] | ["low quality", "r&b", "uptempo hi hats", "distorted bass", "repetitive synth lead melody", "filtered background male vocal", "punchy snare", "shimmering cymbals", "punchy kick", "flat male vocal", "energetic", "emotional", "addictive", "messy"] | 4 | nSLxQLYYoNE | 4538 |
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;