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