musiccaps_details (view)

1 row where musiccaps_aspects contains "engaging crowds", musiccaps_aspects contains "guitarist talks", musiccaps_names contains "Plucked string instrument" and musiccaps_names contains "Tapping (guitar technique)"

✎ View and edit SQL

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
Andy McKee explains fanned frets (Multi-scale Geometry) - Piermont, NY 3/3/09 (7/10) A guitarist is tuning his guitar making string noises, peg sounds and fretboard noises. The audio is very bad with a boomy low end. The conversation is engaging and keeps the crowds occupied as the guitarist gets ready for the next song. 2009-04-11T05:55:32Z Rael0505 While preparing for Shanghai (as requested by someone in the audience), Andy McKee broke a string and began talking about his tour in Asia while restringing. Towards the end of the video he explains why the frets on his guitar are crooked, a question a lot of people are wondering. Basically, the fanned frets on his new Greenfield guitar are both comfortable ergonomically and provide more accurate intonation. And although he doesn't mention it in this video, fan frets handle dropped tunings much better than regular frets do (and since Andy plays in so many different alternate tunings, fanned frets must be a dream come true). Thicker strings are naturally designed for a wider scale length - I would say all guitars should be built this way, and for a lot of handmade instruments with more than 6 strings, they are mandatory. You can see him play Shanghai in the next video, linked below: http://www.youtube.com/watch?v=uuUeAwnTYzA&fmt=18 ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] ["guitarist talks", "tuning notes", "tuning pegs", "guitar master class", "guitar solo", "live concert", "live audience", "soloist", "random notes", "laughing", "bad audio quality", "engaging crowds", "performer", "famous guitarist", "tuning legs", "fretboard sounds", "no fixed tempo", "bad audio quality", "ambient crowd noises"] 1 cQX-WgT0ACQ 3705

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;