musiccaps
2 rows where aspect_list contains "shimmering hi hats" and audioset_ids contains "/m/05lls"
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 |
---|---|---|---|---|---|---|---|---|---|---|
TokHdpvX7Es | The low quality recording features a choir singing over punchy kick and snare hits, shimmering hi hats, groovy piano and groovy bass. In the first half, there are harmonizing female vocals singing, after which the male harmonizing vocals start singing. It sounds soulful, passionate and emotional. The recording is a bit noisy. | ["low quality", "noisy", "choir", "harmonizing female vocals", "harmonizing male vocals", "punchy snare", "punchy kick", "shimmering hi hats", "groovy piano melody", "groovy bass", "live performance", "soulful", "passionate", "emotional"] | ["Singing", "Music", "Opera", "Classical music", "Choir"] | 4 | 30 | 40 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/m/05lls", "/m/0ggq0m", "/m/0l14jd"] | |
WE0JqjuhaQI | The low quality recording features a passionate female vocalist singing over dissonant brass stabs, groovy bass, wooden snare hits, synth pad chords, punchy kicks and shimmering hi-hats. It sounds groovy and passionate. | ["low quality", "dissonant brass stabs", "groovy bass", "passionate female vocal", "wooden snare hits", "punchy kick", "shimmering hi hats", "groovy", "passionate", "synth pad chords"] | ["Electronic music", "Music", "Opera", "Techno"] | 4 | 30 | 40 | 0 | 0 | ["/m/02lkt", "/m/04rlf", "/m/05lls", "/m/07gxw"] |
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 );