musiccaps_details (view)
2 rows where musiccaps_aspects contains "female singer" and musiccaps_aspects contains "viola"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- captivating 2
- celestial 2
- cello 2
- ethereal 2
- female singer · 2 ✖
- mesmerising 2
- orchestra 2
- slow tempo 2
- viola · 2 ✖
- angelic 1
- celestial music 1
- classical music 1
- compelling 1
- concert 1
- descan 1
- descant 1
- dreamy 1
- eloquent piano accompaniment 1
- enchanting 1
- enigmatic 1
- enthralling 1
- falsetto 1
- high notes 1
- interlude in song 1
- live performance 1
- mellifluous 1
- melodic violin 1
- opera singer 1
- people talking 1
- philharmonic 1
- pleasant 1
- powerful vocals 1
- rich 1
- soothing 1
- soprano 1
- symphony 1
- symphony orchestra 1
- violin harmony 1
- violin symphony 1
musiccaps_names (array) 4 ✖
- Music 2
- Opera 1
- Singing 1
- Tender music 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 | |
Celine Dion - Live in Las Vegas 2011 - Open Arms | A female vocalist sings this enchanting song.the tempo is slow with this clip opening with the vocalist almost ending the sentence. The singer is accompanied by mesmerising Violin symphony and piano accompaniment . This song is a live performance as it is sung with an orchestra and there is the sound of people talking. The song is enchanting, ethereal, captivating, soothing and celestial. | 2011-03-16T14:38:34Z | Woodsy | 15/03/11 - Celine Dion sings "Open Arms" live in Las Vegas on her new tour. Please comment, like and subscribe, thanks! | ["Singing", "Music", "Tender music"] | ["female singer", "slow tempo", "violin harmony", "live performance", "concert", "orchestra", "celestial", "cello", "viola", "symphony", "orchestra", "celestial music", "ethereal", "soothing", "rich", "eloquent piano accompaniment", "ethereal", "compelling", "enigmatic", "mesmerising", "captivating", "interlude in song", "powerful vocals", "live performance", "people talking"] | 7 | MROotmz8a-U | 2267 |
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;