musiccaps
1 row where aspect_list contains "vintage" and audioset_ids contains "/m/06bz3"
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 |
---|---|---|---|---|---|---|---|---|---|---|
VpikuLP_9qQ | The low quality recording features a rock song sung by passionate male vocalists, after which there are camera shuttering and crowd yelling sound effects. The recording is in mono and overall it sounds distorted, crushed, noisy and vintage. | ["low quality", "mono", "noisy", "camera shuttering sound effects", "crowd yelling crowd effect", "rock", "passionate male vocal", "distorted", "crushed", "vintage"] | ["Music", "Radio"] | 4 | 70 | 80 | 0 | 1 | ["/m/04rlf", "/m/06bz3"] |
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 );