musiccaps_details (view)
1 row where search matches "opera", musiccaps_aspects contains "vibrant" and musiccaps_names contains "A capella"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 7 ✖
- acapella 1
- magical 1
- male vocal 1
- multiharmony 1
- multitrack 1
- rock opera 1
- vibrant · 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
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;