musiccaps_details (view)
3 rows where musiccaps_aspects contains "ethereal" and musiccaps_aspects contains "female vocalist" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- ethereal · 3 ✖
- female vocalist · 3 ✖
- slow tempo 3
- brass band 2
- emphatic vocals 2
- high notes 2
- beseeching 1
- captivating 1
- celestial 1
- clarinet 1
- classical music 1
- controlled singing 1
- emotional 1
- engaging 1
- enigmatic flutes 1
- enthralling 1
- euphonious 1
- expressive vocals 1
- falsetto 1
- harp 1
- icelandic lullaby 1
- icelandic song 1
- imploring 1
- intense cello 1
- lilting 1
- lilting melody 1
- mellifluous 1
- mesmerising 1
- minimalist music 1
- opera 1
- opera singer 1
- orchestra 1
- passionate 1
- peaceful 1
- piano accompaniment 1
- pleading 1
- powerful vocals 1
- rapid changes in pitch 1
- romantic piano 1
- soft 1
- soothing 1
- soprano 1
- soulful 1
- story telling 1
- string instruments 1
- trumpets 1
- vibrant vocals 1
- viola 1
- violin plucking rhythm 1
- violin symphony 1
- violins 1
- vocalisation 1
- western classical 1
- wind instrument 1
- yodelling 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Yohanna - A lullaby in Icelandic (Beat for Beat) - Jóhanna Guðrún | A female vocalist sings this melodic song in Icelandic. The tempo is slow with vocal emphasis and a soft and romantic piano accompaniment. The song is a mellow, soothing, peaceful, soothing, ethereal, mesmerising and captivating Icelandic lullaby. | 2012-11-25T14:05:24Z | Videos by Yohanna.de | Yohanna sings a lullaby in Icelandic. Very short but very enchanting clip ... ♥️ Piano: Trond Nagell Dahl Part of the TV show "Beat for beat" - November 23, 2012 More infos about Iceland's Most Beautiful Voice (in German): https://www.Yohanna.de | ["Music", "Lullaby"] | ["female vocalist", "slow tempo", "soft", "euphonious", "mellifluous", "piano accompaniment", "emphatic vocals", "icelandic song", "icelandic lullaby", "minimalist music", "romantic piano", "ethereal", "mesmerising", "captivating", "engaging", "peaceful", "soulful", "soothing"] | 7 | Y5RVYmf3uWc | 3253 | |
Phantom of the Opera AND Music of the Night - Boyertown High School | A female vocalist sings this soprano solo. The tempo is slow with a classic orchestral accompaniment of violin harmony, an intense incessant cello melody, brass instrument and organ. The song is an intense, emotional, beseeching, sad, and imploring classic opera . | 2011-10-15T23:21:13Z | BASHMusical | This is from Boyertown Area Senior High School's fantastic 2011 production of Andrew Lloyd Webber's "The Phantom of the Opera." | ["Country", "Music", "Opera"] | ["female vocalist", "slow tempo", "soprano", "intense cello", "beseeching", "imploring", "classical music", "western classical", "opera singer", "violins", "brass band", "story telling", "passionate", "emotional", "pleading", "opera", "orchestra", "lilting melody", "expressive vocals", "emphatic vocals", "ethereal", "high notes", "harp"] | 7 | -w12aSkQ9No | 101 |
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;