Debugging public data - county codes in Texas
If you sort a list of Texas counties by county name, the counties will not be in order by county number. Texas Center for Healthcare Statistics Every county in the United States has a FIPS code. These standards codes are usful for mapping and joining additional datasets. Texas state agencies do not bother with these FIPS codes. Instead, each state agency publishes data using their own county codes. The county codes of one state agency may not match other agencies’ county codes. I recently spent a few hours extremely confused by this, because I used the formula published by the Texas Department of State Health Services on data published by the Texas Health and Human Services, resulting in incorrect data. ...