musiccaps_details (view)
2 rows where musiccaps_author = 4, musiccaps_names contains "Blues" and musiccaps_names contains "Jazz"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 17 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jam Track - Jazzy Funk Blues - Bm7 (rhythm guitar track) | The Low quality recording features a groovy acoustic rhythm guitar melody that occasionally has some audio cuts out in the stereo image - making it sound unbalanced. | 2013-11-28T08:13:31Z | Randy Struble Backing Tracks | A play on the Bm7 chord in a funk, jazz, blues kinda way!! Listen! Be inspired! Create! Improvise! Enjoy!! You can DOWNLOAD this and any of my other Jam/Backing Tracks @ https://bluegrassbackingtracks.bandcamp.com/track/jam-track-jazzy-funky-blues-bm7-rhythm-guitar-track Thanks for using a Backing Track by Randy Struble Produced with CyberLink PowerDirector 10 | ["Blues", "Funk", "Guitar", "Jazz", "Acoustic guitar", "Music", "Strum"] | ["unbalanced stereo", "audio cutout", "groovy acoustic rhythm guitar melody", "low quality"] | 4 | VOWGbyg4KZY | 2998 | |
Shirley King - Let The Good Times Roll | The low quality recording features a live performance of a jazz song and it consists of a passionate female vocalist singing over groovy piano melody, saxophone melody, groovy bass, shimmering hi hats, punchy snare and soft kick hits. It sounds passionate, soulful and the recording is noisy and in mono. | 2008-11-26T05:14:33Z | Bob .Hampton | Daughter of the Blues Shirley King on B.B King's "Let The Good Times Roll". Performed at the VFW in Berwyn, IL at a benefit for Big Time Sarah's church | ["Blues", "Singing", "Jazz", "Music", "Harmonic"] | ["low quality", "live performance", "passionate female vocal", "groovy piano melody", "saxophone melody", "groovy bass", "shimmering hi hats", "punchy snare", "soft kick hits", "jazz", "passionate", "soulful", "noisy", "mono"] | 4 | mFcHGbnNtSQ | 4456 |
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;