musiccaps_details (view)

2 rows where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "external amplification", musiccaps_names contains "Music" and musiccaps_names contains "Reverberation"

✎ 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
Keeley Memphis Sun Part II This music is instrumental. The tempo is medium with rhythmic drumming accompaniment. The melody is simple and gets interesting as a layer of drums gets added. It is spirited, catchy and engaging. 2015-10-21T22:38:15Z Mike Hermans https://robertkeeley.com/product/Memphis+Sun+LoFi+Reverb+Delay+ADT/ Memphis Fun – What The Heck Is That? The new Memphis Sun – Lo-Fi Reverb, Echo and Double-Tracker is our second studio themed pedal. Like the Keeley 30ms ADT this pedal gives you a wealth of tones for capturing that classic Rock-and-Roll sound as well as sounds you’ve not heard before. It’s NeoVintage. It’s an Echo and Reverb pedal. Think of this pedal as three different effects: ECHO 600 – Echo for Long Delays SUN MODE – Auto Track-Doubling and Slapback with Short Delays REVERB – Room Reverb – Full Studio Studio Simulation. Both of the ECHO 600 and SUN MODE effects have a Room Reverb. It’s a one-knob, rock and roll type of room reverb. ["Reverberation", "Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Distortion"] ["instrumental", "medium tempo", "electric guitar", "sonic power", "spirited", "catchy", "engaging", "smooth", "rock", "external amplification", "vibrating strings", "slick drumming", "layers of music", "groovy", "catchy", "energetic", "sonic power", "minimal instrumentation"] 7 U-L9YCIdLbg 2880

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;