musiccaps_details (view)
1 row where musiccaps_aspects contains "male vocals", musiccaps_aspects contains "religious" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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;