musiccaps
1 row where aspect_list contains "acoustic rhythm guitar", aspect_list contains "crowd chattering", aspect_list contains "mono" and aspect_list contains "passionate male vocal"
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 |
---|---|---|---|---|---|---|---|---|---|---|
lI8aGjIb8Jg | The low quality recording features a cover of a regional Mexican song and it consists of a passionate male vocalist singing over acoustic rhythm guitar. There are some crowd chattering and asphalt sounds in the background. The recording is noisy, in mono and it sounds passionate and emotional. | ["low quality", "mono", "regional mexican", "passionate male vocal", "cover", "noisy", "acoustic rhythm guitar", "crowd chattering", "asphalt sounds", "low quality", "emotional", "passionate"] | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | 4 | 30 | 40 | 1 | 1 | ["/m/042v_gx", "/m/04rlf", "/m/06w87", "/m/07s0s5r", "/m/0fx80y"] |
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 );