home / musiccaps

musiccaps_details (view)

5 rows where search matches "opera" and musiccaps_aspects contains "dramatic"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date)

musiccaps_aspects (array) >30 ✖

  • dramatic · 5 ✖
  • opera 2
  • orchestral accompaniment 2
  • rock opera 2
  • choir 1
  • classical music 1
  • concert hall reverb 1
  • cymbal crash 1
  • dreamy 1
  • fast-paced 1
  • female singer 1
  • female vocal 1
  • flute 1
  • french opera 1
  • grandiose 1
  • harp 1
  • harpsichord 1
  • instrumental 1
  • intrigue 1
  • live performance 1
  • male vocal 1
  • medieval sounding 1
  • medium-to-high pitch singing 1
  • no instruments 1
  • orchestra 1
  • orchestral brass 1
  • passionate singing 1
  • piano 1
  • sentimental 1
  • string bass 1
  • …

musiccaps_names (array) 9 ✖

  • Music 4
  • Singing 3
  • Opera 2
  • Chant 1
  • Classical music 1
  • Harpsichord 1
  • Keyboard (musical) 1
  • Music of Asia 1
  • Sad music 1

musiccaps_author 2 ✖

  • 9 3
  • 8 2
video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Queen - "We Are the Champions" Acapella (Vocals Only) Concert Mash-Up This is an isolated vocal track of a rock opera piece. There are no instruments. A passionate male vocalist is singing melodically in the lead. There is a choir in the background providing medium-to-high pitched back vocals. There is an uplifting atmosphere. This piece could be used in remixes. Vocal samples can be lifted for DJ sets or beat-making. 2015-12-30T08:49:25Z Playback.fm About video: http://playback.fm/blog/queen-we-are-the-champions-acapella/ - Follow us on Facebook: https://www.facebook.com/playbackapp We love Queen and Freddie Mercury, so we've edited 4 concert films including a rare recording session of "We Are The Champions" and synced them all up to the isolated vocals in honor of the late, great, Freddie Mercury. This video showcases his presence and consistency as the ultimate stage man. RIP Freddie. You are a rock god. ["Chant", "Music"] ["rock opera", "vocal track", "no instruments", "male vocal", "passionate singing", "choir", "dramatic", "uplifting", "vibrant"] 9 GF8QWSW0UbY 1701
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
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
The Sound of Music - Musical-sing-a-long (repetitie) This is a rock opera piece that is being sung by a female vocalist in a medium-to-high pitch range. There is an orchestra playing the melody in the background composed of strings, flute and a piano. The atmosphere of the piece is dreamy and sentimental. It could be used in the soundtrack of a fairytale movie. 2014-09-01T19:54:18Z Kindermuziek De cast van The Sound of Music maakt haar opwachting tijdens de Musical-sing-a-long tijdens de Uitmarkt 2014 op het Museumplein in Amsterdam ["Singing", "Music of Asia", "Music", "Sad music"] ["rock opera", "live performance", "female vocal", "medium-to-high pitch singing", "orchestra", "strings", "flute", "piano", "dreamy", "sentimental", "dramatic"] 9 fZjQBgPD1Ys 3960
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 66.386ms · About: simonw/musiccaps-datasette