musiccaps_details (view)

1 row where musiccaps_aspects contains "soothing", musiccaps_author = 6 and musiccaps_names contains "Theremin"

✎ View and edit SQL

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
Experimental Electronic Music (1984-1989): Excerpts from 5 Songs A high pitched long note is playing along with other synthesizer pad sounds to create a bizarre and mildly creepy atmosphere. A synthesizer lead is playing a disharmonious melody. The sounds are full of reverb and delay. This song may be playing in an alien arrival movie scene. 2010-01-17T13:52:45Z music by longzijun I recorded these original experimental music compositions in the 1980s and recently recovered them from twenty-year-old cassette tapes. The first excerpt is from a work that was recorded at Fanshawe College in London, Ontario. The other songs were recorded at Carleton University in Ottawa. #ExperimentalMusic #electronica #longzijun The video clips are processed (using AfterEffects) screen captures (using CamStudio) of music visualizations (using the iTunes and Dr. Glitter visualizers). Track 1. Blade: http://www.youtube.com/watch?v=qTSPsu9vkYc 'Blade' features drums, synthesizer (Yahama DX-7), alto saxophone, voices, a bicycle pump, coins, pieces of wood, glasses of water and probably a few things I have forgotten about. This was recorded at Fanshawe College with my classmates in the Music Industry Arts program. We had some free time and I had an idea kicking around in my head, so we just went into one of the studios (the small one) and recorded it one afternoon. (I left the MIA programme shortly after the recording to work, saved up some money and then went on to study at university). Track 2. Young Sycamore: http://www.youtube.com/watch?v=V7RPmwxyhBA Young Sycamore' has live vocal and percussion parts that weren't recorded. It was only performed once. The lyrics were adapted from a poem by Wlliam Carlos Williams. The piece was written/played using the software 'PC Composer' and a midi controller. It was recorded at the Computer Music room at Carleton University. Track 3. Untitled: http://www.youtube.com/watch?v=kdO-5iTFCMs 'Untitled' features an EMS Synthi 100, a synthesizer from the early 70s. The device takes up half of small room and is interesting to use because you have to physically connect all the different sound items like sine waves, noise and filters. According to Wikipedia, only about 30 of these synthesizers were produced and their original selling price was 25,000 USD (the equivalent of over $100,000 USD today). If I had known it was so rare and expensive, maybe I would have appreci… ["Music", "Theremin"] ["experimental", "electronic music", "synthesizer strings and pads", "bizarre and creepy atmosphere", "soothing"] 6 zPhuyMYy9EI 5473

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;