musiccaps_details (view)
3 rows where musiccaps_aspects contains "acapella", musiccaps_author = 9 and musiccaps_names contains "Music"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Mansion Robe and Crown ( Acapella with Lyrics ) | This is a gospel music piece. The piece is a church hymn that is being sung by a choir in the style of acapella. The male vocals are harmony singing. The atmosphere is festive. This piece can be played at Christian religious events. It could also be used in the soundtrack of a modern drama movie during religious scenes. | 2011-08-03T18:53:32Z | CHURCHofCHRIST24 | * I do not own any part of this video. All song materials belong to rightful owner. Lyrics: I'm gonna trade my earthly home For a better one, bright and fair. Christ left to prepare a mansion For His children in the air. I'll join Him in that land Where tears nor sorrows can be found And I'll receive my mansion, Robe, and crown. Chorus (bass Mansion, robe, and a crown Lord I want a brand new mansion, robe, and a crown in glory There love always abound There I know that peace and love will always abound forever Let me Your throne surround Let me be among the saved to Your throne surround Lord, please reserve my mansion, robe and crown And I'll receive my mansion Robe, and crown. The weather there is always fair, There is sunshine day and night No cold and no rain will fall there For the sun shines ever bright I'll need no heavy garments, I'll just wrap my robe around When I receive my mansion, Robe, and crown. Chorus My head is bowed and bloody now From the work that I've tried to do But one day I'll be rewarded With a crown so bright and new I'll wear a smile so bright For there'll be no cause for a frown When I receive my mansion, Robe, and crown Chorus | ["Chant", "Music", "Choir", "A capella"] | ["gospel", "church hymn", "acapella", "male vocals", "choir", "harmony singing", "festive christian", "religious", "spiritual"] | 9 | IDHHAwqDpzU | 1882 | |
| 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 | |
| 딸한테 아카펠라를 시켰다 | This is an acapella version of a swing jazz music piece that was performed with various layers of a vocal synth software called vocaloid. Three different harmonies can be heard from this vocal synth. There is a bass guitar playing a walking bass line in the background. The rhythmic background consists of finger clicks and a swing jazz beat performed with brushes on a snare drum. The atmosphere is cheerful but eerie. This piece could be used in the soundtrack of an arcade/analog type video game. It could also work well in the soundtrack of an anime. | 2015-09-25T14:24:08Z | Rain Silver | http://tvple.com/350077 http://www.nicovideo.jp/watch/sm25083117 | ["Music", "Vocal music", "A capella", "Happy music"] | ["acapella", "vocaloid", "swing jazz", "female synth vocal", "harmony singing", "bass guitar", "finger click", "snare drum", "brush", "eerie", "cheerful", "upbeat"] | 9 | nYO8n62Piys | 4550 |
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;