musiccaps_details (view)
5 rows where youtube_channel = "GuitarJamz"
This data as json, CSV (advanced)
Suggested facets: musiccaps_author, youtube_published (date)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Blues Guitar Lessons - Stormy Monday - Style Blues Progression | The low quality recording features a cover of a blues song and it consists of subtly strummed, acoustic rhythm guitar, followed by electric guitar solo melody. It sounds passionate, easygoing and cool - like something you would hear in high end bars or blues clubs. The recording is a bit noisy. | 2010-12-31T03:07:30Z | GuitarJamz | Free Ebook when you sign my email list http://www.guitarjamz.com/new_requests/ Tony's Site http://www.tonybrucco.com | ["Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["cover", "low quality", "noisy", "blues", "subtly strummed acoustic rhythm guitar", "electric guitar solo melody", "passionate", "easygoing", "cool"] | 4 | 1JwoLPCIGhs | 259 | |
| Yellow Ledbetter Tab How to Play Pearl Jam guitar Lesson - Eddie Vedder | This clip features a guitar chord being strummed in the beginning. This is followed by a male voice narrating a song. There are no other instruments in this song. There is no vocal melody in this clip. | 2009-12-18T08:33:21Z | GuitarJamz | click here to request your song http://www.guitarjamz.com/new_requests/ Great Lessons at http://www.guitarjamz.com/shop/ | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["electric guitar", "male voice", "narration", "no other instruments", "no vocal melody"] | 0 | 1o7iTDLNTFk | 312 | |
| Hall and Oates - Rich Girl - How to Play on Guitar - Lesson - Tutorial - Guitar Lesson | The low quality recording features a tutorial where a flat male vocal is talking, followed by acoustic rhythm guitar chords. The recording is mono and noisy. | 2014-03-15T17:09:13Z | GuitarJamz | Please watch: "Beginner Acoustic guitar lesson "Tom Petty I won't back down" How to" https://www.youtube.com/watch?v=xJDQyT1zStY --~-- Lessons Here http://www.guitarjamz.com Marty's Links Facebook http://goo.gl/RKWhcZ Free lessons and Ebook: http://guitarjamz.com/new_requests/ Site http://www.guitarjamz.com Free Mobile Apps: http://guitarjamz.com/app/all_apps/ | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | ["low quality", "mono", "noisy", "flat male vocal", "acoustic rhythm guitar chords", "tutorial"] | 4 | GW6pti04qIo | 1728 | |
| Joe Bonamassa Inspired Guitar Lick - Blues Rock Guitar Lessons - Speed Building | This is the recording of a guitar lesson video. There is a male instructor first performing the tune and then describing what he is playing. The tune is being played on a clean sounding electric guitar and there is a blues feel to it. The atmosphere is easygoing. The parts the male voice is not heard can be sampled for use in beat-making. | 2011-06-01T23:23:19Z | GuitarJamz | My Technique and review channel http://www.youtube.com/youcanlearnguitar Joe Bonamassa Inspired Guitar Lick - Blues Rock Guitar Lessons - Speed Building Excercise marty schwartz lesson against rise electric metal picking steve play "guitar lesson" chords gilbert sweep improvisation guitarist solos beginner learn acoustic tab jazz scales jam instrumental guitars "electric guitar" minor classical "guitar lessons" | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | ["guitar lesson", "male voice", "electric guitar", "clean sound", "blues", "easygoing"] | 9 | YDh36ZdneAU | 3266 | |
| Stevie Ray Vaughan - Love Struck Baby - Blues Guitar Intros - SRV - Blues Guitar Lessons | This audio clip features an instruction of playing the guitar. An electric guitar plays a descending pentatonic run at two different places on the guitar to give a different feel. The voice narrates the process of playing the notes. This is followed by a double stop which is played seven times with a string bend on the eighth time. This can be used in an instruction video. | 2013-02-13T21:04:13Z | GuitarJamz | Please watch: "Beginner Acoustic guitar lesson "Tom Petty I won't back down" How to" https://www.youtube.com/watch?v=xJDQyT1zStY --~-- Click Here http://www.guitarjamz.com/ytblues | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["electric guitar", "instructional clip", "male voice", "pentatonic scale descending run", "double stop", "string bending"] | 0 | rn_v88OiRks | 4902 |
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;