musiccaps_details (view)
5 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "hip-hop" and musiccaps_aspects contains "male singer"
This data as json, CSV (advanced)
musiccaps_aspects (array) 62 ✖
- emotional · 5 ✖
- hip-hop · 5 ✖
- male singer · 5 ✖
- passionate 4
- rap 4
- intense 3
- medium tempo 3
- rhythmic patter 3
- digital drum rhythm 2
- disco rap 2
- engaging 2
- keyboard harmony 2
- persuasive 2
- pop rap 2
- rhythmic speech 2
- slow tempo 2
- steady drumming 2
- story telling 2
- synthesiser arrangements 2
- youthful 2
- alternative rap 1
- amplified organ 1
- atmospheric synthesiser 1
- beat boxing 1
- boomy bass 1
- bouncy 1
- chimes 1
- christian rap 1
- clean lyrics 1
- compelling 1
- drum machine 1
- electroni music 1
- electronic instruments 1
- funky bass lines 1
- gangsta rap 1
- grim 1
- groovy bass line 1
- hip-hop hits 1
- impactful 1
- insightful 1
- intense drumming 1
- intense organ music 1
- mellow 1
- minimalist music 1
- psychedelic synthesiser 1
- punchy 1
- punchy bass 1
- punk rap 1
- r&b 1
- rapper 1
- rhythmic chanting 1
- rhythmic electric guitar 1
- rhythmic speechlow notes 1
- serious 1
- simple lyrics 1
- smooth 1
- soul 1
- sound of picture being clicked 1
- steady bass 1
- synth rap 1
- teen rap 1
- vocal backup 1
musiccaps_names (array) 10 ✖
- Music 5
- Rapping 3
- Hip hop music 2
- Reggae 2
- Afrobeat 1
- Christian music 1
- Heart murmur 1
- Music of Asia 1
- Rhythm and blues 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lately (Official Music Video) | A male vocalist sings this mellow rap. The tempo is medium with a groovy bass line, keyboard harmony , slick drumming and vocal backup. The song is youthful, story telling, passionate, impactful, compelling and engaging. This song is contemporary Hip-Hop/Rap. | 2016-04-16T18:42:59Z | Official Lobo | Song: Lately Artist: Lobo Directed/Produced/Edited by: Lobo Shot by: CHRIS Kai Bordenave Lobo | ["Music", "Tender music"] | ["male singer", "slow tempo", "funky bass lines", "intense drumming", "synthesiser arrangements", "vocal backup", "hip-hop", "rap", "pop rap", "hip-hop hits", "disco rap", "rhythmic speech", "story telling", "passionate", "emotional", "persuasive", "compelling", "engaging", "persuasive", "youthful"] | 7 | 0Ubu4BqSWmU | 174 | |
Initial D - We Roll 咆哮.avi | A male vocalist sings this intense Rap. The tempo is slow with boomy bass drumming and atmospheric synthesiser. The music is minimalist with emphatic vocals. The song is a passionate, youthful,insightful,persuasive and intense Synth Rap. | 2012-01-31T17:40:11Z | Coup0705 | ["Heart murmur", "Music of Asia", "Music"] | ["male singer", "slow tempo", "rap", "hip-hop", "synth rap", "rhythmic patter", "rhythmic speechlow notes", "rapper", "electroni music", "atmospheric synthesiser", "boomy bass", "psychedelic synthesiser", "minimalist music", "intense", "serious", "grim", "emotional", "passionate"] | 7 | 6Sdu56gquJE | 758 | ||
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 | |
South Central Cartel - It's A S.C.C. Thang ft. The Chi-Lites | A male vocalist sings this groovy R&B. The tempo is medium with a funky bass guitar, steady guitar, bright electric guitar and keyboard harmony. The song is mellow, emotional, soft, smooth and engaging. This song is an R&B. | 2009-11-23T18:52:26Z | SthCentralCartelVEVO | Music video by South Central Cartel performing It's A S.C.C. Thang. (C) 1994 RAL/Def Jam | ["Music", "Rapping", "Reggae"] | ["male singer", "medium tempo", "groovy bass line", "mellow", "smooth", "emotional", "engaging", "steady drumming", "keyboard harmony", "hip-hop", "r&b", "soul", "alternative rap", "rhythmic electric guitar"] | 7 | S7R3NMq3MKk | 2739 | |
NEW Christian Rap - J-Tru Soldier4Christ ft. Gigglez - "Never Give Up" (@ChristianRapz) | A male vocalist sings this rap. The tempo is medium with the keyboard harmony, digital drum rhythm and boomy bass. The song is passionate, youthful, emotional, buoyant, insightful, intense and story telling in a rhythmic patter. This song is contemporary Rap/Hip. | 2015-10-07T12:29:47Z | Christian Hip Hop | CLICK HERE TO SUBSCRIBE - https://www.youtube.com/subscription_center?add_user=christianrapz Follow Christian Hip Hop Hits Just as Hard! Twitter - http://www.christianrapz.org Facebook - http://www.christianrapz.us Matt Bold - http://www.christianrapz.info YouTube - http://www.christianrapz.com Soundcloud - https://soundcloud.com/christianraps Visit http://www.christianraps.com for more Christian Hip-Hop & Rap Not for selling purposes all honor and glory to God http://www.evelutionbeats.com http://www.soundcloud.com/jtrujillo220 NEW Christian Rap - J-Tru Soldier4Christ ft. Gigglez - "Never Give Up" (@ChristianRapz) | ["Afrobeat", "Christian music", "Music", "Rapping", "Reggae", "Rhythm and blues", "Hip hop music"] | ["male singer", "medium tempo", "hip-hop", "rap", "insightful", "clean lyrics", "simple lyrics", "christian rap", "youthful", "teen rap", "bouncy", "punchy", "steady bass", "beat boxing", "keyboard harmony", "drum machine", "digital drum rhythm", "rhythmic patter", "rhythmic speech", "passionate", "emotional", "impactful", "intense"] | 7 | dwAo0dKCyBI | 3828 |
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;