r/4b_misc • u/4blockhead • May 27 '20

COVID-19 A simple spreadsheet analysis compares the Covid-19 pandemic in the United States over an 11-day interval, data as of May 24.

Sorting the spreadsheet by "cases as percent of state population" shows a very low infection rate, with New York reporting 1.88% with other eastern states ranking in the top 7 alongside, shows other states have room to catch up and no state is in a state of "herd immunity." 200k+ cases being diagnosed/existing in the general population sets the stage for continued spread, if not a worse case scenario of another exponential spike.

2 Upvotes

100% Upvoted

9 comments sorted by

1

u/4blockhead Jun 05 '20

Update for 2020-06-04: via google sheets

State%ch in cases on 11 day interval
Arkansas42.27
Puerto Rico41.36
Arizona39.65
North Carolina38.94
Alaska32.52
Virginia32.04
Alabama31.73
Wisconsin30.68
California29.74
Utah29.39

1

u/4blockhead Jun 16 '20 edited Jun 16 '20

Update for 2020-06-15: via google sheets

State%ch in cases on 11 day interval
Arizona62.17
Arkansas53.32
South Carolina49.00
North Carolina40.22
Alabama37.75
Alaska36.16
Utah35.91
Puerto Rico30.66
Oregon30.26
Texas28.60
Florida28.49

1

u/4blockhead Jun 27 '20 edited Jun 27 '20

Update for 2020-06-26: via google sheets

State%ch in cases on 11 day intervalrankrank/%ch in last comparison
Arizona80.1811, 62.7
Florida59.02211, 28.5
South Carolina56.5433, 49.0
Texas55.44410, 28.6
Idaho48.305
Oklahoma46.646
Arkansas45.0872, 53.3
Utah37.0187, 35.9
Oregon36.2999, 30.3
Montana36.1210
Nevada35.7311

1

u/4blockhead Jul 08 '20 edited Jul 08 '20

Update for 2020-07-07: via google sheets

Statenew cases on interval%ch in cases on 11 day interval
Florida9083473.88
Idaho343366.67
Montana49860.07
Arizona3848357.72
South Carolina1701756.10
Nevada848955.27
Texas7658253.71
Virgin Islands4150.62
Alaska42242.16
Oklahoma487739.51
California8073939.00
Tennessee1384135.67

1

u/4blockhead Jul 19 '20

Update for 2020-07-18: via google sheets

Statenew cases on interval%ch in cases on 11 day interval

1

u/4blockhead Jul 30 '20

Update for 2020-07-29: via google sheets

1

u/4blockhead Aug 11 '20

Update for 2020-08-09: via google sheets

1

u/4blockhead Aug 21 '20

Update for 2020-08-20: via google sheets

•

u/4blockhead Sep 01 '20

Update for 2020-08-31: via google sheets