musiccaps

1 row where aspect_list contains "acoustic guitar", aspect_list contains "flamenco", aspect_list contains "instrumental" and aspect_list contains "rising"

✎ 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
r43WrKA6ppI This is an instructive flamenco guitar piece. The player is depicting how the piece must be played by starting it slow and eventually getting faster. The theme is repeated by the player. ["flamenco", "acoustic guitar", "instrumental", "exercise", "rising", "repeating theme", "spanish"] ["Flamenco", "Acoustic guitar", "Music", "Strum", "Plucked string instrument"] 9 30 40 1 1 ["/m/0326g", "/m/042v_gx", "/m/04rlf", "/m/07s0s5r", "/m/0fx80y"]

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