musiccaps
2 rows where aspect_list contains "crowd chattering" and audioset_ids contains "/m/042v_gx"
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 |
---|---|---|---|---|---|---|---|---|---|---|
PNT3hW4qFpQ | The low quality recording features a live performance of the percussive & arpeggiated acoustic guitar melody. There are some crowd chattering noises in the background, by which we can definitely conclude that it is, in fact, a live performance. Sounds a bit boomy and the high frequencies of the guitar are lacking volume. | ["low quality", "percussive arpeggiated acoustic guitar melody", "noisy", "crowd chattering", "live performance", "lacking high frequencies", "boomy"] | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument"] | 4 | 290 | 300 | 0 | 1 | ["/m/01glhc", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw"] | |
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 );