musiccaps
2 rows where aspect_list contains "guitar pedal demonstration" and audioset_ids contains "/m/0342h"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Pn8HqUbNQAc | A male guitar player plays a guitar riff followed by an introduction of a guitar effects flanger pedal. The video has an instrumental solo of a guitar playing rhythm and no other instrumentation. The soundtrack has a poor audio quality. | ["male guitar teacher", "guitar pedal demonstration", "poor audio quality", "guitarist", "home video", "guitar player", "electric guitar solo", "youtube gear demonstration", "instrumental", "average audio quality", "amplifier", "flanger unit", "energetic", "exciting", "gadget porn"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Speech", "Plucked string instrument", "Distortion"] | 1 | 30 | 40 | 0 | 0 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/09x0r", "/m/0fx80y", "/m/0g12c5"] | |
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"] |
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 );