musiccaps_details (view)
3 rows where musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "hip-hop" and musiccaps_aspects contains "male vocal"
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 |
---|---|---|---|---|---|---|---|---|---|---|
D-Tent Boys - Dig It (OST The Holes) [Official Music Video] [Exclusive!] | This is a comedic hip-hop music piece. There is a male vocal rapping in the lead. The melody in the beat is being played by the piano and the electric guitar while a bass guitar plays in the background. The rhythm is provided by an electronic drum beat. The piece has an amusing aura to it. It could be used in the background of funny social media content. | 2011-03-10T08:32:03Z | KhleoTeeFanPaqe | follow mee aht www.twitter.com/@khleo_t .... YouuTube Haters Lehs Goo ! | ["Music", "Soundtrack music", "Happy music"] | ["comedy", "hip-hop", "male vocal", "rapping", "piano", "electric guitar", "bass guitar", "electronic drums", "funny", "amusing", "hip"] | 9 | -jpbCWcz2pk | 78 | |
Z-Ro Ft. Mya - Tired Official video (with lyrics) Widescreen and HD | This is a hip-hop music piece. There is a duo of one male and one female vocal singing in a way that resembles rapping. The beat has an electric guitar and a bass guitar playing a groovy tune. The rhythmic background consists of an electronic drum beat. The atmosphere is urban. This piece could be playing in the soundtrack of a crime movie where the characters are doubting their actions. | 2009-03-11T22:15:57Z | 99esteban | 2nd video off crack God Damn When will a nigga get a brake I work so damn hard but I never come up I do worse with ever breath I take Sunshine is a leauxry Just to see another day is enough for me Cause I'm livin on borrowed time Every funeral I go to it might be mine it might be mine God Damn, I'm trying to hold on to my faith They use to tell me it was going to get greater later later Now it's later and I'm still I'm the same place Anytime I get off the ground Some crab in the bucket ass niggas pull me back down Bald fade on my fade Feeling helpless and it's written all over my face Here we go again just to live another season I keep my faith in god to peace these demons Sometimes I win the battle it doesnt mean I win the war I got to laugh to keep from crying good times I really wonder what they are Even if I fell there's no reason to feel asamed Cause I use to lose I had an opertuntly to play in the game I can't be stopped 98 percent from the field But they won't pass the rock Even tho I'm wide open for the shot Got me ready to scream fuck my team Seem like the players I'm running with don't want me to touch my dream With my own hands I'm tierd of makeing money in the name of brothers I'm trying to touch it with my own hands Make me wanna rob a bank somtimes But then I have to spend my life my life my life my life Dunken one time And end up back in the pen So I'm stuck as starter paid as if I was riden a bench I know it look like I rich but it's not I just how to take what I got and wipe it so it looks like alot Sometimes I wanna give up but when I look at my daughter I got to survive Here we go again just to live another season I keep my faith in god to peace these demons Sometimes I win the battle it doesnt mean I win the war I got to laugh to keep from crying good times I really wonder what they are To many niggas trying to take me off of my game I'm trying to do somthing good but beacuse I'm from the hood I always end up in these chains When you see m… | ["Reggae"] | ["hip-hop", "male vocal", "female vocal", "rap-like singing", "electric guitar", "bass guitar", "electronic drums", "groovy", "hip", "urban", "southern rap sound"] | 9 | GRdzFvQezUE | 1723 | |
Puff Daddy Ill Be Missing You | This is an R&B/soul music piece. There is a female vocal singing at a high pitch joined by a male vocal singing at a medium pitch and a female choir backing. The beat has a repeating electric guitar tune. There is a groovy bass line. The rhythm is provided by an electronic drum beat. The atmosphere is emotional and grandiose. This piece could be playing in the background at a memorial event. | 2009-03-24T09:22:59Z | Noti1986 | ["Singing", "Music of Asia", "Crowd", "Music"] | ["r&b", "soul", "hip-hop", "live performance", "female vocal", "male vocal", "female choir", "melodic singing", "electric guitar", "bass guitar", "electronic drums", "groovy", "emotional", "grandiose"] | 9 | vxIF3B4YqW8 | 5221 |
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;