musiccaps_details (view)

3 rows where musiccaps_aspects contains "male vocal", musiccaps_author = 9 and musiccaps_names contains "Opera"

✎ View and edit SQL

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
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
Константин Плужников Lullaby Berceuse de la Bretagne This is a Russian lullaby piece with classical music elements. The male vocalist is singing at a medium-to-high pitch in an opera-like manner. The strings and the piano are playing a gentle but crestfallen melody. The atmosphere is haunting. This piece could fit perfectly in the soundtrack of a post-apocalyptic war movie or a video game of similar theme. It could also work well in the soundtrack of a drama movie or an art movie that takes place in Russia or Eastern Europe. It might also be playing in the background at a high-tier Russian cuisine restaurant. 2012-12-24T03:43:59Z Bronisliva Константин Плужников Бретонская колыбельная песня (М.Ипполитов-Иванов - В. Соловьев) Konstantin Pluzhnikov Berceuse de la Bretagne Lullaby (M.Ippolitov-Ivanov - V. Soloviev) Artist - P. de Chavannes ["Music", "Opera", "Lullaby"] ["russian", "lullaby", "classical", "male vocal", "medium-to-high pitch singing", "strings", "piano", "crestfallen", "haunting", "melancholic"] 9 ZKkfCOqLrT0 3363
Tyler Samuel Lee sings Roger Quilter's "Hey Ho the Wind and the Rain" This is a live performance of an art song piece. There is a male vocalist singing as if he is performing a role at a theater play. The grand piano is playing a melodic accompaniment piece in the background to support the vocals. The words are derived from English literature. 2012-04-22T22:00:38Z Gail Tyler Samuel Lee senior recital sings Roger Quilter's "Hey ho, the wind and the rain" at Peabody Conservatory April 2012. ["Music", "Opera"] ["art song", "live performance", "male vocal", "theatrical singing", "grand piano", "merry tune", "story-telling mood", "light music", "english"] 9 dztizAgcQ08 3834

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;