Seattle_Street_Clock_Database.xlsx

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 growing number of sign and facade clocks in the database. On the linked page I will maintain a list of open questions, and areas I know I need to work on.本电子表格包含三张数据表：钟表表（Clocks）、所有者表（Owners）与佐证数据表（Evidence）。佐证数据表以钟表表的名称列与所有者表的企业列作为关联键。 佐证数据列表收录了本人通过报纸、照片、文献或其他渠道获取的所有唯一事实条目，内容涵盖某座钟表所处的具体位置，以及该位置下该钟表的所有者信息。该数据集v1版本共包含1033条佐证数据。 若您有补充内容或发现数据错误，欢迎与我联系。本人将定期更新该数据集，且持续发掘新的相关资料。本人与友人保罗·米登茨（Paul Middents）已证实了多位所有者之间的关联关系，同时本人确信后续还将有更多发现，可揭示更多钟表后续归属至其他珠宝商的相关记录。 关于各字段的几点说明： - 在佐证数据表中，"Var_Year"代表来源年份（Source_Year）的±误差范围。此字段为空时，表示来源年份为精确值；取值为0时，则代表该钟表首次进驻当前地点的年份。 - 若来源类型（Source_Type）为照片，且来源ID（Source_ID）存在有效值但未提供URL，则说明该照片存储于本人本地硬盘中，暂无法公开发布。 - 在钟表表中，若"Unique"字段取值为"Yes"，则表明本人确认该钟表无法与列表内其他任何钟表进行匹配。当前列表中共收录114座钟表，数量偏多，理想情况下应缩减至60座左右。 - 该数据库中收录的招牌钟与外立面钟表数量正逐步增加。本人将在关联页面中持续维护一份待解决问题清单，以及本人已知需开展后续工作的相关领域。