musiccaps
2 rows where aspect_list contains "low quality" and audioset_ids = "["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y", "/t/dd00125"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ITq14s8h92I | The low quality recording features electric rhythm guitar chords being strummed. It sounds monotone, but groovy and the recording is noisy and in mono. | ["low quality", "electric rhythm guitar chords", "monotone", "groovy", "noisy", "mono"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Inside, small room"] | 4 | 400 | 410 | 0 | 0 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y", "/t/dd00125"] | |
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 );