musiccaps_details (view)
1 row where musiccaps_aspects contains "emotional", musiccaps_names contains "Acoustic guitar", musiccaps_names contains "Chorus effect" and "youtube_published" is on date 2011-04-02
This data as json, CSV (advanced)
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 |
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;