CSSEGISandData / COVID-19

Novel Coronavirus (COVID-19) Cases, provided by JHU CSSE
https://systems.jhu.edu/research/public-health/ncov/
29.12k stars 18.41k forks source link

Leading zeros missing from state FIPS (again) #2183

Open bbgvisualjournalist opened 4 years ago

bbgvisualjournalist commented 4 years ago

The leading zeros on states Alabama - Connecticut are missing. This was reported and fixed a couple of days ago.

For example the FIPS code for Autauga, Alabama is 01001, but is recorded in the CSV as 1001.

StateCenterKid commented 4 years ago

I believe Colorado, Arizona and California were excelified as well.

Lucas-Czarnecki commented 4 years ago

Part of the problem may be that JHU's Lookup Table also omits leading zeros for states. The following states are affected:

It appears then that all the counties for these states are also affected.

edit: I've briefly looked through the commit history, and have noticed that this is a recent problem.