musiccaps
2 rows where aspect_list contains "noisy" and audioset_ids = "["/m/015lz1", "/m/01swy6", "/m/04rlf"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
LybSS4amIS0 | The low quality recording features a reverberant male vocal yodeling over acoustic rhythm guitar and smooth double bass, both located in the right channel of the stereo image. It sounds passionate, fun and happy - like something you would try to sing to when you are in a good mood. | ["low quality", "reverberant yodel male vocal", "acoustic rhythm guitar", "noisy", "unbalanced stereo image", "smooth double bass", "passionate", "happy", "fun"] | ["Singing", "Yodeling", "Music"] | 4 | 30 | 40 | 1 | 1 | ["/m/015lz1", "/m/01swy6", "/m/04rlf"] | |
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 );