musiccaps
1 row where aspect_list contains "chair crackling sounds" and audioset_ids contains "/m/02qmj0d"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ua0hgl8fi0I | The low quality recording features a live performance of a classical song that consists of sustained strings and flute melody. There are some chair crackling noises, as well as camera shuttering sounds. It sounds emotional and passionate, and the recording itself is noisy. | ["low quality", "noisy", "sustained strings melody", "chair crackling sounds", "flute melody", "classical", "live performance", "emotional", "passionate", "camera shuttering sounds"] | ["Cello", "String section", "Violin, fiddle", "Bowed string instrument"] | 4 | 260 | 270 | 0 | 0 | ["/m/01xqw", "/m/02qmj0d", "/m/07y_7", "/m/0l14_3"] |
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 );