musiccaps_details (view)
2 rows where musiccaps_aspects contains "no singer", musiccaps_aspects contains "rock music", musiccaps_names contains "Musical instrument" and musiccaps_names contains "Plucked string instrument"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Change The World, Eric Clapton, Fingerstyle Guitar, Jake Reichbart, lesson available | This is an instrumental rock music piece. The piece is being performed on a clean sounding electric guitar. There is an easygoing guitar solo being played. The atmosphere is groovy. This piece could be used as an advertisement jingle. | 2008-07-24T14:41:20Z | Jake Reichbart | Updated 2021: I have continued to post a new guitar arrangement nearly every Friday for the past 12 years, currently up to 550+ guitar arrangement videos. I have also produced 200+ full length video lessons teaching some of my most popular arrangements note for note, going into right hand technique, articulation, improvisation and 100 other topics that solo guitar arranging is made of. To learn all about my lessons, cost and discounts, please visit here: https://www.jakereichbart.com/jr-lessons.html check out also my method lesson "An introduction to fingerstyle guitar and solo guitar arranging" here: https://youtu.be/Yug7Qe-xNXs email me jake.reichbart@gmail.com with any questions. Also, please consider becoming a patron for as little as $3 at https://www.patreon.com/JakeReichbart Monthly lessons, on air requests, custom arrangements made just for you are among the perks offered, please take a look, thanks! The best fingerstyle guitar lessons on YouTube! Please read on! Updated June, 2018 - An hour long widescreen DVD lesson - also downloadable - on how to perform this arrangement, and much more, is now available!!! Every note and chord is shown slowly and in closeup. No online store, just email me at jake.reichbart@gmail.com to learn more! All my video guitar lessons are now also available as downloads, simply email jake.reichbart@gmail.com for all the info and just write "Guitar Lessons", or similar, in the subject line! Most lessons are on my specific song arrangements for solo guitar, check out these samples: https://www.youtube.com/watch?v=LM2ZyCduUqk Also check out my lesson "How to Arrange Any Song for Solo Guitar": http://www.youtube.com/watch?v=jg-et0nVgo8 #fingerstyle #fingerstyleguitar #acousticguitar #guitarcover #jazzguitar #acousticcover #sologuitar A complete list of all my 200+ guitar lessons, and much more, is available at https://www.jakereichbart.com/guitar-video-lessons/dvds-downloadable-guitar-lessons.html and you can also email me at jake.reichbart@gmail.com for more info. Please… | ["Flamenco", "Guitar", "Musical instrument", "Plucked string instrument"] | ["rock music", "no singer", "instrumental", "single instrument", "electric guitar", "clean sound", "guitar solo", "easygoing", "groovy"] | 9 | QS3DabGF41Y | 2619 | |
| Epiphone Les Paul Blues in G | This is an instrumental rock music piece recording in the style of blues. There is an electric guitar playing a solo using the shredding technique. The backing track consists of a piano, a bass guitar and acoustic drums. There is a groovy feel to it. Parts of this recording could be sampled for use in beat-making. | 2006-02-22T07:39:48Z | Raúl Cabezalí | Download my tunes for free from http://www.jamendo.com/en/artist/353294/raulin-de-los-bosques Raulin de los Bosques plays some blues licks over a g-blues backing track on a Epiphone 'Les Paul' Standard through his Behringer V-amp2. | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["rock music", "jam", "no singer", "instrumental", "electric guitar", "guitar solo", "shredding", "backing track", "piano", "bass guitar", "acoustic drums", "groovy", "blues"] | 9 | hVVrl9FkKnY | 4113 |
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;