musiccaps
1 row where aspect_list contains "sound effects" and aspect_list contains "unique"
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 |
---|---|---|---|---|---|---|---|---|---|---|
en56uOGTwzg | This is a beatbox performance played on a flute. There is a flushing sound effect in the beginning of the recording and then the performance begins. There is an eccentric feel to the piece. The sound effect in the beginning could be used in a soundboard while the flute can be sampled for use in beat-making. | ["sound effects", "toilet flushing sound", "flute", "beatbox", "unique", "different", "eccentric"] | ["Wind instrument, woodwind instrument", "Flute"] | 9 | 0 | 10 | 0 | 0 | ["/m/085jw", "/m/0l14j_"] |
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 );