musiccaps
3 rows where aspect_list contains "electric guitar" and audioset_ids contains "/m/06w87"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
DvOA0K-DIFM | This is an amateur jam video of an electric guitar solo. The player uses the flanger pedal to achieve the effect of two tape recordings playing at the same time, one slower than the other. This piece could be used as a sample for a beat with a trippy feel. | ["jam", "instrumental", "electric guitar", "solo", "flanger pedal", "trippy"] | ["Tapping (guitar technique)", "Effects unit", "Music", "Musical instrument", "Steel guitar, slide guitar", "Distortion"] | 9 | 30 | 40 | 0 | 1 | ["/m/01glhc", "/m/02rr_", "/m/04rlf", "/m/04szw", "/m/06w87", "/m/0g12c5"] | |
_yWsqs9FOnU | This is an instrumental piece consisting of an electric guitar solo which is played with the tapping technique. There is a usage of complex chords and syncopations, essential characteristics of the progressive rock genre. The guitar has a clear tone. | ["instrumental", "progressive rock", "electric guitar", "solo", "tapping", "complex"] | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Steel guitar, slide guitar", "Distortion"] | 9 | 10 | 20 | 0 | 1 | ["/m/01glhc", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/06w87", "/m/0g12c5"] | |
k2uiJXN3L6E | The excerpt features an electric guitar playing a descending melody note by note with a slight distortion effect on. This doesn't sound like actual music but more like an exercise. | ["electric guitar", "slight distortion effect", "no music", "exercise"] | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | 2 | 290 | 300 | 0 | 1 | ["/m/0155w", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/06w87", "/m/0fx80y"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [musiccaps] ( [ytid] TEXT PRIMARY KEY, [url] TEXT, [caption] TEXT, [aspect_list] TEXT, [audioset_names] TEXT, [author_id] TEXT, [start_s] TEXT, [end_s] TEXT, [is_balanced_subset] INTEGER, [is_audioset_eval] INTEGER, [audioset_ids] TEXT );