musiccaps

1 row where aspect_list contains "mono", aspect_list contains "passionate", aspect_list contains "people talking" and aspect_list contains "sustained strings melody"

✎ 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
NgniX3tg_Mo The low quality recording features a live performance of a traditional song and it consists of a flat male vocal singing over sustained strings melody and mellow, subtle percussive element. There are some people talking in the background, followed by a cough. It sounds passionate and emotional, even though the recording is noisy and in mono. ["low quality", "traditional", "live performance", "noisy", "mono", "flat male vocal", "mellow wooden percussion", "sustained strings melody", "passionate", "emotional", "people talking", "cough"] ["Tabla", "Drum", "Percussion"] 4 50 60 0 0 ["/m/01p970", "/m/026t6", "/m/0l14md"]

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