musiccaps
1 row where aspect_list contains "electric guitar" and aspect_list contains "lead"
This data as json, CSV (advanced)
aspect_list (array) 15 ✖
- amplified guitar 1
- electric guitar · 1 ✖
- external amplification 1
- fast tempo 1
- hard rock 1
- heavy metal 1
- instrumental 1
- lead · 1 ✖
- loud 1
- metal 1
- minimalist 1
- powerful 1
- rock 1
- stringed instrument 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
9QEm6u4bowQ | This music is instrumental. The tempo is medium fast with an energetic electric guitar lead. The music is minimalist with no accompaniment. It is youthful, powerful, enthusiastic, controlled, engaging and intense. This music is Hard Rock/Heavy Metal. | ["instrumental", "fast tempo", "electric guitar", "metal", "heavy metal", "hard rock", "amplified guitar", "external amplification", "minimalist", "youthful", "loud", "powerful", "lead", "stringed instrument", "rock", "heavy metal"] | ["Echo", "Effects unit", "Electric guitar", "Music", "Distortion"] | 7 | 30 | 40 | 0 | 1 | ["/m/01jnbd", "/m/02rr_", "/m/02sgy", "/m/04rlf", "/m/0g12c5"] |
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 );