musiccaps_details (view)
2 rows where youtube_channel = "YourGuitarSage"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Careless Love Guitar Improvisation - Pentatonic Scale - Harmonic Minor - Major Scale Usage | One acoustic guitar is strumming chords while the other one is playing a solo melody on top with bending notes in a pentatonic scale. This song may be playing at home practicing guitar. | 2012-03-03T19:14:55Z | YourGuitarSage | This video is a guitar improvisation jam using the classic swing tune, "Careless Love". If you want the form for the pentatonic scale, go to http://www.yourguitarsage.com and get the free Ultimate Guitar Guide. If you like free guitar lessons, your mom will be so proud of you for subscribing to my channel. That is if Free and Guitar are things you like... Your $1 UGS membership trial is right here: http://www.yourguitarsage.com/1-dollar Feel free to ask me guitar questions on Twitter at: http://www.twitter.com/yourguitarsage and Facebook at http://www.facebook.com/yourguitarsage Now go swing that guit fiddle! :) e | ["Blues", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["folk rock", "acoustic guitars", "amateur recording", "uptempo", "uplifting vibe"] | 6 | RSryuuvUfDM | 2703 | |
Guitar lesson Lonely Boy by the Black Keys showing chords, licks, riffs & tricks beginner | The low quality recording features a cover of an alternative/indie song that consists of acoustic guitar melody. It sounds groovy and the recording is in mono and noisy. | 2011-12-16T06:16:34Z | YourGuitarSage | Go to http://www.yourguitarsage.com/the-ultimate-guitar-guide-part-1/ to find out how to get a free guitar ebook that will help you play this song and 100s of other songs!!! This guitar lesson vid shows you how to play Lonely Boy by the Black Keys. It shows you the chords, strumming technique and style. Check out http://yourguitarsage.com/ for info on my online instructional resources about charts, chords, strumming and the techniques that I use here in my videos.. For more guitar lessons, see my other free tutorials. For original and cover music by me, Erich, go to http://www.myspace.com/erichandreas . Since I'm so busy making new video tutorial lessons all the time and teaching guitar, I probably won't have time to answer individual questions regarding guitar. Other videos cover beginner, advanced and intermediate levels. I teach rock, blues, country and just about any other style on electric or acoustic. If you can't find your answer from the resources at the website above, keep digging into my vids, and I'm sure you will find your answer. Keep practicing!!! Your $1 UGS membership trial is right here: http://www.yourguitarsage.com/1-dollar Of course you can follow me on Twitter!! http://twitter.com/yourguitarsage Like me on facebook -- http://www.facebook.com/pages/Your-Guitar-Sage/168919156461750 Get the YourGuitarSage AppRats app for your Facebook page and never miss another video! http://apps.facebook.com/yourguitarsage/ ...and for Twitter, too! http://twitter.apprats.com/YourGuitarSage | ["Music", "Steel guitar, slide guitar", "Plucked string instrument"] | ["low quality", "alternative/indie", "acoustic guitar melody", "noisy", "mono", "groovy", "cover"] | 4 | We9P_UcHNk8 | 3119 |
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;