musiccaps_details (view)
3 rows where musiccaps_aspects contains "gangsta rap" and musiccaps_names contains "Hip hop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- gangsta rap · 3 ✖
- ad-libs 1
- amplified organ 1
- chimes 1
- digital drum rhythm 1
- disco rap 1
- electronic drums 1
- electronic instruments 1
- emotional 1
- fuzzy synth bass 1
- groovy 1
- gunshot sound effect 1
- hardcore hip-hop 1
- hip hop 1
- hip hop drum beat 1
- hip-hop 1
- intense 1
- intense organ music 1
- male singer 1
- male vocals 1
- medium tempo 1
- passionate 1
- persuasive 1
- pop rap 1
- punchy bass 1
- punk rap 1
- rap 1
- rapping 1
- raspy rap vocal 1
- repeated theme 1
- rhythmic chanting 1
- rhythmic patter 1
- sound of picture being clicked 1
- steady drumming 1
- story telling 1
- string instrument 1
- string motif 1
- synthesiser arrangements 1
- urban 1
- violent 1
- violin 1
- violin riff 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 | |
G Unit - 3. Round Here - Automatic Gunfire Mixtape | This is a hardcore hip-hop/gangsta rap music piece. There are male vocals taking turns rapping and when they are not rapping they are shouting ad-libs. There is a fuzzy synth bass playing the repeated melodic theme of the beat while the rhythm consists of an electronic drum beat with gunshot effects every now and then. The atmosphere is urban and violent. This piece could be included in the soundtrack of a crime movie that takes place in the big city. It could also be used in the soundtrack of a crime video game. | 2014-07-24T21:34:14Z | The Woods ENT. | This is "Round Here" off 50 Cent & G-Unit's mixtape "Automatic Gunfire" Hosted By DJ Whoo Kid, Produced by Sha Money XL. 2003, G-Unit. | ["Music", "Hip hop music"] | ["hardcore hip-hop", "gangsta rap", "male vocals", "rapping", "ad-libs", "fuzzy synth bass", "repeated theme", "electronic drums", "gunshot sound effect", "groovy", "urban", "violent"] | 9 | KxZ0yDfyaJw | 2134 | |
One Car In Evington Leicester Snow Skidding | The song is a hip hop song with a violin motif playing the most prominent role in the instrumental. The drum beat is a simple boom bap beat. The rapper has a raspy voice and he sounds emboldened regarding his message. The violin riff is repeated throughout the song. | 2009-02-02T01:52:57Z | farooq007 | once upon a time we saw snow and got crazy, and wanted to do somthing. and then i glanced on my new saab CONVERTIBLE (DREAM CAR) AND START SKIDING .when we say on our mobile it looked cool to us . | ["Music", "Rapping", "Hip hop music"] | ["hip hop", "hip hop drum beat", "string instrument", "violin", "violin riff", "string motif", "raspy rap vocal", "gangsta rap"] | 3 | kX5bTiq5eBo | 4326 |
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;