musiccaps_details (view)
2 rows where musiccaps_aspects contains "male voice rapping" and "youtube_published" is on date 2010-04-21
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Sound of Dubstep (Ministry of Sound) Mega Mix | This song contains digital drums playing along with a raw synth bass sound playing a melody while a male voice is rapping in a higher key. Then a female voice takes over singing a melody along to the bass. This song may be playing loud when at home alone. | 2010-04-21T11:05:23Z | Ministry of Sound | BUY NOW @ HMV - http://bit.ly/cCxAaE BUY NOW @ ITUNES - http://bit.ly/cjeguR Ministry of Sound brings you the latest buzz genre to emerge from the underground club scene. Over the last couple of years Dubstep has risen to prominence with mass exposure across national radio, being championed by the likes of Annie Mac & Zane Lowe on Radio 1 as well as massive club nights surfacing all over the world. Having been the first to bring out a collection of Bassline as it hit its peak, The Sound of Dubstep is now the freshest sound in dance music and makes this an essential purchase for all people that like their raw bass. The Sound of Dubstep is the first TV album to bring together all the biggest tunes, allowing you to experience the low bass frequencies bought to you by the pioneers of the scene including Skream, Benga, Caspa, Rusko & Doorly. With massive remixes of The Prodigy, MJ Cole, Dizzee Rascal, Calvin Harris and loads more. This is the ultimate collection of over 40 classic and exclusive heavy hitting tracks that is destined cause some serious damage! http://bit.ly/MoStv | ["Music", "Dubstep", "Hip hop music"] | ["dubstep", "digital drums", "synth bass", "male voice rapping", "female voice singing", "uptempo", "energetic"] | 6 | BgTB_xt11bA | 1274 | |
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;