musiccaps
1 row where aspect_list contains "electric guitar mellow feedback" and aspect_list contains "shimmering hi hats"
This data as json, CSV (advanced)
aspect_list (array) 12 ✖
- addictive 1
- electric guitar mellow feedback · 1 ✖
- groovy 1
- groovy bass guitar 1
- instrumental 1
- passionate 1
- passionate electric guitar solo melody 1
- punchy kick 1
- punchy snare 1
- rock 1
- shimmering hi hats · 1 ✖
- wooden bouncy percussion 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
I4Jp0kB2Ns0 | The Rock instrumental features a passionate electric guitar solo melody played over punchy kick and snare hits, shimmering hi hats, groovy bass guitar, wooden bouncy percussion and electric guitar, mellow feedback, located in the left channel of the stereo image. It sounds groovy, addictive and passionate, thanks to that solo melody. | ["rock", "instrumental", "groovy bass guitar", "passionate electric guitar solo melody", "punchy kick", "punchy snare", "wooden bouncy percussion", "shimmering hi hats", "electric guitar mellow feedback", "groovy", "addictive", "passionate"] | ["Music", "Grunge"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/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 );