musiccaps
1 row where aspect_list contains "synth lead riser" and audioset_ids contains "/m/07phhsh"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ywuR9AfpA_E | The low quality recording features an aggressive, distorted car engine revving sound effect and layered sustained string and synth lead riser in the background. There are some wide crackling noises, which, besides a slight distortion of the actual sound, is making this sound lower in quality. | ["low quality", "aggressive distorted car engine revving sound effects", "sustained strings", "synth lead riser", "wide crackling noises"] | ["Music", "Rumble"] | 4 | 10 | 20 | 1 | 1 | ["/m/04rlf", "/m/07phhsh"] |
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 );