musiccaps

1 row where aspect_list contains "melancholic", aspect_list contains "sight reading" and aspect_list contains "western classical music"

✎ 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
C9e2k030QcY The song is an instrumental. The tempo is medium with a Harpsichord being played by an elder gentleman in classic baroque style. The music is engaging and exciting. The song audio quality is poor. ["harpsichord player", "harpsichord", "baroque music", "poor audio quality", "traditional music", "kings and queens", "western classical music", "slow tempo", "staggered play", "instrumental music", "engaging", "emotional", "melancholic", "youthful", "spirited", "passionate", "tragedy", "great composers", "sight reading"] ["Harpsichord", "Keyboard (musical)"] 1 30 40 0 0 ["/m/03q5t", "/m/05148p4"]

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