musiccaps
2 rows where aspect_list contains "distorted" and audioset_ids contains "/m/05pd6"
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 |
---|---|---|---|---|---|---|---|---|---|---|
KB4e9v_5uTE | The low quality recording features a live performance that consists of a tuba solo melody and some loud impact in the background. The recording is noisy, loud and distorted. | ["low quality", "loud", "distorted", "loud impact", "tuba solo melody", "noisy", "live performance"] | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Orchestra"] | 4 | 170 | 180 | 0 | 0 | ["/m/01kcd", "/m/04fq5q", "/m/04rlf", "/m/04szw", "/m/05pd6"] | |
O6xMQnKJROc | The low quality recording features a live performance of an orchestra that consists of staccato strings melody and sustained woodwinds melody at least. The recording is very noisy, to the point that it is distorting, and in mono - as it was probably recorded with a poor quality microphone. | ["low quality", "noisy", "live performance", "mono", "orchestra", "distorted", "staccato strings melody", "sustained woodwinds melody"] | ["Orchestra"] | 4 | 140 | 150 | 0 | 0 | ["/m/05pd6"] |
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 );