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）已证实了多位所有者之间的关联关系，同时相信未来还将有更多发现，可揭示更多钟表后续被其他珠宝商收藏的情况。

关于各字段的几点说明：
1. 在Evidence表中，"Var_Year（可变年份）"字段表示"Source_Year（来源年份）"的±误差范围，留空则代表来源年份为精确值；若取值为0，则代表该钟表入驻该地点的首年。
2. 若"Source_Type（来源类型）"为"Photograph（照片）"且"Source_ID（来源编号）"存在对应值，但未提供"URL（统一资源定位符）"，则说明该照片存储于笔者本地硬盘中，无法公开发布。
3. 在Clocks表中，若"Unique（唯一性）"字段取值为"Yes"，则表明笔者可确认该钟表无法与列表中的其他任何钟表进行匹配。当前列表中共收录114台钟表，数量偏多，理想情况下应缩减至60台左右。
4. 本数据库中包含少量大型招牌钟，此类钟表均位于市中心区域。O. B. McClintock招牌钟明确应纳入本数据库，其余少量招牌钟的相关说明已在Evidence表与Clocks表的"Notes（备注）"字段中给出。

笔者将在关联页面中维护一份待解决问题清单，以及笔者已知需要完善的工作领域。