musiccaps_details (view)

3 rows where musiccaps_aspects = "["amateur recording", "e-guitar"]", musiccaps_author = 6 and musiccaps_names contains "Music"

✎ View and edit SQL

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
pedal joyo californiasound Someone is playing an e-guitar melody and licks. This is an amateur recording. This song may be playing at home practicing e-guitar. 2011-08-16T21:21:59Z sxguitar666 California Sound es el pedal que emula los mesas mk2 californianos de siempre. Prince, Slash, Santana,...entre otros. http://sxguitarist.com/ California sound, simulates mesa boogie MK ? amplifier 2.Get natural permeable or original sound and very full principal tone 3.High, mid, and low sound switches and voice, level and drive switches 4.True bypass design to minimize the tone loss 5.LED power indicator 6.Powered by 6F22 9V battery(included) or to the wall optional psu not included Specifications: 1.Input impedance: 1 Mω 2.Output impedance:1 kω 3.Running current: 3.8 mA 4.Voltage: 9V battery/adapter 5.Dimension: 120 x 97 x 55 mm 6.Net weight: 390g 7.Color: white http://sxguitarist.com/ ["Tapping (guitar technique)", "Music", "Distortion"] ["amateur recording", "e-guitar"] 6 I-XYm2Ck2r8 1858
Sperzel How To: Drop D Tuning Using "D-Thing Tuner" Someone is playing a fast paced melody running up and down a scale. This is an amateur recording. This song may be playing soundcheck with a band. 2011-04-09T20:41:10Z Peter Barlow Sperzel 1 ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] ["amateur recording", "e-guitar"] 6 JKbUVdMJAO8 1990
MARSHALL 8200 VALVESTATE AMP HEAD DEMO W Bi-Chorus Someone is strumming chords on an e-guitar. The e-guitar is slightly out of tune. This song may be playing at home trying out sounds on the e-guitar. 2013-08-30T20:43:55Z allanz00 This demo is only meant to show a little of the performance of what the Marshall 8200 Amp head can do (Not My playing LOL.) The gear is a Marshall 8200 Valvestate 200w (100w x 100w) head on top of a Marshall JCM 900 Lead 1960 4 speaker cab. The pedal is a Fulltone GT-500 Distortion & Booster/OD pedal. Used the Chorus channel at around 2:43 nothing fancy, really just played a bit of whatever I was felling at the time. ["Bass guitar", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] ["amateur recording", "e-guitar"] 6 PB3i02Cjf1k 2515

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;