musiccaps
1 row where aspect_list contains "wooden impact sounds" and audioset_ids contains "/m/0642b4"
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 |
---|---|---|---|---|---|---|---|---|---|---|
P54hbuQLkc4 | The low quality recording features foley effects that include metallic, wooden and screeching sound effects. At the very end of the loop, there is an intense background orchestra music, representing some combat scene. | ["low quality", "foley effects", "metallic impact sounds", "wooden impact sounds", "screeching sound effect", "intense orchestra music"] | ["Music", "Cupboard open or close"] | 4 | 220 | 230 | 0 | 1 | ["/m/04rlf", "/m/0642b4"] |
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 );