musiccaps_details (view)
2 rows where musiccaps_aspects contains "clean sound", musiccaps_aspects contains "no singer", musiccaps_aspects contains "rock music" and musiccaps_names contains "Musical 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Danelectro Reel Echo Jam | This is an instrumental rock music jam. The only instrument is a clean-sounding electric guitar playing an arpeggio with an added echo effect. The atmosphere is calming. Although the recording quality is a bit low, this piece could be playing in the background of a rock bar after a decent mix is applied. | 2008-08-10T08:24:19Z | slugsvideos | I just tried out the 'Reel Echo' a bit. Settings are: https://dl.dropbox.com/u/7261736/WP_000222.jpg | ["Echo", "Effects unit", "Guitar", "Heavy metal", "Music", "Musical instrument", "Distortion"] | ["jam", "rock music", "electric guitar", "clean sound", "single instrument", "no singer", "instrumental", "echo", "gentle", "calm"] | 9 | J0RzvGnQxD0 | 1958 | |
| 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 |
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;