[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