musiccaps_details (view)
3 rows where musiccaps_aspects contains "electric guitar solo" and musiccaps_names contains "Reverberation" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- electric guitar solo · 3 ✖
- instrumental 2
- medium tempo 2
- amplified guitar 1
- blues 1
- catchy riff 1
- clear 1
- complex electric guitar playing 1
- crisp 1
- demonstration 1
- dense 1
- edgy 1
- electric guitar 1
- electric guitar feedback 1
- electric guitar lead 1
- electric guitar lesson 1
- electric guitars 1
- empahtic 1
- energetic 1
- enthusiastic 1
- groovy 1
- intricate walking bassline 1
- jazz 1
- jazzy 1
- learning electric 1
- loud 1
- loud feed back 1
- powerful 1
- resonating 1
- reverb 1
- reverb effect 1
- rich 1
- rock 1
- simple jazzy drumming 1
- smooth 1
- sonic power 1
- stringed instrument 1
- tutorial 1
- vibrant 1
- vibrations 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 3
- Reverberation · 3 ✖
- Distortion 2
- Effects unit 2
- Electric guitar 2
- Guitar 2
- Musical instrument 2
- Plucked string instrument 2
- Steel guitar, slide guitar 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rocktron Cyber Reverb Noodling | This song is an instrumental. The tempo is medium with an enthusiastic electric guitar solo. There are no other instruments used. The guitar riff is loud, enthusiastic and youthful. | 2009-04-14T23:49:26Z | bryan arzaga | Rocktron Cyber Reverb Noodling | ["Reverberation", "Effects unit", "Electric guitar", "Music"] | ["instrumental", "electric guitar feedback", "vibrations", "sonic power", "electric guitar solo", "medium tempo", "enthusiastic", "energetic", "vibrant"] | 7 | AFwtBviVhhM | 1094 | |
FRV-1 Fender® Reveb [BOSS Sound Check] | Here we have an electric guitarist intricately playing a guitar solo with a reverb effect applied to his guitar. The music is a jazzy type of backing track with a sophisticated walking bassline. The guitarist is highly skilled. | 2010-08-03T02:11:30Z | BOSSchannel | http://www.boss.info/global/gear/255/1021 A Classic Reborn — the legendary sound of the 1963 Fender® Spring Reverb returns as a modern stompbox. BOSS and Fender® USA have collaborated to create the FRV-1, a stunning recreation of the legendary '63 Fender® Reverb via COSM technology. The FRV-1 puts that timeless tube-driven reverb sound under your foot in a tough, reliable compact pedal. | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument", "Distortion"] | ["jazzy", "electric guitar solo", "simple jazzy drumming", "intricate walking bassline", "reverb effect", "complex electric guitar playing"] | 3 | NVo-stvk_QE | 2341 | |
The Jim Kelley Reverb amplifier, demo by Pete Thorn | This music is an electric guitar instrumental. The tempo is medium with a smooth electric guitar lead harmony. The music is clear, emphatic, smooth, groovy, youthful, crisp, edgy and dominant. | 2013-03-03T20:58:20Z | Pete Thorn | An in-depth look at the Kelley Reverb head, built by J.S. Technologies Check out Pete Thorn's "Guitar Nerd" album at CDbaby.com and iTunes: http://www.cdbaby.com/cd/petethorn https://itunes.apple.com/us/artist/pete-thorn/id437846702 | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["instrumental", "electric guitars", "medium tempo", "demonstration", "tutorial", "learning electric", "electric guitar lesson", "clear", "loud", "powerful", "empahtic", "amplified guitar", "electric guitar", "stringed instrument", "loud feed back", "blues", "rock", "jazz", "resonating", "reverb", "youthful", "groovy", "catchy riff", "smooth", "electric guitar lead", "electric guitar solo", "dense", "rich", "crisp", "edgy"] | 7 | ouVuF-y8bog | 4664 |
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;