EPA Safe Drinking Water Information System
Drinking water systems & violations
Every public water system: who it serves, its facilities and service areas, violations, enforcement, and lead and copper test results.
Published by EPA Safe Drinking Water Information System
Finest detail facility
Tables 9
Lead and copper samples
Sample of 25 rows out of about 932,823
· 22 columns
| id | vintage | county_fips | state | lat | lon | submissionyearquarter | pwsid | sample_id | sampling_end_date | sampling_start_date | reconciliation_id | sample_first_reported_date | sample_last_reported_date | sar_id | contaminant_code | result_sign_code | sample_measure | unit_of_measure | sar_first_reported_date | sar_last_reported_date | loaded_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2026-10-08 | 26111 | MI | No data | No data | 2026Q3 | MI0004370 | S468 | 06/30/1998 | 01/01/1998 | No data | 04/10/2004 | 04/10/2004 | 2321546 | PB90 | No data | .009 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 2 | 2026-10-08 | 26111 | MI | No data | No data | 2026Q3 | MI0004370 | S467 | 12/31/1994 | 07/01/1994 | No data | 04/10/2004 | 04/10/2004 | 2321547 | PB90 | No data | .012 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 3 | 2026-10-08 | 26111 | MI | No data | No data | 2026Q3 | MI0004370 | S466 | 06/30/1994 | 01/01/1994 | No data | 04/10/2004 | 04/10/2004 | 2321548 | PB90 | No data | .012 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 4 | 2026-10-08 | 26115 | MI | No data | No data | 2026Q3 | MI0004450 | S439 | 06/30/1993 | 01/01/1993 | No data | 04/10/2004 | 04/10/2004 | 2321549 | PB90 | No data | .0121 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 5 | 2026-10-08 | 26115 | MI | No data | No data | 2026Q3 | MI0004450 | S438 | 12/31/1992 | 07/01/1992 | No data | 04/10/2004 | 04/10/2004 | 2321550 | PB90 | No data | .0103 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 6 | 2026-10-08 | 26017 | MI | No data | No data | 2026Q3 | MI0004440 | S1 | 12/31/1992 | 07/01/1992 | No data | 04/10/2004 | 04/10/2004 | 2321551 | PB90 | No data | .023 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 7 | 2026-10-08 | 26125 | MI | No data | No data | 2026Q3 | MI0004390 | S1038 | 12/31/1996 | 01/01/1996 | No data | 04/10/2004 | 04/10/2004 | 2321552 | PB90 | No data | .004 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 8 | 2026-10-08 | 26115 | MI | No data | No data | 2026Q3 | MI0004450 | S440 | 06/30/1994 | 07/01/1993 | No data | 04/10/2004 | 04/10/2004 | 2325093 | PB90 | No data | .0028 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 9 | 2026-10-08 | 26115 | MI | No data | No data | 2026Q3 | MI0004450 | S444 | 12/31/2001 | 01/01/1999 | No data | 04/10/2004 | 04/10/2004 | 2325094 | PB90 | No data | .002 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 10 | 2026-10-08 | 26115 | MI | No data | No data | 2026Q3 | MI0004450 | S443 | 12/31/1999 | 01/01/1997 | No data | 04/10/2004 | 04/10/2004 | 2325095 | PB90 | No data | .0026 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 11 | 2026-10-08 | 26115 | MI | No data | No data | 2026Q3 | MI0004450 | S442 | 06/30/1995 | 07/01/1994 | No data | 04/10/2004 | 04/10/2004 | 2325096 | PB90 | No data | .0037 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 12 | 2026-10-08 | 26067 | MI | No data | No data | 2026Q3 | MI0005930 | S147 | 12/31/1995 | 01/01/1995 | No data | 04/10/2004 | 04/10/2004 | 2327475 | PB90 | No data | .017 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 13 | 2026-10-08 | 26161 | MI | No data | No data | 2026Q3 | MI0005900 | S90 | 12/31/2002 | 01/01/2000 | No data | 04/10/2004 | 04/10/2004 | 2327476 | PB90 | No data | .0022 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 14 | 2026-10-08 | 26161 | MI | No data | No data | 2026Q3 | MI0005900 | S89 | 12/31/1999 | 01/01/1997 | No data | 04/10/2004 | 04/10/2004 | 2327477 | PB90 | No data | .015 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 15 | 2026-10-08 | 26161 | MI | No data | No data | 2026Q3 | MI0005900 | S88 | 12/31/1996 | 01/01/1996 | No data | 04/10/2004 | 04/10/2004 | 2327478 | PB90 | No data | .001 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 16 | 2026-10-08 | 26161 | MI | No data | No data | 2026Q3 | MI0005900 | S87 | 06/30/1995 | 07/01/1994 | No data | 04/10/2004 | 04/10/2004 | 2327479 | PB90 | No data | .002 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 17 | 2026-10-08 | 26161 | MI | No data | No data | 2026Q3 | MI0005900 | S86 | 06/30/1994 | 07/01/1993 | No data | 04/10/2004 | 04/10/2004 | 2327480 | PB90 | No data | .005 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 18 | 2026-10-08 | 26161 | MI | No data | No data | 2026Q3 | MI0005900 | S85 | 06/30/1993 | 01/01/1993 | No data | 04/10/2004 | 04/10/2004 | 2327481 | PB90 | No data | .012 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 19 | 2026-10-08 | 26161 | MI | No data | No data | 2026Q3 | MI0005900 | S84 | 12/31/1992 | 07/01/1992 | No data | 04/10/2004 | 04/10/2004 | 2327482 | PB90 | No data | .004 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 20 | 2026-10-08 | 26145 | MI | No data | No data | 2026Q3 | MI0005860 | S9 | 12/31/2001 | 01/01/2001 | No data | 04/10/2004 | 04/10/2004 | 2327483 | PB90 | No data | 0 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 21 | 2026-10-08 | 26121 | MI | No data | No data | 2026Q3 | MI0005800 | S2 | 06/30/1993 | 01/01/1993 | No data | 04/10/2004 | 04/10/2004 | 2327418 | PB90 | No data | .021 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 22 | 2026-10-08 | 26121 | MI | No data | No data | 2026Q3 | MI0005800 | S1 | 12/31/1992 | 07/01/1992 | No data | 04/10/2004 | 04/10/2004 | 2327419 | PB90 | No data | .008 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 23 | 2026-10-08 | 26163 | MI | No data | No data | 2026Q3 | MI0005785 | S9 | 12/31/2002 | 01/01/2002 | No data | 04/10/2004 | 04/10/2004 | 2327420 | PB90 | No data | .003 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 24 | 2026-10-08 | 26163 | MI | No data | No data | 2026Q3 | MI0005785 | S8 | 12/31/2001 | 01/01/2001 | No data | 04/10/2004 | 04/10/2004 | 2327421 | PB90 | No data | .0045 | mg/L | No data | No data | 2026-10-09 05:01:53 |
| 25 | 2026-10-08 | 26163 | MI | No data | No data | 2026Q3 | MI0005785 | S7 | 12/31/1998 | 07/01/1998 | No data | 04/10/2004 | 04/10/2004 | 2327422 | PB90 | No data | .015 | mg/L | No data | No data | 2026-10-09 05:01:53 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing