musiccaps

1 row where aspect_list contains "crowds cheering", aspect_list contains "high gain noise" and aspect_list contains "march rhythm"

✎ 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
qBe_D8Gg5lA The song is an instrumental. The bagpipes play together in unison and march to the sounds of crowds cheering and other ambient sounds. The song is patriotic like a victory march. The song has very bad audio quality. ["bagpipers playing", "army band", "marching sounds", "instrumental music", "crowds cheering", "ambient crowd noise", "very poor audio quality", "distorted sounds", "high gain noise", "medium tempo", "spirited", "passionate", "victory march", "army band", "bagpipe harmony", "emotional", "patriotic music", "march rhythm"] ["Bagpipes", "Wind instrument, woodwind instrument"] 1 30 40 0 0 ["/m/0192l", "/m/085jw"]

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