3 ms·
tldr: region=$(grep YOUR_ZIP_GOES_HERE UCMR3_ZipCodes.txt|awk '{print $1}') grep $region.*= UCMR3_All.txt | awk 'FS = "\t" {print $14,$5,$18}'| sort o
by rando832 10y ago
tldr:
region=$(grep YOUR_ZIP_GOES_HERE UCMR3_ZipCodes.txt|awk '{print $1}')
grep $region.*= UCMR3_All.txt | awk 'FS = "\t" {print $14,$5,$18}'| sort
open page 7 in ucmr3-data-summary-april-2016.pdf, compare
- twr 10y agoUsing xsv (https://github.com/BurntSushi/xsv https://github.com/BurntSushi/xsv): cargo install xsv xsv search -s ZIPCODE <zipcode> -d $'\t' UCMR3_ZipCodes.txt xsv search -s PWSID <pwsid> -d $'\t' UCMR3_All.txt | xsv search -s AnalyticalResultsSign = | xsv select FacilityName,Contaminant,AnalyticalResultsValue | xsv table