musiccaps_details (view)
3 rows where musiccaps_aspects contains "enthusiastic", musiccaps_aspects contains "youthful" and musiccaps_names contains "Rapping"
This data as json, CSV (advanced)
musiccaps_aspects (array) 59 ✖
- energetic 3
- enthusiastic · 3 ✖
- youthful · 3 ✖
- bouncy 2
- club music 2
- dj 2
- drum machine 2
- engaging 2
- fast tempo 2
- hip-hop 2
- male singer 2
- punchy 2
- punk rap 2
- rap 2
- rhythmic patter 2
- atmospheric music 1
- boy band 1
- concert 1
- crowd cheering 1
- crowd screaming 1
- dance groove 1
- dance music 1
- dance pop 1
- digital drum arrangement 1
- digital drumming 1
- disco rap 1
- edm 1
- fans 1
- fans going berserk 1
- fans going crazy 1
- foreign language 1
- funk rap 1
- groovy bass line 1
- hip-hop hits 1
- hit song 1
- k-pop 1
- keyboard harmony 1
- live audience 1
- live performance 1
- lively piano 1
- male vocalist 1
- medium tempo 1
- melodious 1
- passionate 1
- pop rap 1
- popularity 1
- punch 1
- recurring beat 1
- reverb 1
- rhythmic speech 1
- steady drumming 1
- synth articulation 1
- synth pop 1
- synthesiser arrangements 1
- teen pop 1
- vibrant 1
- vibrant vivacious 1
- vigorous rhythmic speech 1
- vocal backup 1
musiccaps_names (array) 7 ✖
- Music 3
- Rapping · 3 ✖
- Funk 1
- Hip hop music 1
- Independent music 1
- Music of Asia 1
- Pop music 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 | |
BTOB - Beep Beep (Feb 20, 2014) | A male vocalist sings this melodious pop song. The tempo is medium with piano accompaniment, rhythmic acoustic guitar, groovy bass line ,steady drumming and energetic vocal backup. The song is spirited, youthful, vivacious, popular, bright and engaging. The song is a live performance and there are sounds of people cheering, hooting hysterically and singing along. This song is a hit in K-Pop. | 2014-02-21T07:07:36Z | Minhyuk ครับผม | 140220 BTOB - Beep Beep @ M Countdown Comeback Stage | ["Music of Asia", "Funk", "Music", "Independent music", "Pop music", "Rapping"] | ["male singer", "foreign language", "medium tempo", "youthful", "engaging", "energetic", "enthusiastic", "vibrant vivacious", "concert", "teen pop", "k-pop", "live performance", "concert", "live audience", "enthusiastic", "crowd cheering", "crowd screaming", "fans", "fans going crazy", "fans going berserk", "popularity", "hit song", "boy band", "melodious", "steady drumming", "lively piano", "groovy bass line"] | 7 | cADT8fUucLQ | 3686 | |
Smack Wooo Riddim Freestyle | A male vocalist sings this energetic rap. The tempo is fast with electronic music and synthesiser arrangements with digital drum rhythm and boomy bass. The song is upbeat, energetic, buoyant, punchy and youthful with a bright dance groove. This song is an EDM/Synth pop. | 2012-02-04T03:16:37Z | ILOVEUKGRIME1 | ["Music", "Rapping"] | ["male singer", "fast tempo", "synth pop", "punchy", "atmospheric music", "vibrant", "edm", "drum machine", "synthesiser arrangements", "digital drumming", "reverb", "rhythmic patter", "vigorous rhythmic speech", "pop rap", "disco rap", "dance pop", "energetic", "enthusiastic", "punch", "youthful", "bouncy", "hip-hop", "rap", "dj", "punk rap", "club music"] | 7 | u6tgeRXOxnU | 5090 |
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;