State of Michigan: Taking Action on Flint Water Test Results, 2015-2017 (ICPSR 36955)

Version Date: Nov 13, 2017 View help for published

Principal Investigator(s): View help for Principal Investigator(s)
Michigan Department of Health and Human Services

https://doi.org/10.3886/ICPSR36955.v1

Version V1

The data were downloaded from the State of Michigan Taking Action on Flint Water website. This website contains testing results for blood levels, sentinel sites, residential sites, schools, establishment sites, and Confirming Lead Elimination After Replacement (CLEAR) sites. For this study, the sentinel testing, school testing, and establishment testing results were used.

Michigan Department of Health and Human Services. State of Michigan: Taking Action on Flint Water Test Results, 2015-2017. Ann Arbor, MI: Inter-university Consortium for Political and Social Research [distributor], 2017-11-13. https://doi.org/10.3886/ICPSR36955.v1

Export Citation:

  • RIS (generic format for RefWorks, EndNote, etc.)
  • EndNote

Dwelling

Inter-university Consortium for Political and Social Research
2015-11 -- 2017-03
2015-11 -- 2017-03
Users may be able to find additional information by accessing the State of Michigan Taking Action on Flint Water home page.

The purpose of the study was to collect water testing results in the city of Flint, Michigan. It is part of a process to allow community members access to the ongoing water testing results following the water crisis which began in Flint in 2014.

The data were downloaded from the State of Michigan Taking Action on Flint Water website. In particular, the Sentinel Testing, School Testing, and Establishment Testing results were used.

For the Sentinel sites, Excel files were combined into two different datasets. Then, each Excel file had extraneous information removed. Excel files for each section (sentinel and extended sentinel) were combined to create two datasets. The variable "date posted" was added to the sentinel and extended sentinel datasets.

For the School sites, PDF files were converted to Excel. Then, each Excel file had extraneous information removed. Excel files for each section (pre-fixture replacement, post-fixture replacement, post-filter installation) were combined to create three datasets. Variables added to each dataset include school name, school city, school ZIP code, data capture time point, and sampling assessment date.

For the Establishment sites, PDF files were converted to Excel. Then, each Excel file had extraneous information removed. Excel files for each section (adult foster care and day care) were combined to create two datasets. Variables added to the adult foster care dataset include the adult foster care name, city, ZIP code, and date of post filter assessments. Variables added to the day care dataset include the day care name, city, ZIP code, and date of post filter assessments.

Longitudinal, Cross-sectional

Schools, day care centers, adult foster and health care centers, and sentinel sites in Flint, Michigan

Water fixtures
administrative records data, experimental data

2017-11-13

2018-02-15 The citation of this study may have changed due to the new version control system that has been implemented. The previous citation was:
  • Michigan Department of Health and Human Services. State of Michigan: Taking Action on Flint Water Test Results, 2015-2017. ICPSR36955-v1. Ann Arbor, MI: Inter-university Consortium for Political and Social Research [distributor], 2017-11-13. http://doi.org/10.3886/ICPSR36955.v1

2017-11-13 ICPSR data undergo a confidentiality review and are altered when necessary to limit the risk of disclosure. ICPSR also routinely creates ready-to-go data files along with setups in the major statistical software formats as well as standard codebooks to accompany the data. In addition to these procedures, ICPSR performed the following processing steps for this data collection:

  • Created variable labels and/or value labels.
  • Checked for undocumented or out-of-range codes.

The data are not weighted, and the dataset does not contain weight variables.

Notes

  • The public-use data files in this collection are available for access by the general public. Access does not require affiliation with an ICPSR member institution.