musiccaps

1 row where aspect_list contains "emotional", aspect_list contains "heartfelt" and aspect_list contains "legendary violinists"

✎ 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
q6GBCmLxNIk The song is an instrumental. The tempo is medium with a string section accompanying the first violin playing a melancholic melody. The song is emotional and melancholic. The song is a classic western classical music piece. ["first violin solo", "string section", "opera hall", "great composers", "beautiful music", "legendary violinists", "tense", "eerie", "philharmonic orchestra", "conductor", "cellos", "violas", "violins", "lead melody", "instrumental music", "string orchestra", "western classical music", "vibrato", "violin virtuoso", "greta composers", "melancholic music", "romantic", "emotional", "heartfelt", "the good life", "passionate"] ["String section", "Orchestra"] 1 30 40 0 0 ["/m/02qmj0d", "/m/05pd6"]

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