musiccaps
2 rows where aspect_list contains "passionate", 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"] | |
qET3h3w35EA | The Regional Mexican song features a passionate female vocal singing over groovy piano melody, wide muffled brass section melody layered with soft crashes and percussive elements. The recording is low quality and vintage, but it still sounds passionate and emotional - like something you would dance to in a latin pub. | ["regional mexican", "groovy piano melody", "wide muffled brass section", "passionate female vocal", "percussive elements", "soft crashes", "low quality", "vintage", "passionate", "emotional"] | ["Swing music", "Music", "Orchestra", "Music of Latin America", "Salsa music"] | 4 | 110 | 120 | 1 | 1 | ["/m/015y_n", "/m/04rlf", "/m/05pd6", "/m/0g293", "/m/0ln16"] |
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 );