musiccaps_details (view)
2 rows where musiccaps_author = 8, musiccaps_names contains "Gospel music" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 21 ✖
- bluegrass 1
- clapping 1
- country 1
- encouraging 1
- fast 1
- female and male yodeling 1
- female background shouts 1
- female lead vocalist 1
- gospel 1
- guitar 1
- heavy drumkit 1
- one chord 1
- organ chords 1
- simple chord progression 1
- simple rhythms 1
- steady bass and drums 1
- syncopated bassline 1
- vamp 1
- virtuosic 1
- women's choir 1
- yodeling 1
musiccaps_names (array) 7 ✖
- Gospel music · 2 ✖
- Music 2
- Singing · 2 ✖
- Christian music 1
- Christmas music 1
- Song 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
UBC Youth Choir Singing "Who's On The Lord's Side (Get Up)" 03.21.10-11AM | Encouraging gospel music featuring a women's choir, hand clapping, female background shouting, and a lead female vocalist. The choir is accompanied by a band vamping on one chord with an organist, heavy drumkit, and a syncopated bassline. Would fit in a southern spiritual service. | 2010-04-23T15:34:59Z | BaptistBoi | Youth Choir Singing an Elder Timothy Wright Classic!!! Please enjoy and continue to rate and comment!!! | ["Singing", "Gospel music", "Music"] | ["gospel", "clapping", "female background shouts", "encouraging", "female lead vocalist", "organ chords", "heavy drumkit", "syncopated bassline", "vamp", "women's choir", "one chord"] | 8 | 7fVfG0DrLjI | 872 | |
Buzz Goertzen - The Idaho Yodeler - TheIdahoYodeler.com | A female and male duo yodeling over a fast bluegrass band. The bass and drums are steady and simple as is the chord progression. The guitarist and other instrumentalists are virtuosic. | 2011-03-30T18:33:50Z | theidahoyodeler | Nothing stirs up an audience like yodeling, and no one yodels like Buzz Goertzen. His charismatic personality, wit and unique style have endeared him to audiences everywhere. Being also a gifted songwriter as well as a humorist, it is no wonder that standing ovations are the norm wherever he performs. He has written most of his own compositions, but also sings many of the "old favorite" yodeling songs of the past. Visit his website today at www.TheIdahoYodeler.com | ["Christmas music", "Singing", "Gospel music", "Yodeling", "Christian music", "Music", "Song"] | ["yodeling", "female and male yodeling", "country", "fast", "bluegrass", "steady bass and drums", "guitar", "virtuosic", "simple rhythms", "simple chord progression"] | 8 | Y7mTjfgcybQ | 3256 |
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;