musiccaps
1 row where aspect_list contains "punchy "4 on the floor"" and aspect_list contains "shimmering hi hats"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- chaotic 1
- chicago house 1
- echoing tom 1
- energetic 1
- high pitched male vocal one shot 1
- low echoing vocal 1
- low quality 1
- punchy "4 on the floor" · 1 ✖
- shimmering hi hats · 1 ✖
- snare rolls 1
- syncopated claps 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
EsHXnkZ_W2c | The low quality recording features a Chicago house song that consists of a punchy "4 on the floor" kick pattern, some snare rolls, syncopated claps, shimmering hi hats, low echoing vocals, echoing toms and high pitched male vocals one shot. It sounds chaotic and energetic. | ["chicago house", "punchy \"4 on the floor\"", "low quality", "snare rolls", "syncopated claps", "shimmering hi hats", "low echoing vocal", "high pitched male vocal one shot", "chaotic", "energetic", "echoing tom"] | ["Sampler", "House music", "Music", "Drum machine"] | 4 | 40 | 50 | 0 | 1 | ["/m/01v1d8", "/m/03mb9", "/m/04rlf", "/m/0cfdd"] |
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 );