musiccaps
1 row where aspect_list contains "electric guitar lead" and aspect_list contains "guitar amplifier"
This data as json, CSV (advanced)
aspect_list (array) 16 ✖
- amplifier knob flicks 1
- echo tones 1
- electric guitar lead · 1 ✖
- emotional 1
- exciting 1
- guitar amplifier · 1 ✖
- guitar licks 1
- guitar tone test demo 1
- home music video 1
- loud music 1
- medium tempo 1
- passionate 1
- poor audio quality 1
- rock guitar lead 1
- rock solo 1
- tremolo tones 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
R4b_-IT43P4 | The song is an instrumental. The song is medium tempo with an amplified guitar solo lead, complete with knob flicking tones. The song is loud and energetic. The audio quality is poor and recorded live at home. | ["electric guitar lead", "poor audio quality", "rock solo", "guitar amplifier", "home music video", "guitar tone test demo", "medium tempo", "rock guitar lead", "tremolo tones", "echo tones", "amplifier knob flicks", "loud music", "emotional", "passionate", "exciting", "medium tempo", "guitar licks"] | ["Blues", "Echo", "Effects unit", "Electric guitar", "Music", "Distortion"] | 1 | 30 | 40 | 0 | 1 | ["/m/0155w", "/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 );