musiccaps_details (view)
2 rows where musiccaps_aspects contains "choir" and musiccaps_names contains "Chant"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Queen - "We Are the Champions" Acapella (Vocals Only) Concert Mash-Up | This is an isolated vocal track of a rock opera piece. There are no instruments. A passionate male vocalist is singing melodically in the lead. There is a choir in the background providing medium-to-high pitched back vocals. There is an uplifting atmosphere. This piece could be used in remixes. Vocal samples can be lifted for DJ sets or beat-making. | 2015-12-30T08:49:25Z | Playback.fm | About video: http://playback.fm/blog/queen-we-are-the-champions-acapella/ - Follow us on Facebook: https://www.facebook.com/playbackapp We love Queen and Freddie Mercury, so we've edited 4 concert films including a rare recording session of "We Are The Champions" and synced them all up to the isolated vocals in honor of the late, great, Freddie Mercury. This video showcases his presence and consistency as the ultimate stage man. RIP Freddie. You are a rock god. | ["Chant", "Music"] | ["rock opera", "vocal track", "no instruments", "male vocal", "passionate singing", "choir", "dramatic", "uplifting", "vibrant"] | 9 | GF8QWSW0UbY | 1701 | |
| 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 |
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;