musiccaps
1 row where aspect_list contains "people grunting" and audioset_ids contains "/m/014zdl"
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 |
---|---|---|---|---|---|---|---|---|---|---|
BGD7J6MP2C8 | This is an excerpt from an advertisement that is all full of sound effects. There is a burning beam coming from the sky and blowing up the earth. Sounds of explosions can be heard as a car and multiple people jump to the sky and the people start grunting as they see their surroundings burning. The sounds from this track can be sampled to be used in beat-making and in soundboards. | ["advertisement", "sound effects", "explosions", "people grunting", "car falling", "things burning"] | ["Explosion", "Music", "Shatter"] | 9 | 30 | 40 | 0 | 1 | ["/m/014zdl", "/m/04rlf", "/m/07rn7sz"] |
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 );