musiccaps
1 row where aspect_list contains "clapping", aspect_list contains "electric guitar lick" and aspect_list contains "mono"
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 |
---|---|---|---|---|---|---|---|---|---|---|
yAvqiPL-ssU | The low quality recording features a bagpipe melody, layered with an electric guitar lick and followed by punchy kick hits. In the background there are some crowd talking noises and claps. It sounds exciting and the recording is noisy and in mono. | ["low quality", "bagpipe melody", "clapping", "punchy kick", "crowd talking", "mono", "noisy", "electric guitar lick", "exciting"] | ["Bagpipes", "Wind instrument, woodwind instrument"] | 4 | 30 | 40 | 0 | 0 | ["/m/0192l", "/m/085jw"] |
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 );