musiccaps

1 row where aspect_list contains "fart jokes", aspect_list contains "groovy" and aspect_list contains "killing time"

✎ 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
Z8L3jychP14 A female singer sings this casual melody. The tempo is medium with clapping and desk tapping percussion and no other instrumentation. The song is very casual and made up for fun. The song has poor audio quality. ["female singer", "amateur video", "poor quality", "youthful", "teen age fun", "groovy", "made up songs", "cheerful", "college humour", "killing time", "having fun", "killing time", "make your own songs", "fart jokes", "laughing", "funny videos", "clapping rhythm", "desk tapping rhythm", "no harmony instrumentation", "medium tempo"] ["Singing", "Music", "Hands", "Clapping"] 1 30 40 1 1 ["/m/015lz1", "/m/04rlf", "/m/0k65p", "/m/0l15bq"]

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