musiccaps_details (view)
2 rows where musiccaps_aspects contains "cinematic", musiccaps_aspects contains "string instruments" and musiccaps_author = 3
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- cinematic · 2 ✖
- string instruments · 2 ✖
- brass instruments 1
- electric bass guitar playing 1
- electric guitar arpeggio 1
- emotional 1
- epic 1
- momentous 1
- music backing 1
- narration 1
- orchestral 1
- orchestral music 1
- rapid flute melody 1
- violins 1
musiccaps_names (array) 5 ✖
- Electric piano 1
- Keyboard (musical) 1
- Music 1
- New-age music 1
- Piano 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DPRK Music 1-15 어머니의 노래 | The song feels cinematic and momentous. It's an orchestral piece with string instruments, and then with an electric guitar lick. The emotion is gripping and a little sombre. | 2008-08-25T06:06:02Z | chosunmusiccom | Chosun Music Disc 1 - North Korean Karaoke Song | ["New-age music", "Music"] | ["orchestral music", "cinematic", "string instruments", "emotional", "electric guitar arpeggio", "electric bass guitar playing", "cinematic", "epic"] | 3 | BquHBzP5Ep0 | 1295 | |
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;