musiccaps_details (view)
1 row where musiccaps_names contains "Acoustic guitar", musiccaps_names contains "Strum" and youtube_channel = "gearmanndude"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SVI Sound GE BOOST germanium booster pedal demo with SG & Dr Z Antidote | An almost clean e-guitar is playing a gentle melody in a minor chord that is repeating itself. This song may be played at a backing track to practice along. | 2014-08-02T13:39:35Z | gearmanndude | http://reverb.com/?query=svisound&utm_source=gearmandude Reverb is THE buying and selling source for all things new/used/vintage guitar and bass gear related...there's also drum and keyboard and other stuff! A large percentage of listings are in the 'make an offer' form, so you can really score some great deals. Much lower seller fees than eBay, and it's focused on music gear exclusively, so you don't have to wade through vintage Ford Mustang fenders and headlights, when you're really looking for a '69 reissue Mustang guitar. The selling format and layout is WAY faster and simpler than ebay as well. Check it out! http://www.svisound.com Awesome little multi tonal boost from the king of the small footprint box or art. I'm a big fan of this guys enclosures! SviSound! I used a Gibson SG Standard, cocked rocked and loaded with http://www.dallenpickups.com David Allen CRAZY CAT Humbuckers, and http://www.drzamps.com Dr Z Antidote amp, and a pair of mighty fine http://www.thedivinenoise.com Divine Noise tasty white coily and straight cables....yep! | ["Electric guitar", "Guitar", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["e-guitar", "repetitive", "amateur recording"] | 6 | Ip6FptuXHyk | 1943 |
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;