home / musiccaps

musiccaps_details (view)

3 rows where search matches "opera" and musiccaps_aspects contains "classical music"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date)

musiccaps_aspects (array) >30 ✖

  • classical music · 3 ✖
  • ethereal 2
  • high notes 2
  • opera singer 2
  • orchestra 2
  • slow tempo 2
  • soprano 2
  • angelic 1
  • beseeching 1
  • brass band 1
  • captivating 1
  • celestial 1
  • cello 1
  • descan 1
  • descant 1
  • dramatic 1
  • dreamy 1
  • emotional 1
  • emphatic vocals 1
  • enchanting 1
  • enthralling 1
  • expressive vocals 1
  • falsetto 1
  • fast-paced 1
  • female singer 1
  • female vocalist 1
  • french opera 1
  • grandiose 1
  • harp 1
  • harpsichord 1
  • …

musiccaps_names (array) 5 ✖

  • Music 2
  • Opera 2
  • Country 1
  • Harpsichord 1
  • Keyboard (musical) 1

musiccaps_author 2 ✖

  • 7 2
  • 9 1
video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Phantom of the Opera AND Music of the Night - Boyertown High School A female vocalist sings this soprano solo. The tempo is slow with a classic orchestral accompaniment of violin harmony, an intense incessant cello melody, brass instrument and organ. The song is an intense, emotional, beseeching, sad, and imploring classic opera . 2011-10-15T23:21:13Z BASHMusical This is from Boyertown Area Senior High School's fantastic 2011 production of Andrew Lloyd Webber's "The Phantom of the Opera." ["Country", "Music", "Opera"] ["female vocalist", "slow tempo", "soprano", "intense cello", "beseeching", "imploring", "classical music", "western classical", "opera singer", "violins", "brass band", "story telling", "passionate", "emotional", "pleading", "opera", "orchestra", "lilting melody", "expressive vocals", "emphatic vocals", "ethereal", "high notes", "harp"] 7 -w12aSkQ9No 101
Lord of the Rings - In Dreams (Soundtrack) A female opera singer sings this soprano melody. The tempo is slow with an ethereal violin symphony accompaniment. The song is mellifluous , soft, enchanting, enigmatic, mystical, ethereal,celestial and dreamy. This is a Classic Opera. 2011-04-11T07:29:38Z Z7TomC7Z (In Dreams) Main Theme of The Lord of the Rings - In Dreams (Soundtrack) Fellowship of the Ring (Theme song) (Choir) By Howard Shore Lyrics When the cold of Winter comes Starless night will cover day In the veiling of the sun We will walk in bitter rain But in dreams I can hear your name And in dreams We will meet again When the seas and mountains fall And we come to end of days In the dark I hear a call Calling me there I will go there And back again Lord of the Rings - In Dreams (Soundtrack) Chior Theme Lord of the Rings - In Dreams (Soundtrack) Chior Theme Disclaimer to rights of video. I did not take the pictures or create/write the music in this video. ["Music", "Opera"] ["female singer", "slow tempo", "soprano", "falsetto", "descant", "high notes", "melodic violin", "violin symphony", "cello", "viola", "orchestra", "philharmonic", "symphony orchestra", "classical music", "ethereal", "angelic", "celestial", "enthralling", "captivating", "mesmerising", "pleasant", "dreamy", "mellifluous", "enchanting", "descan", "opera singer"] 7 Ha-FS_CHmGw 1818
Rameau - La Pantomime - Skip Sempé / Olivier Fortin This is a French opera music piece. It is an instrumental piece. There are two harpsichords performing the piece. There is a medieval sound to the piece. It has a dramatic and grandiose feel. This piece could be used in the soundtrack of a movie or a TV series that takes place in the medieval era, especially during scenes of intrigue. 2009-09-30T09:43:52Z Skip Sempé - Capriccio Stravagante - Paradizo Rameau: La Pantomime (1741). Transcribed and arranged for 2 harpsichords by Skip Sempé & Olivier Fortin. Skip Sempé & Olivier Fortin, harpsichords. Harpsichords after 18th century French models by Bruce Kennedy and Patrick Chevalier. Paradizo - From the bonus DVD included with PA0003 (Rameau - La Pantomime) www.paradizo.org International CD and Digital distribution: Outhere Music iTunes: https://itunes.apple.com/fr/album/rameau-la-pantomime/id799190961?l=en ["Harpsichord", "Keyboard (musical)"] ["classical music", "french opera", "instrumental", "harpsichord", "medieval sounding", "dramatic", "grandiose", "intrigue", "fast-paced"] 9 wwbATvWFaLY 5294

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;
Powered by Datasette · Queries took 67.796ms · About: simonw/musiccaps-datasette