musiccaps_details (view)
1 row where musiccaps_aspects contains "groovy", musiccaps_aspects contains "hip-hop music", musiccaps_author = 9 and musiccaps_names contains "Speech"
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 Game-From Adam ft Lil Wayne-The Documentary 2.5 (NEW 2015) Lyrics in the description! | This is a hip-hop music piece. There is a male vocal rapping in the lead. The beat has a soul music sample as the main structure. There is a choir singing melodically. The piano and the electric guitar are playing the tune with the backing of a bass guitar. The rhythmic background consists of a mild tempo acoustic drum beat. The atmosphere is groovy. This piece could be used in the soundtrack of a crime movie, especially during the scenes where a long-lost rival is making a comeback in the town. | 2015-10-12T11:02:12Z | TheRealTunechi YM | The Game - From Adam (ft. Lil Wayne) (Prod. Cool & Dre) Lyrics: [Intro: Game] Here we go again Ten years later You know what man? Uhm (I wanna know) Fuck it Ayo C Give me that Jamison and that pickle juice Thank you I got some shit on my mind (I wanna know) [Verse 1: Game] My little nigga Frog dead, dog They shot my little nigga in his head, dog You heard what the fuck I just said, dog? Walk inside my closet like fuck everything red, dog If you seen your best friend stiff, you would cry too Sometimes I don't even wanna be a Piru Then I think about it like, fuck everything blue Who killed my motherfuckin' brother? (I wanna know) Who killed G man too? The shit I seen men do If I told you, I'd have me floating in cement shoes See Compton ain't shit really And I’ve been at the bottom of the pits, feel me? I done had some real niggas try to kill me Fake niggas in my crew Crip niggas more loyal than a few of my Piru I done been shot, had a surgery or two Above the rim like Pac, I’m like birdie at the troops I can’t lie, every time I see Suge my heart beat Cause I don’t know if I should dap him or let the hawk speak Wilmington and Brazil, nigga them my cross streets And who gon’ take it from me? [Hook: Lil Wayne] They think they know me But they do not know me Cause I do not know me Who killed my homie? I wanna know names Click-clack explain I can kill you but ain’t nothing gon' change But I might do it anyway You gonna die any way I’m gonna die any way We can go any day It can be any day But for you Today is the day Today is the day [Verse 2: Game] I was playing Madden then I heard a knock Everybody know I got shot but this for niggas that forgot Sometimes I thank God that I got set up When you shot twice in the chest, it's kinda hard to keep your head up Suspect one: the homies never came to see me Suspect two: Red hid my gun behind the TV Suspect three: I was beefing with this Crip in my apartment Shit started cause we fought and he couldn't see me There's usually ten niggas in our dope spot Cold ass night, I'm … | ["Music", "Rhythm and blues", "Speech", "Happy music"] | ["hip-hop music", "male vocal", "rapping", "soul music sample", "choir", "piano", "electric guitar", "bass guitar", "acoustic drums", "hip", "groovy"] | 9 | 9zmQwBUFwd4 | 1055 |
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;