musiccaps_details (view)
2 rows where musiccaps_aspects contains "creepy" and musiccaps_names contains "Theremin"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- creepy · 2 ✖
- unsettling 2
- bass guitar 1
- bizarre 1
- high-pitched sounds 1
- homemade theremin 1
- instrumental 1
- jam 1
- live performance 1
- percussion 1
- theremin 1
- weird 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
supertalent 2009 theremin, seaweed | This is a live performance of a theremin piece. The theremin is playing eerie high-pitched sounds in the lead while the bass guitar and the percussion is playing in the background. The atmosphere is creepy and unsettling. This piece could be used in the soundtrack of a horror movie or a horror video game. | 2006-09-11T14:19:03Z | pedda Borowski | performance with barbara buchholz; theremin and pedda borowski: overheadprojection | ["Music", "Theremin"] | ["live performance", "instrumental", "theremin", "bass guitar", "percussion", "weird", "unsettling", "creepy"] | 9 | UXDzDV_f1jw | 2923 | |
My Simple Homemade Theremin | This is a jam performed on a homemade theremin instrument. There are irritatingly high-pitched sounds coming from the theremin. The atmosphere is creepy and unsettling. The sounds in this recording could be sampled for use in beat-making. | 2013-01-30T04:22:44Z | Chris Caglayan | This instrument was invented in 1919 by Leon Theremin. I decided to design the simplest version of Theremin. I`ve never played this instrument before, so don`t expect any nice music in my video:):) This is only demonstration of my design. | ["Theremin"] | ["jam", "homemade theremin", "high-pitched sounds", "creepy", "bizarre", "unsettling"] | 9 | nsxaoH9DjDo | 4585 |
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;