musiccaps
1 row where aspect_list contains "punchy snare" and audioset_ids = "["/m/0145m", "/m/0164x2", "/m/04rlf", "/m/06j6l"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
XjUmXwVlDDo | The low quality recording features a fruity male vocal, alongside processed background male vocal, with autotune and echoing effect on, rapping over repetitive synth melody, groovy synth bass, punchy kick and punchy snare hits. The song is uptempo and it sounds energetic. | ["low quality", "afrobeats", "fruity male vocal", "repetitive synth melody", "groovy synth bass", "punchy kick", "punchy snare", "energetic", "uptempo", "background processed male vocal", "autotune", "echoing effect"] | ["Afrobeat", "Music of Africa", "Music", "Rhythm and blues"] | 4 | 30 | 40 | 1 | 1 | ["/m/0145m", "/m/0164x2", "/m/04rlf", "/m/06j6l"] |
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 );