musiccaps
1 row where aspect_list contains "aggressive electric guitar riffs" and aspect_list contains "double pedal kick"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- aggressive 1
- aggressive electric guitar riffs · 1 ✖
- double pedal kick · 1 ✖
- energetic 1
- groovy distorted bass guitar 1
- manic 1
- manic solo electric guitar melody 1
- metal 1
- punchy snare 1
- shimmering crash cymbals 1
- shimmering hi hats 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
OEuBITrf-kE | The Metal song features a manic solo electric guitar melody over shimmering hi hats, shimmering crash cymbals, double pedal kick hits, punchy snare, groovy distorted bass guitar and aggressive electric guitar riffs. It sounds aggressive, manic and energetic - like something you would jump to at the concerts. | ["metal", "energetic", "manic solo electric guitar melody", "shimmering hi hats", "shimmering crash cymbals", "double pedal kick", "punchy snare", "groovy distorted bass guitar", "aggressive electric guitar riffs", "aggressive", "manic"] | ["Music", "Cacophony"] | 4 | 210 | 220 | 0 | 1 | ["/m/04rlf", "/m/07szfh9"] |
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 );