musiccaps_details (view)
1 row where musiccaps_aspects contains "electric guitar melody", musiccaps_aspects contains "mono", musiccaps_names contains "Electric guitar" and musiccaps_names contains "Guitar"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Joyo JF-37 Analog Chorus | The low quality recording features an electric guitar melody played with a chorus effect on. The recording is noisy and in mono. | 2013-02-10T07:46:29Z | musicexpresscanada | JOYO EFFECTS JF-37 "ANALOG CHORUS" BBD CHIP SET WATERY CHORUS TONES TRUE BYPASS Joyo JF-37 Analog Chorus Effects Pedal You are viewing the JF-37 Classic Chorus. A Great choice to touch up a clear and melodious tone. This Analog Chorus uses the classic BBD chip to acheive those warm, rich and thick classic chorus tones. Rate and Depth knobs let you shape your sound. True Bypass design. Powered by a 9V Battery or 9V adapter. This is a very well electrically designed and mechanically rugged pedal, at a great price!!!.... Buy it Here http://www.musicexpresscanada.com Direct Link http://www.musicexpresscanada.com/product_info.php?products_id=415 | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | ["low quality", "mono", "noisy", "tinny tap sound", "chorus effect", "electric guitar melody"] | 4 | c6Fiz5IznkU | 3679 |
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;