musiccaps_details (view)
4 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "guitar solo", musiccaps_aspects contains "no singer" and musiccaps_aspects contains "single 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Percussive Slap Technique - Acoustic Guitar Lesson Part 1 - The Basics | This is an instrumental jam piece. The only instrument is an acoustic guitar which is being played with a percussive slap technique. The track is groovy. This piece could fit perfectly as an advertisement jingle. | 2014-03-07T10:05:04Z | Gareth Evans | Watch the rest of this series now Part 1 - https://youtu.be/F1uXNtotVsg Part 2 - https://youtu.be/KI0LjpPiu5U Part 3 - https://youtu.be/5eBNvXbvxHQ Part 4 - https://youtu.be/TmGTzpyyE3c Part 5 - https://youtu.be/P81hTF8Bmw8 My website will be back very soon. http://www.goliathguitartutorials.com/ Don't forget to like and subscribe, it helps me a lot, thank you. Gareth | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["jam", "no singer", "instrumental", "single instrument", "acoustic guitar", "guitar solo", "percussive slap", "groovy", "easygoing"] | 9 | F1uXNtotVsg | 1609 | |
| 1963 fiesta red sparkle stratocaster in 1966 deluxe reverb | This is an instrumental jam. The only instrument being played is a clean sounding electric guitar. The guitar solo has simple, groovy tunes played in an improvised manner. The atmosphere is easygoing. Parts of this recording could be sampled to be used in beat-making. | 2008-08-05T22:43:30Z | vineeth77 | an ultra rare 63 red sparkle cutsom color, all original vintage fender stratocaster, L series, a little bit fiesta red sparkle... originla frets and nut... cream tolex case, with stratp etc... lava cable van den hul and 66 deluxe reverb with 1960 P12N jensen | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["jam", "no singer", "instrumental", "single instrument", "electric guitar", "guitar solo", "easygoing", "groovy", "clean sounding", "simple tunes"] | 9 | Kd7aHdOwh0I | 2100 | |
| 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 | |
| Fender Deluxe Reverb II Andy Gardiner | This is the recording of a gear showcase jam. There is an overdriven electric guitar playing a groovy solo with the amplified reverb effect. There is a crunchy sound. The piece can be used as the jingle of an advertisement. It could also be used for lifting electric guitar samples to be used in a beat. | 2010-01-20T21:51:48Z | Andrew Gardiner | Fender Deluxe Reverb II. 1983. Single 12" original CTS speaker. 1989 PRS C24. Basic control settings. | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Distortion"] | ["jam", "no singer", "instrumental", "single instrument", "overdriven electric guitar", "guitar solo", "effects", "reverb", "easygoing", "groovy", "simple tune"] | 9 | _KGUrOb1qgU | 3463 |
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;