musiccaps_details (view)
2 rows where musiccaps_aspects contains "guitar solo", musiccaps_aspects contains "soloist" and musiccaps_names contains "Tapping (guitar technique)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- guitar solo · 2 ✖
- soloist · 2 ✖
- adventure music 1
- adventurous 1
- ambient crowd noises 1
- ambient echoes 1
- bad audio quality 1
- emotional 1
- engaging crowds 1
- exciting 1
- famous guitarist 1
- fretboard sounds 1
- guitar amplifier 1
- guitar demo 1
- guitar master class 1
- guitar played accompaniment style 1
- guitarist talks 1
- home video 1
- instrumental music 1
- laughing 1
- live audience 1
- live concert 1
- medium tempo 1
- no fixed tempo 1
- passionate 1
- performer 1
- poor audio quality 1
- random notes 1
- subtle bass line 1
- tone generator 1
- tuning legs 1
- tuning notes 1
- tuning pegs 1
- youtube music video 1
musiccaps_names (array) 7 ✖
- Guitar 2
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Tapping (guitar technique) · 2 ✖
- Electric guitar 1
- Reverberation 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1964 Fender Deluxe Reverb + 1999 Fender 52 Vintage Telecaster Part2 | The song is an instrumental. The song is medium tempo with a guitar playing solo accompaniment style, with a subtle bass line. The song is entertaining and passionate. The song audio quality is poor with a lot of ambient echoes. | 2010-03-17T17:54:45Z | GregsGuitars | 1964 Fender Deluxe Reverb is an original vintage amp - not Reissue. Tele has a Texas Special Pickup at the neck and a nocaster bridge pickup. Okko Diablo Custom made overdrive pedal with 3 channels www.gregorhilden.de | ["Reverberation", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental music", "poor audio quality", "guitar solo", "ambient echoes", "guitar played accompaniment style", "guitar amplifier", "tone generator", "subtle bass line", "home video", "youtube music video", "soloist", "guitar solo", "exciting", "adventurous", "guitar demo", "passionate", "medium tempo", "emotional", "adventure music"] | 1 | DUNOn71oGCw | 1482 | |
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
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;