musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance music", musiccaps_aspects contains "hip-hop" and musiccaps_names contains "Rapping"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- dance music · 2 ✖
- energetic 2
- hip-hop · 2 ✖
- bass 1
- bouncy 1
- club music 1
- dance groove 1
- digital drum arrangement 1
- dj 1
- drum machine 1
- electric guitar 1
- electronic drums 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- flamboyant singing 1
- funk rap 1
- groovy 1
- hip 1
- hip-hop hits 1
- keyboard harmony 1
- male vocal 1
- male vocalist 1
- passionate 1
- playful 1
- punchy 1
- punk rap 1
- rap 1
- recurring beat 1
- rhythmic patter 1
- rhythmic speech 1
- shuffle 1
- synth articulation 1
- urban 1
- vocal backup 1
- youthful 1
musiccaps_names (array) 3 ✖
- Hip hop music 2
- Music 2
- Rapping · 2 ✖
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 | |
Hip Hop Academy Sid Shuffle | This is a hip-hop dance music piece. There is a male vocalist who is singing in a flamboyant manner. There is an electric guitar playing the melody joined by a strong bass sound. There is a groovy, urban atmosphere. This piece can be used as an accompaniment piece in modern dancing courses. | 2013-09-15T18:15:10Z | HipHopAcademy08 | ["Music", "Rapping", "Hip hop music"] | ["hip-hop", "dance music", "shuffle", "male vocal", "flamboyant singing", "electric guitar", "bass", "electronic drums", "playful", "groovy", "hip", "urban", "energetic"] | 9 | V9EFYFKlYbE | 2976 |
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;