musiccaps
2 rows where aspect_list contains "shimmering hi hats" and audioset_ids contains "/m/0145m"
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 |
---|---|---|---|---|---|---|---|---|---|---|
6vM7Kv42Uv0 | The low quality recording features a pop song that consists of stuttering vocal effects, flat male vocal speaking alongside female vocal, bleating goat sound effect, some percussive elements, boomy bass, crispy snare and shimmering hi hats. There are some scratching effects in the left channel of the stereo field. It sounds funny and like it is a parody song. | ["low quality", "funny", "pop", "flat male vocal", "stuttering vocal effect", "wide layered vocals", "bleating goat sound effect", "percussive elements", "shimmering hi hats", "scratching sound effect", "boomy bass", "crispy snare", "parody"] | ["Afrobeat", "Music", "/t/dd00032"] | 4 | 20 | 30 | 0 | 1 | ["/m/0145m", "/m/04rlf", "/t/dd00032"] | |
INBx8CrIWcg | The low quality recording features an electro song that consists of acid aggressive synth melody, repetitive synth lead melody, boomy 808 bass, claps and shimmering hi-hats. There is a sizzling riser in the first section of the loop. It sounds energetic and like something you would hear in an underground club. | ["low quality", "sizzling", "electro", "acid aggressive synth melody", "repetitive synth lead melody", "boomy 808 bass", "claps", "shimmering hi hats", "energetic", "sizzling riser"] | ["Afrobeat", "Sampler", "House music", "Music", "Musical instrument", "Techno", "Trance music", "Dubstep", "Electronic dance music", "Drum machine", "Synthesizer"] | 4 | 30 | 40 | 0 | 1 | ["/m/0145m", "/m/01v1d8", "/m/03mb9", "/m/04rlf", "/m/04szw", "/m/07gxw", "/m/07lnk", "/m/07s72n", "/m/08cyft", "/m/0cfdd", "/m/0l14qv"] |
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 );