musiccaps_details (view)
5 rows where musiccaps_aspects contains "e-bass" and musiccaps_aspects contains "hiphop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- e-bass · 5 ✖
- hiphop · 5 ✖
- acoustic drums 2
- e-guitar 2
- male voice rapping 2
- medium tempo 2
- scratching 2
- slow tempo 2
- acoustic drum sample 1
- acoustic drums sample 1
- congas 1
- drums 1
- e-guitar sample 1
- e-piano 1
- gunshot 1
- higher pitch 1
- higher register 1
- laid back atmosphere 1
- laid back vibe 1
- male deeper voice rapping 1
- male voice sample 1
- male voice singing 1
- slower tempo 1
- sound sample 1
- vocal samples 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
2007 - DJ Miya Jima (Japan) - DMC World DJ Final | This song contains someone scratching over a Hip-Hop track. The track contains acoustic drums with a rim-shot as snare and congas playing along. The e-bass and an e-guitar are playing the same lines in the lower register. This song may be playing live at a scratching contest. | 2013-11-18T10:27:09Z | DMC World Championships | DJ Miya Jima (Japan) DMC World DJ Finals 2007 Indig02, The 02, London. www.dmcworld.com www.dmcdjchamps.com www.facebook.com/dmcdjchamps www.twitter.com/dmc_dj_champs | ["Electronic music", "Music", "Scratch", "Speech", "Inside, large room or hall"] | ["hiphop", "scratching", "e-guitar", "acoustic drums", "congas", "e-bass", "male voice sample", "slow tempo"] | 6 | 8oTTgXIO0-I | 946 | |
First World - Mad Weed | This song contains acoustic drums playing a simple hip hop groove along with a e-bass and e-guitars playing a simple repeating line. A male voice with a deeper voice is rapping on top of it. The song may be playing while having a BBQ in the garden with your friends. | 2009-10-31T15:09:26Z | OGDonNinja | 1994 http://www.discogs.com/First-World-Hip-Hops-Not-Over/release/2216755 | ["Electronic music", "Music", "Reggae", "Hip hop music"] | ["hiphop", "e-guitar", "e-bass", "acoustic drums", "male deeper voice rapping", "slow tempo", "laid back vibe"] | 6 | Zq92ED3IvLQ | 3419 | |
Chris Paul - Here comes the Hotstepper | This song contains a drumbeat with a funky bassline. A male voice is singing in a higher range. in the background you can hear different voice samples and scratching. This song may be playing while cruising down the street in your car. | 2008-02-07T18:29:09Z | LUXfinest | My Chris Paul Mix | ["Music", "Reggae"] | ["hiphop", "drums", "scratching", "e-bass", "vocal samples", "male voice singing", "laid back atmosphere", "slower tempo"] | 6 | h9zF09TMgLU | 4081 | |
Rek Large - Snappin Nex (rare indie rap) demo tape | A male voice is rapping in a higher pitch and with reverb and delay on his voice. An acoustic drum sample is playing a simple hip hop groove along with a tambourine like sound. The hihat is panned to the right side of the speakers. An e-bass is playing along. A clean e-guitar sample is being repeated as a melodic and rhythmic element. This song may be playing at home while cleaning the house. | 2011-09-15T19:38:13Z | MadHuman09 | NY - demo tape 93'. Props to Pat | ["Music", "Independent music", "Rapping", "Rhythm and blues", "Hip hop music"] | ["hiphop", "acoustic drum sample", "e-bass", "e-guitar sample", "male voice rapping", "higher pitch", "medium tempo"] | 6 | rG_6MS6_K6g | 4862 | |
Bomb First by Lloyd Banks - Directed By 50 Cent - HFM2 Coming Soon | 50 Cent Music | This song contains an acoustic drum sample playing a groove along with an e-bass line. A high pitched sound sample is playing along with an e-piano playing single notes in a higher register. A male voice is rapping in a higher register. In-between you can hear a gunshot and a male voice shouting. This song may be playing while doing sports. | 2010-04-21T05:00:14Z | 50 Cent | SUBSCRIBE: http://bit.ly/YeOjEy Lloyd Banks - ""Bomb First"" - Directed By 50Cent - HFM2 Coming Soon ""Bomb First"" Off of ""Halloween Havoc"" Directed by 50 Cent Download ""Halloween Havoc"" here: http://www.thisis50.com/page/thisis50-mixtape-vault Lloyd Banks' new album ""H.F.M.2"" coming summer 2010 ""Beamer, Benz, or Bentley"" 1st official single off his upcoming album. Download here - http://bit.ly/9UPdth watch video here: http://www.youtube.com/watch?v=OQE238J9toA About 50 Cent: Curtis James Jackson III, better known by his stage name 50 Cent, is an American rapper, entrepreneur, investor, and actor. This is his official YouTube Music Channel. Connect with 50 Cent Online: Visit 50 Cent Website: http://bit.ly/WM9S21 Like 50 Cent on Facebook: http://on.fb.me/XxuVyR Follow 50 Cent on Twitter: http://bit.ly/Y4XxPY Follow 50 Cent on Instagram: http://bit.ly/VLeAeX Buy 50 Cent Music Online: iTunes: http://bit.ly/1663kwB Amazon: http://amzn.to/14p4Gic Bomb First by Lloyd Banks - Directed By 50 Cent - HFM2 Coming Soon | 50 Cent Music http://www.youtube.com/user/50centmusic | ["Music", "Exciting music"] | ["hiphop", "e-piano", "e-bass", "sound sample", "acoustic drums sample", "gunshot", "male voice rapping", "higher register", "medium tempo"] | 6 | sjiE5CfyuHU | 4975 |
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;