Seattle Street Clock Database

2017-01-29T00:16:29Z (GMT) by Rob Ketcherside

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.



CC BY 4.0