musiccaps_details (view)
4 rows where musiccaps_aspects contains "cover" and musiccaps_names contains "Tapping (guitar technique)"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| blues solo in A tokai les paul and marshall jcm900 dual reverb combo | The low quality recording features a cover of a rock song that consists of an electric guitar solo melody played over playback instrumental. The instrumental features a punchy kick and snare hits, soft cymbals and smooth bass. It sounds passionate, even though the recording is muffled and noisy, as it was probably recorded with a phone. | 2014-03-06T23:42:30Z | Dave Hardy | Dave does a blue in A from a tracker off youtube.The guitar is a modded tokai/gibbo love rock with seymor duncan sh5 and warman p90.The amp is a 1992 Marhall 100 watt dual reverb combo.The effects and pedals are named as he uses them. | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Heavy metal", "Music", "Distortion"] | ["low quality", "noisy", "cover", "rock", "electric guitar solo melody", "playback instrumental", "punchy snare", "punchy kick", "smooth bass", "soft cymbals", "passionate", "muffled"] | 4 | -OAyRsvFGgc | 41 | |
| Humbuckers vs P90 Pickups | The low quality recording features a cover of a rock song that consists of passionate electric guitar melody playing over playback. The playback features a groovy bass guitar, punchy snare and kick hits, shimmering cymbals and mellow synth key chords. It sounds groovy - thanks to the bass-drums relationship and passion - thanks to the electric guitar melody. | 2012-11-27T09:11:40Z | intheblues | Humbuckers vs P90 Electric Guitar Pickups. The Red Les Paul is a Tokai Love Rock with Humbucker Pickups The Gold Top is a Gibson Studio Les Paul with P90 Pickups I am playing into a Fender Blues Jr iii Gold Amplifier (into a AxeTrak) with a Klon Overdrive Pedal and a Boss Digital Delay DD7 on Analog mode. This YouTube channel participates in Affiliate programs. These programs are designed in a way for the channel to earn an income by using the links provided in the description or pinned comment section. Please note: Not all links on this Youtube channel are affiliate links. | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "rock", "passionate electric guitar solo melody", "cover", "playback", "groovy bass guitar", "shimmering cymbals", "punchy snare", "punchy kick", "mellow synth keys chords", "groovy", "passionate"] | 4 | PyVuHAskeUg | 2584 | |
| 13 year old kid plays Eruption by Van Halen | This is an amateur cover of a guitar solo in a heavy metal piece. The solo is being played on an electric guitar. There is a rapid procession of high-pitch notes in the solo. The feel is complex and aggressive. The quality of the recording is a bit poor. If the quality issue can be resolved, this piece could be sampled for use in beat-making. | 2008-05-01T15:30:23Z | dave8386 | Me playing Eruption on my dad's Squire Strat. For everyone saying that I "deserve a better guitar": I got a Fender Stratocaster that Christmas so I'm sorry if you're disappointed that it was played on a Squire but I don't feel it sounded too bad on it! =) | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["cover", "amateur recording", "heavy metal", "no singer", "instrumental", "electric guitar", "guitar solo", "shredding", "complex", "aggressive"] | 9 | Y6OOFbrzdP8 | 3254 | |
| スライドギター ソロギター プライマル。 The yellow monkey slide guitar | The low quality recording features a cover of a song and it consists of an addictive electric guitar melody played over barely audible playback. The recording is very noisy and in mono, as it was probably recorded with a phone. | 2010-07-19T06:51:12Z | 1985masayuki | イエローモンキーの「プライマル。」をスライドギターでアレンジしてみました。バック音源はシングルCDからのものを流してます。 | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument"] | ["low quality", "addictive electric guitar melody", "cover", "playback", "noisy", "mono"] | 4 | qEJ_jxZzt7k | 4768 |
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;