musiccaps_details (view)

1 row where musiccaps_aspects contains "no instruments", musiccaps_aspects contains "synth noises" and musiccaps_names contains "Effects unit"

✎ 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
noise synth built from 4x4 matrix mixer and guitar effect pedals This clip features noises created by mixing output from different effect pedals. This is a synth noise. There are no instruments or voices in this song. 2012-06-15T20:34:56Z NoizeHack Synthesizing tones with a passive 4x4 matrix mixer that I built. There is no input into the mixer, all sounds are generated from feedback. A matrix mixer allows you to mix any input to any output, even an input into its own output, so that simple an complex feedback loops can be created. pedals used are an Electro Harmonix Memory Toy analog delay, a Digitech Death Metal distortion, a DOD fx40-b eq, and Behringer dr100 reverb and us600 pitch shifter. ["Effects unit", "Music", "Noise", "Synthesizer"] ["synth noises", "no voice", "no instruments", "effects processors", "modulated noises"] 0 Qw468qlDaAE 2651

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;