musiccaps_details (view)
1 row where musiccaps_author = 6, musiccaps_names contains "Distortion" and "youtube_published" is on date 2011-09-16
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Z.VEX Effects Instant Lo-Fi Junky Chorus/Vibrato | Two e-guitars playing a melody. An electric bass is playing the rootnotes. They run through a chorus/vibrato effect. This song may be playing at home building a song with a loopstation. | 2011-09-16T20:14:07Z | Prymaxe | The Z.VEX Effects Instant Lo-Fi Junky Chorus/Vibrato provides you with that super unique Lo-fi Loop Junky tone... IN REAL TIME! not quite a compressor or a chorus/vibrato while simultaneously being both, the Z.VEX Effects Instant Lo-Fi Junky Chorus/Vibrato has loads of sounds on tap, whether it be warmer lo-fi comp, or shimmering bell like tones, the Z.VEX Effects Instant Lo-Fi Junky Chorus/Vibrato also features a 3 way wave selector switch to choose your poison, sine, square or triangle, in tandem with the speed and depth knobs for wild pitch vibrato or lush chorus tones! You can pick up the Z.VEX Effects Instant Lo-Fi Junky Chorus/Vibrato by giving us al call at 1-855-PRYMAXE or visiting the new home of tone, https://www.prymaxe.com | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | ["rock/pop", "e-guitars", "e-bass", "amateur recording"] | 6 | kZYBpOwNGZU | 4330 |
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;