musiccaps
1 row where aspect_list contains "electric guitar" and aspect_list contains "string noise"
This data as json, CSV (advanced)
aspect_list (array) 6 ✖
- distortion effect 1
- electric guitar · 1 ✖
- improvisation 1
- low quality audio recording 1
- rock genre 1
- string noise · 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 );