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.
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
p.s. every zip code i've tried has a bunch of findings. anyone have a zip code without one?
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.
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
it's ugly. If I get a chance later, I'll throw some styles on it to make it easier to read.