Login Register

Coronavirus Thread

History, science(!), computers, sports, movies, careers, art, music...
Forum rules
Disallowed: religion, race, politics, war and disrespect toward others.
Allowed: history, science(!), computers, sports, movies, careers, art, music, relationships and the ten million other topics in our lives.
Post Reply
User avatar
volvolugnut
Posts: 6235
Joined: 19 January 2014
Year and Model: 2001 V70
Location: Oklahoma USA
Has thanked: 928 times
Been thanked: 1002 times

Re: Coronavirus Thread

Post by volvolugnut »

volvolugnut wrote: 27 Sep 2022, 13:49
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 Sept 27, 2022. 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 7 day average (the worst containment) are: West Virginia (0.181) with 599,436 cases, South Dakota (0.181) with 260,639 cases, Wyoming (0.160) with 176,256 cases, North Dakota (0.144) with 268,307 cases, and US Virgin Islands (0.096) with 23,148 cases. West Virginia has been in the top 5 states for 295 of the last 386 days. South Dakota has been in the top 5 states for 28 of the last 28 days. Wyoming has been in the top 5 states for 83 of the last 91 days. North Dakota has been in the top 5 states for 17 of the last 33 days. US Virgin Islands has been in the top 5 states for 81 of the last 97 days.

Several states have stopped posting new case and new death numbers. I will back calculate where possible.

A column on the right shows the previous day growth rate divided by the 7 day moving average. Red highlight states were over 2.0 yesterday. Yellow highlight states were over 1.5 yesterday. This is an early warning of higher growth rate in states. Many of these states did not report the last several days making this measure more variable for those states.

My calculated growth rate for USA is 0.0102 for yesterday, up from previous day of 0.00752. This is not population or case number weighted. Yesterday, 32 states did not report new cases. It appears some states, particularly Wyoming, are deleting active cases from the count much earlier that others. These differences in the states reporting, makes the growth rate comparisons misleading.

Daily active case counts have been falling the last several weeks. There have been 148 of last 239 days with decreasing active case numbers.

There have now been 97 million total cases of Covid-19 in the US. This is 29% of the total US population. Reinfections and under reporting will distort the total number of cases.

With new home tests widely available, new case counts are likely under counting the true number of active cases.


[/quote]
volvolugnut
Attachments
State Growth 092722 A.png
State Growth 092722 A.png (129.81 KiB) Viewed 379 times
State Growth 092722 B.png
State Growth 092722 B.png (117.9 KiB) Viewed 379 times
The Fleet:
Volvo: 2001 V70 T5, 1986 244DL, 1983 245DL, 1975 245DL, 1959 PV544, multiple Volvo parts cars.
Mercedes: 2001 E320, 1973 280, 1974 280C, 1989 300E, 1988 300TE, 1979 300TD, parts cars.
2009 Smart Passion
Ford: 1977 F350, 1964 F150 (2), 1938 Tudor Sedan
Farmall tractors: 1956 400 Diesel, 1946 A
And others.

User avatar
volvolugnut
Posts: 6235
Joined: 19 January 2014
Year and Model: 2001 V70
Location: Oklahoma USA
Has thanked: 928 times
Been thanked: 1002 times

Post by volvolugnut »

volvolugnut wrote: 28 Sep 2022, 06:38
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 Sept 28, 2022. 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 7 day average (the worst containment) are: West Virginia (0.173) with 599,770 cases, South Dakota (0.147) with 261,371 cases, North Dakota (0.144) with 268,307 cases, Wyoming (0.132) with 176,728 cases, and Minnesota (0.097) with 1,663,922 cases. West Virginia has been in the top 5 states for 296 of the last 387 days. South Dakota has been in the top 5 states for 29 of the last 29 days. North Dakota has been in the top 5 states for 18 of the last 34 days. Wyoming has been in the top 5 states for 84 of the last 92 days.

Several states have stopped posting new case and new death numbers. I will back calculate where possible.

A column on the right shows the previous day growth rate divided by the 7 day moving average. Red highlight states were over 2.0 yesterday. Yellow highlight states were over 1.5 yesterday. This is an early warning of higher growth rate in states. Many of these states did not report the last several days making this measure more variable for those states.

My calculated growth rate for USA is 0.0180 for yesterday, up from previous day of 0.0102. This is not population or case number weighted. Yesterday, 14 states did not report new cases. It appears some states, particularly Wyoming, are deleting active cases from the count much earlier that others. These differences in the states reporting, makes the growth rate comparisons misleading.

Daily active case counts have been falling the last several weeks. There have been 149 of last 240 days with decreasing active case numbers.

There have now been 98 million total cases of Covid-19 in the US. This is 29% of the total US population. Reinfections and under reporting will distort the total number of cases.

With new home tests widely available, new case counts are likely under counting the true number of active cases.


[/quote]
volvolugnut
Attachments
State Growth 092822 A.png
State Growth 092822 A.png (136.07 KiB) Viewed 370 times
State Growth 092822 B.png
State Growth 092822 B.png (121.91 KiB) Viewed 370 times
The Fleet:
Volvo: 2001 V70 T5, 1986 244DL, 1983 245DL, 1975 245DL, 1959 PV544, multiple Volvo parts cars.
Mercedes: 2001 E320, 1973 280, 1974 280C, 1989 300E, 1988 300TE, 1979 300TD, parts cars.
2009 Smart Passion
Ford: 1977 F350, 1964 F150 (2), 1938 Tudor Sedan
Farmall tractors: 1956 400 Diesel, 1946 A
And others.

User avatar
volvolugnut
Posts: 6235
Joined: 19 January 2014
Year and Model: 2001 V70
Location: Oklahoma USA
Has thanked: 928 times
Been thanked: 1002 times

Post by volvolugnut »

volvolugnut wrote: 29 Sep 2022, 18:06
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 Sept 29, 2022. 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 7 day average (the worst containment) are: West Virginia (0.171) with 600,173 cases, South Dakota (0.147) with 261,371 cases, North Dakota (0.144) with 268,307 cases, Wyoming (0.132) with 176,728 cases, and US Virgin Islands (0.088) with 23,162 cases. West Virginia has been in the top 5 states for 297 of the last 388 days. South Dakota has been in the top 5 states for 30 of the last 30 days. North Dakota has been in the top 5 states for 19 of the last 35 days. Wyoming has been in the top 5 states for 85 of the last 93 days. US Virgin Islands has been in the top 5 states for 82 of the last 99 days.

Several states have stopped posting new case and new death numbers. I will back calculate where possible.

A column on the right shows the previous day growth rate divided by the 7 day moving average. Red highlight states were over 2.0 yesterday. Yellow highlight states were over 1.5 yesterday. This is an early warning of higher growth rate in states. Many of these states did not report the last several days making this measure more variable for those states.

My calculated growth rate for USA is 0.0148 for yesterday, down from previous day of 0.0180. This is not population or case number weighted. Yesterday, 28 states did not report new cases. It appears some states, particularly Wyoming, are deleting active cases from the count much earlier that others. These differences in the states reporting, makes the growth rate comparisons misleading.

Daily active case counts have been falling the last several weeks. There have been 150 of last 241 days with decreasing active case numbers.

There have now been 98 million total cases of Covid-19 in the US. This is 29% of the total US population. Reinfections and under reporting will distort the total number of cases.

With new home tests widely available, new case counts are likely under counting the true number of active cases.


[/quote]
volvolugnut
Attachments
State Growth 092922 A.png
State Growth 092922 A.png (130.36 KiB) Viewed 357 times
State Growth 092922 B.png
State Growth 092922 B.png (121.22 KiB) Viewed 357 times
The Fleet:
Volvo: 2001 V70 T5, 1986 244DL, 1983 245DL, 1975 245DL, 1959 PV544, multiple Volvo parts cars.
Mercedes: 2001 E320, 1973 280, 1974 280C, 1989 300E, 1988 300TE, 1979 300TD, parts cars.
2009 Smart Passion
Ford: 1977 F350, 1964 F150 (2), 1938 Tudor Sedan
Farmall tractors: 1956 400 Diesel, 1946 A
And others.

User avatar
volvolugnut
Posts: 6235
Joined: 19 January 2014
Year and Model: 2001 V70
Location: Oklahoma USA
Has thanked: 928 times
Been thanked: 1002 times

Post by volvolugnut »

volvolugnut wrote: 30 Sep 2022, 17:42
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 Sept 30, 2022. 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 7 day average (the worst containment) are: West Virginia (0.166) with 600,558 cases, South Dakota (0.147) with 261,371 cases, North Dakota (0.144) with 268,307 cases, Wyoming (0.132) with 176,728 cases, and Montana (0.111) with 310,731 cases. West Virginia has been in the top 5 states for 298 of the last 389 days. South Dakota has been in the top 5 states for 31 of the last 31 days. North Dakota has been in the top 5 states for 20 of the last 36 days. Wyoming has been in the top 5 states for 86 of the last 94 days. Montana has been in the top 5 states for 187 of the last 284 days.

Several states have stopped posting new case and new death numbers. I will back calculate where possible.

A column on the right shows the previous day growth rate divided by the 7 day moving average. Red highlight states were over 2.0 yesterday. Yellow highlight states were over 1.5 yesterday. This is an early warning of higher growth rate in states. Many of these states did not report the last several days making this measure more variable for those states.

My calculated growth rate for USA is 0.0136 for yesterday, down from previous day of 0.0148. This is not population or case number weighted. Yesterday, 28 states did not report new cases. It appears some states, particularly Wyoming, are deleting active cases from the count much earlier that others. These differences in the states reporting, makes the growth rate comparisons misleading.

Daily active case counts have been falling the last several weeks. There have been 150 of last 242 days with decreasing active case numbers.

There have now been 98 million total cases of Covid-19 in the US. This is 29% of the total US population. Reinfections and under reporting will distort the total number of cases.

With new home tests widely available, new case counts are likely under counting the true number of active cases.


[/quote]
volvolugnut
Attachments
State Growth 093022 A.png
State Growth 093022 A.png (130.79 KiB) Viewed 346 times
State Growth 093022 B.png
State Growth 093022 B.png (121.77 KiB) Viewed 346 times
The Fleet:
Volvo: 2001 V70 T5, 1986 244DL, 1983 245DL, 1975 245DL, 1959 PV544, multiple Volvo parts cars.
Mercedes: 2001 E320, 1973 280, 1974 280C, 1989 300E, 1988 300TE, 1979 300TD, parts cars.
2009 Smart Passion
Ford: 1977 F350, 1964 F150 (2), 1938 Tudor Sedan
Farmall tractors: 1956 400 Diesel, 1946 A
And others.

User avatar
volvolugnut
Posts: 6235
Joined: 19 January 2014
Year and Model: 2001 V70
Location: Oklahoma USA
Has thanked: 928 times
Been thanked: 1002 times

Post by volvolugnut »

volvolugnut wrote: 01 Oct 2022, 12:11
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 October 1, 2022. 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 7 day average (the worst containment) are: West Virginia (0.166) with 600,558 cases, South Dakota (0.147) with 261,371 cases, North Dakota (0.140) with 269,306 cases, Wyoming (0.132) with 176,728 cases, and Montana (0.111) with 310,731 cases. West Virginia has been in the top 5 states for 299 of the last 390 days. South Dakota has been in the top 5 states for 32 of the last 32 days. North Dakota has been in the top 5 states for 21 of the last 37 days. Wyoming has been in the top 5 states for 87 of the last 95 days. Montana has been in the top 5 states for 188 of the last 285 days.

Several states have stopped posting new case and new death numbers. I will back calculate where possible.

A column on the right shows the previous day growth rate divided by the 7 day moving average. Red highlight states were over 2.0 yesterday. Yellow highlight states were over 1.5 yesterday. This is an early warning of higher growth rate in states. Many of these states did not report the last several days making this measure more variable for those states.

My calculated growth rate for USA is 0.00772 for yesterday, down from previous day of 0.0136. This is not population or case number weighted. Yesterday, 45 states did not report new cases. It appears some states, particularly Wyoming, are deleting active cases from the count much earlier that others. These differences in the states reporting, makes the growth rate comparisons misleading.

Daily active case counts have been falling the last several weeks. There have been 151 of last 243 days with decreasing active case numbers.

There have now been 98 million total cases of Covid-19 in the US. This is 29% of the total US population. Reinfections and under reporting will distort the total number of cases.

With new home tests widely available, new case counts are likely under counting the true number of active cases.


[/quote]
volvolugnut
Attachments
State Growth 100122 A.png
State Growth 100122 A.png (133.81 KiB) Viewed 337 times
State Growth 100122 B.png
State Growth 100122 B.png (115.85 KiB) Viewed 337 times
The Fleet:
Volvo: 2001 V70 T5, 1986 244DL, 1983 245DL, 1975 245DL, 1959 PV544, multiple Volvo parts cars.
Mercedes: 2001 E320, 1973 280, 1974 280C, 1989 300E, 1988 300TE, 1979 300TD, parts cars.
2009 Smart Passion
Ford: 1977 F350, 1964 F150 (2), 1938 Tudor Sedan
Farmall tractors: 1956 400 Diesel, 1946 A
And others.

User avatar
volvolugnut
Posts: 6235
Joined: 19 January 2014
Year and Model: 2001 V70
Location: Oklahoma USA
Has thanked: 928 times
Been thanked: 1002 times

Post by volvolugnut »

volvolugnut wrote: 02 Oct 2022, 14:01
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 October 2, 2022. 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 7 day average (the worst containment) are: West Virginia (0.166) with 600,558 cases, South Dakota (0.147) with 261,371 cases, North Dakota (0.140) with 269,306 cases, Wyoming (0.132) with 176,728 cases, and Montana (0.111) with 310,731 cases. West Virginia has been in the top 5 states for 300 of the last 391 days. South Dakota has been in the top 5 states for 33 of the last 33 days. North Dakota has been in the top 5 states for 22 of the last 38 days. Wyoming has been in the top 5 states for 88 of the last 96 days. Montana has been in the top 5 states for 189 of the last 286 days.

Several states have stopped posting new case and new death numbers. I will back calculate where possible.

A column on the right shows the previous day growth rate divided by the 7 day moving average. Red highlight states were over 2.0 yesterday. Yellow highlight states were over 1.5 yesterday. This is an early warning of higher growth rate in states. Many of these states did not report the last several days making this measure more variable for those states.

My calculated growth rate for USA is 0.00294 for yesterday, down from previous day of 0.00772. This is not population or case number weighted. Yesterday, 53 states did not report new cases. It appears some states, particularly Wyoming, are deleting active cases from the count much earlier that others. These differences in the states reporting, makes the growth rate comparisons misleading.

Daily active case counts have been falling the last several weeks. There have been 152 of last 244 days with decreasing active case numbers.

There have now been 98 million total cases of Covid-19 in the US. This is 29% of the total US population. Reinfections and under reporting will distort the total number of cases.

With new home tests widely available, new case counts are likely under counting the true number of active cases.


[/quote]
volvolugnut
Attachments
State Growth 100222 A.png
State Growth 100222 A.png (132.75 KiB) Viewed 327 times
State Growth 100222 B.png
State Growth 100222 B.png (117.59 KiB) Viewed 327 times
The Fleet:
Volvo: 2001 V70 T5, 1986 244DL, 1983 245DL, 1975 245DL, 1959 PV544, multiple Volvo parts cars.
Mercedes: 2001 E320, 1973 280, 1974 280C, 1989 300E, 1988 300TE, 1979 300TD, parts cars.
2009 Smart Passion
Ford: 1977 F350, 1964 F150 (2), 1938 Tudor Sedan
Farmall tractors: 1956 400 Diesel, 1946 A
And others.

User avatar
volvolugnut
Posts: 6235
Joined: 19 January 2014
Year and Model: 2001 V70
Location: Oklahoma USA
Has thanked: 928 times
Been thanked: 1002 times

Post by volvolugnut »

volvolugnut wrote: 03 Oct 2022, 17:08
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 October 3, 2022. 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 7 day average (the worst containment) are: West Virginia (0.167) with 601,234 cases, South Dakota (0.147) with 261,371 cases, North Dakota (0.140) with 269,306 cases, Wyoming (0.132) with 176,728 cases, and Montana (0.111) with 310,731 cases. West Virginia has been in the top 5 states for 301 of the last 392 days. South Dakota has been in the top 5 states for 34 of the last 34 days. North Dakota has been in the top 5 states for 23 of the last 39 days. Wyoming has been in the top 5 states for 89 of the last 97 days. Montana has been in the top 5 states for 190 of the last 287 days.

Several states have stopped posting new case and new death numbers. I will back calculate where possible.

A column on the right shows the previous day growth rate divided by the 7 day moving average. Red highlight states were over 2.0 yesterday. Yellow highlight states were over 1.5 yesterday. This is an early warning of higher growth rate in states. Many of these states did not report the last several days making this measure more variable for those states.

My calculated growth rate for USA is 0.00847 for yesterday, up from previous day of 0.00294. This is not population or case number weighted. Yesterday, 36 states did not report new cases. It appears some states, particularly Wyoming, are deleting active cases from the count much earlier that others. These differences in the states reporting, makes the growth rate comparisons misleading.

Daily active case counts have been falling the last several weeks. There have been 153 of last 245 days with decreasing active case numbers.

There have now been 98 million total cases of Covid-19 in the US. This is 29% of the total US population. Reinfections and under reporting will distort the total number of cases.

With new home tests widely available, new case counts are likely under counting the true number of active cases.


[/quote]
volvolugnut
Attachments
State Growth 100322 A.png
State Growth 100322 A.png (128.57 KiB) Viewed 317 times
State Growth 100322 B.png
State Growth 100322 B.png (116.62 KiB) Viewed 317 times
The Fleet:
Volvo: 2001 V70 T5, 1986 244DL, 1983 245DL, 1975 245DL, 1959 PV544, multiple Volvo parts cars.
Mercedes: 2001 E320, 1973 280, 1974 280C, 1989 300E, 1988 300TE, 1979 300TD, parts cars.
2009 Smart Passion
Ford: 1977 F350, 1964 F150 (2), 1938 Tudor Sedan
Farmall tractors: 1956 400 Diesel, 1946 A
And others.

User avatar
volvolugnut
Posts: 6235
Joined: 19 January 2014
Year and Model: 2001 V70
Location: Oklahoma USA
Has thanked: 928 times
Been thanked: 1002 times

Post by volvolugnut »

volvolugnut wrote: 04 Oct 2022, 11:46
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 October 4, 2022. 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 7 day average (the worst containment) are: West Virginia (0.172) with 601,520 cases, South Dakota (0.147) with 261,371 cases, North Dakota (0.140) with 269,306 cases, Wyoming (0.132) with 176,728 cases, and Montana (0.111) with 310,731 cases. West Virginia has been in the top 5 states for 302 of the last 393 days. South Dakota has been in the top 5 states for 35 of the last 35 days. North Dakota has been in the top 5 states for 24 of the last 40 days. Wyoming has been in the top 5 states for 90 of the last 98 days. Montana has been in the top 5 states for 191 of the last 288 days.

Several states have stopped posting new case and new death numbers. I will back calculate where possible.

A column on the right shows the previous day growth rate divided by the 7 day moving average. Red highlight states were over 2.0 yesterday. Yellow highlight states were over 1.5 yesterday. This is an early warning of higher growth rate in states. Many of these states did not report the last several days making this measure more variable for those states.

My calculated growth rate for USA is 0.0108 for yesterday, up from previous day of 0.00847. This is not population or case number weighted. Yesterday, 31 states did not report new cases. It appears some states, particularly Wyoming, are deleting active cases from the count much earlier that others. These differences in the states reporting, makes the growth rate comparisons misleading.

Daily active case counts have been falling the last several weeks. There have been 154 of last 246 days with decreasing active case numbers.

There have now been 98 million total cases of Covid-19 in the US. This is 29% of the total US population. Reinfections and under reporting will distort the total number of cases.

With new home tests widely available, new case counts are likely under counting the true number of active cases.


[/quote]
volvolugnut
Attachments
State Growth 100522 A.png
State Growth 100522 A.png (135.72 KiB) Viewed 302 times
State Growth 100522 B.png
State Growth 100522 B.png (119.06 KiB) Viewed 302 times
The Fleet:
Volvo: 2001 V70 T5, 1986 244DL, 1983 245DL, 1975 245DL, 1959 PV544, multiple Volvo parts cars.
Mercedes: 2001 E320, 1973 280, 1974 280C, 1989 300E, 1988 300TE, 1979 300TD, parts cars.
2009 Smart Passion
Ford: 1977 F350, 1964 F150 (2), 1938 Tudor Sedan
Farmall tractors: 1956 400 Diesel, 1946 A
And others.

User avatar
volvolugnut
Posts: 6235
Joined: 19 January 2014
Year and Model: 2001 V70
Location: Oklahoma USA
Has thanked: 928 times
Been thanked: 1002 times

Post by volvolugnut »

volvolugnut wrote: 05 Oct 2022, 14:50
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 October 5, 2022. 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 7 day average (the worst containment) are: South Dakota (0.223) with 262,213 cases, West Virginia (0.184) with 601,887 cases, North Dakota (0.140) with 269,306 cases, US Virgin Islands (0.116) with 23,198 cases, and Montana (0.111) with 310,731 cases. South Dakota has been in the top 5 states for 36 of the last 36 days. West Virginia has been in the top 5 states for 303 of the last 394 days. North Dakota has been in the top 5 states for 25 of the last 41 days. US Virgin Islands has been in the top 5 states for 83 of the last 105 days. Montana has been in the top 5 states for 192 of the last 289 days.

Several states have stopped posting new case and new death numbers. I will back calculate where possible.

A column on the right shows the previous day growth rate divided by the 7 day moving average. Red highlight states were over 2.0 yesterday. Yellow highlight states were over 1.5 yesterday. This is an early warning of higher growth rate in states. Many of these states did not report the last several days making this measure more variable for those states.

My calculated growth rate for USA is 0.0195 for yesterday, up from previous day of 0.0108. This is not population or case number weighted. Yesterday, 17 states did not report new cases. It appears some states, particularly Wyoming, are deleting active cases from the count much earlier that others. These differences in the states reporting, makes the growth rate comparisons misleading.

Daily active case counts have been falling the last several weeks. There have been 154 of last 247 days with decreasing active case numbers.

There have now been 98 million total cases of Covid-19 in the US. This is 29% of the total US population. Reinfections and under reporting will distort the total number of cases.

With new home tests widely available, new case counts are likely under counting the true number of active cases.


[/quote]
volvolugnut
Attachments
State Growth 100522 A.png
State Growth 100522 A.png (137.52 KiB) Viewed 291 times
State Growth 100522 B.png
State Growth 100522 B.png (121.24 KiB) Viewed 291 times
The Fleet:
Volvo: 2001 V70 T5, 1986 244DL, 1983 245DL, 1975 245DL, 1959 PV544, multiple Volvo parts cars.
Mercedes: 2001 E320, 1973 280, 1974 280C, 1989 300E, 1988 300TE, 1979 300TD, parts cars.
2009 Smart Passion
Ford: 1977 F350, 1964 F150 (2), 1938 Tudor Sedan
Farmall tractors: 1956 400 Diesel, 1946 A
And others.

User avatar
volvolugnut
Posts: 6235
Joined: 19 January 2014
Year and Model: 2001 V70
Location: Oklahoma USA
Has thanked: 928 times
Been thanked: 1002 times

Post by volvolugnut »

volvolugnut wrote: 06 Oct 2022, 17:26
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 October 6, 2022. 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 7 day average (the worst containment) are: West Virginia (0.188) with 602,173 cases, North Dakota (0.140) with 269,306 cases, US Virgin Islands (0.113) with 23,202 cases, Montana (0.111) with 310,731 cases, and New York (0.096) with 6,317,900 cases. West Virginia has been in the top 5 states for 304 of the last 395 days. North Dakota has been in the top 5 states for 26 of the last 42 days. US Virgin Islands has been in the top 5 states for 84 of the last 106 days. Montana has been in the top 5 states for 193 of the last 290 days.

Several states have stopped posting new case and new death numbers. I will back calculate where possible.

A column on the right shows the previous day growth rate divided by the 7 day moving average. Red highlight states were over 2.0 yesterday. Yellow highlight states were over 1.5 yesterday. This is an early warning of higher growth rate in states. Many of these states did not report the last several days making this measure more variable for those states.

My calculated growth rate for USA is 0.0163 for yesterday, down from previous day of 0.0195. This is not population or case number weighted. Yesterday, 26 states did not report new cases. It appears some states, particularly Wyoming, are deleting active cases from the count much earlier that others. These differences in the states reporting, makes the growth rate comparisons misleading.

Daily active case counts have been falling the last several weeks. There have been 155 of last 248 days with decreasing active case numbers.

There have now been 98 million total cases of Covid-19 in the US. This is 29% of the total US population. Reinfections and under reporting will distort the total number of cases.

With new home tests widely available, new case counts are likely under counting the true number of active cases.


[/quote]
volvolugnut
Attachments
State Growth 100622 A.png
State Growth 100622 A.png (132.71 KiB) Viewed 283 times
State Growth 100622 B.png
State Growth 100622 B.png (119.99 KiB) Viewed 283 times
The Fleet:
Volvo: 2001 V70 T5, 1986 244DL, 1983 245DL, 1975 245DL, 1959 PV544, multiple Volvo parts cars.
Mercedes: 2001 E320, 1973 280, 1974 280C, 1989 300E, 1988 300TE, 1979 300TD, parts cars.
2009 Smart Passion
Ford: 1977 F350, 1964 F150 (2), 1938 Tudor Sedan
Farmall tractors: 1956 400 Diesel, 1946 A
And others.

Post Reply