musiccaps
1 row where aspect_list contains "electric guitar slide" and aspect_list contains "harsh"
This data as json, CSV (advanced)
aspect_list (array) 12 ✖
- aggressive drum cymbals 1
- distorted bass guitar 1
- electric guitar slide · 1 ✖
- energetic 1
- flat male vocal 1
- harsh · 1 ✖
- low quality 1
- messy 1
- punchy kick 1
- punchy snare 1
- rock 1
- wide 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 |
---|---|---|---|---|---|---|---|---|---|---|
7jWRIjFaoeU | The low quality recording features a rock song that consists of wide electric guitar chords, punchy kick and snare, electric guitar slide, distorted bass guitar, aggressive drums cymbals and flat male vocals singing over it. It sounds energetic, but also harsh and messy thanks to those cymbals. | ["rock", "energetic", "low quality", "wide electric guitar chords", "aggressive drum cymbals", "punchy kick", "punchy snare", "electric guitar slide", "distorted bass guitar", "flat male vocal", "harsh", "messy"] | ["Heavy metal", "Music", "Rustling leaves"] | 4 | 30 | 40 | 0 | 1 | ["/m/03lty", "/m/04rlf", "/m/09t49"] |
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 );