musiccaps
1 row where aspect_list contains "electric guitar", aspect_list contains "flanger pedal" and aspect_list contains "solo"
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"] |
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 );