Table 1 Part of database of participant addresses and water source information Information for four participants is shown. For each change in address or primary source of water a new row is entered in the database. Therefore there are 16 rows in this sample database.
Year moved in | Year moved out | Sample ID | City | Primary Source of Water |
|---|---|---|---|---|
9/12/1935 | 1/1/1953 | 1 | Swartz Creek | Private well |
1/1/1956 | 1/1/1958 | 1 | Swartz Creek | Private well, softener |
1/1/1958 | 1/1/1963 | 1 | Swartz Creek | Private well |
1/1/1963 | 1/1/1974 | 1 | Swartz Creek | Private well, reverse osmosis |
1/1/1974 | 1/1/1990 | 1 | Swartz Creek | new private well |
1/1/1990 | 1/1/2002 | 1 | Swartz Creek | Community Supply |
1/1/2002 | 1/1/2004 | 1 | Swartz Creek | Community Supply, softener |
1/1/1976 | 1/1/1990 | 2 | Livonia | Community Supply |
1/1/1990 | 1/1/2004 | 2 | Brighton | CS (township well and treatment plant) |
1/1/1953 | 1/1/1961 | 3 | Jackson | Community Supply |
1/1/1961 | 1/1/1971 | 3 | Jackson | Well (30 ft) |
1/1/1971 | 1/1/1984 | 3 | Michigan Centre | Private well |
1/1/1984 | 1/1/1993 | 3 | Vandercook Lake | Private well |
1/1/1993 | 1/1/2004 | 3 | Horton | Well (280 feet) |
1/1/1943 | 1/1/1958 | 4 | Ferndale | Community Supply |
1/1/1982 | 1/1/2004 | 4 | Waterford | Community Supply |