musiccaps
2 rows where aspect_list contains "acoustic rhythm guitar", aspect_list contains "regional mexican" and is_balanced_subset = 1
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"] | |
rrWQd5SZK74 | The low quality recording features a live performance of a regional Mexican song that consists of reverberant, high register, passionate male vocal singing over acoustic rhythm guitar and widely spread, groovy claps. It sounds passionate, traditional and emotional. Judging by the reverb, it was probably played in some huge concert hall. | ["low quality", "regional mexican", "live performance", "wide groovy clapping", "reverberant high register passionate male vocal", "acoustic rhythm guitar", "traditional"] | ["Yodeling", "Music"] | 4 | 30 | 40 | 1 | 1 | ["/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 );