musiccaps_details (view)
1 row where musiccaps_aspects contains "calm", musiccaps_aspects contains "classical music", musiccaps_aspects contains "dreamy" and musiccaps_aspects contains "percussive"
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
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;