This table contains Freedom of Information Act (FOIA) documents released to the public.
This dataset has the following 3 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
Reference Number | reference_number | url | view top 100 |
Date Created | create_date_copied_pasted | text | 2021-09-24 2021-07-07 2021-08-24 2020-07-28 2020-09-29 view top 100 |
Request Summary | request_summary | text | SDWIS Export of all Michigan 2021 Lead and Copper Rule compliance sampling data for the 2021 January-June sampling period. The data should include sample address, sample date, lead results, lead units, copper results, copper units, first liter/fifth liter, accepted/rejected status, not highest status. Final records describing the water quality parameters established by the Michigan Department of Environment, Great Lakes, and Energy regarding the Benton Harbor public water supply pursuant to Mich. Admin. Code R. 325.10604f(3)(f), including a minimum value or range of values of pH at each entry point, a minimum pH value at taps, a minimum concentration or range of concentrations for the corrosion control inhibitor (if used) at each entry point and at taps, a minimum or range of concentrations for alkalinity (if adjusted) at each entry point and at taps, a minimum or range of concentrations for calcium (if calcium carbonate stabilization is used) at taps, and any additional water quality parameters determined to reflect optimal corrosion control for the Benton Harbor public water supply. Final records describing the optimal corrosion control treatment designated by the Michigan Department of Environment, Great Lakes, and Energy regarding the Benton Harbor public water supply pursuant to Mich. Admin. Code R. 325.10604f(3)(d). Final records describing the recommended optimal corrosion treatment submitted by or on behalf of Benton Harbor public water supply pursuant to Mich. Admin. Code R. 336.10604f(2)(e)(i). Final records describing the results of follow-up tap sampling conducted by the Benton Harbor public water supply after the Michigan Department of Environment, Great Lakes, and Energy has designated optimal corrosion control treatment pursuant to Mich. Admin. Code R. 325.10604f(2)(e)(v); 325.10710a(4)(b)(ii). Final records describing tap water monitoring results for lead submitted by or on behalf of Benton Harbor pursuant to Mich. Admin. Code R 325.10710d(a)(i)(A) from January 1, 2018 until the present day. Raw compliance data for lead and copper water rule for the entire state of Michigan including location and results of each sample for 2020. For every community water system with a lead action level exceedance from 2016-2019 that also has lead service lines, please provide the number of full lead service lines replaced each year per the requirements of the Lead and Copper Rule, the number of partial lead service lines replaced each year per the requirements of the Lead and Copper Rule, the total number of lead service lines reported each year and the total number of service lines reported each year. For example, Benton Harbor had lead action level exceedances in 2018-2020. In this case please provide the number of full and partial lead service line replacements completed between October 1, 2018 and September 30, 2019 and also for the time period between October 1, 2019 and September 30, 2020, as well as the total number of lead and total service lines used to calculate the 7% replacement rate. From January 2020 through April 2020, any and all emails to or from Eric Oswald that include "Benton Harbor" and "corrosion” or “Benton Harbor” and “orthophosphate.” view top 100 |