musiccaps
3 rows where aspect_list contains "flat male vocal" and audioset_ids contains "/m/0mkg"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0u1sk49gAU0 | The low quality recording features a flat male vocal talking and playing a groovy accordion melody, before which a male and a female laugh. It sounds passionate and groovy. | ["low quality", "groovy accordion melody", "flat male vocal", "male laugh", "female laugh", "noisy", "mono", "passionate", "groovy"] | ["Accordion"] | 4 | 20 | 30 | 0 | 0 | ["/m/0mkg"] | |
FLJPxFCPeDY | The low quality recording features an accordion melody played over regional Mexican playback that consists of accordion chords, groovy bass and flat male vocal singing over it. The recording is in mono, noisy and it sounds emotional and passionate. | ["regional mexican", "low quality", "mono", "noisy", "playback", "groovy bass", "accordion chords", "flat male vocal", "accordion melody", "passionate", "emotiona"] | ["Accordion"] | 4 | 40 | 50 | 0 | 0 | ["/m/0mkg"] | |
s72505MIhz8 | The low quality recording features a flat male vocal talking, after which an accordion melody starts playing. It sounds joyful and happy, even though the recording is noisy. | ["low quality", "noisy", "mono", "flat male vocal", "accordion melody", "joyful", "happy"] | ["Harmonica", "Bowed string instrument", "Accordion"] | 4 | 80 | 90 | 0 | 0 | ["/m/03qjg", "/m/0l14_3", "/m/0mkg"] |
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 );