musiccaps_details (view)
1 row where musiccaps_aspects contains "modulated noises", musiccaps_author = 0 and musiccaps_names contains "Synthesizer"
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
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;