Update on my County-Level #COVID19 Tracking Project: All 50 states complete thru 6/02; DC/territories to be added next

Since I've been neglecting other ACA/healthcare posts the past couple of weeks, I figured I should at least provide regular updates on why I've been mostly absent.

I've made major progress in updating and revising my breakout of COVID-19 cases and fatalities at not just the state level but the county level. Again, I've separates the states into two separate spreadsheets:

Thanks to the combination of the GitHub data repository resource from Johns Hopkins University, the GitHub repository of the New York Times and various state health department websites, I've managed to finally complete plugging in the official COVID-19 cases and fatalities for every single county (or county equivalent) in all 50 states from March 20th - June 2nd.

I still have to add in DC, Guam, the U.S. Virgin Islands, American Samoa (that one's easy...they've reported no cases at all), Puerto Rico and the Northern Mariana Islands, each of which will only count as a single "county" since none of my sources break them down any further.

After that, it shouldn't take too much time to simply update the previous day's numbers for every county for each day going forward.

Advertisement