musiccaps
2 rows where aspect_list contains "aggressive" and audioset_ids contains "/m/02sgy"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
2xQuWif8axE | This is a live recording of an instrumental progressive metal piece. A solo is being played on the electric guitar at a very fast pace using the technique of shredding. Rapid jumps from medium to high range notes can be heard. The atmosphere is aggressive. | ["live recording", "progressive metal", "instrumental", "no singer", "single instrument", "electric guitar", "guitar solo", "shredding", "fast-paced", "aggressive"] | ["Electric guitar", "Music", "Cacophony", "Distortion"] | 9 | 30 | 40 | 0 | 1 | ["/m/02sgy", "/m/04rlf", "/m/07szfh9", "/m/0g12c5"] | |
rfah0bhmYkc | The song is an instrumental. The song is medium tempo with an overdriven guitar playing a jarring lead in rhythmic fashion and guitar over tones that sound like bell tones. The song is aggressive and experimental. The song is a modern rock intro. | ["electric guitar lead", "distorted tones", "experimental", "playing alone", "guitar practice routine", "no percussion instrumentation", "goofing around", "instrumental music", "playing rhythmically", "guitar overtones", "no", "percussion instruments", "jarring tones", "bell tones", "rock music", "exciting", "spirited", "rebellious", "aggressive", "no other instrumentation", "medium tempo", "hard metal"] | ["Electric guitar", "Music", "Distortion", "Sad music"] | 1 | 30 | 40 | 1 | 1 | ["/m/02sgy", "/m/04rlf", "/m/0g12c5", "/t/dd00033"] |
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 );