musiccaps
1 row where aspect_list contains "instrumental" and audioset_ids = "["/m/05pd6", "/m/0dwsp", "/m/0dwtp", "/m/0j45pbj"]"
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 );