musiccaps
1 row where audioset_ids contains "/m/01glhc", audioset_ids contains "/m/02rr_" 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"] |
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 );