musiccaps
1 row where aspect_list contains "fast metal drumming" and aspect_list contains "guitar lead"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- adrenaline rush 1
- bad audio quality 1
- cymbals crashing 1
- distorted guitar rhythm 1
- fast metal drumming · 1 ✖
- fast tempo 1
- groovy rhythm 1
- guitar lead · 1 ✖
- heavy metal music 1
- instrumental music 1
- keyboard accompaniment 1
- passionate 1
- percussive bass line 1
- rebellious 1
- song ending 1
- song fade 1
- spirited 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
nbb8vmfjHJs | The song is an instrumental. The tempo is fast with a fast metal drumming rhythm, complete with cymbal crashes, distorted guitar lead, guitar playing rhythm, and percussive bass line. The song is a death metal song ending with a bad audio quality. | ["heavy metal music", "instrumental music", "fast metal drumming", "distorted guitar rhythm", "keyboard accompaniment", "instrumental music", "fast tempo", "groovy rhythm", "cymbals crashing", "song fade", "song ending", "passionate", "adrenaline rush", "spirited", "youthful", "rebellious", "bad audio quality", "guitar lead", "percussive bass line"] | ["Heavy metal", "Music", "Rock music", "Angry music"] | 1 | 220 | 230 | 0 | 0 | ["/m/03lty", "/m/04rlf", "/m/06by7", "/t/dd00036"] |
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 );