musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "male vocal" and musiccaps_aspects contains "piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- bass guitar 5
- electric guitar · 5 ✖
- male vocal · 5 ✖
- piano · 5 ✖
- acoustic drums 4
- choir 2
- hip 2
- melodic singing 2
- rapping 2
- acoustic guitar 1
- amusing 1
- bleak 1
- christian contemporary music 1
- christian rock 1
- comedy 1
- dramatic singing 1
- easygoing 1
- electronic drums 1
- energetic 1
- funny 1
- gloomy 1
- groovy 1
- hip-hop 1
- hip-hop music 1
- medium tempo 1
- religious 1
- rising pattern 1
- rock 1
- rock opera 1
- soul music sample 1
- vibrant 1
musiccaps_names (array) 10 ✖
- Music 5
- Happy music 2
- Christian music 1
- Country 1
- Grunge 1
- Independent music 1
- Punk rock 1
- Rhythm and blues 1
- Soundtrack music 1
- Speech 1
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 | |
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 | |
Praying Mantis Eats Cricket | This is a rock opera piece. There is a male vocalist singing passionately with a choir of backing vocals. The piano plays the main theme with the electric guitar while a bass guitar plays in the background. The rhythmic background is provided by the acoustic drums playing a simple rock beat. There is an energetic atmosphere to the piece. This piece could be used at sports venues. It could also be playing in the background of a bar. | 2008-05-05T19:45:40Z | caz50 | One of my mantis nymphs munching on a cricket. | ["Music", "Punk rock", "Grunge"] | ["rock opera", "male vocal", "dramatic singing", "choir", "piano", "electric guitar", "bass guitar", "acoustic drums", "rising pattern", "vibrant", "energetic"] | 9 | QqRrZzOY2xw | 2642 | |
Cry In My Heart | This is a Christian rock/CCM piece. There is a male vocalist singing melodically. The main melody is being played by the acoustic guitar. The electric guitar, the piano and the bass guitar are playing in the background. The rhythm consists of an easygoing acoustic drum beat. The atmosphere is religious. This piece could be used in the soundtrack of a gospel movie. It could also be playing in the background at a Christian religious event. | 2008-04-04T03:20:47Z | fansofstarfield | "Cry In My Heart" There's a cry in my heart For Your glory to fall For Your presence to fill up my senses There's a yearning again A thirst for discipline A hunger for things that are deeper Could You take me beyond? Could You carry me through? If I open my heart? Could I go there with You? (For I've been here before But I know there's still more Oh, Lord, I need to know You) For what do I have If I don't have You, Jesus? What in this life Could mean any more? You are my rock You are my glory You are the lifter Of my head Lifter of this head | ["Music", "Independent music"] | ["christian rock", "christian contemporary music", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "piano", "acoustic drums", "easygoing", "religious"] | 9 | nT1YAP4Vy9s | 4540 | |
Kelly Ayotte: The Sound Of Silence | This is a rock music piece. There is a male vocalist singing melodically in the lead. A clean sounding electric is playing the main tune while a piano later joins in for texture. There is a mild sounding bass guitar. A basic rock acoustic drum beat provides the rhythmic structure. There is a gloomy aura to this song. It could be used in the soundtracks of drama movies and TV shows. | 2010-03-02T17:33:01Z | NHDP | ["Country", "Christian music", "Music"] | ["rock", "male vocal", "melodic singing", "electric guitar", "piano", "bass guitar", "acoustic drums", "gloomy", "bleak", "medium tempo"] | 9 | wKE9STHwX-Q | 5254 |
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;