musiccaps_details (view)

1 row where search matches "opera" and musiccaps_names contains "A capella"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date)

musiccaps_aspects (array) 7 ✖

musiccaps_names (array) 3 ✖

musiccaps_author 1 ✖

  • 9 1
video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Bohemian Rhapsody - Acapella Multitrack This is a multitrack acapella cover of a rock opera music piece. The same vocalist is singing different harmonies in separate tracks to create the aura of a magical experience. Usage of multiple tracks creates a vibrant atmosphere. 2009-11-24T08:16:09Z Rob Angus by Freddie Mercury and Queen. SATTBB I'll put this in my "More Balls than Ability" file.... I recorded each of the 6 parts 6 times. Some parts of the bass and soprano were recorded a semitone or two ... 3?...lower or higher and then adjusted. There were some notes in those parts that would not come out of my mouth. It is not pitch corrected.... the sour notes are all me. This project pushes the limits of my laptop. (and far exceeds my ability!) Often the tracks recorded way out of alignment & had to be manually aligned. I assembled the video using Corel Video Studio Pro X2. I had never used it before and had a heck of a time rendering the video to the size and resolution I was looking for. Nonetheless, here it is... such as it is. ["Chant", "Music", "A capella"] ["acapella", "rock opera", "male vocal", "multiharmony", "multitrack", "vibrant", "magical"] 9 mBNdDQamtXA 4453

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;