musiccaps_details (view)
2 rows where search matches "opera", musiccaps_aspects contains "classical" and musiccaps_aspects contains "opera"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 19 ✖
- classical · 2 ✖
- opera · 2 ✖
- compilation 1
- coughing 1
- emotional 1
- female vocal 1
- fruity male vocal 1
- high-pitched singing 1
- live performance 1
- low quality 1
- muffled 1
- noisy 1
- orchestra 1
- passionate 1
- piano melody 1
- reverberant 1
- strings 1
- telephone ring 1
- vocal range 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cecilia Bartoli's Operatic Vocal Range (in about a minute!) | This piece is a compilation of an opera singer's high-pitched singing that shows how high of a pitch she can reach. For the most part, she is holding a single high note as the strings in the orchestra provide the harmonic background. | 2010-12-23T17:05:25Z | SsteinwayS | US: http://amzn.to/2itVgnr Canada: http://amzn.to/2iRUtNK Cecilia Bartoli’s vocal range: from low E below middle C to high E-flat above soprano high C! | ["Singing", "Music", "Opera"] | ["opera", "classical", "orchestra", "strings", "female vocal", "high-pitched singing", "compilation", "vocal range"] | 9 | AElgGuUSSKE | 1088 | |
Cantor Helfgot @ Lincoln Center | The low quality recording features a live performance of a classical song that consists of a fruity male opera singer over a piano melody. In the background there are coughing and telephone ring sounds. The recording is noisy, muffled and it sounds emotional and passionate. | 2008-01-02T17:40:24Z | yessory | Helfgot sings Vlirusholayim Ircha, Avery Fisher Hall, Dec. 02, 2007. At the concert while this selection was sung, rare footage of how Moshe koussevitsky masterfully sang this selection were shown. The recorded audio appears with a slideshow of pictures, from previous Helfgot Performances. | ["Singing", "Mantra", "Music", "Opera", "Orchestra", "Classical music"] | ["low quality", "live performance", "reverberant", "noisy", "muffled", "coughing", "classical", "opera", "fruity male vocal", "piano melody", "emotional", "passionate", "telephone ring"] | 4 | PFa1XVCgPgM | 2522 |
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;