musiccaps
1 row where aspect_list contains "aggressive" and aspect_list contains "ride cymbal one shot"
This data as json, CSV (advanced)
aspect_list (array) 10 ✖
- aggressive · 1 ✖
- distorted 1
- drums solo 1
- energetic 1
- exhale 1
- low quality 1
- manic tom rolls 1
- mono 1
- noisy 1
- ride cymbal one shot · 1 ✖
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
bJVogLOURmc | The low quality recording features a drums solo that contains manic tom rolls and a ride cymbal one shot at the end. There was an exhale sound once the player finished his performance. The recording is very noisy, in mono and it sounds aggressive and energetic. | ["low quality", "noisy", "drums solo", "manic tom rolls", "distorted", "mono", "exhale", "energetic", "aggressive", "ride cymbal one shot"] | ["Drum", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 4 | 30 | 40 | 0 | 0 | ["/m/026t6", "/m/02k_mr", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] |
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 );