addresstimeline

Table: addresstimeline

Purpose: Keeps track of the cohort state for the USA or province in Canada starting from 2008-2011.

Key columns:

• QID (biging 20)
• PeopleUniqueID (bigint20)
• State2008 (varchar 2)
• State2009 (varchar 2)
• State2010 (varchar 2)
• State2011 (varchar 2)
• Registry (varchar 2)
• FromCanada (bit 1)
• RegistryComplete (varchar 4)

Notes: Dirty data, the data says its from Canada yet has USA states and Canada provinces.