musiccaps
2 rows where aspect_list contains "out of tune" and audioset_ids contains "/m/02sgy"
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 |
---|---|---|---|---|---|---|---|---|---|---|
CKEPPcaCjbw | solo electric guitar music with a clean tone. The guitar is slightly out of tune. The music mostly consists of single notes as opposed to chords. The guitar plays blues licks. | ["solo electric guitar", "clean tone", "out of tune", "blues licks", "single notes"] | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 8 | 60 | 70 | 0 | 0 | ["/m/01b9nn", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] | |
KXRngbBe0bg | The song is an instrumental. The tempo is medium with a guitar playing lead and rhythm with differences ranging from echo tones to distorted high gains. The song is a guitar reverb pedal test or demonstration. The audio quality is poor with high gains. | ["instrumental music", "high gain", "dissonant tones", "home music video", "poor audio quality", "effects pedal", "high gain tones", "changing tones", "echoes", "delay effects", "distortion tones", "guitar effects module demonstration", "homemjsic video", "guitar echo pedal", "overuse of effect", "melancholic", "poignant", "groovy", "amateur player", "soloist", "out of tune", "medium tempo", "noisy"] | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument"] | 1 | 80 | 90 | 0 | 1 | ["/m/01glhc", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw"] |
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 );