musiccaps
1 row where aspect_list contains "exciting", aspect_list contains "percussive elements" and aspect_list contains "snare roll"
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 |
---|---|---|---|---|---|---|---|---|---|---|
JsHTGDW5dgw | The low quality recording features an electro song that consists of percussive elements, echoing hi hats, shimmering shakers, cowbell, claps and repetitive percussive bass loop. At the end of the loop, there are snare rolls and risers layered together, building up tension for the drop. It sounds exciting and suspenseful. | ["low quality", "electro", "percussive elements", "echoing hi hats", "shimmering shakers", "cowbell", "clapping", "repetitive percussive bass loop", "snare roll", "riser", "exciting", "suspenseful"] | ["Music", "Rattle", "Electronic dance music"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07qn4z3", "/m/08cyft"] |
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 );