musiccaps

1 row where aspect_list contains "4 on the floor kick pattern", aspect_list contains "crowd cheering" and aspect_list contains "electric guitar melody"

✎ 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
HEhogaw0vUg The low quality recording features a live performance of a pop song and it consists of flat female and male vocal rapping over "4 on the floor" kick pattern and electric guitar melody. There are some crowd clapping and cheering noises in the background. It sounds exciting and energetic. ["low quality", "clapping", "crowd cheering", "pop", "live performance", "flat male vocal", "flat female vocal", "4 on the floor kick pattern", "electric guitar melody", "exciting", "energetic"] ["Singing", "Music of Asia", "Music", "Pop music"] 4 30 40 0 1 ["/m/015lz1", "/m/028sqc", "/m/04rlf", "/m/064t9"]

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