musiccaps_details (view)
5 rows where musiccaps_aspects contains "piano", musiccaps_author = 9 and musiccaps_names contains "Happy music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- piano · 5 ✖
- acoustic drums 4
- bass guitar 4
- electric guitar 3
- male vocal 3
- female vocal 2
- hip 2
- rapping 2
- acoustic guitar 1
- amusing 1
- ballad 1
- cartoon theme 1
- childlike 1
- choir 1
- comedy 1
- country music 1
- easygoing 1
- electronic drums 1
- flute 1
- funny 1
- gentle singing 1
- groovy 1
- hip-hop 1
- hip-hop music 1
- japanese 1
- melodic singing 1
- merrily singing 1
- playful 1
- positive 1
- rock 1
- romantic 1
- sentimental 1
- simple tune 1
- soul music sample 1
- strings 1
- thai 1
- upbeat 1
- uplifting 1
- valentines 1
musiccaps_names (array) 8 ✖
- Happy music · 5 ✖
- Music 5
- Exciting music 1
- Music of Asia 1
- Rhythm and blues 1
- Song 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 | |
รวมลูกทุ่งเพลงรักต้อนรับวานเลนไทน์ | Happy Valentines Love Music | This is a Valentine's ballad. The male vocalist is singing gently in the Thai language. There is an acoustic guitar, a piano and a flute playing the melody interchangeably. There is a simple acoustic drum beat in the rhythmic background. The atmosphere of this piece is romantic. It could be used in romantic social media content in Thailand. It could also be used in romantic movies and TV shows that take place in Thailand. | 2016-02-05T05:56:27Z | ป.ฉลาดใหญ่ | รวมลูกทุ่งเพลงรักต้อนรับวานเลนไทน์ | Happy Valentines Love Music ฝากกดติดตามช่อง ป.ฉลาดใหญ่ บันเทิงศิลป์ ด้วยนะครับ คลิกที่ลิ้งค์เลย https://www.youtube.com/channel/UC98T... แสลงใจ อ้ายมีเขา แต่เจ้ามีอ้าย กลิ่นไฟเก่า บ่ฮักกะส่าง อยู่กับอ้ายน้อยใจบ่ ผัวสำรอง เมียสำรอง ฮัก คารม ซ่อยข่อยแหน่ | ["Music of Asia", "Music", "Song", "Happy music"] | ["ballad", "male vocal", "gentle singing", "acoustic guitar", "piano", "flute", "acoustic drums", "sentimental", "romantic", "valentines", "thai"] | 9 | L0oun9F67tg | 2142 | |
Hot Top Country Music Josie Brandon - So Cool (Official Music Video) | This is a country music piece. There is a female vocalist singing melodically at the forefront. The melodic background consists of the electric guitar, the bass guitar and the piano. The rhythmic background is provided by a simple acoustic drum beat. The atmosphere is upbeat and easygoing. This piece could be playing in the background at a rock bar. It could also work well as an advertisement jingle. | 2012-07-10T23:34:20Z | ARIZONA HEALING RETREATS PAIN TO PROMISE WORKSHOP | DOWNLOAD ALBUM OR SONGS AT www.JosieBrandonMusic.Com Top Hot Original Country Music, Crazy Week, Original Music & Lyrics by Josie Brandon, Nigel Lythgoe. This Opening Act Will Rock The House! CMT Country Music Television, Sexiest Country Music Videos, Great American Country, Country Hits | ["Music", "Happy music", "Exciting music"] | ["country music", "rock", "female vocal", "melodic singing", "electric guitar", "piano", "bass guitar", "acoustic drums", "simple tune", "upbeat", "easygoing"] | 9 | suX7Cri4kAo | 4986 | |
Doraemon Opening Theme Song (Japanese Version) | This is the theme of a cartoon. There is a female vocalist singing merrily at a medium-to-high pitch in the Japanese language. The melody is being played on the strings and the piano while a simple on-beat bass line can be heard being played in the background. There is a simple 4/4 acoustic drum beat for the rhythm. The piece has an uplifting atmosphere. This piece could be used in the soundtrack of a children's movie. It could also be used in anime soundtracks. | 2012-04-28T03:24:44Z | Jennifer Nguyen | Doraemon Opening Theme Song (Japanese Version) | ["Music", "Happy music"] | ["cartoon theme", "female vocal", "merrily singing", "strings", "piano", "bass guitar", "acoustic drums", "playful", "uplifting", "positive", "childlike", "japanese"] | 9 | wBozBh7BR6k | 5247 |
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;