musiccaps

1 row where aspect_list contains "digital drum", audioset_ids contains "/m/0283d" and author_id = 7

✎ 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
XZurp_Ex9No This music is an electronic instrumental. The tempo is medium fast with synthesiser arrangements, digital drumming and an insistent, persistent ,and incessant electronic drone sound that over powers the background music. It is loud, sharp and unpleasant after a bit. ["electronic music", "medium fast tempo", "loud", "sharp", "unpleasant droning sound", "synthesiser arrangement", "slick drumming", "digital drum", "electronic arrangements", "droning sound", "monotone", "bass drum", "snare", "psychedelic", "trance", "hypnotic", "club music", "dj"] ["Sampler", "Drum and bass", "Music", "Techno", "Trance music", "Dubstep", "Drum machine", "Electronica"] 7 30 40 0 1 ["/m/01v1d8", "/m/0283d", "/m/04rlf", "/m/07gxw", "/m/07lnk", "/m/07s72n", "/m/0cfdd", "/m/0m0jc"]

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