musiccaps_details (view)
1 row where musiccaps_names = "["Reverberation", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"]" and musiccaps_names contains "Electric guitar"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Reverb Shootout: Boss FRV-1 vs a Circa 1964 Fender Reverb Unit by Scott Sill | Two e-guitars are playing a melody with a little bit of reverb. The e-guitars sound clean. This is an amateur recording. This song may be jamming out with friends. | 2013-02-22T15:13:06Z | sillennium | Check out our new site: http://www.floguitarenthusiasts.com to learn more about The Flo Guitar Enthusiasts Radio Show! -We Talk Guitars, Tone and Gear- Scott Sill takes you through a Reverb Shootout between a Boss FRV-1 ('63 Fender Reverb) and an original 1968 Fender Reverb Unit. Scott plays the same guitar licks while keeping the exact same settings on the pedal and reverb unit to compare them. Scott even does a duel between the two reverbs playing two guitars to the song "Pipeline". Scott uses a Gretsch White Falcon with TV Jones pickups and a Nitro finish thorugh a Fender '57 Custom Twin. Scott used a Sennheiser e609 Silver guitar amplifier microphone along with a Zoom H4n. Like us on Facebook http://www.facebook.com/The.Flo.Guitar.Enthusiasts Follow Scott Sill on Twitter: http://twitter.com/Sillennium http://www.floguitarenthusiasts.com Video by: Scott Sill | ["Reverberation", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["e-guitar", "amateur recording", "medium tempo"] | 6 | JZnOGRCBW0I | 2019 |
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;