State of Michigan: Taking Action on Flint Water Test Results, 2015-2017 (ICPSR 36955)
Version Date: Nov 13, 2017 View help for published
Summary View help for Summary
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.
Citation View help for Citation
Subject Terms View help for Subject Terms
Geographic Coverage View help for Geographic Coverage
Smallest Geographic Unit View help for Smallest Geographic Unit
Distributor(s) View help for Distributor(s)
Time Period(s) View help for Time Period(s)
Date of Collection View help for Date of Collection
Data Collection Notes View help for Data Collection Notes
Study Purpose View help for Study Purpose
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.
Study Design View help for Study Design
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.
Time Method View help for Time Method
Universe View help for Universe
Schools, day care centers, adult foster and health care centers, and sentinel sites in Flint, Michigan
Unit(s) of Observation View help for Unit(s) of Observation
Data Source View help for Data Source
Method of Data Collection View help for Method of Data Collection
Mode of Data Collection View help for Mode of Data Collection
Original Release Date View help for Original Release Date
Version History View help for Version History
- 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 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.