musiccaps
2 rows where aspect_list contains "shimmering hi hats" and audioset_ids contains "/m/04wptg"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-WvVG0wHcTc | The low quality recording features a classical live performance of sustained violin melody, shimmering hi hats, electric guitar melody, theremin solo melody and subtle female vocals at the end of the loop. There are some crowd clapping sounds in the background. It is noisy, in mono and it sounds passionate and emotional. | ["classical", "sustained violin melody", "crowd clapping", "shimmering hi hats", "theremin solo", "subtle female vocal", "live performance", "electric guitar melody", "low quality", "noisy", "mono", "passionate", "emotional"] | ["Singing", "Country", "Guitar", "Music", "Wedding music"] | 4 | 310 | 320 | 0 | 1 | ["/m/015lz1", "/m/01lyv", "/m/0342h", "/m/04rlf", "/m/04wptg"] | |
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 );