musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_names contains "Distortion" and musiccaps_names contains "Strum" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 23 ✖
- 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
- sharp 1
- sonic power 1
- static 1
- string instrument 1
- vibrations 1
musiccaps_names (array) 11 ✖
- Chorus effect 2
- Distortion · 2 ✖
- Electric guitar 2
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Strum · 2 ✖
- Acoustic guitar 1
- Bass guitar 1
- Effects unit 1
- Guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | ||
MARSHALL 8200 VALVESTATE AMP HEAD DEMO W Bi-Chorus | Someone is strumming chords on an e-guitar. The e-guitar is slightly out of tune. This song may be playing at home trying out sounds on the e-guitar. | 2013-08-30T20:43:55Z | allanz00 | This demo is only meant to show a little of the performance of what the Marshall 8200 Amp head can do (Not My playing LOL.) The gear is a Marshall 8200 Valvestate 200w (100w x 100w) head on top of a Marshall JCM 900 Lead 1960 4 speaker cab. The pedal is a Fulltone GT-500 Distortion & Booster/OD pedal. Used the Chorus channel at around 2:43 nothing fancy, really just played a bit of whatever I was felling at the time. | ["Bass guitar", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["amateur recording", "e-guitar"] | 6 | PB3i02Cjf1k | 2515 |
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;