musiccaps

1 row where aspect_list contains "amateur recording", aspect_list contains "digital drums", aspect_list contains "male voices singing" and aspect_list contains "uptempo"

✎ 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
cabjr3xtcR4 This song contains digital drums with a kick on every beat and an open hi hat on the backbeat. A synth bass is playing a melody along with an e-bass. A male voice is singing along with a male backing singer. The crowd is cheering and singing along. This is an amateur recording and of poor audio-quality. This song may be playing at a live concert. ["pop", "amateur recording", "digital drums", "synthesizer", "bass", "male voices singing", "crowd cheering and singing", "uptempo"] ["Crowd", "Music", "Pop music", "Bellow"] 6 270 280 0 0 ["/m/03qtwd", "/m/04rlf", "/m/064t9", "/m/07q4ntr"]

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