musiccaps
1 row where aspect_list contains "high pitched down sweeps" and audioset_ids contains "/m/07bjf"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0soVCtJgDTk | The low quality recording features an advertisement that consists of camera shuttering effects and high pitched down sweeps, followed by arpeggiated strings melody, orchestra percussions and synth sound effects playing in the background. It sounds exciting and epic. | ["low quality", "advertisement", "camera shuttering sound effects", "high pitched down sweeps", "arpeggiated strings melody", "epic", "orchestra percussions", "synth sound effects", "exciting"] | ["Music", "Single-lens reflex camera"] | 4 | 5 | 15 | 0 | 1 | ["/m/04rlf", "/m/07bjf"] |
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 );