musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "inferior audio quality" and musiccaps_names contains "Electric guitar" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- fast tempo 3
- inferior audio quality · 3 ✖
- instrumental 3
- sharp 2
- sonic power 2
- vigorous 2
- amateur recording 1
- amplified guitar 1
- boisterous 1
- catchy riff 1
- cymbals 1
- dexterous 1
- distorted sounds 1
- electric guitar 1
- electronic music 1
- energetic riff 1
- engaging 1
- harsh 1
- high notes 1
- instrumental rock 1
- intense 1
- loud 1
- loud electric guitar feedback 1
- minimal 1
- muffled audio 1
- no accompaniment 1
- noisy 1
- piercing sound 1
- rapid riff 1
- raw 1
- rhythmic percussion sound 1
- rock 1
- soft drumming 1
- sound of fingers moving 1
- subdued song in background 1
- tambourine 1
- unpleasant 1
musiccaps_names (array) 11 ✖
- Electric guitar · 3 ✖
- Music 3
- Distortion 2
- Bass guitar 1
- Blues 1
- Clatter 1
- Effects unit 1
- Guitar 1
- Heavy metal 1
- Reverberation 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blink 182 - cacophony bass cover | A musician plays this rock instrumental. The tempo is fast with an intense, emphatic electric guitar riff and enthusiastic drumming and cymbal rides in the background and tambourine beats. The music is muffled as the sound quality is inferior. The music is energetic, enthusiastic, and animated . This is a Rock instrumental. | 2010-05-31T18:19:30Z | Walli182 | ["Blues", "Electric guitar", "Guitar", "Music"] | ["instrumental", "fast tempo", "electric guitar", "inferior audio quality", "catchy riff", "rock", "instrumental rock", "sonic power", "muffled audio", "soft drumming", "cymbals", "tambourine", "inferior audio quality", "energetic riff", "amateur recording"] | 7 | xx3nnVzGXa0 | 5366 | ||
Humor: That's how regular guitar sounds with Guitar Hero chords | This music is instrumental. The tempo is medium with a loud , distorted electric guitar harmony. The audio is inferior quality and the sound is raw, loud , unpleasant , boisterous and harsh. There is some noise, like a subdued song playing in the background. | 2009-01-21T04:02:38Z | scooperfield | Is it hard to play Guitar hero with normal guitar? | ["Bass guitar", "Reverberation", "Effects unit", "Electric guitar", "Heavy metal", "Music", "Clatter", "Distortion"] | ["instrumental", "fast tempo", "distorted sounds", "subdued song in background", "harsh", "raw", "inferior audio quality", "vigorous", "boisterous", "noisy", "unpleasant", "electronic music", "intense", "loud electric guitar feedback", "unpleasant", "sharp"] | 7 | c-8SLUH5pp4 | 3673 | |
eruption | This music is an electric guitar instrumental. The tempo is very fast with the guitarist playing a very animated riff rapidly with a lot of dexterity. There is no accompaniment except for the sound of rhythmic clicking which could be percussion or just the sound of fingers moving along the guitar rapidly. The audio quality is inferior so the sounds are sharp, piercing , loud and a little unpleasant to the ear. | 2006-12-27T07:14:56Z | ohjiozubon | how about this | ["Tapping (guitar technique)", "Electric guitar", "Music", "Distortion"] | ["instrumental", "fast tempo", "rapid riff", "dexterous", "no accompaniment", "minimal", "piercing sound", "high notes", "sonic power", "rhythmic percussion sound", "amplified guitar", "sound of fingers moving", "vigorous", "engaging", "inferior audio quality", "loud", "sharp"] | 7 | oYEzy8gH6q8 | 4640 |
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;