Here is the cumulative number of COVID-19 deaths for each state (plus DC) through today. It's adjusted for population, and the ten biggest states are shown in red.
47 thoughts on “Raw Data: COVID-19 Deaths By State”
Comments are closed.
Cats, charts, and politics
Here is the cumulative number of COVID-19 deaths for each state (plus DC) through today. It's adjusted for population, and the ten biggest states are shown in red.
Comments are closed.
Your numbers are wrong
Then post the correct numbers. Or at least explain Kevin's error.
There are only nine red bars.
I'm counting 10.
From left to right:
NC
CA
FL
OH
TX
MI
GA
IL
PA
NY
Given the likelihood of later correction, archive.org early, archive.org often.
The time the chart was added appears to have been 6:52 PM, the above comment is from 8:01 PM - I see 10 red columns. Was one added?
And each time stamp is obviously adjusted for Pacific time, since my comment was post ef d at 2:02 AM on Thursday.
Now, do a scatter plot of deaths / 1M against size of population! ????
Cell OV (Oscar Victor) 78 of Tab StatePopulationAndDeathsPer1M of spreadsheet: https://docs.google.com/spreadsheets/d/1ymc191k5T37xgUlOuK3SBI9PQtZxm_aVwDnncICh85c/edit?usp=sharin Next to it is the value of 'r' for the correlation. 0.278 which if I am not mistaken suggests while there is a correlation, it isn't all that strong.
Actually, it would be more interesting to plot deaths per million vs. population density.
Wonder if density of population per square mile explains the northeast.
Some of it may have to do with density. But the bulk of the Northeast's above average death toll was generated during the first wave, and my hunch the biggest factor there is the that the region serves as the country's principle conduit to Europe.
There is a chart for Census Designated Regions at cell X100 of the tab RateCharts of the spreadsheet at https://docs.google.com/spreadsheets/d/1ymc191k5T37xgUlOuK3SBI9PQtZxm_aVwDnncICh85c/edit?usp=sharin which suggests to these Mk I eyeballs that "bulk" here would be perhaps 60% and falling as a fraction. Depends on when one calls the end of the first wave. If one calls it at July 1, 2020 then it is half from the first wave.
Also corporate events. MA had a major breakout early on because of a Biogen conference. And despite Trump's fictional Chin-er travel ban, there were still flights packed with Chinese students landing in Logan Airport every single day.
I think that has to be a big part of it -- the NYC metro area, Philadelphia, Boston, Providence, etc. are very dense, and home to a lot of working class and multi-generational households that couldn't easily distance, and older-than-average residents with comorbidities. Residents in those cities also use public transportation a lot, which is where Covid really got started.
Hmm. Florida right in the middle and we've been pretty much open for many months and schools have been open since August. Thank goodness for Governor DeSantis.
can't trust the Florida numbers
Give me a break. That's the standard liberal talking points for people who can't accept maybe the extreme lockdowns and keeping kids out of school all year maybe wasn't necessary.
Just to be clear, I'm not one of these anti-mask nuts and I do agree that some forms of shut downs were necessary. Just that some states took it way too far. And the fact that some schools are still closed is criminal.
A lot of people agree that schools should have reopened sooner. Maybe summer school will be popular this year, but by August, all will be open, I think.
LOL.
I know who you are -- you're the professional rightwing agitator who stood unmasked in front of the Michigan State Police, spewing your saliva toward them while bellowing to liberate the Great Lakes State.
Monty, you are confusing me with someone else. I haven't been inside a public building without wearing a mask in about a year. And I've never to MI.
The Biden Recession has ended. The De Santis Boom has just begun.
(H/t @dougjballoon)
Florida hasn't compared so well lately. They are ninth-highest in deaths per million over the past four weeks.
We're in the jung--... Everglades, baby. We're gonna die.
Imagine how low Florida's covid numbers would if they'd locked down just a bit more ...
A person could argue that since CA's and FL's numbers are close, CA's lockdowns & mask mandates & etc. weren't any better than doing what FL did. That's not the way I see it. CA's lockdowns kept us in the middle of the pack. Otherwise we'd be like New York, not Florida. It was going way, way sideways here before lockdown #2.
Thank god for DeSantis being far, far away. 🙂
How are the businesses and schools doing in CA? You have to balance all factors.
Spring Break seemed to have been a super spreader event last year--for the rest of the country.
The one thing that's clear, from Hawaii, Australia, New Zealand, and Taiwan, is that it's good to be an island.
Tell that to the UK.
Being an island is a big advantage, but for it to matter, leaders still have to make the right decisions at the time it matters.
An island small enough to more or less completely ban ingress.
The UK's problem wasn't its size, it was that at the start of the pandemic its government thought they could ride it out and refused to implement any serious measures to control the spread. It wasn't until they had become the biggest hotspot in Europe and Boris himself got sick when they started to take it seriously.
England in particular also has a very high population density. Of course, Taiwan has an even higher population density, so that's obviously not determinative.
It is clear that being a large, urbanized state is a risk factor. It is just much harder to control spread when people live in high density. The East Coast had the double whammy of high density and an early outbreak, when testing was hard to get and we knew less about effective prevention.
But that just highlights how bad North and South Dakota are. They are very rural, and should look more like Vermont, Maine, Oregon, or Wyoming. But they totally skrewed themselves over, and did so long after we knew what worked to slow spread.
Apparently Alaska is not a big state 😉
The Chart Title (as of April 22, 2021) is "COVID-19 Deaths Through April 2021" - Kevin are you making a prediction of where things will be in a week's time?-)
For those who would like to see the numbers through April 21st, 2021 to go along with the bars there is a table and a chart around Row 100 in the tab "RateCharts" of https://docs.google.com/spreadsheets/d/1ymc191k5T37xgUlOuK3SBI9PQtZxm_aVwDnncICh85c/edit?usp=sharin
And the R's in CA want to recall Newsom because of his "failure"?
Chart shows pretty good results.
What are their alternatives? North and South Dakota?
Rs' motivations in California aside, Newsom was extremely lucky the several SF Bay Area counties were out ahead of and more persistent than he was for shelter-in-place and restrictions and such, or Northern California would have looked more like Southern California. California's overall may be "only" 1554 cumulative deaths/million, but Southern California's is 1892 (Between Illinois and Arkansas), with Northern California at 1028 (between Colorado and New Hampshire)
They want to recall Newsom because the GQP cannot win on a level playing field in California. Recall is a thumb on the scale.
Obviously size, presumably population in this graph, is not a dominant factor. Density may be one factor, but the most populous states have big cities but also lots of rural low density areas. To evaluate the effect of density it would probably be necessary to go down to at least the county level. There could be many other factors - influx from Europe and China, state and local rules, fraction of rule-defiers, etc. etc. By this time it is clear that there is no one magic factor. To get a valid mathematical treatment, which is the only way to decide ultimately, all factors will have to be included on the appropriate geographical scale. This is going to take some time to sort out.
Also, given how various states, countries, and areas have risen and fallen in relative ranking, any conclusions prior to the end of the pandemic should be exceptionally humble and tentative (and therefore wholly out of place on the internet).
I see Florida and Ohio are side by side. At least for a while they had dissimilar policies, IIRC. I wonder what the graph would look like if you sorted by average age.
"I wonder what the graph would look like if you sorted by average age."
This.
Utah, sixth from the bottom, has the lowest average age of any state. I wouldn't be surprised if it has the lowest death rate per case*. (*Estimated, not official, because you need to control for level of testing, either through the positivity rate, or tests administered per million population.)
On the other hand, the correlation between population density and cases is probably why Utah isn't vying for lowest death rate with Hawaii. Utah is in the top ten most urban** states. While Hawaii is even more urban, it has the advantage of being a chain of islands.
(**Before you express incredulity -- Population in dry states crowds into the few spots with water.)
I left my microscope at home and thus can't read this chart
Lol. I couldn't read it either at first. Right click on it and open in new tab. It's much larger.
Lol. I couldn't read it either at first. Right click on it and open in new tab. It's much larger.
There is also apparent seasonality with the virus.
So many variables, so little time....
But under any conditions, wearing masks helps.