musiccaps_details (view)
1 row where musiccaps_aspects contains "male voice choir", musiccaps_author = 6 and musiccaps_names contains "Opera"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"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;