musiccaps
1 row where aspect_list contains "maracas", aspect_list contains "marimba" and aspect_list contains "orchestra"
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 |
---|---|---|---|---|---|---|---|---|---|---|
aURLQXt_6fE | This is a percussion orchestra performance. There are many percussive elements in this orchestra such as the congas, the maracas, the marimba and the xylophone. There is also an acoustic drum playing in the orchestra. The atmosphere is lively. | ["orchestra", "instrumental", "percussion", "congas", "maracas", "xylophone", "marimba", "acoustic drums", "rhythmic", "lively"] | ["Orchestra", "Marimba, xylophone", "Glockenspiel", "Mallet percussion"] | 9 | 40 | 50 | 0 | 0 | ["/m/05pd6", "/m/0dwsp", "/m/0dwtp", "/m/0j45pbj"] |
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 );