musiccaps_details (view)
4 rows where musiccaps_aspects contains "dramatic" and musiccaps_names contains "Opera" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- dramatic · 4 ✖
- classical music 2
- opera 2
- orchestral accompaniment 2
- amateur recording 1
- background whispering 1
- baroque 1
- cello 1
- concert hall reverb 1
- cymbal crash 1
- emotional 1
- female singer 1
- flutes 1
- harp 1
- male vocal 1
- oboes 1
- orchestra 1
- orchestral brass 1
- slow tempo 1
- soft and dreamy 1
- soprano 1
- string bass 1
- string ensemble 1
- string section 1
- violin 1
musiccaps_names (array) 4 ✖
- Music 4
- Opera · 4 ✖
- Classical music 3
- Singing 2
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | ||
Baroque music - Extremely rare voice (Sad classical music) | This is a classic music piece belonging to the baroque era. There is a soprano male vocal singing at an extraordinarily high pitch. The melody is being played by the violin and the cello. There is an emotional atmosphere to this piece. It could be playing in the background at a classy restaurant. It could also work well in the soundtrack of an art movie. | 2012-04-07T00:22:30Z | Ksenia Vorobieva | Baroque, classical music ... Extremely rare voice - male soprano Radu Marian sings aria from Baroque cantata "Vorrei, pupille belle, con Violini" (Bononcini). This is his natural soprano voice, not falsetto. For more songs and videos: http://www.youtube.com/user/radumariandotnet If you like, please share this video with others. --- Раду Марьян (мужское сопрано). http://www.youtube.com/user/radumariandotnet --- Baroque music, sad classical music | ["Music", "Opera", "Classical music"] | ["classical music", "baroque", "male vocal", "soprano", "violin", "cello", "emotional", "dramatic"] | 9 | 5nJr7iar6ZM | 695 | |
Mara Galeazzi & Edward Watson in Romeo & Juliet. | A full orchestra is playing a slow dramatic, emotional and soft composition. In the background whispering can be heard. This is an amateur recording. This song may be playing at a theater dancing ballet. | 2013-09-24T15:32:40Z | Approximatesonata | Balcony scene pas de deux. Cor. Kenneth Mac Millan. | ["Music", "Opera", "Classical music"] | ["classical music", "orchestra", "flutes", "string section", "oboes", "slow tempo", "dramatic", "background whispering", "soft and dreamy", "amateur recording"] | 6 | q9zAlMM-A9I | 4759 | |
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 |
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;