musiccaps
3 rows where aspect_list contains "arpeggiated electric guitar melody" and audioset_ids contains "/m/02rr_"
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 |
---|---|---|---|---|---|---|---|---|---|---|
YNdexakUGOo | The low quality recording features an arpeggiated electric guitar melody with an aggressive echoing effect on. The recording is noisy as it was probably recorded with a phone. | ["low quality", "arpeggiated electric guitar melody", "aggressive echoing effect", "noisy"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | 4 | 180 | 190 | 0 | 1 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y"] | |
gffng5G4X4w | The low quality recording features an arpeggiated electric guitar melody. It sounds passionate, fun, happy and joyful. The recording is noisy and in mono. | ["low quality", "mono", "noisy", "arpeggiated electric guitar melody", "passionate", "fun", "happy", "joyful"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | 4 | 270 | 280 | 0 | 0 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y"] | |
nZmhIHZINL8 | The low quality recording features an arpeggiated electric guitar melody that changes pitch occasionally. The recording is very noisy and in mono, but it sounds passionate and like something John Lenon would sing to. | ["low quality", "arpeggiated electric guitar melody", "pitch change", "noisy", "mono", "passionate"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Inside, small room"] | 4 | 520 | 530 | 1 | 1 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y", "/t/dd00125"] |
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 );