musiccaps_details (view)
2 rows where musiccaps_aspects contains "gospel" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- gospel · 2 ✖
- busy kick pattern 1
- choir 1
- clapping 1
- encouraging 1
- female background shouts 1
- female lead vocalist 1
- female singer 1
- finger snaps 1
- group vocals 1
- heavy drumkit 1
- hopeful 1
- low fidelity recording 1
- male rapper 1
- one chord 1
- organ chords 1
- piano 1
- slow tempo 1
- spiritual 1
- syncopated bassline 1
- vamp 1
- women's choir 1
musiccaps_names (array) 6 ✖
- Music 2
- /t/dd00003 1
- Choir 1
- Gospel music 1
- Singing 1
- Synthetic singing 1
youtube_published (date) 2 ✖
- 2007-12-11 1
- 2010-04-23 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Charles aka Faithful Singing Pleasure P Did U Wrong | A low fidelity recording of a gospel choir with group vocals, a female singer, a male rapper, piano, a busy kick pattern, finger snaps and a slow tempo. The mood is hopeful and spiritual. | 2007-12-11T05:35:03Z | Nook4pound | Pleasure | ["Music", "Choir", "/t/dd00003", "Synthetic singing"] | ["low fidelity recording", "gospel", "choir", "piano", "group vocals", "female singer", "male rapper", "busy kick pattern", "finger snaps", "slow tempo", "hopeful", "spiritual"] | 8 | 01hjVJN9xCg | 111 | |
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 |
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;