musiccaps_details (view)
2 rows where musiccaps_aspects contains "hopeful" and musiccaps_aspects contains "piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- hopeful · 2 ✖
- piano · 2 ✖
- brass instruments 1
- busy kick pattern 1
- choir 1
- emotional 1
- female singer 1
- finger snaps 1
- french horn 1
- gospel 1
- group vocals 1
- low fidelity recording 1
- male rapper 1
- slow tempo 1
- spiritual 1
- string instruments 1
- uplifting 1
musiccaps_names (array) 7 ✖
- /t/dd00003 1
- Choir 1
- Electric piano 1
- Keyboard (musical) 1
- Music 1
- Piano 1
- Synthetic singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Charles aka Faithful Singing Pleasure P Did U Wrong | A low fidelity recording of a gospel choir with group vocals, a female singer, a male rapper, piano, a busy kick pattern, finger snaps and a slow tempo. The mood is hopeful and spiritual. | 2007-12-11T05:35:03Z | Nook4pound | Pleasure | ["Music", "Choir", "/t/dd00003", "Synthetic singing"] | ["low fidelity recording", "gospel", "choir", "piano", "group vocals", "female singer", "male rapper", "busy kick pattern", "finger snaps", "slow tempo", "hopeful", "spiritual"] | 8 | 01hjVJN9xCg | 111 | |
Wicked - For Good (Karaoke Instrumental) w/ Lyrics | This is an instrumental song. We have piano, brass, and string instruments. The piano melody is light and dainty, but also uplifting and positive. The pattern is like a dance among the clouds. The string instruments are violins, and the brass being the french horn. The brass gives the clip the sense of importance and grand atmosphere. | 2012-05-08T01:03:19Z | QualityKaraoke1 | Lyrics from eLyrics (It's always good to compare!) (Elphaba): Im limited Just look at me - Im limited And just look at you You can do all I couldn't do, Glinda So now it's up to you For both of us - now it's up to you... (Glinda): I've heard it said That people come into our lives for a reason Bringing something we must learn And we are led To those who help us most to grow If we let them And we help them in return Well, I don't know if I believe that's true But I know I'm who I am today Because I knew you... Like a comet pulled from orbit As it passes a sun Like a stream that meets a boulder Halfway through the wood Who can say if I've been changed for the better? But because I knew you I have been changed for good (Elphaba): It well may be That we will never meet again In this lifetime So let me say before we part So much of me Is made from what I learned from you You'll be with me Like a handprint on my heart And now whatever way our stories end I know you have re-written mine By being my friend... [- From :http://www.elyrics.net/read/w/wicked-lyrics/for-good-lyrics.html -] Like a ship blown from its mooring By a wind off the sea Like a seed dropped by a skybird In a distant wood Who can say if I've been changed for the better? But because I knew you (Glinda): Because I knew you (Both): I have been changed for good (Elphaba): And just to clear the air I ask forgiveness For the things I've done you blame me for (Glinda): But then, I guess we know There's blame to share (Both): And none of it seems to matter anymore (Glinda): Like a comet pulled from orbit As it passes a sun Like a stream that meets a boulder Halfway through the wood (Elphaba): Like a ship blown from its mooring By a wind off the sea Like a seed dropped by a bird in the wood (Both): Who can say if I've been Changed for the better? I do believe I have been Changed for the better (Glinda): And because I knew you... (Elphaba): Because I knew you... (Both): Because I knew you... I have been changed for good... High Quality version … | ["Electric piano", "Keyboard (musical)", "Piano"] | ["piano", "string instruments", "emotional", "brass instruments", "french horn", "uplifting", "hopeful"] | 3 | K5ilD6nEJ-g | 2056 |
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;