musiccaps
2 rows where aspect_list contains "sustained strings" and audioset_ids contains "/m/02fsn"
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 |
---|---|---|---|---|---|---|---|---|---|---|
EayN_Jj0740 | The low quality recording features a classical song that consists of a sustained cello melody playing over sustained strings. It sounds emotional, passionate and the recording is a bit noisy. | ["low quality", "classical", "sustained cello melody", "sustained strings", "noisy", "emotional", "passionate"] | ["Cello", "Double bass", "Bowed string instrument"] | 4 | 90 | 100 | 0 | 0 | ["/m/01xqw", "/m/02fsn", "/m/0l14_3"] | |
WmTDKYYH5OU | The low quality recording features a flat male vocal rapping over sustained strings melody, punchy kick, mellow snare, groovy bass and some commentary that can be heard in the background. It sounds emotional, energetic and the recording is noisy. | ["low quality", "sustained strings", "flat male vocal", "punchy kick", "mellow snare", "groovy bass", "commentary", "noisy", "emotional", "energetic"] | ["Cello", "Double bass", "Bowed string instrument"] | 4 | 180 | 190 | 0 | 0 | ["/m/01xqw", "/m/02fsn", "/m/0l14_3"] |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );