musiccaps
2 rows where aspect_list contains "acoustic rhythm guitar", aspect_list contains "emotional", aspect_list contains "mono" and aspect_list contains "passionate"
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 |
---|---|---|---|---|---|---|---|---|---|---|
fDMbNCdGXBc | The low quality recording features a country song being played on an acoustic rhythm guitar and raw male vocal singing over it. It sounds passionate and emotional, even though the recording is noisy and in mono. | ["low quality", "noisy", "mono", "country", "acoustic rhythm guitar", "raw male vocal", "emotional", "passionate"] | ["Country", "Music", "Bluegrass"] | 4 | 30 | 40 | 0 | 0 | ["/m/01lyv", "/m/04rlf", "/m/0gg8l"] | |
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 );