musiccaps_details (view)
3 rows where musiccaps_aspects contains "arpeggiated electric guitar melody", musiccaps_aspects contains "emotional" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- arpeggiated electric guitar melody · 3 ✖
- emotional · 3 ✖
- low quality 3
- addictive 1
- crowd cheering 1
- crowd singing 1
- flat male vocal 1
- groovy bass guitar 1
- high pitched sped up audio 1
- live performance 1
- noisy 1
- passionate 1
- punchy kick 1
- rock 1
- shimmering hi hats 1
- smooth bass guitar 1
- snappy rimshots 1
- weird 1
musiccaps_names (array) 9 ✖
- Music 3
- Musical instrument · 3 ✖
- Acoustic guitar 1
- Blues 1
- Chorus effect 1
- Guitar 1
- Plucked string instrument 1
- Singing 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Compact - Fata din vis | The low quality recording features a live performance of a rock song and it consists of flat male vocal singing over arpeggiated electric guitar melody, groovy bass guitar, shimmering hi hats, snappy rimshots and punchy kicks. In the background, there are some crowd singing and crowd cheering noises. It sounds emotional and a bit addictive. | 2008-04-19T14:23:33Z | Horia D | nice love song | ["Blues", "Singing", "Music", "Musical instrument"] | ["low quality", "live performance", "rock", "crowd cheering", "crowd singing", "flat male vocal", "punchy kick", "snappy rimshots", "shimmering hi hats", "arpeggiated electric guitar melody", "groovy bass guitar", "emotional", "addictive"] | 4 | cTJqIkSuf6s | 3710 | |
Remington Restore [Part 4] Finish | The low quality recording features a high pitched, sped up audio playing in the background, followed by arpeggiated electric guitar melody and smooth bass guitar. Even though the sped up audio sounds weird, the guitar melodies are emotional. | 2012-06-26T17:39:34Z | kg6tgr | This Remington Noiseless Model 7 typewriter numbered H38502 built 1935... is back. It will be placed in my classroom and a million monkeys will bang at the keys and will randomly produce works of Shakespeare. This was a serious time-suck, well over 100 hours total. It is far from perfect, a key sticks now and then. Also, the features that make it noiseless can really make it hard to type. I lowered the rubber bar and the keys fly a bit faster, but I think I am going to avoid 'noiseless', because I noticed it on my other typewriter also. The bell, is beyond me. They were crafty in design, perhaps a bit too crafty. If I change the feet, I'll do a video on it. As of now, they stay. Also, I left the original paint. This typewriter has lived a long life with it, and I hate adding anything that is not needed. The rubber had to go, but the paint stayed. I had to paint a few pieces, as rust had come through. Thanks for watching and please subscribe. | ["Music", "Musical instrument", "Steel guitar, slide guitar"] | ["low quality", "noisy", "high pitched sped up audio", "arpeggiated electric guitar melody", "smooth bass guitar", "emotional", "weird"] | 4 | tvcJENqxr1c | 5077 |
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;