musiccaps_details (view)

1 row where musiccaps_aspects contains "audio buzz noises", musiccaps_aspects contains "choral harmony" and musiccaps_aspects contains "meditational"

✎ 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
XAVER VARNUS: MY LIFE IS THE ORGAN - 18TH PART (SONY MUSIC, 2007) The song is a vintage recording of a church choir singing in vocal harmony. The song is medium tempo with a church organ accompanying the choir with no other instrumentation. The song is devotional and prayerful. The audio quality is highly deteriorated and is probably an amateur home video recording. The song is a classic church choir harmony. 2011-08-28T23:36:51Z Xaver Varnus "The film about the incomparable Hungarian-Canadian organist Xaver Varnus is an experience for all, who have been deeply affected by this man's art. Varnus was often called "the Horowitz of the organ" - and not just by the press, but by many leading organists themselves. This film contains treasures of archival footage of Varnus in recitals, his own recollections of his fascinating life and the on-camera interviews given in 2008. The film is very well-made, balancing as it does Varnus' voice-over narration with historical footage of many events in Europe. It is incredible to follow the life of one human being, who rises to world prominence out of the circumstances, which made his very survival questionable and to sense in all of it the Guidance of a Higher Power. The Guidance, which is available to every human being, but which is simply more noticeable in Varnus' case." (Francois Fejto, journalist of Le Figaro) A film by Mate Vargha. Sony Music, 2007 (233 min.) 1st part: http://www.youtube.com/watch?v=x5rbXWfxz7k 2nd part: http://www.youtube.com/watch?v=yvqw4ZLR52Y 3rd part: http://www.youtube.com/watch?v=vEQHe-nXkns 4th part: http://www.youtube.com/watch?v=Ho5CiI_w02o 5th part: http://www.youtube.com/watch?v=RY09aVHM8Yg 6th part: http://www.youtube.com/watch?v=DqIcF2fMEbk 7th part: http://www.youtube.com/watch?v=2xwv-SOML7s 8th part: http://www.youtube.com/watch?v=XiZmkolLkZ0 9th part: http://www.youtube.com/watch?v=uwgsy-ZWhpk 10th part: http://www.youtube.com/watch?v=oFRyKnp5vNo 11th part: http://www.youtube.com/watch?v=j1AFilIqCn0 12th part: http://www.youtube.com/watch?v=PMWsILDGrmg 13th part: http://www.youtube.com/watch?v=J7sf8UR5c64 14th part: http://www.youtube.com/watch?v=Cz3c-0era7M 15th part: http://www.youtube.com/watch?v=4EXUu-Lf37k 16th part: http://www.youtube.com/watch?v=4r8v4CIufVA 17th part: http://www.youtube.com/watch?v=9qOj6pvDCQE 18th part: http://www.youtube.com/watch?v=tGv_L09pf6E ["Background music", "Music", "Sad music"] ["choral music", "bad quality recording", "western classical music", "audio buzz noises", "audio quality deterioration", "church choir", "children’s church choir", "amateur recording", "no percussion instruments", "heavenly", "meditational", "inspiring", "jarring tones", "inspiring", "christian classical music", "choral harmony", "male and female singers", "passionate", "prayerful", "emotional", "home video recording", "church organ playing", "slow tempo"] 1 tGv_L09pf6E 5023

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;