musiccaps

1 row where aspect_list contains "classical dance" and audioset_ids contains "/m/0ggq0m"

✎ 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
hkWcUtga1lw The song is an instrumental. The song is medium tempo with a violin playing a solo with a piano accompaniment. The song is emotional and positive. The song is a classic western hit and has poor audio quality in general. ["piano accompaniment", "violin solo", "instrumental music", "music rehearsal", "classical duet", "medium tempo", "western classical music", "studio chamber echo", "instrumental music", "memdium tempo", "emotional", "dance groove", "cheerful", "spirited", "nostalgia", "good day", "poor audio quality", "home video quality", "entertaining", "classical dance", "composers"] ["Music", "Musical instrument", "Piano", "Violin, fiddle", "Classical music"] 1 400 410 0 1 ["/m/04rlf", "/m/04szw", "/m/05r5c", "/m/07y_7", "/m/0ggq0m"]

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