musiccaps_details (view)
2 rows where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "poor audio quality" and musiccaps_names contains "Chorus effect" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- electric guitar · 2 ✖
- poor audio quality · 2 ✖
- amplifier 1
- background music 1
- chord arpeggios 1
- distortion tones 1
- echoes 1
- guitar instrumental 1
- guitar lead 1
- guitar pedal test 1
- guitar pedal tones 1
- guitar solo 1
- instrumental music 1
- live performance 1
- music demo 1
- peaceful 1
- pedal 1
- pleasant 1
- relaxing 1
- slow tempo 1
- soloist 1
- soothing and gentle music 1
- warm sounding guitar tone 1
musiccaps_names (array) 10 ✖
- Chorus effect · 2 ✖
- Guitar 2
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Reverberation 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ZCAT Q-MOD Pedal | The song is an instrumental. The song is medium tempo with an electric guitar playing a pleasant solo with a pedal affecting its tone. The song is a guitar effects demo. The song audio quality is poor. | 2010-09-13T19:45:04Z | ZCAT Pedals | http://zcatpedals.com/?dir=view&id=20090818194445xiVC Q-Mod is a digital multi-effects processor featuring Chorus, Flanger, Phaser, Tremolo and Reverb. | ["Reverberation", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | ["amplifier", "pedal", "guitar solo", "slow tempo", "poor audio quality", "echoes", "relaxing", "guitar instrumental", "background music", "music demo", "guitar pedal test", "electric guitar", "guitar lead", "distortion tones", "pleasant", "instrumental music", "slow tempo", "guitar pedal tones", "soloist"] | 1 | W58kioYp1Ms | 3062 | |
Demo of Danelectro Cool Cat Chorus | This is the live performance of an electric guitarist. The chords are arpeggiated and the guitar has effects applied to it to produce a warm and rich tone. The song is calm and peaceful, and would be suitable for a tranquil afternoon walk at the park. | 2007-05-02T17:24:01Z | gitaarheld | Just a little demo of my Danelectro Cool Cat Chorus pedal. First you hear the clean sound without chorus, then the clean sound with chorus. Same for the lead. Don't blame me for the crappy playing, I haven't played this song for years and can't play without faults when the camera is running. I hope you like the sound. Btw the song (a small part of it) is Always With Me, Always With You by Joe Satriani. Comments are always welcome. | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["electric guitar", "live performance", "chord arpeggios", "warm sounding guitar tone", "poor audio quality", "soothing and gentle music", "peaceful"] | 3 | ZOGMpGQQ3FI | 3371 |
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;