musiccaps_details (view)

1 row where musiccaps_aspects contains "contemporary", musiccaps_aspects contains "instrumental" and musiccaps_names contains "Musical instrument"

✎ 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
Carolina Eyck /Theremin - Elephant in Green (live 2015) This is a contemporary classic music piece being performed on a theremin. The player gives the theremin and electronic sounding character. The atmosphere is weird and eccentric. This piece could go well in the soundtrack of an absurdist/surrealist art movie. 2015-05-17T17:11:22Z Carolina Eyck This song is available for streaming and download on my new album for Theremin & Voice "Elephant in Green" https://www.carolinaeyck.com/elephant-in-green 🐘💚 ------- Encore after the performance of Kalevi Aho's Theremin Concerto "Eight Seasons" with Staatskapelle Halle and conductor Luke Dollman. Performed live on April 20, 2015 at the Georg-Friedrich-Händel-Halle in Halle, Germany. WEBSITE: http://carolinaeyck.com FACEBOOK: https://facebook.com/carolinaeyck TWITTER: https://twitter.com/CarolinaEyck Many thanks to Tom Fichtner for the recording! ["Music", "Musical instrument", "Theremin"] ["classical music", "contemporary", "theremin", "electronic sounding", "instrumental", "weird", "eerie", "eccentric"] 9 MX0wS7MX3Zo 2277

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;