musiccaps

1 row where aspect_list contains "classic composers", aspect_list contains "melancholic" and aspect_list contains "poor audio quality"

✎ 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
1WlvXneu6oY The song is instrumental music. The song is medium tempo with just a piano playing pensively and no other instrumentation. The song is emotional and poignant. The song is a western classical masterpiece, but with bad audio quality issues. ["western classical music", "poor audio quality", "poor audio quality", "western classical masterpieces", "piano playing", "love song", "forever classics", "poignant", "melancholic", "winter", "classic composers", "conductor", "piano solo", "emotional", "medium tempo", "dynamics", "instrumental music", "in love", "dance like", "lullaby"] ["Music", "Sad music"] 1 30 40 0 1 ["/m/04rlf", "/t/dd00033"]

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