musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "arpeggiated electric guitar melody", musiccaps_aspects contains "emotional" and musiccaps_names contains "Chorus effect"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 9 ✖
- arpeggiated electric guitar melody · 2 ✖
- emotional · 2 ✖
- low quality 2
- passionate 2
- emotional electric guitar melody 1
- mellow kick hits 1
- shimmering hi hats 1
- soft snare hits 1
- unbalanced stereo 1
musiccaps_names (array) 8 ✖
- Chorus effect · 2 ✖
- Music 2
- Acoustic guitar 1
- Bass guitar 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- 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 |
---|---|---|---|---|---|---|---|---|---|---|
The Electro Harmonix Neo Clone | The low quality recording features an emotional electric guitar melody, shimmering hi hats, soft kick hits and punchy snare in the left channel and arpeggiated electric guitar melody and simple bass guitar in the right channel of the stereo image. Due to this unconventional panning, the stereo image sounds a bit unbalanced. It is still emotional and passionate. | 2011-04-11T21:28:19Z | Mike Hermans | The Neo Clone is a clone of the Small Clone..... Lush Chorus! | ["Bass guitar", "Music", "Steel guitar, slide guitar", "Chorus effect"] | ["low quality", "emotional electric guitar melody", "arpeggiated electric guitar melody", "mellow kick hits", "soft snare hits", "shimmering hi hats", "unbalanced stereo", "emotional", "passionate"] | 4 | 2T1P9ovsl4A | 368 | |
Laney Lionheart L20T410 Combo Guitar Amplifier Demo (Video) | Low quality recording features an arpeggiated electric guitar melody. It sounds emotional and passionate. | 2011-04-02T18:10:09Z | gearwire | So why is the Laney Lionheart L20T410 named after Richard I of England? Perhaps it's the guitar combo's ability to go from lucid, even-handed clean tones to berserking hard rock brutality with a few simple knob twists. This 4x10, two-channel combo is one of the most impressive-sounding pieces we've had in the Gearwire studio--so literally awesome as to be able to shut up even me for a span of almost 3 minutes in pure tube (valve)-soaked reverie. I've long been a fan of Laney tube amps, and this most recent arrival did not at all disappoint. It's 20-watts are loud as heck, and the Lionheart L20410's response has that satisfying woodiness that exemplifies the most celebrated of British amps. And British heads of state, come to think of it. | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["arpeggiated electric guitar melody", "emotional", "passionate", "low quality"] | 4 | XoTJkok3FlY | 3226 |
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;