To ensure the drinking water for the largest portion of Michigan residents was tested for PFAS, beginning in April 2018, the Michigan Department of Environment, Great Lakes, and Energy (EGLE) implemented a statewide survey to test Michigan's public water supplies across several phases of sampling. *Results are provided in parts per trillion. A part per trillion (ppt) is the equivalent of 1 drop of water in 20 Olympic-size swimming pools FOR FULL DETAILS ABOUT THE DATASET, VISIT: https://www.michigan.gov/pfasresponse/drinking-water/statewide-survey
This dataset has the following 70 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| System Name | systemname | text | Great Lakes Water Authority Kalamazoo Wyandotte Whittemore/Prescott School Complex Ann Arbor view top 100 |
| WSSN | wssn | number | 2838 3520 7210 2021235 220 view top 100 |
| System Type | systemtype | text | MUN SCH CHLCMP INDUS DAYCARE view top 100 |
| Location Name | locname | text | 1 TP001 LOC01 TP100 CH001 view top 100 |
| SysLocCode | sysloccode | text | WYANDOTTE07210TP100 GREATLAKES02838TP102 SIMSWUA06073TP001 DEERFLD01770TP001 MONROE04450TP001 view top 100 |
| Position Source | positionsource | text | EGLE YUMA view top 100 |
| Phase Code | phasecode | text | PHASE_1 Monthly_2019 PHASE_2 Quarterly_2020 Quarterly_2019 view top 100 |
| Task Code | taskcode | text | STATEMUN2018 Monthly_2019 PHASE_2 STATESCH2018 DAYCARE2018 view top 100 |
| Sample Date | sampledate | text | 2018/08/02 09:30:00+00 2019/04/30 14:05:00+00 2019/04/25 10:05:00+00 2018/07/26 10:20:00+00 2018/11/28 14:00:00+00 view top 100 |
| Treatment Status | treatmentstatus | text | TREATED RAW Raw Treated MP view top 100 |
| SysSampleCode | syssamplecode | text | SWEF1810230955KME SWEF1904291400GSC SWEF1905031005GGA SWEF1905010830GSC SWEF1809121020GGA view top 100 |
| Lab Name Code | labnamecode | text | VAL MER EGLE view top 100 |
| LabSdg | labsdg | text | 1001043 1901117 2006210 1001105 1901207 view top 100 |
| Analytic Method | analyticmethod | text | EPA-537 EPA-537M view top 100 |
| HFPODA Result | hfpodaresult | text | view top 100 |
| HFPODA Flags | hfpodaflags | text | U,* U UJ view top 100 |
| PFBS Result | pfbsresult | number | 3 2 4 6 5 view top 100 |
| PFBS Flags | pfbsflags | text | U,* U * UJ J view top 100 |
| PFHxA Result | pfhxaresult | number | 3 2 4 5 7 view top 100 |
| PFHxA Flags | pfhxaflags | text | U,* U * UJ J view top 100 |
| PFHxS Result | pfhxsresult | number | 3 2 4 5 6 view top 100 |
| PFHxS Flags | pfhxsflags | text | U,* U * UJ R view top 100 |
| PFNA Result | pfnaresult | text | 2 9 8 14 6 view top 100 |
| PFNA Flags | pfnaflags | text | U,* U UJ * R view top 100 |
| PFOA Result | pfoaresult | number | 2 3 4 5 6 view top 100 |
| PFOA Flags | pfoaflags | text | U,* U * UJ J view top 100 |
| PFOS Result | pfosresult | number | 2 3 4 5 7 view top 100 |
| PFOS Flags | pfosflags | text | U,* U * UJ J view top 100 |
| PF3OUdS11Cl Result | pf3ouds11clresult | text | view top 100 |
| PF3OUdS11Cl Flags | pf3ouds11clflags | text | U,* U UJ view top 100 |
| FTSA42 Result | ftsa42result | text | view top 100 |
| FTSA42 Flags | ftsa42flags | text | U,* U UJ R view top 100 |
| FTSA62 Result | ftsa62result | number | 4 2 3 6 22 view top 100 |
| FTSA62 Flags | ftsa62flags | text | U,* U UJ * R view top 100 |
| FTSA82 Result | ftsa82result | text | view top 100 |
| FTSA82 Flags | ftsa82flags | text | U,* U UJ R view top 100 |
| PF3ONS9Cl Result | pf3ons9clresult | text | view top 100 |
| PF3ONS9Cl Flags | pf3ons9clflags | text | U,* U UJ view top 100 |
| ADONA Result | adonaresult | text | view top 100 |
| ADONA Flags | adonaflags | text | U,* U UJ view top 100 |
| FOSA Result | fosaresult | text | 70 view top 100 |
| FOSA Flags | fosaflags | text | U,* U UJ R * view top 100 |
| NEtFOSAA Result | netfosaaresult | text | 4 110 13 19 41 view top 100 |
| NEtFOSAA Flags | netfosaaflags | text | U,* U UJ * R view top 100 |
| NMeFOSAA Result | nmefosaaresult | text | 3 30 36 4 5 view top 100 |
| NMeFOSAA Flags | nmefosaaflags | text | U,* U UJ * R view top 100 |
| PFBA Result | pfbaresult | number | 2 3 4 5 6 view top 100 |
| PFBA Flags | pfbaflags | text | U,* U * UJ R view top 100 |
| PFDA Result | pfdaresult | text | view top 100 |
| PFDA Flags | pfdaflags | text | U,* U UJ R view top 100 |
| PFDoDA Result | pfdodaresult | text | view top 100 |
| PFDoDA Flags | pfdodaflags | text | U,* U UJ R view top 100 |
| PFDS Result | pfdsresult | text | view top 100 |
| PFDS Flags | pfdsflags | text | U,* U UJ R view top 100 |
| PFHpA Result | pfhparesult | number | 2 3 6 9 7 view top 100 |
| PFHpA Flags | pfhpaflags | text | U,* U * UJ R view top 100 |
| PFHpS Result | pfhpsresult | text | view top 100 |
| PFHpS Flags | pfhpsflags | text | U,* U UJ R view top 100 |
| PFNS Result | pfnsresult | text | view top 100 |
| PFNS Flags | pfnsflags | text | U,* U UJ R view top 100 |
| PFPeA Result | pfpearesult | number | 2 8 5 12 4 view top 100 |
| PFPeA Flags | pfpeaflags | text | U,* U * UJ R view top 100 |
| PFPeS Result | pfpesresult | text | view top 100 |
| PFPeS Flags | pfpesflags | text | U,* U UJ R view top 100 |
| PFTeDA Result | pftedaresult | text | view top 100 |
| PFTeDA Flags | pftedaflags | text | U,* U UJ R view top 100 |
| PFTrDA Result | pftrdaresult | text | view top 100 |
| PFTrDA Flags | pftrdaflags | text | U,* U UJ R view top 100 |
| PFUnDA Result | pfundaresult | text | view top 100 |
| PFUnDA Flags | pfundaflags | text | U,* U UJ R view top 100 |