musiccaps
1 row where aspect_list contains "chicago house" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 );