musiccaps_details (view)
2 rows where musiccaps_aspects contains "higher register" and musiccaps_aspects contains "male voice rapping"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- higher register · 2 ✖
- male voice rapping · 2 ✖
- medium tempo 2
- acoustic drums sample 1
- backgroundnoises 1
- e-bass 1
- e-piano 1
- gunshot 1
- hiphop 1
- male voices talking 1
- mobile phones ringing 1
- rap 1
- sound sample 1
musiccaps_names (array) 5 ✖
- Music 2
- Dial tone 1
- Exciting music 1
- Music of Asia 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
//EXO ON CRACK | Buy Tao's special foam!!! | The recording contains two parts. One being a song with digital drums with a sub bass on the kick and a finger snapping sound used as a snare. A steeldrum sample is playing a repeating melody while a male voice is rapping in a higher pitch along to backing vocals creating a cheerful atmosphere. Then the song stops and you can hear mobile phones ringing. Two male voices are talking to each other. Then the recording stops with a beeping sound. This recording may be playing in a movie scene. | 2015-11-28T16:46:23Z | WH3RES MY HA1R | Le first EXO crack video! Plees like and subscribe for more I DONT OWN THE VIDEOS OR MUSIC IN THE VIDEO im sleepy ~-~ | ["Dial tone", "Music of Asia", "Music", "Speech"] | ["rap", "mobile phones ringing", "male voices talking", "backgroundnoises", "male voice rapping", "higher register", "medium tempo"] | 6 | LaaC_q3QDUE | 2202 | |
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;