musiccaps

1 row where aspect_list contains "high-pitch singing", aspect_list contains "live performance" and aspect_list contains "violin"

✎ 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
J4tjy-0CNm4 This is the live performance of a Huayno folk music piece which belongs to the Andean region. There is a female vocalist singing at a high-pitch, almost at a screeching range. The tune is being played by a violin and an Andean/Peruvian harp. The atmosphere is eccentric. This piece could be playing from a radio in a movie taking place in a mountainous Latin American village. ["huayno music", "folk", "female vocal", "high-pitch singing", "andean harp", "violin", "vibrant", "eccentric", "amateur recording", "live performance"] ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] 9 30 40 0 0 ["/m/03m5k", "/m/07y_7", "/m/0d8_n", "/m/0l14_3"]

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