musiccaps
1 row where audioset_names contains "Distortion", audioset_names contains "Harmonic" and audioset_names contains "Tapping (guitar technique)"
This data as json, CSV (advanced)
audioset_names (array) 7 ✖
- Distortion · 1 ✖
- Effects unit 1
- Electric guitar 1
- Guitar 1
- Harmonic · 1 ✖
- Music 1
- Tapping (guitar technique) · 1 ✖
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
XrjkzI6TVwc | The excerpt features an electric guitar with a distortion effect on playing what sounds to be an improvised passage. The style comes closest to the rock genre. The lower quality of the audio recording coupled with string noises makes me think this is an amateur recording, most probably recorded with a phone. | ["electric guitar", "distortion effect", "improvisation", "rock genre", "string noise", "low quality audio recording"] | ["Tapping (guitar technique)", "Effects unit", "Electric guitar", "Guitar", "Music", "Harmonic", "Distortion"] | 2 | 30 | 40 | 0 | 1 | ["/m/01glhc", "/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/0b9m1", "/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 );