One notable feature of the current coronavirus epidemic is a pattern of sharp, but relatively short, waves of cases. The U.S. has previously endured two of these waves. One, in the spring, was centered in the Northern states, particularly the Northeast, and another was centered in the South and Southwest in summer. The current autumn case wave has been particularly intense in the Midwest and Rocky Mountain states.
The attributes of these case waves, here and abroad, have been very sharp case rises, but a relatively short duration measured in weeks, followed by a quick decline in cases, falling off to a long tail.
Policymakers and their advisers might have taken note of this pattern and adjusted decisions accordingly.
The two most critical parameters to monitor for management of any epidemic are the number of active cases and the trend in those active cases. Active cases represent those persons who may be infectious, capable of transmitting the pathogen to others, who might then become infected and infectious. A number of states report this important statistic; Minnesota for unknown reasons does not.
Not only is it not reported, but with the information we are provided it can be difficult to ascertain.
The best way to calculate it with the available data is to take the total PCR-confirmed cases for each day as reported on the table of cases by specimen collection date. Subtract from this the "no longer needing isolation" number, which you must record every day from the situation report, as the state does not make a daily table available. These are persons whose period of infectiousness has passed. Then you further subtract the total number of deaths for the day.
There are a variety of factors which might suggest this method produces an overestimate of actual likely infectious cases, including an inability to adjust the "no longer isolating" number for total cases added from 10 days or more earlier. On the other hand, there also are likely many undetected cases. But adding an estimate of those would not change the direction of the trend analysis.
Using these methods, I have tracked the number of active cases, the daily change in that number, and the percent change since Aug. 1. The last week or so of data is incomplete due to reporting lags.