home / musiccaps

musiccaps_details (view)

4 rows where search matches "opera" and musiccaps_aspects contains "amateur recording"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date)

musiccaps_aspects (array) 19 ✖

  • amateur recording · 4 ✖
  • opera 2
  • strings 2
  • acoustic drums 1
  • acoustic piano 1
  • e-bass 1
  • fast tempo 1
  • female opera singer 1
  • harp 1
  • higher pitch 1
  • italian ballad 1
  • male opera voice 1
  • male voices singing 1
  • medium tempo 1
  • mid range singing 1
  • piano/opera 1
  • slow tempo 1
  • synthesizer 1
  • vocal sound 1

musiccaps_names (array) 9 ✖

  • Music 3
  • /t/dd00003 2
  • /m/05zppz 1
  • Choir 1
  • Harp 1
  • Pizzicato 1
  • Singing 1
  • Theremin 1
  • Vocal music 1

musiccaps_author 1 ✖

  • 6 4
video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
The Singing Priests Rehearse O Holy Night This audio contains male voices singing together an opera in a higher pitch creating harmonies. In the background you can hear strings playing. This song may be playing live in a theater. 2008-06-09T19:53:50Z PlaceForMusic http://www.thepriests.com Amazingly beautiful christian Music by "The Priests". The Priests are recording in the studio. The Priests are: Father Eugene O'Hagan of the Parish of Ballyclare and Ballygowan: Church of The Sacred Heart and Church of The Holy Family. Dioceses of Down and Connor Father Martin O'Hagan of the Parish of Cushendun: Church of St. Patrick (Craigagh), Church of St. Mary, The Star of the Sea (Culraney). Dioceses of Down and Connor. Father David Delargy of the Parish of Hannahstown: Church of St. Joseph and Church of St. Peter, the Rock , Dioceses of Down and Connor. It was at St. MacNissi's College, Co Antrim, a local school in Derry, where Father Eugene O'Hagan, Father Martin O'Hagen and Father David Delargy met for the first time... ["Music", "Choir", "/t/dd00003"] ["amateur recording", "opera", "male voices singing", "higher pitch", "strings", "slow tempo"] 6 6FQ1nQ0FvgQ 738
Theremin player Armen Ra Someone is playing an acoustic piano repeating a phrase of a chord with single notes in the mid-range while a voice-like synthesizer sound is being played in a higher register. The instrument does sound like a female opera singer with a lot of vibrato. This song may be playing in a theater. 2006-06-28T06:42:04Z Klara Palotai Armen Ra at a benefit concert on April 4, 2006 at the Angel Orensanz Foundation in New York ["Music", "Theremin"] ["piano/opera", "acoustic piano", "synthesizer", "vocal sound", "amateur recording"] 6 Wd5l_FHGWfE 3112
Mandoline - Diana Damrau This audio contains someone playing a harp picking a tremolo melody. A female opera voice starts singing along in a higher pitch. This is an amateur recording. You can hear recording noises and the whole audio is panned to the left side of the speakers. This song may be playing in a theaterhouse. 2009-09-27T07:43:48Z Lilith89ibz Breathtaking rendition of Debussy's "Mandoline", from a Liederabend Harfe she gave in Baden-Baden with Xavier de Maistre at the harp. He wrote most of the arrangments for the harp from the original piano score (personally, I find that amazing). ["Harp", "Pizzicato"] ["amateur recording", "opera", "harp", "female opera singer", "fast tempo"] 6 fe10sxFSz_I 3965
Francis Coppola singing Male Femmena A male voice is singing loudly with an opera technique while an acoustic drum is playing along with a e-bassline. Underlined by strings playing a melody. This song may be playing at a wedding. 2007-07-23T20:57:52Z Francis Coppola Russo's on the Bay Howard beach NYC- Born in Queens NYC Frankie singing mala femmena 2004. My Origin is from Pomigliano D'arco, Castello di Cisterno and Brusciano.; NAPOLI Mt. Versuvio ["Singing", "Music", "/m/05zppz", "Vocal music", "/t/dd00003"] ["italian ballad", "strings", "acoustic drums", "e-bass", "male opera voice", "mid range singing", "medium tempo", "amateur recording"] 6 zdtVT2xwrHU 5500

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 65.36ms · About: simonw/musiccaps-datasette