musiccaps_details (view)

1 row where musiccaps_names contains "Guitar" and "youtube_published" is on date 2014-08-02

✎ 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
SVI Sound GE BOOST germanium booster pedal demo with SG & Dr Z Antidote An almost clean e-guitar is playing a gentle melody in a minor chord that is repeating itself. This song may be played at a backing track to practice along. 2014-08-02T13:39:35Z gearmanndude http://reverb.com/?query=svisound&utm_source=gearmandude Reverb is THE buying and selling source for all things new/used/vintage guitar and bass gear related...there's also drum and keyboard and other stuff! A large percentage of listings are in the 'make an offer' form, so you can really score some great deals. Much lower seller fees than eBay, and it's focused on music gear exclusively, so you don't have to wade through vintage Ford Mustang fenders and headlights, when you're really looking for a '69 reissue Mustang guitar. The selling format and layout is WAY faster and simpler than ebay as well. Check it out! http://www.svisound.com Awesome little multi tonal boost from the king of the small footprint box or art. I'm a big fan of this guys enclosures! SviSound! I used a Gibson SG Standard, cocked rocked and loaded with http://www.dallenpickups.com David Allen CRAZY CAT Humbuckers, and http://www.drzamps.com Dr Z Antidote amp, and a pair of mighty fine http://www.thedivinenoise.com Divine Noise tasty white coily and straight cables....yep! ["Electric guitar", "Guitar", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] ["e-guitar", "repetitive", "amateur recording"] 6 Ip6FptuXHyk 1943

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;