musiccaps_details (view)
1 row where musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "hip", musiccaps_aspects contains "rap-like singing" and musiccaps_names contains "Reggae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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;