musiccaps_details (view)
1 row where musiccaps_aspects contains "embedded pickups", musiccaps_aspects contains "guitar tutorial", musiccaps_names contains "Guitar" and musiccaps_names contains "Reverberation"
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
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;