musiccaps
2 rows where aspect_list contains "4 on the floor kick pattern" and audioset_ids contains "/m/02lkt"
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 |
---|---|---|---|---|---|---|---|---|---|---|
qeoYWM1uYPI | The low quality recording features an electro song that consists of reversed hi hats, followed by shimmering 2 step hi hats and "4 on the floor" kick pattern playing on top of it. It sounds groovy and exciting. | ["electro", "reversed hi hats", "4 on the floor kick pattern", "groovy", "exciting", "low quality", "shimmering 2 step hi hats"] | ["Electronic music", "Music", "Drum machine", "Synthesizer"] | 4 | 40 | 50 | 0 | 0 | ["/m/02lkt", "/m/04rlf", "/m/0cfdd", "/m/0l14qv"] | |
sU08gu2zJ4c | The Electro song features a passionate female vocalist singing over wide synth pad chords, mellow synth keys, shimmering hi hats, "4 on the floor" kick pattern and haunting synth lead melody. It sounds addictive and exciting. | ["electro", "passionate female vocal", "wide synth pad chords", "mellow synth keys", "shimmering hi hats", "4 on the floor kick pattern", "haunting synth lead melody", "addictive", "exciting"] | ["Electronic music", "Music", "Electronic dance music"] | 4 | 110 | 120 | 0 | 0 | ["/m/02lkt", "/m/04rlf", "/m/08cyft"] |
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 );