musiccaps
1 row where aspect_list contains "kick drum" and aspect_list contains "vinyl scratch"
This data as json, CSV (advanced)
aspect_list (array) 6 ✖
- children voices 1
- cowbell 1
- hi-hat 1
- kick drum · 1 ✖
- vinyl scratch · 1 ✖
- zipper sound 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
V3Jb0Q_e_pQ | The music features a small group of children singing a repeating melody. A kick drum along with a hi-hat drives the pulse of the music. Throughout the music excerpt one can hear zipper sounds, vinyl scratches and other percussive sounds like cowbells. | ["hi-hat", "zipper sound", "kick drum", "vinyl scratch", "children voices", "cowbell"] | ["Zipper (clothing)", "Music"] | 2 | 30 | 40 | 0 | 1 | ["/m/01s0vc", "/m/04rlf"] |
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 );