musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "strumming" and musiccaps_names contains "Plucked string instrument" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 5 ✖
- chorus pedal 1
- electric guitar 1
- jam 1
- lo-res 1
- strumming · 1 ✖
musiccaps_names (array) 4 ✖
- Chorus effect 1
- Effects unit 1
- Music 1
- Plucked string instrument · 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fromel Seraph Chorus Pedal Demo by Bobby DeVito Boss Dimension C DC-2 clone | This is an amateur low-resolution recording of an electric guitar with the chorus pedal effect. The player keeps on strumming chords to show the effect of the pedal. This piece could be used as an old-fashioned rock guitar sample for a beat. | 2009-04-29T20:41:48Z | Robert DeVito | A quick video demo of the AMAZING Seraph Chorus by John Fromel -- this is a clone of the sought after and long discontinued analog DC-2 Dimension C chorus from BOSS -- a chorus pedal for people who don't like chorus pedals! Also using the Catalinbread DLS pedal and the Fromel GO! pedal for a little dirt, as well as the Mad Professor Deep Blue Delay for some ambience. | ["Effects unit", "Music", "Chorus effect", "Plucked string instrument"] | ["jam", "electric guitar", "chorus pedal", "strumming", "lo-res"] | 9 | uoee1ikakWY | 5137 |
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;