musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_author = 9 and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- acoustic drums · 3 ✖
- bass guitar 3
- electric guitar 2
- groovy 2
- male vocal 2
- acoustic guitar 1
- background music 1
- bells 1
- choir 1
- description 1
- generic 1
- high pitch singing 1
- hip 1
- hip-hop music 1
- jingle 1
- male narrator 1
- male voice 1
- piano 1
- product review 1
- r&b music 1
- rapping 1
- sit-com soundtrack 1
- soul music sample 1
- urban 1
musiccaps_names (array) 6 ✖
- Music 3
- Speech · 3 ✖
- Happy music 1
- Music for children 1
- Rhythm and blues 1
- Ska 1
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 | |
GASP, Hardcore, Wrist Wraps | This is a product review video. There is a male voice describing the product. In the background music, there is a very generic jingle that contains an acoustic guitar, a bass guitar, an acoustic drum beat and bells. If the track can be isolated from the piece, it could be used as an advertisement jingle. | 2014-06-04T09:32:13Z | Bodybuilding Singapore | BUY FROM https://www.amazon.com/gp/search?ie=UTF8&tag=carlingnets0d-20&linkCode=ur2&linkId=afcb849ff72bf7c560a563a94352691c&camp=1789&creative=9325&index=aps&keywords=Wrist%20Wraps | ["Music", "Music for children", "Speech"] | ["product review", "male voice", "description", "background music", "jingle", "generic", "acoustic guitar", "bass guitar", "bells", "acoustic drums"] | 9 | RxBFh-zdid4 | 2731 | |
Everybody Hates Chris | This is an R&B music piece from a sit-com soundtrack. Initially, there is a male voice narrating what is going on in the episode. Then the piece starts playing with a high pitched male vocal at the forefront. The melody is being played by the electric guitar and the bass guitar while the rhythmic background consists of an acoustic drum beat. The atmosphere is urban. | 2007-02-10T13:09:18Z | tigerzrule | My Personal Fav Bits OF EHC | ["Music", "Ska", "Speech"] | ["sit-com soundtrack", "male narrator", "r&b music", "male vocal", "high pitch singing", "electric guitar", "bass guitar", "acoustic drums", "groovy", "urban"] | 9 | T78nMdsJMmk | 2810 |
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;