Updated Minnesota Trends

You may recall a couple of weeks ago I did a post with a table and I think a chart on trends in hospitalization and death rates as a function of cases.  I have updated and enhanced those below.  One think I learned is that case numbers can be retroactively adjusted as long ago as a couple of months but it seems to be single digit changes, so doesn’t really affect the calculations.  You will note that in addition to the cumulative rates, I have separated out the most recent week, to give sort of a current picture.  Remember this works back from deaths, for deaths reported in a certain week, hospitalizations are taken from ten days earlier and cases from 14 days earlier, based on the median lags reported by the CDC.  So for cumulative deaths in the week ending July 31, for example, cumulative hospitalizations were taken from July 21, and cumulative cases from the July 17.  The current rates reflect those number changes in a specific week.  This is my attempt to create a cohort view.  That is frustrated by the state’s refusal to give us deaths on the date they occurred and I recently learned that hospitalizations are also by day of report, and I have no idea what the lag is.  I have been working on a deaths by date occurred chart, which I posted on, and in the next iteration of this chart, I am going to incorporate that work.

You can see the continuing decline in rates, although the recent week current hospitalization rate showed a slight uptick.  I think this helps us all get some sense of real trends.  And again, if the state and CDC are correct that actual cases are ten times reported ones, then divide all these ratios by ten.  Thanks to Lisa Jansa for helping with the charts and table.