musiccaps

1 row where aspect_list contains "instrumental music" and audioset_ids = "["/m/04rlf", "/m/07pjwq1"]"

✎ 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
2ZB7DUGOdZw The song is an instrumental. The song is fast tempo with distorted guitars playing in rhythm. The song is energetic and an amateurish performance. The song is of very poor quality with audio noise and hissing sound. ["poor audio quality", "noise", "distortion", "hissing tones", "noisy ambience", "instrumental music", "distorted guitar rhythm", "fast", "amateur quality recording", "deteriorated audio quality", "metal band", "amateur band"] ["Music", "Buzz"] 1 30 40 0 1 ["/m/04rlf", "/m/07pjwq1"]

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