musiccaps
1 row where aspect_list contains "low quality" and audioset_ids = "["/m/0145m", "/m/04rlf", "/m/0ln16"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
B_kAtTBUDIA | The low quality recording features a regional Mexican song that contains wooden percussive elements, groovy bass and staccato brass melody over which flat male vocalists sing. It sounds vintage, as the recording is very noisy and in mono. | ["low quality", "flat male vocal", "wooden percussive elements", "staccato brass melody", "groovy bass", "mono", "noisy", "regional mexican", "vintage"] | ["Afrobeat", "Music", "Salsa music"] | 4 | 30 | 40 | 0 | 1 | ["/m/0145m", "/m/04rlf", "/m/0ln16"] |
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 );