musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "piano", musiccaps_aspects contains "uplifting", musiccaps_names contains "Electric piano" and musiccaps_names contains "Keyboard (musical)"
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Year of the Sheep Anthem | This is a piano-based ballad. The song is emotional, uplifting and generally pulls on your heartstrings. The singer sounds passionate and sings legato notes while the violins play sustained notes behind him to create an even more dramatic effect. | 2015-02-19T23:14:32Z | Real Big Boys | The Chinese New Year is today and this year marks the Year of the Sheep. So without further ado, here's Kenny the Sheep singing The Year of the Sheep Anthem. | ["Electric piano", "Keyboard (musical)", "Piano"] | ["piano", "ballad", "emotional", "violins", "uplifting", "touching", "goosebumps", "passionate male singer"] | 3 | FgUSmmTEE3M | 1660 | |
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;