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: ↑Tue Jul 07, 2020 7:08 amMore 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 July 7, 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: West Virginia (0.649) with 3505 cases, Oklahoma (0.243) with 17,220 cases, Minnesota (0.179) with 39,133 cases, Hawaii (.178) with 1071 cases, and US Virgin Islands (0.148) with 116 cases. All states have reopened to various levels. US Virgin Islands has few cases. Minnesota had a negative new case number two days ago and the growth rate calculation failed.
A column on the right shows the current growth rate divided by the 5 day moving average. Missouri, Rhode Island, and West Virginia were over 2.0 yesterday (red highlight). Colorado, District of Columbia, Mississippi, Veterans Affairs, and Federal Prisons 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.0350 for yesterday, up sharply from previous day of 0.0324. This is not population or case number weighted.