musiccaps_details (view)

1 row where musiccaps_aspects contains "e-guitars", musiccaps_aspects contains "medium to uptempo", musiccaps_aspects contains "upright bass" 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
Easy Jazz Backing Track (Medium Swing) // 2-5-1 in A Minor Someone is playing a e-guitar solo over another e-guitar providing jazz chords along with acoustic drums playing a jazzy groove with little licks and a steady straight groove in the ride that is panned to the right side of the speakers. An upright bass in playing a walking bassline. This song may be playing at a jazz bar. 2014-06-24T14:42:39Z Quist 🎼 INTRO SOLO TAB & NOTATION → http://bit.ly/2QrVL3c Starts 0:45 SLOW version https://goo.gl/bimM3Z Bassless version http://goo.gl/hJem9j More 2-5-1 play-alongs http://goo.gl/Q1AGSe Download FREE Am Jazz Blues http://bit.ly/2Awwlqh 🎼 ALL TABS, SCALE MAPS + LESSONS 👉 http://www.patreon.com/QuistJam Here's a fun, swinging jazz practice backing track for improvising on the classic minor 2-5-1 progression in the key of A Minor Easy A Minor Jazz Blues Jam Track https://goo.gl/txq320 Slow Jazz Blues Jam Track https://goo.gl/D5obXd Minor 2-5-1 jazz practice jam track in ALL 12 keys http://bit.ly/2cczEqz Smooth Jazz Blues Jam Track (Am) https://goo.gl/pxjRVW More jazz play-alongs https://goo.gl/UlXMTt Chord progression: II: Bmin7b5 I E7 I Amin7 I Amin7 :II On the track, you will hear extensions of these chords - as is common in jazz of course :) Scale suggestions: A minor scale - A B C D E F G (A) (Bmin7b5 chords and Amin7 chords) A harmonic minor scale - A B C D E F G# (A) (E7 chords) Basic arpeggios: Bmin7b5 arpeggio = B D F A E7 arpeggio = E G# B D Am7 arpeggio = A C E G Next up, try out some more advanced colours on the dominant chord (E7) by treating it as an altered chord and using the altered scale: E altered scale - E F G Ab Bb C D (E) The altered scale is the mode which starts on the 7th step of the melodic minor scale, so in other words - the notes of E altered scale are the same as those of F melodic minor scale :) GET THESE SCALE MAPS + ARPEGGIO MAPS → http://bit.ly/34Np1o3 Here's a minor 2-5-1 lick you can try out http://goo.gl/McUjFO And here's lots more free 2-5-1 jam tracks http://goo.gl/GD3K8s Intro played on a Peerless guitar - borrowed from the one and only Les Davidson! Enjoy! Quist Website http://www.quistorama.com Newsletter http://eepurl.com/pERCT Facebook http://www.facebook.com/Quistguitar Instagram http://www.instagram.com/Quistguitar Twitter http://twitter.com/QuistJam Soundcloud https://soundcloud.com/qui… ["Swing music", "Guitar", "Jazz", "Music"] ["jazz", "e-guitars", "acoustic drums", "upright bass", "medium to uptempo"] 6 Mir959i7F2M 2292

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;