Updated Trend Charts and Table

By August 26, 2020Commentary

You will recall a few weeks ago I created this chart and table that show trends in case rates of hospitalizations and deaths.  The idea was to try to create a “cohort” look at a group of cases arising in the same time frame.  Leaving aside data issues, what this does is take deaths as reported by Minnesota for a certain week, take cases from the week ending 14 days earlier, which is the median time to death according to the CDC and take hospitalizations from 10 days earlier, which is the median time from hospitalization to death.  The analysis shows for cases in a particular  week, what percent ended up in the hospital and what percent died.  I show this both cumulatively since the start of the epidemic up to the latest week of deaths, and just looking at the current week’s numbers and percents.

In the cumulative chart you see that continuing long tail down to the right that indicates that overall the death and hospitalization rates are continuing to decline.  If I had cumulative cases on here, you would see them as an increase in the early part of the epidemic, a decline when the real epidemic was over, and then another  increase over the last 8 weeks or so that reflects testing growth.  In the current chart, you see the slight tick up in hospitalization and death rates in recent weeks.   But in terms of deaths, what it really reflects is two death dumps by the state in the last two weeks.  Most of those deaths were actually in earlier weeks; you will recall my saying that 15 deaths have been added in April and 17 in May.  The next iteration I do of this chart, I am going to create a version that uses the CDC data, which is week of actual death.  That will show a change in the current week graph, instead of the uptick, you will see a flattening.  I wish I had hospital data for actual day’s census as well, but with Minnesota, you have to take what you can get.  Thanks again to Lisa Jansa and one of my daughters for helping with this.

WeekReport Date (Week Ending)DeathsHospitalizations (10 days earlier)Cases (14 days earlier)Hospitalization Rate (Cumulative)Death Rate (Cumulative)Hospitalization Rate (Current)Death Rate (Current)
13-Apr22253038.3%7.3%8.3%7.30%
210-Apr5711264017.5%8.9%25.8%10.4%
317-Apr111242111921.6%9.9%27.1%11.3%
424-Apr221405173323.4%12.8%26.5%17.9%
51-May371629267823.5%13.9%23.7%15.9%
68-May533912481718.9%11.1%13.2%7.6%
715-May6821350878015.4%7.8%11.1%3.8%
822-May84117991310513.7%6.4%10.4%3.7%
929-May99522211742912.7%5.7%9.8%3.6%
105-Jun114727092245112.1%5.1%9.7%3.0%
1112-Jun127231342613612.0%4.9%11.5%3.4%
1219-Jun135934412886011.9%4.7%11.3%3.2%
1326-Jun141136583116811.7%4.5%9.4%2.3%
143-Jul146638603347011.5%4.4%8.8%2.4%
1510-Jul149540543650311.1%4.1%6.4%1.0%
1617-Jul153342523985410.7%3.8%5.9%1.1%
1724-Jul156644524399110.1%3.6%4.8%0.8%
1831-Jul16004723484699.7%3.3%6.1%0.8%
197-Aug16405028530189.5%3.1%6.7%0.9%
2014-Aug16935346575949.3%2.9%6.9%1.2%
2121-Aug17535661619689.1%2.8%7.2%1.4%

Join the discussion 3 Comments

  • James Alt says:

    I wish you knew someone who could do this for North Carolina. Our idiot governor is almost as bad as yours, although as Southerners, we tend to know our governor is not that bright and ignore a lot of his stupid edicts. He has been sued by numerous news outlets to release state data, but refuses to do so. He also filters out who can ask him questions. Thanks for all the info.

  • DuluthGuy says:

    Barring the Republicans taking the state house and President Trump winning in a landslide in November, I don’t see Walz giving up these powers. Now we can’t have our kids in school because schools need the space for “daycare”. Well if the kids were all in school, they wouldn’t need daycare!

  • Ruth-Ann says:

    I’m guessing that the data for Kentucky would be similar – and yet we have a governor who is scared of his shadow; that we have to “be safe Kentucky”; it’s beyond lunacy!

Leave a comment