musiccaps_details (view)
2 rows where musiccaps_aspects contains "e-guitar", musiccaps_names contains "Distortion", musiccaps_names contains "Guitar" and musiccaps_names contains "Tapping (guitar technique)"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Harley Benton SC-550 Paradise Amber Flame sound test | Someone is playing a e-guitar melody and strumming chords using a lot of reverb and delay over a drum backing track. This is an amateur recording. This song may be playing at home practicing guitar. | 2015-07-10T17:17:35Z | Che Guebuddha | Harley Benton SC-550 Paradise Amber Flame from Thomann.de all stock. Amp is Kustom PH2012R and played through Digitech RP70 multi pedal. Same tune clean with delay-reverb and dirty fuzz territory afterwards. Because this cheap camera records very thin sound I had Tone down to almost 0. These are very hot pickups (Wilkinson Alnico) | ["Blues", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Distortion"] | ["amateur recording", "drum loop", "e-guitar", "uptempo"] | 6 | idUZsNLnyDg | 4209 |
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;