musiccaps
1 row where aspect_list contains "4 on the floor kick" and aspect_list contains "tropical"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- 4 on the floor kick · 1 ✖
- clapping 1
- exotic 1
- groovy 1
- groovy bass 1
- low quality 1
- shimmering shakers 1
- steel drums tropical melody 1
- tinny percussive elements 1
- tropical · 1 ✖
- unbalanced stereo image 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
hDzmNYd_eaA | The low quality recording features a cover with a steel drums tropical melody that plays over the playback instrumental in the background that consists of groovy bass, claps, "4 on the floor" kick pattern, shimmering shakers and tinny percussive elements. It sounds tropical, exotic and groovy, but it also has an unbalanced stereo image. | ["low quality", "steel drums tropical melody", "groovy bass", "clapping", "4 on the floor kick", "shimmering shakers", "tinny percussive elements", "unbalanced stereo image", "exotic", "groovy", "tropical"] | ["Blues", "Music", "Musical instrument", "Wedding music"] | 4 | 30 | 40 | 1 | 1 | ["/m/0155w", "/m/04rlf", "/m/04szw", "/m/04wptg"] |
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 );