musiccaps
2 rows where aspect_list contains "digital drumming", aspect_list contains "pulsating" and aspect_list contains "youthful"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
JqmOqYtQqB8 | This music is an Electronic instrumental. The tempo is fast with punchy, synthesised music and thumping drum beats on the drum machine. The music is youthful, energetic, enthusiastic,loud, buoyant, punchy, pulsating and electrifying. The sound quality is of inferior quality and there is a bit of static. | ["instrumental", "fast tempo", "electronic music", "buoyant", "youthful", "pulsating", "electrifying", "static", "inferior audio quality", "amateur recording", "edm", "punchy drumming", "synthesiser articulation", "dj", "dj mixer", "dance floor", "freestyle dance", "drum machine", "digital drumming", "digital music", "distorted sounds"] | ["House music", "Music", "Shuffle", "Dubstep", "Electronic dance music", "Dance music"] | 7 | 30 | 40 | 0 | 1 | ["/m/03mb9", "/m/04rlf", "/m/07qv_x_", "/m/07s72n", "/m/08cyft", "/m/0ggx5q"] | |
oTzTZqDOIt0 | A female vocalist sings this upbeat electronic pop song. The tempo is fast with enthusiastic synthesiser arrangements, groovy drumming. The music is electronically arranged and has a youthful, vivacious, enthusiastic, buoyant dance groove. This music is upbeat Electronic Dance music. | ["female singer", "fast tempo", "electronic music", "punchy", "buoyant", "youthful", "dance groove", "pulsating", "edm", "techno music", "synthesiser arrangements", "slick drumming", "digital drumming", "fast beats", "punchy", "dance groove", "club music", "dj", "dance pop", "electronica"] | ["Electronic music", "Music", "Electronica"] | 7 | 80 | 90 | 0 | 0 | ["/m/02lkt", "/m/04rlf", "/m/0m0jc"] |
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 );