musiccaps

1 row where aspect_list contains "amateur audio", aspect_list contains "low quality audio", aspect_list contains "moderate tempo" and aspect_list contains "trumpets"

✎ 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
X1KJfb5xhr4 This amateur recording features trumpets playing the main melody. This is accompanied by the bass drum playing one beat on alternate counts and two beats on the remaining alternate counts. Hand claps are played on alternate counts. Other instruments are not audible due to the low audio quality. ["amateur audio", "low quality audio", "hand claps", "trumpets", "bass drum", "moderate tempo", "orchestra song"] ["Orchestra"] 0 50 60 0 0 ["/m/05pd6"]

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