musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_author = 6, musiccaps_names contains "Plucked string instrument" and musiccaps_names contains "Tapping (guitar technique)"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 8 ✖
- amateur recording 3
- e-guitar 2
- e-guitars 1
- finger tapping 1
- medium tempo 1
- medium to uptempo 1
- rock 1
- slow tempo 1
musiccaps_names (array) 7 ✖
- Guitar 3
- Music 3
- Musical instrument 3
- Plucked string instrument · 3 ✖
- Tapping (guitar technique) · 3 ✖
- Electric guitar 2
- Distortion 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1963 Gretsch Chet Atkins 6120 | CME Vintage Demo | Someone is playing a melody on the e-guitar with a lot of reverb and a little bit of delay. This song may be playing guitar at home. | 2013-04-27T14:55:44Z | Chicago Music Exchange | Gretsch Chet Atkins 6120 1963 w/OHSC Shop Gretsch at chicagomusicexchange.com We were lucky enough to purchase this from a pro player who owned, played and loved (ie. took meticulous care of) this guitar for a very long time. The original orange color is one of the most vibrant we've seen. The neck is smooth as silk and the thing practically plays itself and the Bigsby is extremely responsive and a joy to use. The filtertrons are chimey and thick sounding and even unplugged the guitar sings loud and clear. Check out our Giveaways page to win gear! - https://www.chicagomusicexchange.com/pages/giveaways | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["amateur recording", "e-guitar", "medium to uptempo"] | 6 | CodqNx1ukOc | 1403 | |
Protest The Hero - Sequoia Throne [2] | Someone is strumming chords on a distorted e-guitar while someone is playing a fast solo up the fretboard with another e-guitar. This song may be playing practicing solos at home. | 2010-01-14T03:52:09Z | kamikaz1k | Tim's Axe - Caparison Dellinger Luke's Axe - Ibanez S5470 | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "rock", "e-guitars", "slow tempo"] | 6 | L1fxVVl_1bM | 2143 | |
BEST Guitar Tapping EVER 2!!!! | someone is playing a distorted e-guitar. Playing a melody using finger tapping. This is an amateur recording. This song may be playing at home practicing finger tapping guitar. | 2011-07-03T09:00:26Z | Angel Rising Guitar Channel | FREE download of my 1st album at http://www.sutros.com/listenangel TABS Here http://www.listenangel.com/pages/tabs/guitar-hero-2.html | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["e-guitar", "finger tapping", "amateur recording", "medium tempo"] | 6 | kGo-dAQXtsA | 4305 |
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;