musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "loud feedback" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 47 ✖
- electric guitar · 3 ✖
- instrumental 3
- loud feedback · 3 ✖
- medium tempo · 3 ✖
- amplified guitar 2
- metal 2
- rock 2
- sonic power 2
- vibrations 2
- abrupt end 1
- acoustic guitar 1
- amateur 1
- amateur recording 1
- applied instruments 1
- boomy 1
- chord progression 1
- chords 1
- classic 1
- electric guitar solo 1
- experiment 1
- external amplification 1
- full bodied 1
- guitar riff 1
- hard rock 1
- heavy metal 1
- home recording 1
- home video 1
- intense 1
- intense deep 1
- loud 1
- lucid 1
- melodic 1
- muffled audio 1
- of static 1
- people talking 1
- pop 1
- powerful 1
- resonating 1
- sharp 1
- shiny acoustic 1
- soft rock 1
- static 1
- string instrument 1
- stringed instrument 1
- tight 1
- tutorial 1
- versatile 1
musiccaps_names (array) 11 ✖
- Distortion 3
- Music 3
- Effects unit 2
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Chorus effect 1
- Echo 1
- Electric guitar 1
- Guitar 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tri Stereo Chorus sound with Boss pedals | This music is an electric guitar solo. The tempo is medium with a haunting and lilting electric guitar riff.The music is minimalist with no accompaniment. It is youthful, energetic, passionate , melodic and pensive. | 2010-09-07T20:12:48Z | oneguitar | my way of faking the 80's tri stereo chorus sound using a Boss CE2, CS2, DD3, HR2, RV5 and FV500 volume pedal | ["Echo", "Music", "Distortion"] | ["instrumental", "electric guitar", "medium tempo", "rock", "metal", "soft rock", "tutorial", "experiment", "applied instruments", "external amplification", "sonic power", "loud feedback", "resonating", "vibrations", "home recording", "muffled audio", "electric guitar solo", "guitar riff"] | 7 | J7fVdG7Zd3A | 1970 | |
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 | ||
TR-2 Tremolo [BOSS Sound Check] | This music is an Electric Guitar instrumental. The tempo is medium with a pleasant electric guitar riff. The music is loud, powerful, clear, tight, intense and engaging. | 2008-10-22T06:25:53Z | BOSSchannel | TR-2 reproduces the classic tremolo effects of vintage '60s amps using a Low Frequency Oscillator (LFO). LFO waveform variable from triangle to square for producing a variety of classic tones. | ["Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["instrumental", "medium tempo", "electric guitar", "stringed instrument", "amplified guitar", "rock", "hard rock", "pop", "metal", "heavy metal", "intense", "full bodied", "classic", "versatile", "shiny acoustic", "tight", "powerful", "intense deep", "loud feedback", "lucid"] | 7 | sp77ueBkqS0 | 4981 |
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;