musiccaps_details (view)
3 rows where musiccaps_aspects contains "dreamy" and musiccaps_aspects contains "western classical"
This data as json, CSV (advanced)
musiccaps_aspects (array) 66 ✖
- celestial 3
- classical music 3
- dreamy · 3 ✖
- slow tempo 3
- western classical · 3 ✖
- calming 2
- enchanting 2
- ethereal 2
- harp 2
- instrumental 2
- mellow 2
- mystical 2
- oldest instrument 2
- soothing 2
- ancient lineage instrument 1
- angelic 1
- beautiful 1
- bow shaped harp 1
- buzzing sound 1
- cascading melody 1
- catholic prayer 1
- catholic salutation 1
- choral symphony 1
- chordophone 1
- clear 1
- dulcet 1
- elegy 1
- emotional 1
- enigmatic 1
- enthralling 1
- falsetto 1
- female harpist 1
- female singer 1
- flowing 1
- full sounding 1
- gentle 1
- harmony 1
- harp solo 1
- heavenly 1
- high notes 1
- latin music 1
- latin song 1
- magical 1
- magicalvocalisation 1
- meditative 1
- melancholic 1
- melodic 1
- minimalist 1
- ost 1
- pensive 1
- plucked string instrument 1
- plucking 1
- resonating 1
- resonator 1
- rich 1
- sentimental 1
- serene 1
- sharp sound 1
- soft 1
- soft piano 1
- soprano 1
- soundtrack 1
- stringed instrument 1
- vocal harmony 1
- vocalisation 1
- wistful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tokyo Ghoul - Soundtrack [OST] Battle Theme (Symphony) | This song is an operatic harmony. The tempo is slow with a soft piano accompaniment and choral vocal harmony. The song is soft, melodic, enigmatic, ethereal, mystical, magical, dreamy and enchanting. This music is a Choral Symphony. | 2014-08-27T04:06:05Z | DarkVul | ["New-age music", "Music"] | ["instrumental", "slow tempo", "choral symphony", "soft piano", "vocalisation", "magical", "enchanting", "dreamy", "magicalvocalisation", "vocal harmony", "classical music", "western classical", "ethereal", "enigmatic", "celestial", "angelic", "heavenly", "mystical", "mellow", "soft", "soothing", "harmony", "soundtrack", "ost", "melancholic", "emotional", "sentimental", "pensive", "wistful"] | 7 | 63jbksEqycQ | 720 | ||
Ave Maria by Schubert, Soprano and harpist Marsha Long | A female vocalist sings this melodious harmony. The tempo is slow with a dulcet Harp accompaniment . The song is soft, mellow, meditative, angelic, celestial,mystical, dreamy and mellifluous. This song is a Catholic prayer or salutation. | 2006-08-09T21:52:26Z | cherubofmusic | Ave Maria by Schubert performed by soprano and harpist Marsha Long | ["Music", "Opera"] | ["female singer", "slow tempo", "dreamy", "meditative", "calming", "dulcet", "high notes", "soprano", "falsetto", "buzzing sound", "harp", "female harpist", "plucking", "melodic", "celestial", "enchanting", "mystical", "enthralling", "ancient lineage instrument", "classical music", "western classical", "resonator", "oldest instrument", "latin song", "latin music", "elegy", "catholic prayer", "catholic salutation", "serene", "calming"] | 7 | ByOqw8M2U-Q | 1310 | |
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;