musiccaps_details (view)

1 row where musiccaps_aspects contains "epic song", musiccaps_aspects contains "guitar strum", musiccaps_names contains "Distortion" 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
Mr. Black Eterna Gold Modified Reverb This audio clip features the end of an instrument with a lot of reverb. This additional reverb gives the ending an epic feel. At the end of the clip, a guitar chord is struck. There are no other instruments in this song. There are no voices in this song. This song can be used to promote a reverb pedal. 2014-05-29T21:49:53Z ProGuitarShopDemos Buy Now: https://goo.gl/iaBJkm Mr. Black Eterna Gold Modified Reverb Presented by Mike Hermans Mr. Black has changed the game. Again. Using the foundation of the widely-regarded Eterna reverb, the latest and final word on shimmer reverb is here. The algorithm of the original has been overhauled to deliver a feature set worthy of the color gold—from impossibly long decays to astonishing shimmer swells. If you've been on the market for a shimmering reverb but haven't been able to make a decision, congratulations. This is the end of your journey. The decay time of the original has been vastly expanded upon. The original Eterna's decay stands at 40+ seconds. For those players that require a little more, the Eterna Gold Modified has widened that decay time to over a full minute of opulent reverb. The reverb engine itself has also been thoroughly tweaked to change the amount of reflections created after picking, creating a fuller, richer base sound for the decay to feast upon. As the decay knob is turned counter-clockwise, the Eterna Gold Modified starts to shimmer-swell, and when the decay knob is dimed, swelling is also at maximum. Much like the original, a precise amount of shimmer can be mixed in with the shimmer knob, from lush bottomless verb to a massive sacred chorale. The pedal is wired for true-bypass switching and is set up for standard 9vDC operation. ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] ["epic song", "instrumental", "no voices", "instrument reverb", "guitar strum", "minimal instruments", "no percussion"] 0 3zntWbS9XeI 527

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;