musiccaps

1 row where aspect_list contains "melancholic", aspect_list contains "poignant" and aspect_list contains "quiet audience"

✎ 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
3kSQNjfJnN8 The song is an instrumental. The song is slow tempo with a Chinese string instrument playing a lilting melody along with tones of the string instrument being plucked like a harp. The song is emotional and melancholic. The song is a live performance with ambient room noise and generally poor audio quality. ["instrumental music", "chinese stringed instrument", "relaxing playlist", "no percussion instruments", "sound searching", "heartfelt", "folk music", "classical music influences", "poor audio quality", "ambient room noises", "slow tempo", "emotional", "passionate", "sad", "melancholic", "poignant", "strings plucked", "live performance", "quiet audience", "harp accompaniment"] ["Music", "Theremin"] 1 210 220 0 1 ["/m/04rlf", "/m/07kc_"]

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