musiccaps

1 row where audioset_ids contains "/m/01b9nn", audioset_ids contains "/m/01glhc", audioset_ids contains "/m/01jnbd" and audioset_ids contains "/m/02rr_"

✎ 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
RczzNAr1T_Q The song is an instrumental. The tempo is medium with a guitar strumming to different settings of an effects delay pedal with echoes and effects being heard. The song is an effects pedal demonstration. The audio quality is poor with hissing sounds. ["instrumental music", "turning knobs", "delay pedal", "poor audio quality", "hissing sounds", "rehearsals session", "ambient room noise", "guitar effects pedal", "tone generator", "poor audio quality", "guitar strumming", "echo tones", "testing effects", "guitar demo", "energetic", "casual playing", "reverb peas", "echoes", "medium tempo"] ["Reverberation", "Tapping (guitar technique)", "Echo", "Effects unit", "Guitar", "Music", "Distortion"] 1 30 40 0 1 ["/m/01b9nn", "/m/01glhc", "/m/01jnbd", "/m/02rr_", "/m/0342h", "/m/04rlf", "/m/0g12c5"]

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