musiccaps_details (view)
2 rows where musiccaps_aspects contains "enchanting" and musiccaps_aspects contains "heavenly"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- enchanting · 2 ✖
- heavenly · 2 ✖
- angelic 1
- calm 1
- captivating 1
- celestial 1
- choral symphony 1
- classical music 1
- dreamy 1
- emotional 1
- enigmatic 1
- ethereal 1
- harmony 1
- harp playing 1
- instrumental 1
- magical 1
- magicalvocalisation 1
- melancholic 1
- mellow 1
- melodic sounding harp 1
- mystical 1
- ost 1
- pensive 1
- sentimental 1
- serenity 1
- slow tempo 1
- soft 1
- soft piano 1
- soothing 1
- soothing instrumental 1
- soundtrack 1
- tranquility 1
- vocal harmony 1
- vocalisation 1
- western classical 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 | ||
memory | This clip features a heavenly sounding harp. The piece is arpeggio driven and elicits a feeling of tranquility and peace. The harp is full bodied and the instrumentalist balances the high tones with a deep bass sound. | 2007-07-31T08:22:08Z | Friedrich M. Hacheney | romantic song played on the paraguayan harp at the castle of Petershagen, Germany | ["Harp", "Pizzicato"] | ["harp playing", "melodic sounding harp", "soothing instrumental", "enchanting", "captivating", "calm", "tranquility", "serenity", "heavenly"] | 3 | YGWweVRzFrw | 3272 |
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;