musiccaps_details (view)
2 rows where musiccaps_aspects contains "humming noise" and musiccaps_names contains "Guitar" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- humming noise · 2 ✖
- ambient room noises 1
- bas]d audio quality 1
- clean amp channel 1
- electric guitar 1
- energetic 1
- fretboard sounds 1
- guitar demo 1
- guitar string tones 1
- guitar technique 1
- guitarist 1
- high gain amp sound 1
- home music video 1
- live recording 1
- male talking 1
- mediocre audio quality 1
- noise signal above threshold 1
- online guitar lessons 1
- overdrive amp channel 1
- passionate 1
- spirited okay 1
- strong voice 1
- twang sounds 1
- youtube tutorial 1
musiccaps_names (array) 11 ✖
- Bass guitar 2
- Guitar · 2 ✖
- Music 2
- Plucked string instrument 2
- Acoustic guitar 1
- Distortion 1
- Echo 1
- Effects unit 1
- Electric guitar 1
- Musical instrument 1
- Speech 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Funky Voodoo Chile' Riff - Stevie Ray Vaughan version | A male guitarist plays the guitar and speaks about technique in this online video tutorial. The male voice is strong and commanding, along with guitar string twang sounds, clearly demonstrating the technique. The audio quality is mediocre. | 2007-12-20T06:13:22Z | Texas Blues Alley | http://txba.ly/v4Ej - Learn how to play a funky little filler riff that Stevie Ray Vaughan played during his cover of Voodoo Chile' by Jimi Hendrix. | ["Bass guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["guitarist", "male talking", "twang sounds", "mediocre audio quality", "guitar string tones", "guitar technique", "fretboard sounds", "guitar demo", "online guitar lessons", "home music video", "youtube tutorial", "bas]d audio quality", "humming noise", "energetic", "passionate", "spirited okay", "strong voice", "ambient room noises"] | 1 | -5xOcMJpTUk | 13 | |
fender deluxe reverb...heavy metal amp?? | This is a live recording of a guitar being played through a high gain amp. The signal is clean at the beginning and switches to an overdrive or distortion tone. A humming noise is heard when the channel is switched to the distortion channel. There are no other instruments played in this clip apart from one guitar. The guitarist seems to be testing the clean and dirty channels of the guitar amplifier. | 2010-04-06T00:07:26Z | diagrammatisk | Chirp chirp chirp | ["Bass guitar", "Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Plucked string instrument", "Distortion"] | ["live recording", "high gain amp sound", "electric guitar", "overdrive amp channel", "clean amp channel", "humming noise", "noise signal above threshold"] | 0 | SEDfsU63w8I | 2749 |
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;