musiccaps
2 rows where audioset_ids contains "/m/02rr_" and audioset_names = "["Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
sp77ueBkqS0 | This music is an Electric Guitar instrumental. The tempo is medium with a pleasant electric guitar riff. The music is loud, powerful, clear, tight, intense and engaging. | ["instrumental", "medium tempo", "electric guitar", "stringed instrument", "amplified guitar", "rock", "hard rock", "pop", "metal", "heavy metal", "intense", "full bodied", "classic", "versatile", "shiny acoustic", "tight", "powerful", "intense deep", "loud feedback", "lucid"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | 7 | 60 | 70 | 0 | 0 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0g12c5"] | |
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 );