musiccaps_details (view)
2 rows where musiccaps_author = 6, musiccaps_names contains "Opera" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 13 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ivan Momirov - Adriana Lecouvreur | This song contains a brass section playing a melody and a string section taking over with a melody. A harp is playing a melody in the background along with plucked celli. An upright bass is playing single notes along. A male voice is singing loud and with an opera technique. This song may be playing while watching an opera. | 2015-07-19T14:34:29Z | Ivo Yordanov | Sandra Mitrovska and Ivan Momirov. Conductor Stefano Romani. Form the opera Adriana Lecouvreur by Francesco Cilea. Production of Macedonian National Opera and Ballet. | ["Singing", "Music", "Opera", "Classical music"] | ["opera", "string section", "harp", "brass section", "upright bass", "male voice", "mid-range singing", "medium to uptempo"] | 6 | AnErEDywInE | 1170 | |
"NESSUN DORMA" - Welsh Male Voice Choir | This audio contains a male church choir singing from the low register up into the mid-higher register. An acoustic piano is providing single notes walking up the keybed. This song may be playing in a church sung by a male choir. | 2010-06-08T21:40:54Z | Cantorion Colin Jones | Cantorion's brand new CD is on iTunes. Please click on the link http://itunes.apple.com/gb/album/nessun-dorma/id488729653 Cantorion Colin Jones are a male voice choir from North Wales. FOR MORE DETAILS AND INFORMATION REGARDING THIS MALE VOICE CHOIR, CLICK ON OUR NEW CHOIR WEBSITE : http://www.cantorioncolinjones.co.uk or http://www.cantorioncolinjones.co.uk/guestbook Nessun dorma WITH LYRICS (None shall sleep) is an aria from the final act of Giacomo Puccini's opera Turandot, and is one of the best-known tenor arias in all opera. It is sung by Calaf, il principe ignoto (the unknown prince), who falls in love at first sight with the beautiful but cold Princess Turandot. However, any man who wishes to wed Turandot must first answer her three riddles; if he fails, he will be beheaded. The video is an excerpt from a concert in Welshpool, UK. The choir is the renowned North Wales Male Chorus, "Cantorion Colin Jones" under the musical direction of John A Daniel. www.cantorioncolinjones.co.uk | ["Singing", "Music", "Opera", "Choir"] | ["amateur recording", "acoustic piano", "male voice choir", "church music/liturgical", "slower tempo"] | 6 | k8AE-vqWbm4 | 4300 |
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;