musiccaps_details (view)
3 rows where musiccaps_aspects contains "pop rap" and musiccaps_names contains "Rapping" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- disco rap 3
- hip-hop 3
- male singer 3
- pop rap · 3 ✖
- rap 3
- rhythmic patter 3
- energetic 2
- medium tempo 2
- punchy 2
- punk rap 2
- steady drumming 2
- synthesiser arrangements 2
- vibrant 2
- youthful 2
- amplified organ 1
- animated 1
- atmospheric music 1
- bouncy 1
- buoyant 1
- chimes 1
- club music 1
- congas 1
- dance groove 1
- dance pop 1
- digital drum rhythm 1
- digital drumming 1
- dj 1
- drum machine 1
- drum stick clicks 1
- edm 1
- electronic instruments 1
- emotional 1
- enthusiastic 1
- fast tempo 1
- foreign language 1
- gangsta rap 1
- guitar accompaniment 1
- intense 1
- intense organ music 1
- keyboard harmony 1
- passionate 1
- persuasive 1
- punch 1
- punchy bass 1
- punchy guitar rhythm 1
- punchy guitar rhythms drum stick clicks 1
- reverb 1
- rhythmic chanting 1
- sound of picture being clicked 1
- spirited 1
- story telling 1
- synth pop 1
- vigorous rhythmic speech 1
musiccaps_names (array) 6 ✖
- Music 3
- Rapping · 3 ✖
- Hip hop music 2
- Afrobeat 1
- Music of Africa 1
- Rhythm and blues 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Busy Signal - How Dem A Talk [Clean Version] | A male vocalist sings this peppy rap. The tempo is medium fast with an enthusiastic and catchy guitar rhythm, drum stick clicks, congas, steady drumming and keyboard accompaniment. The song is simple, punchy; buoyant, youthful, animated, vibrant and has a catchy dance groove. This song is contemporary Hip-Hop/Rap. | 2015-08-20T01:50:47Z | BusySignalRealVEVO | Music video by Busy Signal performing "How Dem A Talk" (Official Visual). ©: Turf Music Entertainment /Stainless Music http://vevo.ly/nWNEGT | ["Afrobeat", "Music of Africa", "Music", "Rapping", "Rhythm and blues", "Hip hop music"] | ["male singer", "medium tempo", "spirited", "vibrant", "buoyant", "foreign language", "punchy guitar rhythm", "drum stick clicks", "disco rap", "punchy", "guitar accompaniment", "steady drumming", "congas", "keyboard harmony", "energetic", "rap", "hip-hop", "pop rap", "youthful", "spirited", "animated", "dance groove", "vibrant", "punchy guitar rhythms drum stick clicks", "rhythmic patter"] | 7 | NWL-P08eM-U | 2342 | |
Hurricane Chris "FREESTYLE" *51/50 RATCHET IN STORES NOW* | A male vocalist sings this passionate rap. The tempo is medium with keyboard harmony, slick drumming, funky bass lines , sound of chimes and synthesiser arrangements. The song is emotional, passionate, emphatic, persuasive, youthful, impactful and rhythmic chanting. The song is a contemporary Hip-Hop/RAo. | 2007-11-01T00:16:48Z | Hurricane Chris | CHECK OUT HURRICANE CHRIS KILL THE "WHITE GIRL" TRACK!!! MAKE SURE YOU POST THIS ON YOUR PAGE AND SEND IT TO FRIENDS!! 51/50 RATCHET IN STORES NOW!! | ["Music", "Rapping", "Hip hop music"] | ["male singer", "medium tempo", "synthesiser arrangements", "rhythmic chanting", "disco rap", "pop rap", "hip-hop", "rap", "punk rap", "gangsta rap", "electronic instruments", "steady drumming", "punchy bass", "intense", "amplified organ", "intense organ music", "sound of picture being clicked", "chimes", "digital drum rhythm", "persuasive", "emotional", "passionate", "story telling", "rhythmic patter"] | 7 | IEVVHo9nr7g | 1883 | |
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;