musiccaps_details (view)

2 rows where musiccaps_aspects = "["amateur recording", "e-guitar", "medium tempo"]", 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
ROLAND JAZZ CHORUS JC-120 DEMO Someone is playing an e-guitar with a chorus effect playing a melody. This song may be playing at home practicing guitar. 2011-04-23T20:29:59Z slaytanictribute ["Guitar", "Music", "Musical instrument", "Radio", "Chorus effect"] ["amateur recording", "e-guitar", "medium tempo"] 6 C-NYmja61zE 1315
That Pedal Show – Strymon Deco demo. Do we know what it is yet? After a clicking sound and e-guitar slide up the fretboard someone is playing a melody on an e-guitar. White noise from the recording can be heard. This song may be playing in a guitar class. 2015-05-29T08:30:51Z Daniel TheGigRig PLEASE NOTE: From January 2016, we have moved. We are now here… https://www.youtube.com/channel/UCnUXq8mGmoHt0e6ItuTs10w Please subscribe to the That Pedal Show dedicated channel. In this episode of That Pedal Show, Daniel and Mick get to grips with the Strymon Deco. What does it do? It simulates the effects of running old tape machines, which means all manner of vintage-voiced phasing, flanging, tape saturation and automatic double tracking effects. Helping Daniel and Mick enjoy the Deco are Dan's Gibson Custom Shop R8 Les Paul and ’61 SG Junior. The pedal is running through a Lazy J J20 and a Mallard 18-watt Marshall clone. TheGigRig G2 is taking care of switching duties. Please note that only the Deco is active in the G2 loop – all the other pedals are disengaged. For more on TheGigRig, please visit www.thegigrig.com ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] ["amateur recording", "e-guitar", "medium tempo"] 6 kuj0Oi2_7yU 4365

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;