musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic piano", musiccaps_aspects contains "low tom backbeat", musiccaps_author = 8, musiccaps_names contains "Blues" and musiccaps_names contains "Swing music"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Sax & Harmonica Blues | Harmonica Blues, Saxophone Blues, Guitar Blues Music | Slow Blues Instrumental Chicago blues music featuring a saxophone melody interspersed with licks from harmonica, Hammond style organ, acoustic piano and electric guitar. The drums play a shuffled backbeat on the snare and low toms under a repetitive electric bass riff. Would be at home in a roadhouse or barbecue festival. 2015-06-23T20:06:53Z Dr. SaxLove Dr. SaxLove loves The Blues! He loves playin' The Blues and hearin' The Blues, especially Blues Harmonica, Saxophone Blues, and Blues Guitar. So here's some smokin' hot blues music from some of San Francisco's finest blues musicians. Enjoy! Many of these songs are available as backing tracks at: ►https://backingtracks.pro Saxophones: Mark Maxwell (Dr. SaxLove) Harmonica: Paul Michael Meredith Guitar: Garth Webber Keyboards: Tony Lufrano Bassist: Endre Tarczy Drummer: Jimmy Sanchez This music is from the album, Saxomonica Blues, by Mark Maxwell and Paul Michael Meredith, and can be found here: ►http://markmaxwellmusic.com/saxomonica-blues ►https://play.spotify.com/artist/2NSDNpSVMmZ5vK5PIjCe4N ►https://itunes.apple.com/us/album/sax-blues/id365744921 -------- The saxophone and the harmonica (blues harp) are great instruments on their own, but when you put them together playing some classic blues tunes, the result is some amazing stuff! This collection, which features some amazing Bay Area blues masters, really captures the essence of the blues harmonica, blues saxophone (saxofon), blues guitar, jazz blues, upbeat blues, down and dirty blues, and is just great fun to listen to. The blues guitar player on video, Garth Webber, has played with many notables including Miles Davis, John Lee H, Gregg Allman, and Boz Scaggs. Harmonica Blues is iconic - it speaks right to the heart. Saxophone blues is the same - people love it! This video is the best blues harmonica music; every song has a harmonica solo. Saxophone blues, too, is iconic, and brings a little jazz to the mix so you'll hear some saxophone blues jazz as well. Enjoy! ~Dr SaxLove ------------ Dr. SaxLove specializes in blues harmonica, jazz saxophone blues, blues guitar, slow blues, 12 bar blues, and blues instrumental music. His music is intended for relaxation, study music, dinner music, gaming, sensual times, and any time. Blues music just always sounds good and this is an excellent blues playlist. This is the music of saxophonist Mark Maxwel… ["Blues", "Swing music", "Music"] ["instrumental", "chicago blues", "saxophone", "harmonica", "electric guitar", "acoustic piano", "shuffle", "repetitive bass riff", "low tom backbeat", "hammond organ"] 8 YIhfk4Zaevk 3273

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;