musiccaps_details (view)
1 row where musiccaps_aspects contains "rock", musiccaps_names contains "Echo", musiccaps_names contains "Guitar" and "youtube_published" is on date 2013-02-02
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 |
---|---|---|---|---|---|---|---|---|---|---|
Death By Audio Echo Dream 2 Advanced Echo Modulation | Someone is playing a clean e-guitar with a lot of reverb and delay. Fingerpicking and creating dreamy rhythm and melodic patterns. In the background you can hear a drumloop and an e-bass. This song may be playing during a little live concert. | 2013-02-02T04:46:42Z | Prymaxe | $270.00 https://www.prymaxe.com/products/death-by-audio-echo-dream-2-advanced-echo-modulation Death By Audio Echo Dream 2 Advanced Echo Modulation This is it. The most beautiful blissed out delay ever heard. You have entered the candy coated dream world of the Echo Dream 2. The Echo Dream 2 is a lofi modulating delay pedal that can drive into fuzzed out insanity. The modulation can be set to give spacey chorus sounds or warbling bounces to robo- groove arpegiations in squarewave mode. The fuzz can range from subtle overdrive to ballsy fuzzstain and bring upon satans spawns to do the mopping up. This is a new take on the Echo Dream circuit with additional knobs for Fuzz and Master Volume and reengineered with a cheaper price tag so all can bask in it's glory. Buy one today. Death By Audio Echo Dream 2 Advanced Echo Modulation Features Sine or Square wave modulation 40ma draw on a 9-volt battery Can also use postive ring, negative tip 9-18 volt power supply (not included) Fuzz control to add additional sound possibilities to your tone | ["Echo", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["rock", "dreamy", "e-guitar", "acoustic drum loop", "e-bass", "uptempo"] | 6 | XnHAH2aPHk0 | 3224 |
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;