Seattle Street Clock Database

This spreadsheet contains three tables: Clocks, Owners, and Evidence - Clocks tab's name column and Owners tab's corporation column keys in Evidence. - Evidence is a list of every unique fact I have via newspaper, photograph, document, or otherwise about when a clock was in a particular location, and who owned it at that time. v1 has 1033 pieces of evidence. Please contact me if you have additions or find errors in my data. I will be refreshing this periodically. I constantly find new resources. Along with my friend Paul Middents we have proven the connection between many owners, and I know that there will be more discoveries to show which clocks were later owned by another jeweler. A few notes on fields: - In Evidence, "Var_Year" indicates a +/- value on the Source_Year. Empty means exact. 0 means it was the first year that the clock was at that location. - If the Source_Type is Photograph, Source_ID has a value, and there is no URL, then I have the photo on my harddrive but can't post it. - In Clocks, if the Unique field is Yes, then I'm sure that this clock cannot be matched with any other clocks in the list. There are 114 clocks in the list which is excessive. It should be down closer to 60. - There are a few large sign clocks in the database. They are all in downtown. The O. B. McClintocks definitely belong in the database, and the few other signs are described that way in the Notes field of both Evidence and Clocks. On the linked page I will maintain a list of open questions, and areas I know I need to work on.

本电子表格包含三张数据表：时钟表（Clocks）、所有者表（Owners）与证据表（Evidence）——Evidence表以Clocks表的名称列与Owners表的企业列作为关联键。
Evidence表收录了本人通过报纸、照片、文件或其他渠道获取的全部唯一史实，内容涵盖各时钟所处的具体位置，以及彼时该时钟的所有者信息。本数据集v1版本共包含1033条证据记录。若您有补充内容或发现数据存在错误，欢迎与我联系。我将定期更新此数据集，并持续发掘新的相关资源。我与友人保罗·米登茨（Paul Middents）已证实了多位所有者之间的关联关系，同时我确信仍有更多新发现可佐证哪些时钟后续为其他珠宝商所持有。
关于各字段的几点说明：
- 在Evidence表中，"Var_Year"字段表示"Source_Year（来源年份）"的±误差范围。若该字段为空，则代表来源年份为精确值；若字段值为0，则代表该时钟首次出现在对应位置的年份。
- 若"Source_Type（来源类型）"为"Photograph（照片）"且"Source_ID（来源ID）"存在有效值，但未提供URL，则表明该照片存储于本人本地硬盘中，无法对外公开。
- 在Clocks表中，若"Unique（唯一标识）"字段值为"Yes"，则说明本人确认该时钟无法与列表中的其他任何时钟进行匹配。当前列表中共收录114台时钟，数量偏多，理想情况下应缩减至60台左右。
- 本数据库中包含少量大型招牌时钟，均位于市中心区域。O. B. McClintock品牌的时钟无疑应纳入本数据集，其余少量招牌时钟的相关说明均存储于Evidence表与Clocks表的"Notes（备注）"字段中。
在关联页面中，我将维护一份待解决问题清单，以及本人已知需完善的工作方向。