musiccaps

1 row where aspect_list contains "dance music", aspect_list contains "pro" and aspect_list contains "techno music"

✎ View and edit SQL

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
ue1sgGEvkwE This music is an Electronic instrumental. The tempo is fast with vigorous electronic and heavily synthesised music using DL mixer, turn table and drum machines.The Ustica is youthful, futuristic, contemporary, vigorous, groovy, psychedelic, trance, hypnotic ,boomy and pulsating. This music is an Electronica/Tech House. ["instrumental", "fast tempo", "drum machine", "turn table", "edm", "synthesised sounds", "dance music", "ambient techno", "hypnotic", "psychedelic", "tech house", "dj mixer", "dj", "edmdance music", "electronic music", "trance music", "trap", "techno music", "scratching sound", "vinyl record", "boomy bass", "skillful", "vigorous", "pro", "dj routine", "club music", "youthful", "high-spirited", "techno trance"] ["Scratching (performance technique)", "Electronic music", "Music"] 7 90 100 0 0 ["/m/01hgjl", "/m/02lkt", "/m/04rlf"]

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);