musiccaps_details (view)
2 rows where musiccaps_names contains "Steel guitar, slide guitar" and youtube_channel = "gmcguitar"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Whammy Bar Phrasing Solo | The song is an instrumental. The tempo is medium with an electric guitar playing a dreamy solo with a keyboard accompaniment , string section harmony and rhythmic percussion rhythm. The song is passionate and emotional. The song is a rock guitar instrumental. | 2011-02-03T00:16:18Z | gmcguitar | Breathtaking solo by Piotr Kaczor with tabs and slow illustrations, more: http://www.guitarmasterclass.net/s/youtube-piotr-whammy-bar-2/ls/Whammy-Bar-Phrasing-II/ More Piotr lessons: http://www.guitarmasterclass.net/s/youtube-piotr-whammy-bar-2/instructor/Piotr-Kaczor/ | ["Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["guitar solo", "whammy bar", "keyboard harmony", "steady percussion rhythm", "tremolo", "vibrato", "guitar skills", "rock guitar solo", "dreamy", "emotional", "adrenaline rush", "retro guitar hits", "instrumental hits", "high on adrenaline", "string section accompaniment", "rock guitarist", "soloist", "keybiard harmony", "steady percussion rhythm", "d]steady drumming rhythm", "groovy music", "medium tempo"] | 1 | BqIZipifARo | 1294 | |
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
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;