musiccaps
1 row where aspect_list contains "addictive" and aspect_list contains "hard rock"
This data as json, CSV (advanced)
aspect_list (array) 12 ✖
- addictive · 1 ✖
- aggressive 1
- distorted bass guitar 1
- down sweep 1
- echoing electric guitar licks 1
- energetic 1
- hard rock · 1 ✖
- punchy kick 1
- punchy snare 1
- repetitive filtered male vocal 1
- shimmering hi hats 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 |
---|---|---|---|---|---|---|---|---|---|---|
KKgYvcfrxj4 | The Hard Rock song features a repetitive filtered male vocal over shimmering hi hats, down sweep, wide aggressive electric guitar chords, distorted bass guitar, echoing electric guitar licks, punchy kick and punchy snare hits. It sounds energetic, aggressive and addictive. | ["hard rock", "shimmering hi hats", "wide aggressive electric guitar chords", "distorted bass guitar", "echoing electric guitar licks", "repetitive filtered male vocal", "punchy kick", "punchy snare", "down sweep", "energetic", "aggressive", "addictive"] | ["Music", "Rock music", "Grunge"] | 4 | 110 | 120 | 0 | 0 | ["/m/04rlf", "/m/06by7", "/m/0dls3"] |
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 );