musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electric guitar playing" and musiccaps_names contains "Effects unit" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 20 ✖
- electric guitar playing · 2 ✖
- arpeggio playing 1
- bas audio quality 1
- different tone settings 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) 9 ✖
- Effects unit · 2 ✖
- Guitar 2
- Music 2
- Chorus effect 1
- Distortion 1
- Electric guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Reverberation 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;