musiccaps_details (view)

1 row where musiccaps_aspects contains "calm", musiccaps_aspects contains "classical music" and musiccaps_aspects contains "recital"

✎ 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
Sally Beamish - Awuya (performed by Anne Denholm) This is the live recording of a classical music recital. There is a harp being played in an innovative manner that combines both the melodic and the rhythmic aspects of the instrument. The atmosphere of the piece is dreamy. It could be used in the soundtrack of a calm video game or a nature documentary. 2014-01-28T08:21:30Z Sally Beamish Music Music by Sally Beamish Performed by Anne Denholm Produced by Laurie Irvine Performed by the outstanding young harpist, Anne Denholm, the piece was commissioned by Glasgow University for Professor Keith Vickerman, to celebrate his groundbreaking research in the field of African Sleeping Sickness. Awuya is inspired by the changing forms of deadly trypanosomes, by Central African drums and harp, and by a lullaby from a tribe decimated by sleeping sickness in the 1940s. The original words of the lullaby, sung to a little girl called Awuya, are hauntingly reminiscent of the symptoms of the disease. In his new film, Laurie Irvine has incorporated these ideas, enhancing Anne's powerful performance. This film was made possible with funding from Creative Scotland www.sallybeamish.com Follow Sally Beamish on Twitter: @sallybeamish Follow Anne Denholm on Twitter @anne_denholm ["Wood block", "Percussion"] ["classical music", "recital", "live performance", "instrumental", "single instrument", "harp", "melodic", "percussive", "innovative", "dreamy", "calm"] 9 Ux3YosKD-9I 2959

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;