musiccaps

1 row where aspect_list contains "complex", aspect_list contains "organ" and aspect_list contains "solo"

✎ 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
GWxiiDBK5s8 This is the poor quality recording of a bebop jazz music performance. The organ is playing an insanely complex improvised solo. In the background, there is a bass guitar and a jazz acoustic drum beat. The atmosphere is energetic. ["poor quality", "no singer", "instrumental", "bebop jazz", "organ", "solo", "improvisation", "bass guitar", "acoustic drums", "energetic", "complex"] ["Organ", "Electric piano", "Hammond organ", "Keyboard (musical)", "Piano"] 9 30 40 0 0 ["/m/013y1f", "/m/01s0ps", "/m/03gvt", "/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
);