musiccaps
3 rows where aspect_list contains "exciting" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
R4b_-IT43P4 | The song is an instrumental. The song is medium tempo with an amplified guitar solo lead, complete with knob flicking tones. The song is loud and energetic. The audio quality is poor and recorded live at home. | ["electric guitar lead", "poor audio quality", "rock solo", "guitar amplifier", "home music video", "guitar tone test demo", "medium tempo", "rock guitar lead", "tremolo tones", "echo tones", "amplifier knob flicks", "loud music", "emotional", "passionate", "exciting", "medium tempo", "guitar licks"] | ["Blues", "Echo", "Effects unit", "Electric guitar", "Music", "Distortion"] | 1 | 30 | 40 | 0 | 1 | ["/m/0155w", "/m/01jnbd", "/m/02rr_", "/m/02sgy", "/m/04rlf", "/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 );