musiccaps
2 rows where aspect_list contains "bad audio quality" 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 |
---|---|---|---|---|---|---|---|---|---|---|
gpEU6RafUf0 | The song track is an instrumental. The tempo is medium, with a guitarist demonstrating a guitar effects reverb pedal by playing related instrumental phrases. The song is trippy and exciting. The audio quality is poor as it’s an amateur home recording . | ["guitar solo", "delay guitar effects pedal", "guitar demo", "amateur recording", "online tutorial", "walkthrough video", "home studio setup", "instrumental music", "groovy rhythm", "trippy", "exciting", "emotional", "passionate", "youthful", "bad audio quality", "guitar pedal demonstration", "home music video", "soloist", "medium tempo"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | 1 | 30 | 40 | 0 | 0 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y"] | |
xZSioXdxo4Y | The song is an instrumental. The tempo is medium with an electric guitar playing a blues solo with an effects pedal and amplifier. The solo is heartfelt and has a lot of soul and spirit to it. The audio quality is bad. | ["guitar lead", "bad audio quality", "distortion pedal", "amplifier tone", "tone fades", "heartfelt", "blues solo", "guitar tone demo", "online guitar lessons", "groovy music", "instrumental song", "home music video", "demo video", "banshee tone", "medium tempo", "no other instrumentation", "no percussions", "blues solo", "soloist", "guitar virtuoso"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | 1 | 200 | 210 | 0 | 0 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/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 );