musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electric guitar", musiccaps_names contains "Effects unit" and musiccaps_names contains "Inside, small room"
This data as json, CSV (advanced)
musiccaps_names (array) 9 ✖
- Effects unit · 2 ✖
- Guitar 2
- Inside, small room · 2 ✖
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Chorus effect 1
- Distortion 1
- Reverberation 1
musiccaps_aspects (array) 9 ✖
- electric guitar · 2 ✖
- blues licks 1
- bright blues lick 1
- chord ringing out 1
- flanger effect 1
- instrumental 1
- no other instruments 1
- no voices 1
- sustained chord strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Wampler Ego Compressor Demo | This is a recording of an electric guitar, first with a chord being strummed and allowed to ring out, then with licks being played. The guitarist plays a blues lick with the guitar producing a clean and compressed tone. | 2014-05-27T17:22:46Z | Texas Blues Alley | Demo Page: https://texasbluesalley.com/oldtonezone/tone-tuesday/wampler-ego-compressor-demo The Wampler Ego is one of my favorite go-to pedals for rhythm. If you dislike playing through a clean amp as much as I do, this is definitely a pedal you should check out. | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["electric guitar", "sustained chord strum", "blues licks", "chord ringing out", "bright blues lick"] | 3 | rrAIuGMTqtA | 4904 | |
MXR Micro Flanger | This song features an electric guitar playing arpeggiated chords. The guitar is playing with a flanger effect added to change the tone. There are no other instruments in this song. There are no voices in this song. This is an instrumental song. This song can be used in an instructional video on an effects processor. | 2008-12-27T17:59:29Z | blondegraemey | Vintage MXR Micro Flanger with crumbling foam problem! Description and demonstration. | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion", "Inside, small room"] | ["electric guitar", "flanger effect", "no other instruments", "no voices", "instrumental"] | 0 | wYtd_Sq2-Tw | 5274 |
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;