musiccaps_details (view)
3 rows where musiccaps_aspects contains "gospel" and musiccaps_aspects contains "harmony singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- gospel · 3 ✖
- harmony singing · 3 ✖
- acapella 2
- male vocals 2
- acoustic guitar 1
- banjo 1
- bluegrass 1
- children vocals 1
- choir 1
- christmas 1
- church hymn 1
- cozy 1
- easygoing 1
- festive christian 1
- fiddle 1
- goosebumps 1
- heart-touching 1
- live performance 1
- mandolin 1
- religious 1
- spiritual 1
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 | |
WPXI- America's Got Talent Jackie Evancho Sings A Cappella | This is an acapella version of a Christmas gospel music piece. There are children singing using the harmony singing technique. The piece has a heart-touching feel to it. This piece could be used in the soundtrack of a Christmas movie. | 2010-08-17T20:07:03Z | WPXI See & Be Seen | 'America's Got Talent' sensation Jackie Evancho sings a cappella during an exclusive interview at WPXI in Pittsburgh. She's joined by her sister, Rachel, and brother, Jacob for a song. | ["Humming", "Vocal music", "A capella"] | ["acapella", "christmas", "gospel", "children vocals", "harmony singing", "heart-touching", "goosebumps"] | 9 | OJuVsBojdvo | 2426 | |
Doyle Lawson and Quicksilver - Just Over In Heaven | This is the live performance of a bluegrass gospel music piece. There are male vocals synchronously harmony singing which is called a "stack" in bluegrass music. The melody is being played by the fiddle, the banjo, the acoustic guitar and the mandolin. There is a cozy atmosphere in this piece. It could be playing in the background of an American roadside diner. This piece could also be played at a Christian religious event. | 2010-11-26T01:42:06Z | Colt28683 | Doyle Lawson and Quicksilver - Just Over In Heaven Bluegrass Gospel | ["Singing", "Country", "Music", "Bluegrass"] | ["bluegrass", "gospel", "live performance", "male vocals", "harmony singing", "fiddle", "banjo", "acoustic guitar", "mandolin", "easygoing", "cozy"] | 9 | hHqrcLiKJRg | 4093 |
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;