musiccaps

1 row where aspect_list contains "ethereal music", aspect_list contains "purity" and aspect_list contains "solo"

✎ 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
Bx3nzrmGXhw A female soprano singer sings this high pitched melody. The song is medium tempo with just the singer singing this hauntingly beautiful choral melody with no accompaniment. The song is emotional and devotional. The audio quality is bad. ["soprano singers", "church choir", "gospel music", "choral melody", "western classical music", "high pitched singing", "cathedral reverb", "no instrumentation", "solo", "church music", "hymnal", "lilting", "haunting", "ethereal music", "poor audio quality", "retro gospel music", "timeless spirituality", "purity", "emotional", "meditational", "devotional", "hymns"] ["Theremin"] 1 11 21 0 0 ["/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
);