musiccaps_details (view)
2 rows where musiccaps_aspects contains "harp" and musiccaps_aspects contains "minimalist"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- celestial 2
- harp · 2 ✖
- minimalist · 2 ✖
- slow tempo 2
- ambient 1
- beautiful 1
- bow shaped harp 1
- calming 1
- cascading melody 1
- chordophone 1
- classical music 1
- clear 1
- dreamy 1
- ethereal 1
- ethereal harmony 1
- female harpist 1
- female vocalist 1
- flowing 1
- full sounding 1
- gentle 1
- harp solo 1
- instrumental 1
- mellow 1
- melodic 1
- oldest instrument 1
- peaceful 1
- performance 1
- plucked string instrument 1
- resonating 1
- rich 1
- sharp sound 1
- solo 1
- soothing 1
- soothing calming 1
- soprano 1
- soulful 1
- stringed instrument 1
- western classical 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lascia ch'io Pianga | A female vocalist sings this beautiful melody in soprano . The tempo is slow with a harp accompaniment. The song is mellow, soothing, sentimental,calming, ethereal, and dulcet. | 2009-08-31T13:35:19Z | webarp | Chloé chante Lascia ch'io Pianga en s'accompagnant à la harpe. Cette pièce est extraire de l'opéra "Rinaldo" de G.F. Haendel. Enregistrement en concert à l'eglise de Cuzion le 23 Août 2009. Dommage qu'il y ait des bruits dans la salle (Bébé bavard et joueur!) | ["Gospel music", "Music", "Opera"] | ["female vocalist", "slow tempo", "harp", "female harpist", "soprano", "solo", "minimalist", "melodic", "celestial", "ethereal harmony", "peaceful", "soothing calming", "performance", "ambient", "soulful"] | 7 | 7qaRlUc4fb0 | 887 | |
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 |
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;