updated us_state table to contain state code.