musiccaps
1 row where aspect_list contains "drum solo" and aspect_list contains "hi-hat"
This data as json, CSV (advanced)
aspect_list (array) 8 ✖
- drum solo · 1 ✖
- hi-hat · 1 ✖
- kick drum 1
- moderate tempo 1
- no other instruments 1
- no voices 1
- snare 1
- toms 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
c8gD6153aNI | This song features a drum solo being played. The hi-hat, snare, kick and toms are played in this clip. There are no other instruments in this song. There are no voices in this song. This song can be played in an instruction video. | ["drum solo", "no other instruments", "no voices", "kick drum", "snare", "hi-hat", "toms", "moderate tempo"] | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 0 | 80 | 90 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/03qtq", "/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 );