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" 取值为 "Photograph"（照片）且 "Source_ID" 存在有效值但未提供URL，则表示该照片存储于本人本地硬盘中，无法公开上传。
- 在钟表表中，若 "Unique" 字段取值为 "Yes"，则表明本人确认该钟表无法与列表中的其他任何钟表进行匹配。当前列表中共收录114座钟表，数量偏多，理想情况下应缩减至60座左右。
- 本数据库中收录的招牌钟与立面钟数量正逐步增加。本人将在关联页面中持续更新待解决问题清单，以及本人明确需要完善的研究方向。