musiccaps
1 row where aspect_list contains "distorted bass guitar" and aspect_list contains "shimmering open hat"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- aggressive 1
- distorted bass guitar · 1 ✖
- energetic 1
- guitar slide 1
- instrumental 1
- low quality 1
- punchy snare 1
- shimmering hi hats 1
- shimmering open hat · 1 ✖
- soft kick hit 1
- wide aggressive electric guitar chords 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
acEHGV7Gq6U | The low quality recording features wide aggressive electric guitar chords, shimmering hi hats and open hats, punchy snare, soft kick hits and distorted bass guitar. Right before the "drop", there is a short guitar slide, leading perfectly into it. The instrumental sounds energetic and aggressive. | ["low quality", "wide aggressive electric guitar chords", "guitar slide", "shimmering hi hats", "shimmering open hat", "punchy snare", "soft kick hit", "distorted bass guitar", "instrumental", "energetic", "aggressive"] | ["Heavy metal", "Music", "Progressive rock"] | 4 | 30 | 40 | 0 | 1 | ["/m/03lty", "/m/04rlf", "/m/0dl5d"] |
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 );