musiccaps_details (view)

2 rows where "youtube_published" is on date 2008-06-09

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date)

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
EDITH PIAF "CHANTE-MOI" The low quality recording features a Chanson song that consists of passionate female vocal singing over mellow piano melody and soft sustained strings melody. The recording is noisy, crushed and it sounds vintage, and therefore sentimental and nostalgic. 2008-06-09T23:10:38Z originalDimer ORIGINAL RCA VICTOR PLAYING ORIGINAL 45'S ["Singing", "Yodeling", "Music"] ["low quality", "noisy", "mono", "vintage", "crushed", "passionate female vocal", "mellow piano melody", "soft sustained string melody", "chanson", "sentimental", "nostalgic"] 4 Nt0U-CXK6O0 2374

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;