musiccaps

2 rows where aspect_list contains "tutorial" and audioset_ids contains "/m/03gvt"

✎ 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
DU3Vlaa8rU0 The low quality recording features a tutorial on boomy organ keys narrated by flat male vocals. It is noisy and the recording is in mono. ["low quality", "flat male vocal", "tutorial", "organ keys", "mono", "boomy", "noisy"] ["Organ", "Hammond organ", "Keyboard (musical)", "Piano"] 4 290 300 0 0 ["/m/013y1f", "/m/03gvt", "/m/05148p4", "/m/05r5c"]
HVA9-fjtv6U This music is a short instrumental. The tempo is medium with a church organ harmony with a male voice speaking something incoherent and subtle sounds like clinking and whirring. The audio is short and skillful. This is a tutorial on how to play the piano/organ. ["instrumental", "medium tempo", "organ", "sharp notes", "bass", "high notes", "low keys", "church organ", "keyboard", "male voice speaking", "clinking sound", "whirring sound", "tutorial", "demo"] ["Organ", "Electric piano", "Hammond organ", "Electronic organ", "Keyboard (musical)", "Piano"] 7 60 70 0 0 ["/m/013y1f", "/m/01s0ps", "/m/03gvt", "/m/03xq_f", "/m/05148p4", "/m/05r5c"]

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