musiccaps
2 rows where aspect_list contains "drum rolls" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
NJ_Ha89QjiI | The low quality recording features shoe tapping sounds alongside loud bagpipe melody and drum rolls. It sounds like it was recorded outside and therefore it is reverberant, epic and powerful. The recording is in mono and a bit noisy. | ["drum rolls", "shoe tapping", "loud bagpipe melody", "epic", "powerful", "low quality", "mono", "noisy", "reverberant"] | ["Bagpipes", "Wind instrument, woodwind instrument"] | 4 | 70 | 80 | 0 | 0 | ["/m/0192l", "/m/085jw"] | |
w35p3oCU0g4 | The low quality recording features a bagpipe melody, drum rolls and some man shouting sound. The recording is in mono and it is a bit noisy, as it was recorded outdoors. | ["drum rolls", "bagpipe melody", "noisy", "man shouting", "mono", "low quality"] | ["Bagpipes", "Wind instrument, woodwind instrument"] | 4 | 20 | 30 | 0 | 0 | ["/m/0192l", "/m/085jw"] |
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 );