musiccaps_details (view)
2 rows where musiccaps_author = 8 and musiccaps_names contains "Effects unit"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Greer Amps Southland Harmonic Overdrive - Top Boost Gear | Solo performance of an electric guitar player strumming chords. The tone is overdriven and warm. The genre is rock. | 2014-10-17T13:45:51Z | Top Boost Gear | Available at WWW.TOPBOOSTGEAR.COM! The Southland Harmonic Overdrive is built on the Lightspeed Organic Overdrive platform, we have developed what we believe to be the best overdrive on the market. The Lightspeed was built with the specific purpose of being a light to mild overdrive. The Southland is the next logical step for the Lightspeed platform—more gain, with two stages of clipping (utilizing different diode types for each stage of clipping), a focused midrange (not that annoying “hump”), and a bit of presence on top of the signal, to help cut through the mix. The Southland Harmonic Overdrive, like the Lightspeed, is touch sensitive, responds to pick attack, and has dynamics that just won’t stop. On top of that, we’ve selected a chip to drive the Southland that takes it to the next level. | ["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"] | ["electric guitar", "overdrive", "strumming", "rock", "warm"] | 8 | NzvkMWY4EjA | 2387 | |
| AC-33 Acoustic Chorus Guitar Amplifier featuring Alex Hutchings | solo acoustic nylon string guitar playing in a fingerstyle Brazilian bossa nova style. | 2010-02-25T05:59:50Z | RolandChannel | http://www.roland.com/products/en/AC-33/ Worlds First AA Battery-Powered Acoustic Guitar Amp! Rich, deep, stereo sound to go — introducing the AC-33, the worlds first AA battery-powered amp made specifically for acoustic guitar. Portable yet powerful, the AC-33 provides true stereo sound, Guitar and Mic/Line channels, custom-tailored effects, anti-feedback, and a Phrase Looper. But this amp was made to go places no amp has gone before. Thanks to its battery-power capability, the AC-33 lets you take your act anywhere — into the backwoods, onto the streets, or wherever your imagination leads you. | ["Effects unit", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["solo guitar", "nylon string acoustic", "fingerstyle", "bossa nova", "brazilian"] | 8 | ZVvX2-ldhvY | 3387 |
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;