musiccaps
1 row where aspect_list contains "electronic music" and audioset_ids = "["/m/02lkt", "/m/04rlf", "/m/0m0jc"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 );