I am posting this information in the afternoon now (mostly). I try to do outdoor work in the cooler morning and indoor work in the afternoon.volvolugnut wrote: ↑22 Aug 2020, 11:57 More statistics on US states and COVID-19 growth rates. My raw information is from Worldometer. Any errors or misrepresentations are my own.
These tables show all available US states and territories and the COVID-19 data for the last 5 days. I have sorted the states alphabetically and added growth rates for last several days for all states with ranking of each day. Of course, this information changes daily. I have presented the table in two parts because of the screen shot, but it is actually one table in Excel.
Again, results change daily.
State growth rates for August 22, 2020. All information is based on reported information and actual results may be different.
For your information, the top 5 states or territories yesterday in growth rate (the worst containment) are: South Dakota (0.182) with 11,135 cases, North Dakota (0.175) with 9736 cases, Minnesota (0.136) with 68,867 cases, Montana (0.120) with 6376 cases, and Wisconsin (0.120) with 70,009 cases. All states have reopened to various levels. Many states have now paused or reversed opening actions. US North Dakota has been in top 5 list for 36 of last 52 days. Minnesota has been in top 5 list for 13 of last 17 days. Is it only a coincidence that all of these states are near Sturgis, South Dakota, where over 400,000 people gathered a week ago for a motorcycle event?
A column on the right shows the current growth rate divided by the 5 day moving average. Michigan and Vermont were over 2.0 yesterday (red highlight). Alabama, and Montana were over 1.5 yesterday (yellow highlight). This column is an early warning of increasing cases beyond day to day noise.
My calculated growth rate for USA is 0.0176 for yesterday, up sharply from previous day of 0.0204. This is not population or case number weighted.
In the last few days, a new column has been added to the table - Total Recovered.
volvolugnut






