musiccaps_details (view)
4 rows where musiccaps_aspects contains "arpeggiated electric guitar melody", musiccaps_aspects contains "passionate" and musiccaps_names contains "Chorus effect"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- arpeggiated electric guitar melody · 4 ✖
- low quality 4
- passionate · 4 ✖
- emotional 2
- mono 2
- noisy 2
- emotional electric guitar melody 1
- fun 1
- happy 1
- joyful 1
- mellow kick hits 1
- pitch change 1
- shimmering hi hats 1
- soft snare hits 1
- unbalanced stereo 1
musiccaps_names (array) 10 ✖
- Chorus effect · 4 ✖
- Music 4
- Guitar 3
- Musical instrument 3
- Plucked string instrument 3
- Effects unit 2
- Acoustic guitar 1
- Bass guitar 1
- Inside, small room 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 | |
Mogami Cable Vs. Cheap Cable | The low quality recording features an arpeggiated electric guitar melody. It sounds passionate, fun, happy and joyful. The recording is noisy and in mono. | 2011-10-20T23:38:49Z | Halipino | A "Fair and Balanced" comparison between HI-Quality Mogami and bargain brand cables. LET YOUR EAR DECIDE... Hopefully the recording conditions truly capture the nuances of the sound to help you get a clear idea. | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["low quality", "mono", "noisy", "arpeggiated electric guitar melody", "passionate", "fun", "happy", "joyful"] | 4 | gffng5G4X4w | 4044 | |
Roland VG99 Guitar Effects Demo - Alex Hutchings @ PMT | The low quality recording features an arpeggiated electric guitar melody that changes pitch occasionally. The recording is very noisy and in mono, but it sounds passionate and like something John Lenon would sing to. | 2008-10-28T01:53:00Z | PMTVUK | http://www.pmtonline.co.uk/brands/roland https://www.facebook.com/PMTHouseOfRock/ https://twitter.com/pmthouseofrock https://www.instagram.com/pmthouseofrock The VG99 guitar AND amp modeling processor from Roland. | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Inside, small room"] | ["low quality", "arpeggiated electric guitar melody", "pitch change", "noisy", "mono", "passionate"] | 4 | nZmhIHZINL8 | 4555 |
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;