musiccaps_details (view)
2 rows where musiccaps_aspects contains "brass instruments" and musiccaps_aspects contains "uplifting" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- brass instruments · 2 ✖
- uplifting · 2 ✖
- build-up 1
- classical music 1
- emotional 1
- epic 1
- french horn 1
- hopeful 1
- impressive 1
- piano 1
- string instruments 1
- timpani 1
- trumpets 1
musiccaps_names (array) 9 ✖
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 | |
Richard Strauss - Also Sprach Zarathustra (das Ziege) [Opening of 2001: A Space Goat Odyssey] | This is a classical orchestral piece. The melody played on the trumpets feels like a prelude to an important, impressive moment. This music would suit any momentous occasion - like the countdown to a rocket launch. | 2013-02-28T09:51:34Z | switchmodthree | Wait for it... :) --------------------- Source: http://www.youtube.com/watch?v=Y9QxaJLt7EA | ["Timpani", "Brass instrument", "Music", "Musical instrument", "Orchestra", "Classical music"] | ["classical music", "brass instruments", "trumpets", "timpani", "build-up", "epic", "uplifting", "impressive"] | 3 | LSaLPObrnZw | 2190 |
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;