musiccaps

1 row where aspect_list contains "cool", aspect_list contains "short bass stabs" and aspect_list contains "simple synth bells melody"

✎ 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
A6ilKRqIDH4 The low quality recording features a DJ scratching a vinyl of an electro dub song that consists of uptempo hi hats, punchy kick and snare hits, short bass stabs, soft crash cymbal and simple synth melody. It sounds energetic, cool and groovy. ["low quality", "electro dub", "dj scratching", "punchy snare", "punchy kick", "uptempo hi hats", "soft crash cymbal", "simple synth bells melody", "energetic", "cool", "groovy", "short bass stabs"] ["Scratching (performance technique)", "Sampler", "Music", "Scratch", "Dubstep", "Drum machine"] 4 30 40 0 1 ["/m/01hgjl", "/m/01v1d8", "/m/04rlf", "/m/07qb_dv", "/m/07s72n", "/m/0cfdd"]

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