musiccaps_details (view)
1 row where musiccaps_aspects contains "brass instruments", musiccaps_aspects contains "emotional", musiccaps_aspects contains "uplifting" and musiccaps_names contains "Electric piano"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;