musiccaps

1 row where aspect_list contains "amateur recording", aspect_list contains "bass", aspect_list contains "moderate tempo" and aspect_list contains "percussion"

✎ 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
pWHkmo9Kn8g This low quality recording features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. After two bars, the percussion plays only the ride cymbal. A distortion guitar plays power chords and after two bars, lets the last chord ring. The bass plays the root notes of the chords. This song can be played in a Transformers style movie. ["amateur recording", "male voice", "rock song", "distortion guitar", "bass", "percussion", "moderate tempo"] ["Music", "Rock music", "Pulse", "Grunge"] 0 120 130 0 0 ["/m/04rlf", "/m/06by7", "/m/07pt_g0", "/m/0dls3"]

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