musiccaps_details (view)

1 row where musiccaps_names contains "Effects unit", musiccaps_names contains "Guitar", musiccaps_names contains "Plucked string instrument" and "youtube_published" is on date 2008-03-28

✎ 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
Fender Starcaster Distortion Pedal Demo This clip features an electric guitar played through a distortion effects pedal. At the beginning, the sound is open. The guitar plays a power chord using down strokes. After changing settings on the pedal, a chord is strummed and then arpeggiated notes are played. This produces a 'closed' sound. There are no voices in this song. There are no other instruments in this clip. This clip can be played in a demo video of the distortion effect pedal. 2008-03-28T02:14:12Z creepingnet After three takes, I finally manage to keep this thing under 10 minutes...to 9:53 seconds. This is the other pedal I decided to put up here to show what it can do. Once again I use the Jaguar and the V-Amp with no effects and a flat EQ to show the pedal's tone changes and capabilities as much as possible, however, as with all distortion, an amplifier difference can drastically change the sound output. No other pedals were used in the signal chain. ["Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Rock music", "Plucked string instrument"] ["distortion guitar", "power chords", "down strokes", "two different effects", "effects pedal", "no other instrument", "no voices", "instrumental"] 0 6OVb3rjcB3Q 749

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;