RCMD: Resource Center for Minority Data
Really Cool
    Minority Data

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

Version Date: Nov 13, 2017

Cite this study |

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

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

Version V1

Slide tabs to view more

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

Michigan Department of Health and Human Services. State of Michigan: Taking Action on Flint Water Test Results, 2015-2017. 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

Subject Terms

Geographic Coverage

Smallest Geographic Unit

Dwelling

Distributor(s)

Inter-university Consortium for Political and Social Research
Hide

Time Period(s)

2015-11 -- 2017-03

Date of Collection

2015-11 -- 2017-03

Data Collection Notes

  1. Users may be able to find additional information by accessing the State of Michigan Taking Action on Flint Water home page.
Hide

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

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

Longitudinal, Cross-sectional

Universe

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

Unit(s) of Observation

Water fixtures

Data Source

Data Type(s)

Mode of Data Collection

Hide

Original Release Date

2017-11-13

Version History

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.
Hide

Weight

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

Hide

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.

odf logoThis study is provided by ODF. Open Data Flint serves as a central location for housing Flint-based data gathered from academic institutions, local organizations, and federal agencies to encourage a healthier and informed community. The data are made available to researchers, policy makers, general public, and others interested in Flint.