musiccaps_details (view)

1 row where musiccaps_aspects contains "theremin", musiccaps_names contains "Theremin" and "youtube_published" is on date 2015-11-08

✎ 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
Kate Bush - Babooshka (Cover): Theremin Session #7 Someone is playing soft and warm sounding chords on an analog synthesizer slowly opening up a filter letting higher frequencies pass. Someone is playing a melody along on a theremin. Both are playing in the mid to higher range. This song may be playing live. 2015-11-08T18:29:02Z Carolina Eyck This week performing "Babooshka" by Kate Bush together with Marius Leicht: https://youtube.com/mariusleicht Using the following instruments: Moog Prodigy (1980) with Roland Space Echo (produced 1973-1988) Sequential Circuits Prophet 5 Rev 3.3 (1982) with Strymon Timeline (2014) dTape Maschine and Moog MP-201 pedal controlling the filter cutoff frequency Moog Etherwave Pro theremin (2006) with Boss Digital Delay DD-7, Harmonist PS-6 and Loop Station RC-50 -- To take part in this video project, comment or send me your suggestions for an improvisation. This can be: a) a word or sentence b) a photo, a drawing/sketch or painting of yours c) a recording of you playing your instrument d) a video of you playing your instrument I choose one suggestions every week to play an improvisation in the end of the video. Looking forward to your ideas! --- Previous Video "Duo with Oud": https://youtu.be/cLHZdTCcilQ Information about the background paintings: http://carolinaeyck.com/pages/theremin-sessions WEBSITE: http://carolinaeyck.com FACEBOOK: https://facebook.com/carolinaeyck TWITTER: https://twitter.com/CarolinaEyck INSTAGRAM: https://instagram.com/carolinaeyck ["Music", "Musical instrument", "Theremin", "Synthesizer"] ["synth pop", "analog synthesizer", "theremin", "uptempo", "warm", "soft sounding"] 6 raM8Lp0aGCk 4888

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;