musiccaps
1 row where aspect_list contains "distortion", aspect_list contains "large bell ringing" and aspect_list contains "resonance"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Npbs_4DZgEQ | There is a very large bell ringing, and we hear the resonance thereafter. The bell rings repeatedly throughout the whole clip. The audio quality of the clip is poor, and we hear distortion in the clip as a result. | ["poor audio quality", "live recording", "distortion", "large bell ringing", "church bell", "resonance"] | ["Bell"] | 3 | 520 | 530 | 0 | 0 | ["/m/0395lw"] |
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 );