musiccaps_details (view)

2 rows where musiccaps_aspects contains "overdrive" and musiccaps_names contains "Electric guitar"

✎ 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
C minor rock power ballad guitar backing track Here we have a powerful rock ballad instrumental in a minor key. The guitar is grungy and overdriven, and the piano is clean and plays the same chords as the guitar at the same time. 2012-05-13T21:33:38Z Iain MacLeod Hey guys! Sorry I haven't uploaded any tracks in a while. I made this one today and I hope you enjoy playing over it as much as I did :) Thanks for all the amazing support so far! Happy shreddin'! ["Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] ["rock music", "piano", "electric guitar strumming", "minor key", "rock power ballad", "ballad", "grungy electric guitar strumming", "overdrive"] 3 4M0njWKFsME 560
Greer Amps Southland Harmonic Overdrive - Top Boost Gear Solo performance of an electric guitar player strumming chords. The tone is overdriven and warm. The genre is rock. 2014-10-17T13:45:51Z Top Boost Gear Available at WWW.TOPBOOSTGEAR.COM! The Southland Harmonic Overdrive is built on the Lightspeed Organic Overdrive platform, we have developed what we believe to be the best overdrive on the market. The Lightspeed was built with the specific purpose of being a light to mild overdrive. The Southland is the next logical step for the Lightspeed platform—more gain, with two stages of clipping (utilizing different diode types for each stage of clipping), a focused midrange (not that annoying “hump”), and a bit of presence on top of the signal, to help cut through the mix. The Southland Harmonic Overdrive, like the Lightspeed, is touch sensitive, responds to pick attack, and has dynamics that just won’t stop. On top of that, we’ve selected a chip to drive the Southland that takes it to the next level. ["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"] ["electric guitar", "overdrive", "strumming", "rock", "warm"] 8 NzvkMWY4EjA 2387

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;