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: 10 Jul 2022, 12: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 July 10, 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.174) with 537,443 cases, Wyoming (0.149) with 165,619 cases, Guam (0.140) with 52,823 cases, Montana (0.128) with 289,345 cases, and US Virgin Islands (0.116) with 21,103 cases. West Virginia has been in the top 5 states for 216 of the last 307 days. Wyoming has been in the top 5 states for 12 of the last 12 days. Guam has been in the top 5 states for 114 of the last 186 days. Montana has been in the top 5 states for 123 of the last 202 days. US Virgin Islands has been in the top 5 states for 13 of the last 18 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.00684 for yesterday, down from previous day of 0.00886. This is not population or case number weighted. Yesterday, 52 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 started to rise in the last couple weeks. There have been 95 of last 160 days with decreasing active case numbers.

There have now been 90 million total cases of Covid-19 in the US. This is 27% 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.

As the table has expanded, it has become harder to read. You may want to copy the image, paste to another screen. like Word, and increase the size.

volvolugnut
Attachments
State Growth 071022 A.png
State Growth 071022 A.png (148.87 KiB) Viewed 313 times
State Growth 071022 B.png
State Growth 071022 B.png (130.31 KiB) Viewed 313 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: 11 Jul 2022, 13:30
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 July 11, 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.213) with 539,431 cases, Guam (0.182) with 53,066 cases, US Virgin Islands (0.169) with 21,175 cases, Wyoming (0.149) with 165,619 cases, and Montana (0.128) with 289,345 cases. West Virginia has been in the top 5 states for 217 of the last 308 days. Guam has been in the top 5 states for 115 of the last 187 days. US Virgin Islands has been in the top 5 states for 14 of the last 19 days. Wyoming has been in the top 5 states for 13 of the last 13 days. Montana has been in the top 5 states for 124 of the last 203 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.0165 for yesterday, up from previous day of 0.00684. This is not population or case number weighted. Yesterday, 30 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 started to rise in the last couple weeks. There have been 96 of last 161 days with decreasing active case numbers.

There have now been 90 million total cases of Covid-19 in the US. This is 27% 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.

As the table has expanded, it has become harder to read. You may want to copy the image, paste to another screen. like Word, and increase the size.

volvolugnut
Attachments
State Growth 071122 A.png
State Growth 071122 A.png (148.76 KiB) Viewed 302 times
State Growth 071122 B.png
State Growth 071122 B.png (134.86 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: 12 Jul 2022, 11:52
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 July 12, 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.229) with 540,192 cases, US Virgin Islands (0.193) with 21,231 cases, Wyoming (0.149) with 165,619 cases, Guam (0.143) with 53,214 cases, and North Dakota (0.134) with 252,296 cases. West Virginia has been in the top 5 states for 218 of the last 309 days. US Virgin Islands has been in the top 5 states for 15 of the last 20 days. Wyoming has been in the top 5 states for 14 of the last 14 days. Guam has been in the top 5 states for 116 of the last 188 days. North Dakota has been in the top 5 states for 29 of the last 70 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.0279 for yesterday, up from previous day of 0.0165. 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 started to rise in the last couple weeks. There have been 96 of last 162 days with decreasing active case numbers.

There have now been 90 million total cases of Covid-19 in the US. This is 27% 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.

As the table has expanded, it has become harder to read. You may want to copy the image, paste to another screen. like Word, and increase the size.

volvolugnut
Attachments
State Growth 071222 A.png
State Growth 071222 A.png (158.03 KiB) Viewed 289 times
State Growth 071222 B.png
State Growth 071222 B.png (135.86 KiB) Viewed 289 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: 13 Jul 2022, 12: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 July 13, 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.235) with 541,062 cases, US Virgin Islands (0.179) with 21,246 cases, Guam (0.134) with 53,363 cases, Montana (0.128) with 289,345 cases, and North Dakota (0.115) with 252,654 cases. West Virginia has been in the top 5 states for 219 of the last 310 days. US Virgin Islands has been in the top 5 states for 16 of the last 21 days. Guam has been in the top 5 states for 117 of the last 189 days. Montana has been in the top 5 states for 125 of the last 205 days. North Dakota has been in the top 5 states for 30 of the last 71 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.0309 for yesterday, up from previous day of 0.0279. This is not population or case number weighted. Yesterday, 10 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 started to rise in the last couple weeks. There have been 96 of last 163 days with decreasing active case numbers.

There have now been 90 million total cases of Covid-19 in the US. This is 27% 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.

As the table has expanded, it has become harder to read. You may want to copy the image, paste to another screen. like Word, and increase the size.

volvolugnut
Attachments
State Growth 071322 A.png
State Growth 071322 A.png (159.32 KiB) Viewed 280 times
State Growth 071322 B.png
State Growth 071322 B.png (140.38 KiB) Viewed 280 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: 14 Jul 2022, 12:16
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 July 14, 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.232) with 542,092 cases, US Virgin Islands (0.185) with 21,287 cases, Montana (0.128) with 289,345 cases, Guam (0.125) with 53,459 cases, and Wyoming (0.111) with 167,386 cases. West Virginia has been in the top 5 states for 220 of the last 311 days. US Virgin Islands has been in the top 5 states for 17 of the last 22 days. Montana has been in the top 5 states for 126 of the last 206 days. Guam has been in the top 5 states for 118 of the last 190 days. Wyoming has been in the top 5 states for 15 of the last 16 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.0264 for yesterday, down from previous day of 0.0309. This is not population or case number weighted. Yesterday, 24 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 started to rise in the last couple weeks. There have been 96 of last 164 days with decreasing active case numbers.

There have now been 91 million total cases of Covid-19 in the US. This is 27% 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.

As the table has expanded, it has become harder to read. You may want to copy the image, paste to another screen. like Word, and increase the size.

volvolugnut
Attachments
State Growth 071422 A.png
State Growth 071422 A.png (155.42 KiB) Viewed 271 times
State Growth 071422 B.png
State Growth 071422 B.png (136.61 KiB) Viewed 271 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: 15 Jul 2022, 13: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 July 15, 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.213) with 542,887 cases, US Virgin Islands (0.154) with 21,326 cases, Montana (0.142) with 292,026 cases, Guam (0.116) with 53,601 cases, and Wyoming (0.111) with 167,386 cases. West Virginia has been in the top 5 states for 221 of the last 312 days. US Virgin Islands has been in the top 5 states for 18 of the last 23 days. Montana has been in the top 5 states for 127 of the last 207 days. Guam has been in the top 5 states for 119 of the last 191 days. Wyoming has been in the top 5 states for 16 of the last 17 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.0258 for yesterday, down from previous day of 0.0264. This is not population or case number weighted. Yesterday, 22 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 started to rise in the last couple weeks. There have been 96 of last 165 days with decreasing active case numbers.

There have now been 91 million total cases of Covid-19 in the US. This is 27% 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.

As the table has expanded, it has become harder to read. You may want to copy the image, paste to another screen. like Word, and increase the size.

volvolugnut
Attachments
State Growth 071522 A.png
State Growth 071522 A.png (150.3 KiB) Viewed 259 times
State Growth 071522 B.png
State Growth 071522 B.png (136.22 KiB) Viewed 259 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: 16 Jul 2022, 12:16

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 July 16, 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.213) with 542,887 cases, US Virgin Islands (0.154) with 21,326 cases, Montana (0.142) with 292,026 cases, Guam (0.116) with 53,601 cases, and Wyoming (0.111) with 167,386 cases. West Virginia has been in the top 5 states for 222 of the last 313 days. US Virgin Islands has been in the top 5 states for 19 of the last 24 days. Montana has been in the top 5 states for 128 of the last 208 days. Guam has been in the top 5 states for 120 of the last 192 days. Wyoming has been in the top 5 states for 17 of the last 18 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.00739 for yesterday, down from previous day of 0.0258. This is not population or case number weighted. Yesterday, 51 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 started to rise in the last couple weeks. There have been 97 of last 166 days with decreasing active case numbers.

There have now been 91 million total cases of Covid-19 in the US. This is 27% 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.

As the table has expanded, it has become harder to read. You may want to copy the image, paste to another screen. like Word, and increase the size.

volvolugnut
Attachments
State Growth 071622 A.png
State Growth 071622 A.png (152.14 KiB) Viewed 250 times
State Growth 071622 B.png
State Growth 071622 B.png (132.33 KiB) Viewed 250 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: 17 Jul 2022, 13:15
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 July 17, 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.213) with 542,887 cases, US Virgin Islands (0.154) with 21,326 cases, Montana (0.142) with 292,026 cases, Guam (0.116) with 53,601 cases, and Wyoming (0.111) with 167,386 cases. West Virginia has been in the top 5 states for 223 of the last 314 days. US Virgin Islands has been in the top 5 states for 20 of the last 25 days. Montana has been in the top 5 states for 129 of the last 209 days. Guam has been in the top 5 states for 121 of the last 193 days. Wyoming has been in the top 5 states for 18 of the last 19 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.00680 for yesterday, down from previous day of 0.00739. This is not population or case number weighted. Yesterday, 52 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 started to rise in the last couple weeks. There have been 98 of last 167 days with decreasing active case numbers.

There have now been 91 million total cases of Covid-19 in the US. This is 27% 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.

As the table has expanded, it has become harder to read. You may want to copy the image, paste to another screen. like Word, and increase the size.

volvolugnut
Attachments
State Growth 071722 A.png
State Growth 071722 A.png (151.4 KiB) Viewed 238 times
State Growth 071722 B.png
State Growth 071722 B.png (131.86 KiB) Viewed 238 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: 18 Jul 2022, 11: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 July 18, 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.196) with 544,911 cases, Montana (0.142) with 292,026 cases, US Virgin Islands (0.120) with 21,361 cases, Wyoming (0.111) with 167,386 cases, and Guam (0.106) with 53,865 cases. West Virginia has been in the top 5 states for 224 of the last 315 days. Montana has been in the top 5 states for 130 of the last 210 days. US Virgin Islands has been in the top 5 states for 21 of the last 26 days. Wyoming has been in the top 5 states for 19 of the last 20 days. Guam has been in the top 5 states for 122 of the last 194 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, up from previous day of 0.00680. This is not population or case number weighted. Yesterday, 29 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 started to rise in the last couple weeks. There have been 98 of last 168 days with decreasing active case numbers.

There have now been 91 million total cases of Covid-19 in the US. This is 27% 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.

As the table has expanded, it has become harder to read. You may want to copy the image, paste to another screen. like Word, and increase the size.

volvolugnut
Attachments
State Growth 071822 A.png
State Growth 071822 A.png (154.96 KiB) Viewed 227 times
State Growth 071822 B.png
State Growth 071822 B.png (134.72 KiB) Viewed 227 times
Last edited by volvolugnut on 20 Jul 2022, 11:39, edited 1 time in total.
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: 19 Jul 2022, 12:17
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 July 19, 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.199) with 545,745 cases, Montana (0.142) with 292,026 cases, Wyoming (0.111) with 167,386 cases, Guam (0.098) with 54,013 cases, and North Dakota (0.097) with 254,079 cases. West Virginia has been in the top 5 states for 225 of the last 316 days. Montana has been in the top 5 states for 131 of the last 211 days. Wyoming has been in the top 5 states for 20 of the last 21 days. Guam has been in the top 5 states for 123 of the last 195 days. North Dakota has been in the top 5 states for 31 of the last 77 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.0208 for yesterday, up from previous day of 0.0163. 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 started to rise in the last couple weeks. There have been 99 of last 169 days with decreasing active case numbers.

There have now been 91 million total cases of Covid-19 in the US. This is 27% 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.

As the table has expanded, it has become harder to read. You may want to copy the image, paste to another screen. like Word, and increase the size.

volvolugnut
Attachments
State Growth 071922 A.png
State Growth 071922 A.png (156.46 KiB) Viewed 219 times
State Growth 071922 B.png
State Growth 071922 B.png (135.81 KiB) Viewed 219 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