musiccaps_details (view)
2 rows where musiccaps_aspects contains "gospel" and musiccaps_aspects contains "passionate male vocal" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- gospel · 2 ✖
- live performance 2
- low quality 2
- passionate 2
- passionate male vocal · 2 ✖
- soulful 2
- background harmonizing mixed choir 1
- crowd clapping 1
- crowd harmonized singing 1
- emotional 1
- energetic 1
- footsteps 1
- noisy 1
- shimmering hi hats 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The very best of Black Gospel - Hallelujah | The low quality recording features a very interactive live performance of a gospel song that consists of crowd harmonized singing and clapping, alongside passionate male vocals and shimmering hi hats which gives it a subtle rhythm. It sounds passionate, energetic and soulful. | 2009-12-27T00:04:33Z | SissyParker | 13.12.2009 The very Best of Black Gospel live at the St. Michael Church in Schweinfurt. Last year it was already awsome but this year it was even greater. A night filled with lots of Feelings and Emotion | ["Singing", "Gospel music", "Music", "Song"] | ["low quality", "live performance", "passionate male vocal", "crowd harmonized singing", "crowd clapping", "shimmering hi hats", "soulful", "energetic", "passionate", "gospel"] | 4 | Fg8yzA7zifw | 1659 | |
I Want Jesus to Walk With Me (Music Video) | Alex Boyé and The Tabernacle Choir | The low quality recording features a live performance of a gospel song and it consists of passionate male vocal singing over harmonizing mixed choir in the background. The recording is a bit noisy and it has some footsteps sounds in it, but overall it sounds passionate, emotional and soulful - as every gospel song should sound. | 2012-10-31T22:51:03Z | The Tabernacle Choir at Temple Square | Purchase "I Want Jesus to Walk With Me" from the album "Come Thou Fount of Every Blessing: American Folk Hymns and Spirituals": Amazon: http://amzn.to/WqlRyH iTunes: http://bit.ly/TV9N9q Deseret Book: http://bit.ly/Qob6tB LDS Store: http://bit.ly/R1mEEu Alex Boyé joins The Tabernacle Choir in a music video capturing the emotionally moving "I Want Jesus to Walk with Me." Singing from the shores of Cape Coast, Ghana where slaves were sent from Africa to America, Boyé, a member of the Choir, sings what he calls "one of his favorite pieces of music," that reflects the longing, yearning, and hope to find solace and strength with Jesus. | ["Music", "Choir"] | ["low quality", "live performance", "gospel", "passionate male vocal", "background harmonizing mixed choir", "soulful", "emotional", "passionate", "footsteps", "noisy"] | 4 | 0VsjSa1X7iA | 176 |
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;