musiccaps

1 row where aspect_list contains "learn music online", aspect_list contains "online classes" and aspect_list contains "silence"

✎ 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
WT2iyJmKkc8 The song is an instrumental followed by the DJ talking about his lessons. The tempo is medium with disc scratching, steady drumming rhythm, various clapping percussion, modulated vocal samples, and a percussive bass line. The song is an electronic dance tune. ["song fade", "dj techniques", "dj talking", "youtube music lessons", "online tutorials", "learn music online", "turntables", "vinyls", "techno dance tune", "silence", "groovy rhythm", "clapping percussions", "steady drumming", "percussive bass line", "disc scratching tones", "screaming noise", "youtube dj lessons", "dj techniques", "online classes", "instrumental music", "modulated vocal samples"] ["Scratching (performance technique)", "Electronic music", "Music", "Speech"] 1 120 130 0 0 ["/m/01hgjl", "/m/02lkt", "/m/04rlf", "/m/09x0r"]

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