musiccaps

1 row where aspect_list contains "low quality", aspect_list contains "relaxing" and aspect_list contains "shimmering hi hats"

✎ 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
TIAj-fi_R7c The low quality recording features a jazz song that consists of a passionate trumpet melody in the left channel of the stereo image and mellow piano chords in the right channel, followed by smooth double bass and shimmering hi hats. It sounds soft, mellow, passionate and relaxing. The recording is a bit noisy. ["low quality", "noisy", "jazz", "passionate trumpet melody", "shimmering hi hats", "mellow piano chords", "smooth double bass", "soft", "mellow", "passionate", "relaxing"] ["Brass instrument", "Saxophone"] 4 120 130 0 0 ["/m/01kcd", "/m/06ncr"]

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