Weekly Update: Which COUNTIES have the highest per capita rates of #COVID19 cases and deaths?

IMPORTANT UPDATE: I've been alerted to the fact that I had data entry errors in at least two of the states last weekend (Michigan and Texas). It looks like the sort order got messed up during the data transfer in those states. As a result, at least 2 of the "Top 40" / "Top 100" counties I had listed were wrong. I've deleted the spreadsheets for this week and will triple-check everything for this weekend's weekly update. My apologies for the error.

 

Now that I've brought all 50 states (+DC & the U.S. territories) up to date, I'm going to be posting a weekly ranking of the 40 U.S. counties (or county equivalents) with the highest per capita official COVID-19 cases and fatalities.

Again, I've separates the states into two separate spreadsheets:

Most of the data comes from either the GitHub data repositories of either Johns Hopkins University or the New York Times. Some of the data comes directly from state health department websites.

Here's the top 40 counties ranked by per capita COVID-19 cases as of Saturday, July 4th:

 

There's still clear disconnect between the counties with the highest rates of infection and the ones with the worst mortality rate. 16 of the 20 counties with the highest rate of infection are low-population rural counties which voted for Donald Trump...and three of the other four are in states Trump won by wide margins (Alabama, Arkansas and Louisiana).

New York doesn't even show up until #26, and Michigan doesn't show up until #27.

On the other hand, as you can see below, 16 of the 20 counties with the highest COVID-19 mortality rates voted for Hillary Clinton. It's actually more like 18 out of 20, since both the NY Times and John Hopkins University data files lump all 5 New York City boroughs (which are actually counties) into a single listing. Four of the five are solid blue (the exception is Richmond County, aka Staten Island).

Setting political lean aside, it's noteworthy that the four deadliest COVID counties are located in Georgia. In fact, 9 of the top 40 are Georgia counties regardless of red or blue status.

Here's the top 40 counties ranked by per capita COVID-19 fatalities as of Saturday, July 4th:

 

It's also worth noting how the ratio of per capita cases has shifted between the Clinton and Trump counties over time. Back in mid-March, the rate was 4.5x higher in Clinton-voting counties than Trump counties. As of this weekend that ratio was down to 1.6x.

UPDATE: I just realized that with nearly 3,200 counties/parishes nationwide, posting just the top 40 is far too small a sliver...that's only around 1.1% of the total.

A more useful sample would be the Top 100 (which is still only around 3.2% of the total) (click the images for a higher-resolution version):

 

 

 

UPDATE: It's been pointed out that a whopping 84% of all counties voted for Trump. However, here's the point:

  • On 3/20, of the 100 worst-hit counties, the breakout was 51 Trump, 49 Clinton.
  • By 4/05, it was 57 Trump, 43 Clinton.
  • By 5/12, it was 59 Trump, 41 Clinton.
  • By 6/06 it was 62 Trump, 38 Clinton.
  • On 7/04 it was 68 Trump, 32 Clinton.

Get the picture yet?