musiccaps_details (view)
2 rows where musiccaps_aspects contains "spooky" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- spooky · 2 ✖
- cinematic 1
- creeping 1
- fearful male muttering 1
- full ensemble melody 1
- lurching 1
- orchestra 1
- piano counter melody 1
- quirky 1
- sci-fi 1
- string bass ensemble 1
- theremin melody 1
- video game music 1
- waltz 1
- wide vibrato synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Luigi's Mansion Music - Mansion (Luigi Humming Low Health) | A synthesizer holds a note with increasingly wide vibrato then joins the string bass ensemble in playing a lurching, creeping melody. Sounds like music from a spooky video game. Fearful male muttering can also be heard. | 2012-02-14T04:51:08Z | CuriousCoins | Track 024 Composers: Kazumi Totaka; Shinobu Tanaka Luigi's Mansion © Nintendo | ["Theme music", "Humming", "Music", "Soundtrack music"] | ["wide vibrato synthesizer", "full ensemble melody", "string bass ensemble", "fearful male muttering", "video game music", "lurching", "creeping", "spooky"] | 8 | SCcryBmDGPw | 2747 | |
Celia Sheen plays Midsomer Murders on Theremin | An orchestra plays a waltz supporting a Theremin which takes the lead melody while the piano plays a counter melody. The feel is cinematic, spooky and a bit quirky. | 2009-01-17T21:29:10Z | randomnotegenerator | Celia Sheen plays the theme tune from ITV's drama series "Midsomer Murders" on the Theremin. She has done so, along with incidental music, on the soundtrack of every episode for fourteen years. This fascinating instrument was the world's very first electronic instrument, invented in 1920 by Russian scientist Lev Theremin. Of course, nobody ever sees Celia's performances on the recordings, but what makes it interesting is that the Theremin is played without being touched! | ["Background music", "Music", "Opera", "Theremin"] | ["spooky", "theremin melody", "sci-fi", "waltz", "orchestra", "piano counter melody", "cinematic", "quirky"] | 8 | YTZK9FNgK74 | 3288 |
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;