musiccaps

2 rows where aspect_list contains "emotional", aspect_list contains "heartfelt", aspect_list contains "mellow piano chords" and aspect_list contains "passionate"

✎ 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
1YPYQP6yupA The low quality recording features a passionate male vocal singing over mellow piano chords, shimmering hi hats, snappy rimshots, punchy kick and soft bass. It sounds emotional, passionate and heartfelt. ["low quality", "snappy rimshots", "shimmering hi hats", "mellow piano chords", "soft bass", "punchy kick", "passionate male vocal", "emotional", "passionate", "heartfelt"] ["Music", "Sad music"] 4 30 40 0 0 ["/m/04rlf", "/t/dd00033"]
KzvdKLdBw3s The low quality recording features a soul song sung by passionate female vocalists over mellow piano chords, smooth bass, shimmering cymbals and punchy kick and snare hits. There are some crowd chattering sounds. It sounds emotional, passionate and heartfelt. ["low quality", "soul", "emotional", "passionate female vocal", "mellow piano chords", "smooth bass", "punchy bass", "punchy kick", "shimmering cymbals", "crowd chattering", "passionate", "heartfelt"] ["Singing", "/m/02zsn", "Music", "Wedding music"] 4 60 70 1 1 ["/m/015lz1", "/m/02zsn", "/m/04rlf", "/m/04wptg"]

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