Weekly Update: Which COUNTIES have the highest per capita rates of #COVID19 cases and deaths?
The data below comes from the GitHub data repositories of Johns Hopkins University, execpt for Rhode Island, Utah and Wyoming, which come from the GitHub data of the New York Times due to the JHU data being incomplete for these three states. Some data comes directly from state health department websites.
Here's the top 100 counties ranked by per capita COVID-19 cases as of Saturday, August 15th (click image for high-res version):
There's still a clear disconnect between the counties with the highest rates of infection and the ones with the worst mortality rate. 65 of the 100 counties with the highest rate of infection voted for Donald Trump...and 30 of the other 36 are in states Trump won.
New York doesn't even show up until #67 (Rockland County), and Michigan no longer shows up until #648 (even then, it's not Wayne County which ranks highest...it's Oceana County. Wayne County, where Detroit is located, doesn't show up until #739).
On the other hand, as you can see below, fatalities are a different story: 53 of the 100 counties with the highest COVID-19 mortality rates voted for Hillary Clinton. It's actually more like 56 out of 100, 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 four of the 10 deadliest COVID counties are located in Georgia, as are 14 of the top 100. 13 of the top 100 are in Mississippi. New York City ranks #9 (or #9-13, really). Michigan doesn't show up until #52 (Wayne County, which includes Detroit).
Here's the top 100 counties ranked by per capita COVID-19 fatalities as of Saturday, August 15th (click image for high-res version):
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.3x higher. In terms of the mortality rate, the ratio has dropped from 5.3x to 2.1x.