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.
|Week||Report Date (Week Ending)||Deaths||Hospitalizations (10 days earlier)||Cases (14 days earlier)||Hospitalization Rate (Cumulative)||Death Rate (Cumulative)||Hospitalization Rate (Current)||Death Rate (Current)|