Re:CSVKit: CSV utilities that includes csvsql, csvgrep, csvs...
by acdha on Wednesday May 28, 2014 @10:29AM
(#7810096)
Yeah, I'm more sensitive to this class of errors now that I live in DC since the "Washington, District of Columbia" format is common enough to show up sporadically.
cut -d, -f1 2010.csv | grep ILLINOIS
works just fine for this data. I emphasise again - I take your overall point though.