The 1Point3Acres COVID-19 in US and Canada / real time updates with credible sources is a great website; probably the best place to track how the pandemic is growing in the US. While it has great visuals, I firmly believe in playing with / plotting the data yourself to feel like you really understand it.
As of writing this (3/22), despite the social distancing measures and shutdowns happening in a lot of places, it’s still clear that the cases are still growing just as exponentially as it was a week ago (we won’t see if the social distancing measures are working for some number of days after they’re enacted). You can clearly see it rising exponentially when you plot the data on a log scale, where it essentially forms a straight line.
With that linear pattern (in log space), you can make a pretty simple prediction of what the numbers will be if the trend continues. But while the log scale is great at showing just how predictably the cases / deaths are rising (in an exponential manner), it’s a bit hard to fathom what that actually means in real life. That’s why I’ve decided to write out how many people will die in the next week, or the next two weeks, if this trend continues. The numbers are quite harrowing (see below).
I’ll keep updating this plot as long as the trend seems to hold. But wow. I really hope the social distancing and other societal measures really break this trend, because the future is VERY bleak otherwise.
3/23/20: The numbers two days ago were 26899 cases and 348 deaths. The model predicted that yesterday we’d have 35805 cases and 461 deaths. Actual numbers were 35229 and 472 deaths. Pretty close… Based on my ultra simple model, the prediction for the end of day today is 47247 cases and 633 deaths.
3/24/20: Actual numbers for yesterday were 46451 and 597 deaths, so definitely up from the day before, but not quite as much as expected based on the last two weeks of exponential growth. Perhaps a good sign that spread is slowing a little? Predictions for end of day today are now 62551 cases and 792 total deaths.
3/25/20: Actual numbers yesterday were 55258 cases and 802 deaths. So the number of cases was much lower than estimated, but deaths were slightly higher. I had actually estimated the numbers based on cases (and extrapolated deaths based on a constant case fatality rate), but it’s possible CFR is going to start changing soon, so I’m going to estimate both numbers independently. Estimates for tomorrow are now 74258 cases and 1054 deaths by end of day today.
3/26/20: Actual cases yesterday was 69222 (~5000 less than I predicted), but deaths were 1055 (spot on with my prediction). So it really does seem like rate of reported cases are falling (maybe b/c we’re starting to catch up a bit more with testing?) but deaths are still growing in an exponential manner. Predictions for end of day today are 89976 cases (likely going to be another overestimate) and 1375 total deaths.
3/27/20: Actual cases yesterday was 86045, and deaths was 1304. The cases has topped the total cases in China and it’s going to keep climbing, though yesterday’s cases and deaths are less than the estimate (so hopefully that’s a good sign?). Next estimates are 109,690 total cases, and 1701 total deaths.
3/28/20: Actual case total from yesterday was 104848 and deaths 1715. Deaths again below predicted, but deaths again spot on. There has definitely been an uptick in death rate over the last 4 days, and it’s not an anomaly like earlier in the epidemic b/c the n values for each day are now in the hundreds each day. New predictions are 131,271 total cases and 2234 total deaths at the end of the day.
3/29/20: Actual case total from yesterday were 124,626 cases and 2202 deaths. So I think it’s quite clear at this point that our rate of new cases is dropping off a little from a week or two ago, but are deaths haven’t really done that. part of that may be the fact that deaths are more delayed than cases (since the order is case -> death). It’s also possible that with the health care capacities straining, the death rate per person infected is actually increasing. New predicted totals for end of day today is 153854 cases and 2844 deaths.
3/30/20: Well, good news is that both the rate of new cases and new deaths is dropping off of the exponential. Total cases as of yesterday was 142629 and total deaths 2578. Estimates for today are 173129 and 3299.
3/31/20: Yesterday was 164671 and 3180. So still fewer new cases, but plenty of deaths. Will be nice to see the death numbers start decreasing in pace… new numbers are 197504 and 3999.
4/1/20: Yesterday was 189802 and 4086. So again a fair number of fewer new cases than expected, but MORE deaths than expected. So uh…. that’s still not a great sign. New predicted numbers are 223917 and 5102. We’re in the phase now where each day is estimated to bring about a thousand new deaths…
4/2/20: Yesterday was 216762 cases and 5148 deaths. Same overall trend; it’s good I’m still overestimating cases, but bad that deaths have been slightly higher than predicted. New predictions are 252157 cases, 6421 deaths.
4/3/20: Yesterday was 245761 cases and 6076 deaths. Fewer deaths than expected! Finally! Next prediction is 282968 cases and 7514 deaths.
4/4/20: Second day in a row where deaths was less than expected, with yesterday’s numbers being 278196 cases and 7174 deaths! Tomorrow prediction: 318333 cases at the end of day, and 8806 total deaths. Despite the good news, still worth pointing out that 1,000+ people are still dying each day…
4/5/20: End of yesterday stats were 312792 total cases, 8523 total deaths. So both are still slow decreasing in rate still, which is good. Next estimates are 356549 total cases and 10,412 total deaths end of day. That’s right. We’ll be at about 10,000 total COVID19 deaths end of day today.
4/6/20: End of yesterday numbers were 338122 cases and 9677 deaths. So both are way lower than expected, which is great news. New expected number are 381945 and 11624, which will hopefully both be large overestimates as well.
4/7/20: Yesterday totals were 368453 cases and 11020 deaths. Less than predicted, so good. Next estimates are 411890 cases 12975 deaths.
4/8/20: Eh, yesterday’s totals were the same as usual recently. 402383 cases and 12936 deaths; so fewer cases, and people still dying. New total estimates are 445669 cases and 15055 deaths.
4/9/20: Yesterday’s end of day totals: 435624 cases, 14835 deaths. Fewer cases but roughly expected number of deaths. Today’s end of day predictions: 478340 cases, 17183 deaths.
4/10/20: Totals at the end of yesterday were 469994 cases and 16726 deaths. Todays totals predictions are 512233 cases and 19252 deaths.
4/11/20: End of day totals yesterday were 506062 cases and 18827 deaths. Both a bit less than expected. Next predictions are 548807 and 21540 deaths (we’ll be surpassing 20k deaths today even if things work out pretty well.)
4/30/20: OK, I’m now too busy to keep doing this exercise. I will point out that there are still thousands of deaths a day at this point, but at least it’s largely topped out for the moment?