musiccaps_details (view)
1 row where musiccaps_names contains "Effects unit", musiccaps_names contains "Guitar" and "youtube_published" is on date 2011-10-03
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 |
---|---|---|---|---|---|---|---|---|---|---|
1969 Shin-ei Uni-Vibe Demo #2 | This audio contains someone playing an e-guitar using a vibrato and chorus effect. This is an amateur recording. This song may be playing guitar at home. | 2011-10-03T02:31:17Z | yes9310 | This is a special 1969 Shin-ei Uni-Vibe with the gray cord, white Uni-Vibe name painted indicating it is the same type used by Jimi Hendrix at Woodstock and with Band of Gypsys and by Robin Trower for Bridge of Sighs. The later 70s era black cord ones with silver name stencil don't sound near as good or lush. It has a manual speed controller taking up less pedal board space and is in near museaum quality condition for an effect that is over 40 years old and still works as good as the day it was made. Nothing made today comes even close to the original circuit thought they all claim to as do their fans who've never owned a real one. This is a the real issue. Accept no imitations. Contact me if interested. | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["amateur recording", "e-guitar", "vibrato", "chorus"] | 6 | X9H8FzpVL8s | 3165 |
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;