musiccaps_details (view)
3 rows where musiccaps_aspects contains "disco rap" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 54 ✖
- disco rap · 3 ✖
- hip-hop 3
- medium tempo · 3 ✖
- rap 3
- rhythmic patter 3
- male singer 2
- passionate 2
- persuasive 2
- pop rap 2
- steady drumming 2
- synthesiser arrangements 2
- youthful 2
- amplified guitar 1
- amplified organ 1
- animated 1
- buoyant 1
- chanting 1
- chimes 1
- compelling 1
- congas 1
- dance groove 1
- digital drum 1
- digital drum rhythm 1
- drum machine 1
- drum stick clicks 1
- electronic instruments 1
- electronic music 1
- emotional 1
- energetic 1
- engaging 1
- foreign language 1
- gangsta rap 1
- guitar accompaniment 1
- hip-hop hits 1
- intense 1
- intense organ music 1
- keyboard harmony 1
- male vocalist 1
- punchy 1
- punchy bass 1
- punchy guitar rhythm 1
- punchy guitar rhythms drum stick clicks 1
- punk rap 1
- rap hits 1
- recurring beat 1
- rhythmic chanting 1
- slangy lyrics 1
- sound of picture being clicked 1
- spirited 1
- story telling 1
- street rapper 1
- street vernacular 1
- vibrant 1
- vocal backup 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
Pete Kolo Feat Chop Chop - "Help Wanted" | A male vocalist sings this spirited rap. The tempo is medium with keyboard accompaniment, digital drums,electric guitar riff and synthesiser arrangements with vocal backup. The song is passionate, compelling, strong telling, chanting, persuasive and youthful. This song is Contemporary Rap-Hip-Hop. | 2012-09-11T19:47:40Z | 2beyond1 | #Theanbm Pete Kolo releases single "Help wanted" ft. Chop Chop #SOB Anbm.inc@gmail.com @Theanbm @PeteGotBeats @ChopChop_SOB Director: @Stedy4dog , 2DCProductions | ["Music", "Rhythm and blues"] | ["male vocalist", "medium tempo", "rap", "rap hits", "digital drum", "youthful", "street rapper", "disco rap", "hip-hop", "hip-hop hits", "rhythmic patter", "electronic music", "drum machine", "synthesiser arrangements", "vocal backup", "passionate", "engaging", "compelling", "persuasive", "street vernacular", "slangy lyrics", "chanting", "recurring beat", "amplified guitar"] | 7 | SxYnb9_qDtk | 2800 |
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;