musiccaps_details (view)
3 rows where musiccaps_aspects contains "electric guitar playing" and musiccaps_names contains "Guitar" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- electric guitar playing · 3 ✖
- arpeggio playing 1
- bas audio quality 1
- complex guitar playing 1
- country blues guitar playing 1
- different tone settings 1
- electric guitar arpeggio 1
- electric guitar motif 1
- guitar amplifier 1
- guitar test demo 1
- guitar tones 1
- instrumental music 1
- intricate electric guitar lick 1
- medium tempo 1
- melancholic 1
- music demo 1
- no other instrumentation 1
- no percussion instruments 1
- poor audio quality 1
- reverb effect 1
- slow tempo 1
- sustained note 1
- wobbly notes 1
musiccaps_names (array) 10 ✖
- Guitar · 3 ✖
- Music 3
- Effects unit 2
- Electric guitar 2
- Musical instrument 2
- Plucked string instrument 2
- Chorus effect 1
- Distortion 1
- Reverberation 1
- Ukulele 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gretsch 6120TM Chet Atkins guitar review | This is a solo electric guitarist playing some blues. It's a twelve bar blues progression that's intricately finger picked. It has a turnaround. | 2009-02-21T03:53:07Z | John Heussenstamm | John reviews the Gretsch guitar 6120TM Chet Atkins hollow body. link: http://www.johnhguitar.com/john-heussenstamm/GuitarReviews.php | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["electric guitar playing", "country blues guitar playing", "electric guitar arpeggio", "complex guitar playing"] | 3 | aqhhfkXKJ1o | 3577 | |
Strymon Mobius vs Donner Tutti Love Chorus | The song is an instrumental. The song is medium tempo with an amplified guitar playing lead with different tone settings. The song is melancholic and more of a demo play. The song has poor audio quality. | 2015-01-11T21:59:57Z | shnobel | Find great deals on these pedals on Reverb.com Click Here https://reverb.com/marketplace?utm_source=shnobel&query=Strymon+Mobius &_aid=shnobel Strymon Mobius vs Donner Tutti Love Chorus | ["Effects unit", "Electric guitar", "Guitar", "Music", "Chorus effect"] | ["electric guitar playing", "medium tempo", "poor audio quality", "melancholic", "music demo", "different tone settings", "arpeggio playing", "guitar tones", "instrumental music", "guitar test demo", "bas audio quality", "wobbly notes", "no other instrumentation", "no percussion instruments", "guitar amplifier", "slow tempo"] | 1 | BjqhHeJD28U | 1283 | |
ZCAT - HOLD - REVERB Pedal | This is an intricately played piece on the electric guitar, there is a high level of reverb applied to the guitar. There's also one singular sustained note underneath the complex guitar lick being played. | 2010-10-13T20:24:18Z | ZCAT Pedals | Hold - Reverb pedal is a digital multi-effects processor featuring a high quality Reverb and unique Hold effect - which is an infinite long reverb that you can play along with and that can be turned on and off by pressing the momentary Hold switch. | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["electric guitar motif", "electric guitar playing", "reverb effect", "sustained note", "intricate electric guitar lick"] | 3 | EC4GbkL3XvI | 1537 |
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;