musiccaps_details (view)

1 row where musiccaps_aspects contains "guitar licks", musiccaps_aspects contains "no other instrument", musiccaps_aspects contains "no voice" and musiccaps_names contains "Guitar"

✎ View and edit SQL

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
MXR M68 Uni-Vibe Chorus/Vibrato Pedal This clip features an electric guitar being played. This electric guitar has a distortion effect. A chorus effect is also added. The distortion guitar starts off with a descending lick on the pentatonic scale followed by palm muted power chords. A few double stops are played and at the end, a string bend is played. There are no other instruments in this song. There is no voice in this clip. This song can be used in a demo of a chorus effects pedal. 2014-09-24T04:00:01Z Guitar World This video is bonus content related to the November 2014 issue of Guitar World. For the full range of interviews, features, tabs and more, pick up the new issue on newsstands now or at the Guitar World Online Store:http://guitarworld.myshopify.com/collections/guitar-world/products/guitar-world-november-14-billy-gibbons-and-jeff-beck Heard on numerous classic recordings by players like Jimi Hendrix, David Gilmour and Robin Trower, the Uni-Vibe is essentially a four-stage phase shifter. However, without going into a full-blown technical explanation, the components and circuit have certain quirks that distinguish it from a run-of-the-mill phase shifter. For decades, the only viable choices for guitarists seeking authentic classic Uni-Vibe effects were to hunt for an original vintage unit or buy a boutique version, but both options were expensive. The new MXR M68 Uni-Vibe Chorus/Vibrato solves this dilemma once and for all by providing genuine Uni-Vibe effects with thick, rich swirling textures in a pedal that costs less than half of the price of most acclaimed boutique versions. ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] ["electric guitar", "distortion guitar", "guitar riffs", "guitar licks", "no other instrument", "no voice", "instrumental"] 0 cHMDIt3-TsE 3696

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;