musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic drums sample", musiccaps_aspects contains "e-piano" and musiccaps_names contains "Exciting music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;