musiccaps
2 rows where aspect_list contains "poor quality audio" and audioset_ids contains "/m/0fx80y"
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 |
---|---|---|---|---|---|---|---|---|---|---|
8Bu8CkR1xZY | This is a tutorial on the electric guitar. The guitar is high-pitched and rapid arpeggio notes are played on it. The audio is of a poor quality. The individual makes a comment at the end of the video. | ["electric guitar", "distortion", "high pitched", "live recording", "poor quality audio", "distorted audio", "background ambient noise", "speaking male"] | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | 3 | 270 | 280 | 0 | 0 | ["/m/01glhc", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/m/0fx80y"] | |
HrPnGYGrvm0 | The song is an instrumental. The tempo is medium and sometimes glitch out if time, with a banjo being played by a beginner. The song is amateurish in quality and not pleasant. The song audio quality is very poor. | ["home video", "music video", "banjo learning video", "strumming rhythm", "beginner", "banjo lessons", "amateur musician", "learning to play", "musicians diary", "poor quality audio", "playing out of time", "badly tuned strings", "instrumental music", "bad music", "banjo player", "medium tempo"] | ["Banjo", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | 1 | 100 | 110 | 0 | 1 | ["/m/018j2", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/t/dd00125"] |
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 );