musiccaps
1 row where aspect_list contains "blues" and audioset_ids contains "/m/0326g"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ZLDQ8-8AyI4 | The low quality recording features a live performance of a blues song that consists of nasal male vocal singing over acoustic rhythm guitar chord progression and smooth double bass. There are also some crowd talking noises. It sounds groovy and kind of dull, since it is probably recorded with a phone. | ["low quality", "acoustic", "live performance", "blues", "acoustic rhythm guitar chord progression", "smooth double bass", "crowd talking", "nasal male vocal", "groovy", "dull"] | ["Blues", "Country", "Flamenco", "Music"] | 4 | 30 | 40 | 0 | 1 | ["/m/0155w", "/m/01lyv", "/m/0326g", "/m/04rlf"] |
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 );