musiccaps_details (view)
4 rows where musiccaps_author = 8 and musiccaps_names contains "Opera"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Sarah Brightman performing 'Music Of the Night' at Queen Mother's 90th Birthday Gala 1990 | Dramatic female opera singer accompanied by orchestra and brass and cymbal crash. | 2010-06-23T02:57:11Z | tapesalvage | Sarah Brightman performing 'Music Of the Night' from Phantom Of the Opera at Queen Mother's 90th Birthday Gala 1990 | ["Singing", "Music", "Opera", "Classical music"] | ["opera", "dramatic", "cymbal crash", "orchestral brass", "orchestral accompaniment"] | 8 | XUzaEsoOlWQ | 3187 | |
| Celia Sheen plays Midsomer Murders on Theremin | An orchestra plays a waltz supporting a Theremin which takes the lead melody while the piano plays a counter melody. The feel is cinematic, spooky and a bit quirky. | 2009-01-17T21:29:10Z | randomnotegenerator | Celia Sheen plays the theme tune from ITV's drama series "Midsomer Murders" on the Theremin. She has done so, along with incidental music, on the soundtrack of every episode for fourteen years. This fascinating instrument was the world's very first electronic instrument, invented in 1920 by Russian scientist Lev Theremin. Of course, nobody ever sees Celia's performances on the recordings, but what makes it interesting is that the Theremin is played without being touched! | ["Background music", "Music", "Opera", "Theremin"] | ["spooky", "theremin melody", "sci-fi", "waltz", "orchestra", "piano counter melody", "cinematic", "quirky"] | 8 | YTZK9FNgK74 | 3288 | |
| Amira Willighagen - O Mio Babbino Caro - Andre Rieu - Maastricht - July 2014 | A female opera singer accompanied by an orchestra featuring string bass, harp and string ensemble. It sounds like it was performed in a concert hall. Dramatic. | 2014-07-13T11:01:00Z | pa1189j | ["Singing", "Music", "Opera"] | ["opera", "female singer", "orchestral accompaniment", "string bass", "harp", "string ensemble", "concert hall reverb", "dramatic"] | 8 | Z0htOHTOtHY | 3336 | ||
| Ivan Ozhogin - The Jewish lullaby | A professionally trained operatic male singer singing a difficult, high melody accompanied by organ and electric piano. | 2011-06-29T21:31:44Z | MrTweens | Иван Ожогин - Еврейская колыбельная (с) Елена Сорокина Архиповский музыкальный салон, 25.05.2011 | ["Music", "Opera", "Lullaby", "Vocal music"] | ["male singer", "operatic", "electric piano", "organ", "professionally trained", "high melody", "virtuosic"] | 8 | xvryKn-V-JM | 5364 |
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;