musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "amateur recording", musiccaps_names contains "Acoustic guitar" and musiccaps_names contains "Electric guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- amateur recording · 2 ✖
- abrupt end 1
- acoustic guitar 1
- amateur 1
- amplified guitar 1
- boomy 1
- chord progression 1
- chords 1
- e-guitar 1
- electric guitar 1
- home video 1
- instrumental 1
- loud 1
- loud feedback 1
- medium tempo 1
- melodic 1
- of static 1
- people talking 1
- repetitive 1
- sharp 1
- sonic power 1
- static 1
- string instrument 1
- vibrations 1
musiccaps_names (array) 11 ✖
- Acoustic guitar · 2 ✖
- Electric guitar · 2 ✖
- Music 2
- Plucked string instrument 2
- Strum 2
- Chorus effect 1
- Distortion 1
- Effects unit 1
- Guitar 1
- Musical 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Danelectro FAB Chorus D 5 | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | 2010-11-01T07:01:01Z | musicnbooksdotcom | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | 7 | bqvl7IbPteU | 3659 |
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;