[stokedmartin]

To see specific zip codes, download zip[0]. UCMR3_ZipCodes.txt has all the zip codes and you can cross reference UCMR3_All.txt using PWSID to get facility ID; then cross reference UCMR3_DRT.txt using the facility ID to get the disinfection type. Details about the disinfection type can be found in a pdf within the zip file.

[0]https://www.epa.gov/sites/production/files/2015-09/ucmr-3-oc...

[corpus]

I'll paypal $50 to the first person who can write a script or web interface which just takes a zip-code and returns a list of infections based on this data.

[gricardo99]

If you download the zip, here's a bash one-liner (replace 48103 with zip of interest):

for pwsid in $(grep 48103 UCMR3_ZipCodes.txt | cut -f 1);do for fid in $(grep $pwsid UCMR3_All.txt | cut -f 4);do grep $fid UCMR3_DRT.txt | cut -f 6;done;done | sort | uniq

[corpus]

ok this guy wins :) email me at [e-mail] with your paypal details / or pay request. thanks!

p.s. every zip code i've tried has a bunch of findings. anyone have a zip code without one?

[gricardo99]

Thanks, that's very generous.

I updated the bash line to include filtering on "=". From reading other comments, "which means at or above minimum reporting level". But more importantly, the line I had was reporting the "Disinfectant Type" not the "Contaminant"!

If you're feeling really charitable, I'll pay it forward and second another comment: send the donation to EFF.

[gricardo99]

Update: with "=" filtering ("at or above minimum reporting level"), AND... using "Contaminant" instead of "Disinfectant Type" (I followed a comment that seems to be off...always worth checking for yourself!).

for pwsid in $(grep 48103 UCMR3_ZipCodes.txt | cut -f 1);do grep $pwsid UCMR3_All.txt | cut -f 14,17 | grep =;done | sort | uniq

[amenghra]

Go to https://www3.epa.gov/enviro/myenviro/ and put your zip code in there.

[seanp2k2]

I'll try to get something up on GitHub when I'm back by a computer. Give it to the EFF if I win :)

[fomq]

http://uncorrected.com/ucmr/?zip=ENTER_ZIP_HERE

it's ugly. If I get a chance later, I'll throw some styles on it to make it easier to read.

[tbrock]

crap, my zipcode is on there... does this mean i'm going to die?

[buzzybee]

When you get deep into these widespread public health issues you start to realize that there's always going to be at least one that you or your locale is at risk for. If it's not the water, it's the food. If it's not the food, it's the air. If it's not the air, it's the soil. If it's not the soil, it's your building. And so on...

The best you can do, in the end, is to avoid paranoia or panic and just aim for some systematic detection, mitigation and prevention processes in your household. With a little luck and a good system, you cheat death or disability, temporarily. You cannot create an ironclad guarantee of safety, but there are many things that you can do something about.

[tim333]

I figure tallying the top ones based on impact on life expectancy makes some sense. The list is probably going to be dominated by the top two or three items. Probably obesity (4 years?) followed by air pollution (1 year maybe) in my case. Not much point worrying about the barely detectable stuff.

[ianlevesque]

Not sure if you're joking, since we're all dying, but if you really want to know what it means see my other comment.

[InclinedPlane]

Yes. Valar Morghulis.

[honkhonkpants]

Do you live anywhere near a dry cleaner, fuel station, military base, rail yard, airport, freeway, smelter, or mine? If so you are doomed.

[gricardo99]

You might be interested in the Disinfectant Type used by your water district, but I think most people are interested in knowing the "Contaminant" detected in their water.

[enlightenedfool]

I found disinfectant type CAOF in my region. What does that mean? I couldn't gather. But the map shows that contaminants are not detected

[stokedmartin]

CAOF (Chloramine, formed from offsite hypochlorite)

[gricardo99]

That just "cleans" the water, mostly for microbiological contaminants. You'll want to look-up what "Contaminants" were found in your water.