musiccaps_details (view)
3 rows where musiccaps_aspects contains "vamp" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- vamp · 3 ✖
- acoustic guitar strumming 1
- bowed bass 1
- bowed cello 1
- clapping 1
- clave 1
- drum set 1
- electric guitar 1
- encouraging 1
- female background shouts 1
- female lead vocalist 1
- gospel 1
- heavy drumkit 1
- melancholic 1
- mid-tempo 1
- one chord 1
- orchestra 1
- organ chords 1
- pedal steel 1
- pizzicato strings 1
- reverb 1
- roots rock 1
- stationary 1
- syncopated bassline 1
- two chords 1
- waiting 1
- women's choir 1
musiccaps_names (array) 6 ✖
- Music 3
- Gospel music 1
- New-age music 1
- Pop music 1
- Singing 1
- Ska 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 | |
Dr. Zwig - Sunshine Waves (Official Live Music Video) | A mid-tempo two chord vamp on a roots rock song. The music is instrumental, featuring a strummed acoustic guitar, drum set, electric guitar, and pedal steel. The feeling is melancholic. | 2014-06-25T00:13:04Z | Dr. Zwig | "Sunshine Waves" official live music video by Dr. Zwig. From the EP, 'Stones, Bones, And Skin' https://goo.gl/3cjzQz Stream / Buy: Apple Music / iTunes: https://goo.gl/DwQwp5 Spotify: https://goo.gl/8BDQuF Google Play: https://goo.gl/bXd58N Amazon: https://goo.gl/LchWW5 CD: https://goo.gl/wV1gxP Vinyl: https://goo.gl/pVdxCE CONNECT: http://DrZwig.com http://facebook.com/DrZwig http://twitter.com/Dr_Zwig http://instagram.com/DrZwig http://consciousrecords.com Copyright Adam Zwig 2014 Combustible Music / BMI Conscious Records LLC Album: Stones, Bones, And Skin Director/Producer: Randy Edwards Director/DP: Christian Meyers | ["Music", "Pop music", "Ska"] | ["roots rock", "acoustic guitar strumming", "drum set", "pedal steel", "electric guitar", "mid-tempo", "vamp", "melancholic", "two chords"] | 8 | KE-TVQhdCbs | 2069 | |
Sweet November (Enya - Only Time Video) | Orchestra music with pizzicato strings, bowed bass and cello, and a clave with reverb. The music feels stationary, like a vamp, with a sense of waiting. | 2010-03-01T20:16:35Z | zolics666 | My favorite film and music I love it | ["New-age music", "Music"] | ["orchestra", "pizzicato strings", "bowed bass", "bowed cello", "clave", "reverb", "stationary", "waiting", "vamp"] | 8 | _WYwB1qRgLM | 3474 |
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;