musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "distorted audio" and musiccaps_aspects contains "electric guitar" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- distorted audio · 2 ✖
- electric guitar · 2 ✖
- amateur recording 1
- amplified guitar 1
- background ambient noise 1
- boomy 1
- distortion 1
- electrical distortion 1
- high pitched 1
- home video 1
- instrumental 1
- jarring 1
- live recording 1
- loud feed back 1
- poor quality audio 1
- resonant 1
- reverberating 1
- sonic power 1
- speaking male 1
- vibrations 1
musiccaps_names (array) 10 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
How to tap on guitar (super fast tapping lesson) | This is a tutorial on the electric guitar. The guitar is high-pitched and rapid arpeggio notes are played on it. The audio is of a poor quality. The individual makes a comment at the end of the video. | 2008-05-26T02:36:00Z | Amanda Riddle | just me explaining the best i can how to tap on a guitar and the different kinds of tapping. I also explain how to do what i like to call video game tapping (One, lots of dragonforce stuff) woohoo over 100,000 views :) Thanks alot everyone. I hope that this video has helped you out. In light of this milestone, I plan to be producing more videos very very soon. So subscribe or just keep checking my channel (sp? lol) | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["electric guitar", "distortion", "high pitched", "live recording", "poor quality audio", "distorted audio", "background ambient noise", "speaking male"] | 3 | 8Bu8CkR1xZY | 901 | |
Keeley Caverns with Catalinbread Valcoder | This clip is an instrumental. The tempo is slow and deliberate with an electric guitar playing an energetic riff. It is minimal instrumentation with no other instrument used. The electric guitar is loud, boomy, jarring, resonant,recurring, with an insistent riff. | 2015-10-22T02:00:00Z | Iga Massardi | Keeley Caverns delay+reverb with Catalinbread Valcoder tremolo. Available at https://www.bneffects.com Contact : rigrigrigmusic@gmail.com PLEASE SUBSCRIBE :) Camera by Davian Akbar Recorded by Adam Imaduddin All cables by : http://www.rumahtjapgadjah.com Guitar : Fender Stratocaster Amp : Supro Dual Tone Mic : Sennheiser e906 http://www.rigrigrig.com http://www.facebook.com/rigrigrig http://www.twitter.com/rigrigrigdemo | ["Reverberation", "Tapping (guitar technique)", "Effects unit", "Electric guitar", "Music", "Distortion"] | ["instrumental", "electric guitar", "jarring", "reverberating", "boomy", "home video", "amateur recording", "vibrations", "sonic power", "amplified guitar", "resonant", "loud feed back", "distorted audio", "electrical distortion"] | 7 | Xus0LI3QV2A | 3234 |
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;