musiccaps
1 row where aspect_list contains "acoustic drums" and aspect_list contains "steel-drums"
This data as json, CSV (advanced)
aspect_list (array) 5 ✖
- acoustic drums · 1 ✖
- amateur recording 1
- fast tempo 1
- steel drum band 1
- steel-drums · 1 ✖
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
V9jIsOTC1lY | This song contains an acoustic drum set playing a jazzy swing groove using kick,snare and ride. You can hear various steeldrums playing different parts of the song. One is playing as bass, others as chords in the midrange and others are playing a melody in the upper register. This song may be playing live at a local event. | ["steel drum band", "acoustic drums", "steel-drums", "fast tempo", "amateur recording"] | ["Music", "Musical instrument", "Steelpan"] | 6 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/04szw", "/m/0l156b"] |
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 );