musiccaps
1 row where aspect_list contains "electric guitar" and aspect_list contains "progressive metal music"
This data as json, CSV (advanced)
aspect_list (array) 8 ✖
- acoustic drums 1
- agitated 1
- bass guitar 1
- electric guitar · 1 ✖
- guitar solo 1
- instrumental 1
- live performance 1
- progressive metal music · 1 ✖
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
paeNnR33i5Q | This is the live performance of a progressive metal music piece. The electric guitar is playing a complex solo in the lead. There is a bass guitar playing in the background. The rhythm is played by the acoustic drums. There is an agitated feel to the piece. This piece could be playing in the background at a rock bar. | ["live performance", "instrumental", "progressive metal music", "electric guitar", "guitar solo", "bass guitar", "acoustic drums", "agitated"] | ["Heavy metal", "Rock music", "Progressive rock"] | 9 | 300 | 310 | 0 | 0 | ["/m/03lty", "/m/06by7", "/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 );