musiccaps_details (view)

2 rows where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "live recording", musiccaps_names contains "Music" and musiccaps_names contains "Plucked string instrument"

✎ 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
How to tap on guitar (super fast tapping lesson) This is a tutorial on the electric guitar. The guitar is high-pitched and rapid arpeggio notes are played on it. The audio is of a poor quality. The individual makes a comment at the end of the video. 2008-05-26T02:36:00Z Amanda Riddle just me explaining the best i can how to tap on a guitar and the different kinds of tapping. I also explain how to do what i like to call video game tapping (One, lots of dragonforce stuff) woohoo over 100,000 views :) Thanks alot everyone. I hope that this video has helped you out. In light of this milestone, I plan to be producing more videos very very soon. So subscribe or just keep checking my channel (sp? lol) ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] ["electric guitar", "distortion", "high pitched", "live recording", "poor quality audio", "distorted audio", "background ambient noise", "speaking male"] 3 8Bu8CkR1xZY 901
fender deluxe reverb...heavy metal amp?? This is a live recording of a guitar being played through a high gain amp. The signal is clean at the beginning and switches to an overdrive or distortion tone. A humming noise is heard when the channel is switched to the distortion channel. There are no other instruments played in this clip apart from one guitar. The guitarist seems to be testing the clean and dirty channels of the guitar amplifier. 2010-04-06T00:07:26Z diagrammatisk Chirp chirp chirp ["Bass guitar", "Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Plucked string instrument", "Distortion"] ["live recording", "high gain amp sound", "electric guitar", "overdrive amp channel", "clean amp channel", "humming noise", "noise signal above threshold"] 0 SEDfsU63w8I 2749

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;