musiccaps_details (view)

1 row where musiccaps_aspects contains "exercise" and musiccaps_names contains "Blues"

✎ 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
35 Blues Licks Guitar Lesson The excerpt features an electric guitar playing a descending melody note by note with a slight distortion effect on. This doesn't sound like actual music but more like an exercise. 2013-03-09T16:30:19Z gmcguitar Backing tracks: Slow Blues: 14:17, Tasteful Blues: 18:14, Blues Duet: 22:18, Kenny Wayne Style: 25:13 More blues licks: http://bit.ly/1awubom Slow Blues Lesson : http://bit.ly/1hTGBcf Tasteful Blues Soloing Lesson : http://bit.ly/1mE5zN2 Blues Duet Rhythm & Solo Lesson : http://bit.ly/1bni8XV Kenny Wayne Shepherd Phrasing Lesson : http://bit.ly/1mE5ZTz Blues licks shown in this video : Kenny Wayne Style - 00:03 Xtreme Bending - 00:19 Double Lickin' - 00:40 Eric Clapton Style - 01:39 SRV Style Ending - 01:59 Bottleneck Lick - 02:18 SRV Turnaround - 02:36 Modern Blues - 03:02 Double Stops - 03:20 Turnaround - 03:39 Robben Ford Style - 04:13 Ending Lick In E - 04:31 SRV Style - 05:10 Major Minor Lick - 05:30 Albert King Style - 06:09 Classic Shuffle - 06:32 E Blues - 06:52 SRV Style Shuffle - 07:08 Slow Blues - 07:27 I-iV-V Rhythm - 07:50 Blues Riff - 08:34 Mix-O-Major - 08:56 Blues Rhythm - 09:28 Pentatonic Legato - 09:51 Bluesy Groove - 10:13 Blues Power - 10:36 Minor Comping - 10:56 Pentatonic Power - 11:19 Kenny Wayne Style Ending - 11:40 Robben Ford Style - 12:06 Blues Rake Lick - 12:26 BB King Style Lick - 12:57 Shuffle Comping - 13:20 SRV Style Bending - 13:35 BB King Style - 13:56 Related '30 Blues Greats' video : https://www.youtube.com/watch?v=55auX-OxpNk ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] ["electric guitar", "slight distortion effect", "no music", "exercise"] 2 k2uiJXN3L6E 4294

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;