musiccaps_details (view)
1 row where musiccaps_aspects contains "momentous", musiccaps_aspects contains "narration", musiccaps_aspects contains "string instruments" and musiccaps_aspects contains "violins"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Castle of Illusion Starring Mickey Mouse 100% Walkthrough P.11- The Castle - Act 3 (Boss Fight) | This is a cinematic orchestral piece which feels victorious and announces an important moment. There is narration over the music. The instruments are violins and brass instruments. There is a rapid and light flute melody at the end. | 2013-09-05T06:22:53Z | packattack04082 | Disney Castle of Illusion Staring Mickey Mouse 100% walkthrough part 11. #Disney #CastleofIllusion #MickeyMouse I'll be showing the location of the Castle Statue Pieces, Donald's Chili Peppers, Magic Playing Cards and all 75 Diamonds for each stage. This video includes the level called The castle - Act 3, which is the boss fight for The Castle world. This game is a remake of the genesis game of the same name. This channel features instructional & highly edited video game guides, walkthroughs, speedruns and other uniquely transformative videos. My own personal gameplay, extensive editing & creative input are clearly added into each video, ensuring that all videos adhere to YouTube's partner program guidelines. My walkthoughs take tremendous amounts of work & editing so that all videos are straight to the point & can be used as professional video game guides. All gameplay is my own & is recorded and edited solely by me. Permission to upload each game was provided by the game publisher. Castle of Illusion Starring Mickey Mouse Playlist https://www.youtube.com/playlist?list=PLYpDU5ElRBfmyTqt5mA5VCzUDlsZKdsyq | ["Electric piano", "Keyboard (musical)", "Piano"] | ["narration", "music backing", "string instruments", "violins", "brass instruments", "orchestral", "cinematic", "momentous", "rapid flute melody"] | 3 | VrqBeY3kfKI | 3036 |
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;