musiccaps

1 row where aspect_list contains "emotional", aspect_list contains "love song" and aspect_list contains "music covers"

✎ 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
1OIfQHKnAcw A male singer sings this emotional melody. The song is medium tempo with a piano accompaniment and a strong bass drum kick . The song is emotional and romantic. The song is a home music video . ["male singer", "piano accompaniment", "soloist", "modern love", "loneliness", "breakup song", "mameluke in love", "music covers", "youtube music videos", "youtube music artist", "modern pop hits", "courtship song", "desperate for you", "madly in love", "original song", "acoustic pop", "emotional", "love song", "sentimental", "strong bass line", "keyboard accompaniment"] ["Electric piano", "Keyboard (musical)", "Piano"] 1 20 30 0 0 ["/m/01s0ps", "/m/05148p4", "/m/05r5c"]

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