musiccaps
2 rows where aspect_list contains "soft hi hats" and audioset_ids contains "/m/06ncr"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0ZNFJz-eZTU | The low quality recording features a jazz song cover that consists of a passionate saxophone melody played over soft hi hats and kick hits, snappy rimshots, smooth bass, organ keys chords and mellow piano chords. It sounds emotional, passionate and reverberant - as it was probably recorded in a medium size room. | ["snappy rimshots", "soft hi hats", "soft kick", "cover", "smooth bass", "organ keys chords", "mellow piano chords", "passionate saxophone melody", "passionate", "emotional", "jazz", "low quality", "reverberant"] | ["Brass instrument", "Saxophone"] | 4 | 120 | 130 | 0 | 0 | ["/m/01kcd", "/m/06ncr"] | |
AgVUGzrzJ20 | The low quality recording features a jazz song that consists of groovy double bass located in the right channel, groovy piano melody leaning towards the left channel of the stereo image and widely spread shimmering shakers and soft hi-hats. It sounds smooth, chill, easygoing and relaxing - like something you would hear in high-end restaurants. | ["low quality", "jazz", "groovy piano melody", "groovy double bass", "shimmering shakers", "soft hi hats", "smooth", "easygoing", "chill", "relaxing"] | ["Jazz", "Music", "Musical instrument", "Saxophone"] | 4 | 320 | 330 | 0 | 1 | ["/m/03_d0", "/m/04rlf", "/m/04szw", "/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 );