musiccaps

1 row where aspect_list contains "harsh", aspect_list contains "messy" and aspect_list contains "thin"

✎ 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
GkB_BkyVyPs The low quality recording features a live performance of a reggae song that consists of shimmering cymbals, addictive brass melody and muffled male vocal singing over it. It is noisy and in mono, and it sounds thin, harsh, muddy, messy and energetic. ["low quality", "shimmering cymbals", "noisy", "mono", "addictive brass melody", "muffled male vocal", "live performance", "reggae", "loud", "thin", "harsh", "muddy", "messy", "energetic"] ["Music", "Ska", "Music of Latin America"] 4 30 40 1 1 ["/m/04rlf", "/m/06rqw", "/m/0g293"]

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