musiccaps
1 row where aspect_list contains "average audio quality" and aspect_list contains "poor audio quality"
This data as json, CSV (advanced)
aspect_list (array) 15 ✖
- amplifier 1
- average audio quality · 1 ✖
- electric guitar solo 1
- energetic 1
- exciting 1
- flanger unit 1
- gadget porn 1
- guitar pedal demonstration 1
- guitar player 1
- guitarist 1
- home video 1
- instrumental 1
- male guitar teacher 1
- poor audio quality · 1 ✖
- youtube gear demonstration 1
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"] |
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 );