musiccaps_details (view)

1 row where musiccaps_aspects contains "external amplification", musiccaps_aspects contains "medium tempo" and "youtube_published" is on date 2008-06-24

✎ 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
Steve Stevens (Billy Idol) guitar lesson & interview This clip is an instrumental. The tempo is medium with an electric guitar solo lead. There are no other instruments used. There is an interaction between two men in the interval . The music is powerful, loud and skilled and the speech indicates that this is probably a tutorial on how to play the guitar or an interview. 2008-06-24T02:20:17Z bloodySunday77 Steve Stevens, the guitarist of Billy Idol, talks about his influences and gives an insight on his song writing process, style and playing technique. He also shows how to play the basic chords of "Rebel Yell", "White Wedding", "Eyes Without A Face", "Dancing With Myself" and "Rat Race". Wonderful guy, great rock composer, amazing guitarist. Enjoy! PS. If you look very carefully, you can see the letters of those Bare Knuckle pickups on his gorgeous Les Paul. They must be the Mules (according to him, he was using them in the past) because I think the Rebel Yells did not exist at the time this video was made. (Don't take their sound as a characteristic "Mule" sound though - they put him to play through a Fender G Decn for f's sake) PS. It's an old video (probably from Guitar World) with very low resolution. Nothing I can do about that - sorry. ["Reverberation", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] ["instrumental", "electric guitar", "medium tempo", "external amplification", "embedded pickups", "sonic power", "powerful", "amplified guitar", "vibrations", "dexterity", "male voices interaction", "interview", "tutorial", "guitar tutorial"] 7 IqGB4nQIAcQ 1946

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;