musiccaps
3 rows where audioset_ids contains "/m/03_d0" and start_s = 80
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 |
---|---|---|---|---|---|---|---|---|---|---|
Oe_xSG_ic-c | The low quality recording features a live performance of a jazz song and it consists of a saxophone solo melody played over mellow keys chords, groovy bass, punchy snare and kick hits and shimmering hi hats. It sounds passionate and soulful. | ["low quality", "jazz", "live performance", "saxophone solo melody", "shimmering hi hats", "punchy kick", "punchy snare", "mellow keys chords", "groovy bass", "passionate", "soulful"] | ["Jazz", "Music", "Keyboard (musical)", "Piano"] | 4 | 80 | 90 | 0 | 0 | ["/m/03_d0", "/m/04rlf", "/m/05148p4", "/m/05r5c"] | |
P39x5dOsJ40 | The low quality recording features a drummer playing his solo over a weird repetitive electric guitar solo melody. The drums consist of punchy kick and snare hits and shimmering cymbals. Overall it sounds energetic and exciting. | ["low quality", "weird repetitive electric guitar melody", "punchy kick", "punchy snare", "shimmering cymbals", "energetic", "drums solo", "exciting"] | ["Drum", "Drum kit", "Jazz", "Music", "Musical instrument"] | 4 | 80 | 90 | 0 | 0 | ["/m/026t6", "/m/02hnl", "/m/03_d0", "/m/04rlf", "/m/04szw"] | |
tuoBmxts5Xo | The low quality recording features a live performance of a jazz song that consists of a tenor sax solo melody playing over mellow piano chords, sustained strings, groovy bass, snappy rimshots, shimmering hi hats and punchy kicks. It sounds emotional, passionate and soulful. | ["low quality", "live performance", "jazz", "tenor sax solo melody", "groovy bass", "mellow piano chords", "shimmering hi hats", "punchy kick", "snappy rimshots", "sustained strings", "passionate", "emotional", "soulful"] | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Wedding music", "Saxophone"] | 4 | 80 | 90 | 0 | 0 | ["/m/01kcd", "/m/03_d0", "/m/04rlf", "/m/04szw", "/m/04wptg", "/m/06ncr"] |
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 );