musiccaps
1 row where aspect_list contains "funny", aspect_list contains "metallic impact" and aspect_list contains "sustained strings"
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 |
---|---|---|---|---|---|---|---|---|---|---|
q7sK_xrJz-k | The low quality recording features a flat male vocal talking over electric guitar melody and sustained strings, with some metallic impact sound and stuttering vocal sound effect. It sounds funny and the recording is noisy and in mono. | ["low quality", "noisy", "mono", "flat male vocal", "stuttering vocal sound effect", "sustained strings", "electric guitar melody", "metallic impact", "funny"] | ["Bell", "Music", "Speech"] | 4 | 310 | 320 | 0 | 0 | ["/m/0395lw", "/m/04rlf", "/m/09x0r"] |
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 );