musiccaps_details (view)
3 rows where musiccaps_aspects contains "dreamy", musiccaps_aspects contains "harp" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- dreamy · 3 ✖
- harp · 3 ✖
- instrumental · 3 ✖
- calming 2
- classical music 2
- ethereal 2
- mellow 2
- slow tempo 2
- soothing 2
- beautiful 1
- bow shaped harp 1
- calm 1
- cascading melody 1
- celestial 1
- chordophone 1
- clear 1
- enigmatic 1
- flowing 1
- full sounding 1
- gentle 1
- harp solo 1
- innovative 1
- live performance 1
- melancholic 1
- melodic 1
- melodic piano 1
- minimalist 1
- oldest instrument 1
- peaceful 1
- pensive 1
- percussive 1
- plucked string instrument 1
- poignant 1
- recital 1
- resonating 1
- rich 1
- shaker song 1
- sharp sound 1
- single instrument 1
- stringed instrument 1
- violin harmony 1
- western classical 1
- wind instrument 1
musiccaps_names (array) 8 ✖
- Background music 1
- Harp 1
- Music 1
- Percussion 1
- Pizzicato 1
- Sad music 1
- Theme music 1
- Wood block 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dragon Music - Sad Moments | This music is a soothing instrumental. The tempo is slow with a beautiful violin symphony, romantic piano accompaniment, harp melody, a wind instrument and shakers. The music is mellifluous, gentle,pensive, nostalgic, poignant, melancholic, romantic, enthralling, enigmatic, dreamy, calming and ethereal. | 2011-06-01T12:35:57Z | DarkLuna x | ["Background music", "Theme music", "Music", "Sad music"] | ["instrumental", "slow tempo", "violin harmony", "melodic piano", "melancholic", "shaker song", "pensive", "poignant", "harp", "wind instrument", "soothing", "mellow", "calming", "enigmatic", "ethereal", "dreamy", "peaceful", "pensive"] | 7 | 3OUNEL8XaR0 | 461 | ||
Bach Prelude and Fugue BWV 539 | This music is a beautiful Harp instrumental. The tempo is slow with a mellow, gentle and rich Harp melody. The music is dreamy, cascading, ethereal, soothing, calming and harmonic. This music is a Western Classical Harp Solo. | 2011-01-08T20:54:38Z | cbembia | Caroline Bembia playing Bach's Prelude and Fugue in d minor, transcribed for harp | ["Harp", "Pizzicato"] | ["instrumental", "slow tempo", "harp", "gentle", "mellow", "soothing", "harp solo", "minimalist", "celestial", "ethereal", "beautiful", "calming", "stringed instrument", "plucked string instrument", "classical music", "western classical", "bow shaped harp", "chordophone", "oldest instrument", "full sounding", "clear", "flowing", "dreamy", "resonating", "sharp sound", "cascading melody", "rich"] | 7 | POOu05eUvqE | 2531 | |
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;