musiccaps
2 rows where aspect_list contains "synth lead riser" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
8qeTEfOqB0A | The low quality recording features an electro song that features loud choir vocals singing over loud low percussions and some tom rolls. Towards the end of the loop, the choir vocal is sustained and it blends with synth lead riser. It sounds powerful, epic, energetic and exciting. | ["low quality", "electro", "loud choir vocals", "loud low percussions", "tom roll", "synth lead riser", "exciting", "energetic", "powerful", "epic"] | ["Electronic music", "Music", "Electronic dance music", "Inside, large room or hall"] | 4 | 80 | 90 | 0 | 0 | ["/m/02lkt", "/m/04rlf", "/m/08cyft", "/t/dd00126"] | |
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 );