musiccaps

1 row where aspect_list contains "animated singing", aspect_list contains "playful" and aspect_list contains "vocal harmony"

✎ 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
9CJu43AvIds A male singer sings this animated melody with backup singers in vocal harmony. The song is medium tempo with a groovy drum rhythm, clapping percussion and strong bass hits. The song is a pop dance hit with a groovy dance rhythm. ["male singer", "animated singing", "male backup singers", "dance party", "people dancing", "groovy rhythm", "strong bass line", "clapping rhythm", "steady drumming rhythm", "screaming vocals", "pop dance hits", "children’s song", "pop anthem", "playful", "cheerful", "vocal harmony", "medium tempo", "pop song"] ["Music", "Rhythm and blues", "Hip hop music"] 1 30 40 0 0 ["/m/04rlf", "/m/06j6l", "/m/0glt670"]

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