musiccaps

1 row where aspect_list contains "emotional", aspect_list contains "groovy synth bass" and aspect_list contains "soft hi hats"

✎ 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
pmdoDcNBt0E The low quality recording features a live performance of a pop song that consists of groovy synth bass, punchy snare, soft hi hats, heartbeat kick pattern, mellow sustained string melody and passionate female vocal singing over it. It sounds emotional, passionate and groovy thanks to that synth bass. ["low quality", "live performance", "groovy synth bass", "punchy snare", "heartbeat kick pattern", "mellow sustained strings melody", "passionate female vocal", "soft hi hats", "groovy", "passionate", "emotional", "pop"] ["Music", "/t/dd00004"] 4 30 40 1 1 ["/m/04rlf", "/t/dd00004"]

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