musiccaps
2 rows where aspect_list contains "crushed" 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"] | |
aYrjw3gjGuk | The low quality recording features a resonating, distorted, crushed electro song being played on a car subwoofer. It sounds very aggressive and energetic too. There are some outdoor atmosphere sounds, since it was recorded outside. | ["electro", "distorted", "resonating", "noisy", "low quality", "outdoor atmosphere", "aggressive", "energetic", "crushed", "subwoofer"] | ["Music", "Radio", "Microwave oven"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/06bz3", "/m/0fx9l"] |
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 );