musiccaps_details (view)
3 rows where musiccaps_aspects contains "enthralling", musiccaps_aspects contains "ethereal" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- celestial 3
- enthralling · 3 ✖
- ethereal · 3 ✖
- slow tempo · 3 ✖
- falsetto 2
- high notes 2
- viola 2
- violin symphony 2
- ambient 1
- angel 1
- angelic 1
- brass band 1
- captivating 1
- cello 1
- clarinet 1
- classical music 1
- controlled singing 1
- descan 1
- descant 1
- dreamy 1
- enchanting 1
- enigmatic flutes 1
- euphonious 1
- female singer 1
- female vocalist 1
- harp melody 1
- harp solo 1
- instrumental 1
- lilting 1
- mellifluous 1
- mellow 1
- melodic violin 1
- mesmerising 1
- minimalist 1
- opera singer 1
- orchestra 1
- philharmonic 1
- pleasant 1
- plucking 1
- powerful vocals 1
- rapid changes in pitch 1
- soft 1
- soprano 1
- string instruments 1
- stringed instrument 1
- symphony orchestra 1
- trumpets 1
- vibrant vocals 1
- violin plucking rhythm 1
- vocalisation 1
- western classical 1
- wind instrument 1
- yodelling 1
musiccaps_names (array) 7 ✖
- Music 3
- Opera 2
- Classical music 1
- Harp 1
- Musical instrument 1
- Plucked string instrument 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lord of the Rings - In Dreams (Soundtrack) | A female opera singer sings this soprano melody. The tempo is slow with an ethereal violin symphony accompaniment. The song is mellifluous , soft, enchanting, enigmatic, mystical, ethereal,celestial and dreamy. This is a Classic Opera. | 2011-04-11T07:29:38Z | Z7TomC7Z | (In Dreams) Main Theme of The Lord of the Rings - In Dreams (Soundtrack) Fellowship of the Ring (Theme song) (Choir) By Howard Shore Lyrics When the cold of Winter comes Starless night will cover day In the veiling of the sun We will walk in bitter rain But in dreams I can hear your name And in dreams We will meet again When the seas and mountains fall And we come to end of days In the dark I hear a call Calling me there I will go there And back again Lord of the Rings - In Dreams (Soundtrack) Chior Theme Lord of the Rings - In Dreams (Soundtrack) Chior Theme Disclaimer to rights of video. I did not take the pictures or create/write the music in this video. | ["Music", "Opera"] | ["female singer", "slow tempo", "soprano", "falsetto", "descant", "high notes", "melodic violin", "violin symphony", "cello", "viola", "orchestra", "philharmonic", "symphony orchestra", "classical music", "ethereal", "angelic", "celestial", "enthralling", "captivating", "mesmerising", "pleasant", "dreamy", "mellifluous", "enchanting", "descan", "opera singer"] | 7 | Ha-FS_CHmGw | 1818 | |
Carla They - Concerto per sola Arpa (Ponti sul Mincio) | This music is instrumental. The tempo is slow with a euphonious harp melody with no accompaniment. The music is soft, mellow, ethereal, melancholic, nostalgic, pensive, soft and ambient. This music is a Western Classical. | 2012-09-26T18:14:50Z | Carla They | Pace e bellezza regnano a Ponti sul Mincio, comune di origini medievali. Tra i percorsi incantevoli e ritmi rilassanti, fanno il suo ingresso le musiche di "Carla They". La rassegna quest'anno si chiude con un importante concerto per sola arpa di un'artista d'eccezione: Carla They. La prestigiosa carriera dell'artista è testimoniata da varie esperienze in importanti teatri ed apparizioni televisive in Italia, Svizzera, Austria, Germania e Olanda. Il suo repertorio si muove tra celtico, folk e classico. Organizzazione riprese video e audio Tullio Mauro | ["Harp", "Music", "Musical instrument", "Plucked string instrument", "Classical music"] | ["instrumental", "slow tempo", "stringed instrument", "angel", "western classical", "harp solo", "harp melody", "ethereal", "soft", "mellow", "euphonious", "celestial", "enthralling", "minimalist", "plucking", "ambient"] | 7 | OiNlYrlJE4g | 2461 | |
Mary Schneider - Yodelling Overtures | A female vocalist sings this lilting melody. The tempo is slow with the vocalist yodelling to the accompaniment of a violin symphony and brass band . The cello and plucking of violin strings adds a dense bass layer and the subtle flutes and trumpets harmony compliment the vocals. The effect is ethereal, celestial, enthralling, enigmatic, melodic and beautiful. | 2011-01-09T14:02:20Z | German Music Channel | The Australian Queen Of Yodelling! 1. Wilhelm Tell 2. Carmen 3. Can Can Winterfest der Volksmusik 2000 | ["Yodeling", "Music", "Opera"] | ["female vocalist", "slow tempo", "enthralling", "celestial", "enigmatic flutes", "trumpets", "viola", "clarinet", "vocalisation", "yodelling", "high notes", "controlled singing", "violin symphony", "brass band", "string instruments", "wind instrument", "violin plucking rhythm", "vibrant vocals", "powerful vocals", "lilting", "ethereal", "rapid changes in pitch", "falsetto"] | 7 | i_G_0vgEYJg | 4199 |
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;