musiccaps
1 row where aspect_list contains "chanson", aspect_list contains "mono", aspect_list contains "passionate female vocal" and aspect_list contains "sentimental"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Nt0U-CXK6O0 | The low quality recording features a Chanson song that consists of passionate female vocal singing over mellow piano melody and soft sustained strings melody. The recording is noisy, crushed and it sounds vintage, and therefore sentimental and nostalgic. | ["low quality", "noisy", "mono", "vintage", "crushed", "passionate female vocal", "mellow piano melody", "soft sustained string melody", "chanson", "sentimental", "nostalgic"] | ["Singing", "Yodeling", "Music"] | 4 | 50 | 60 | 1 | 1 | ["/m/015lz1", "/m/01swy6", "/m/04rlf"] |
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 );