15
posted ago by mrsucko ago by mrsucko +15 / -0

I wrote a script to pull COVID statistics from the New York Time's live data feed on Github. I calculated per-state mortality and infection percentages, as well as comparisons to deaths per infections and deaths per population (state and national).

Enjoy.

Alabama:

  • Population: 4,932,000
  • Cases: 449,086
  • Deaths: 7,172
  • State Infection Rate: 9.11%
  • State Mortality Rate: 1.6%
  • State Mortality Rate (% of US deaths): 0.03%
  • State Infection Rate (% of US population): 0.14%
  • State Mortality Rate (% of US population): 0.0%

Alaska:

  • Population: 728,903
  • Cases: 53,322
  • Deaths: 252
  • State Infection Rate: 7.32%
  • State Mortality Rate: 0.47%
  • State Mortality Rate (% of US deaths): 0.0%
  • State Infection Rate (% of US population): 0.02%
  • State Mortality Rate (% of US population): 0.0%

Arizona:

  • Population: 7,278,717
  • Cases: 740,599
  • Deaths: 12,668
  • State Infection Rate: 10.17%
  • State Mortality Rate: 1.71%
  • State Mortality Rate (% of US deaths): 0.05%
  • State Infection Rate (% of US population): 0.22%
  • State Mortality Rate (% of US population): 0.0%

Arkansas:

  • Population: 3,017,825
  • Cases: 288,964
  • Deaths: 4,742
  • State Infection Rate: 9.58%
  • State Mortality Rate: 1.64%
  • State Mortality Rate (% of US deaths): 0.02%
  • State Infection Rate (% of US population): 0.09%
  • State Mortality Rate (% of US population): 0.0%

California:

  • Population: 39,512,223
  • Cases: 3,243,704
  • Deaths: 38,510
  • State Infection Rate: 8.21%
  • State Mortality Rate: 1.19%
  • State Mortality Rate (% of US deaths): 0.15%
  • State Infection Rate (% of US population): 0.98%
  • State Mortality Rate (% of US population): 0.01%

Colorado:

  • Population: 5,758,736
  • Cases: 392,408
  • Deaths: 5,648
  • State Infection Rate: 6.81%
  • State Mortality Rate: 1.44%
  • State Mortality Rate (% of US deaths): 0.02%
  • State Infection Rate (% of US population): 0.12%
  • State Mortality Rate (% of US population): 0.0%

Connecticut:

  • Population: 3,565,287
  • Cases: 247,339
  • Deaths: 6,976
  • State Infection Rate: 6.94%
  • State Mortality Rate: 2.82%
  • State Mortality Rate (% of US deaths): 0.03%
  • State Infection Rate (% of US population): 0.07%
  • State Mortality Rate (% of US population): 0.0%

Delaware:

  • Population: 973,764
  • Cases: 75,832
  • Deaths: 1,072
  • State Infection Rate: 7.79%
  • State Mortality Rate: 1.41%
  • State Mortality Rate (% of US deaths): 0.0%
  • State Infection Rate (% of US population): 0.02%
  • State Mortality Rate (% of US population): 0.0%

District of Columbia:

  • Population: 705,749
  • Cases: 35,865
  • Deaths: 895
  • State Infection Rate: 5.08%
  • State Mortality Rate: 2.5%
  • State Mortality Rate (% of US deaths): 0.0%
  • State Infection Rate (% of US population): 0.01%
  • State Mortality Rate (% of US population): 0.0%

Florida:

  • Population: 21,477,737
  • Cases: 1,676,163
  • Deaths: 25,832
  • State Infection Rate: 7.8%
  • State Mortality Rate: 1.54%
  • State Mortality Rate (% of US deaths): 0.1%
  • State Infection Rate (% of US population): 0.51%
  • State Mortality Rate (% of US population): 0.01%

Georgia:

  • Population: 10,617,423
  • Cases: 861,830
  • Deaths: 13,222
  • State Infection Rate: 8.12%
  • State Mortality Rate: 1.53%
  • State Mortality Rate (% of US deaths): 0.05%
  • State Infection Rate (% of US population): 0.26%
  • State Mortality Rate (% of US population): 0.0%

Guam:

  • Population: 165,718
  • Cases: 8,537
  • Deaths: 130
  • State Infection Rate: 5.15%
  • State Mortality Rate: 1.52%
  • State Mortality Rate (% of US deaths): 0.0%
  • State Infection Rate (% of US population): 0.0%
  • State Mortality Rate (% of US population): 0.0%

Hawaii:

  • Population: 1,415,872
  • Cases: 25,366
  • Deaths: 401
  • State Infection Rate: 1.79%
  • State Mortality Rate: 1.58%
  • State Mortality Rate (% of US deaths): 0.0%
  • State Infection Rate (% of US population): 0.01%
  • State Mortality Rate (% of US population): 0.0%

Idaho:

  • Population: 1,787,065
  • Cases: 161,363
  • Deaths: 1,716
  • State Infection Rate: 9.03%
  • State Mortality Rate: 1.06%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population): 0.05%
  • State Mortality Rate (% of US population): 0.0%

Illinois:

  • Population: 12,671,821
  • Cases: 1,114,732
  • Deaths: 20,950
  • State Infection Rate: 8.8%
  • State Mortality Rate: 1.88%
  • State Mortality Rate (% of US deaths): 0.08%
  • State Infection Rate (% of US population): 0.34%
  • State Mortality Rate (% of US population): 0.01%

Indiana:

  • Population: 6,732,219
  • Cases: 620,275
  • Deaths: 9,845
  • State Infection Rate: 9.21%
  • State Mortality Rate: 1.59%
  • State Mortality Rate (% of US deaths): 0.04%
  • State Infection Rate (% of US population): 0.19%
  • State Mortality Rate (% of US population): 0.0%

Iowa:

  • Population: 3,155,070
  • Cases: 315,423
  • Deaths: 4,500
  • State Infection Rate: 10.0%
  • State Mortality Rate: 1.43%
  • State Mortality Rate (% of US deaths): 0.02%
  • State Infection Rate (% of US population): 0.1%
  • State Mortality Rate (% of US population): 0.0%

Kansas:

  • Population: 2,913,314
  • Cases: 275,443
  • Deaths: 3,718
  • State Infection Rate: 9.45%
  • State Mortality Rate: 1.35%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population): 0.08%
  • State Mortality Rate (% of US population): 0.0%

Kentucky:

  • Population: 4,467,673
  • Cases: 356,837
  • Deaths: 3,805
  • State Infection Rate: 7.99%
  • State Mortality Rate: 1.07%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population): 0.11%
  • State Mortality Rate (% of US population): 0.0%

Louisiana:

  • Population: 4,648,794
  • Cases: 392,416
  • Deaths: 8,688
  • State Infection Rate: 8.44%
  • State Mortality Rate: 2.21%
  • State Mortality Rate (% of US deaths): 0.03%
  • State Infection Rate (% of US population): 0.12%
  • State Mortality Rate (% of US population): 0.0%

Maine:

  • Population: 1,344,212
  • Cases: 38,170
  • Deaths: 562
  • State Infection Rate: 2.84%
  • State Mortality Rate: 1.47%
  • State Mortality Rate (% of US deaths): 0.0%
  • State Infection Rate (% of US population): 0.01%
  • State Mortality Rate (% of US population): 0.0%

Maryland:

  • Population: 6,045,680
  • Cases: 346,734
  • Deaths: 6,996
  • State Infection Rate: 5.74%
  • State Mortality Rate: 2.02%
  • State Mortality Rate (% of US deaths): 0.03%
  • State Infection Rate (% of US population): 0.1%
  • State Mortality Rate (% of US population): 0.0%

Massachusetts:

  • Population: 6,949,503
  • Cases: 509,503
  • Deaths: 14,304
  • State Infection Rate: 7.33%
  • State Mortality Rate: 2.81%
  • State Mortality Rate (% of US deaths): 0.06%
  • State Infection Rate (% of US population): 0.15%
  • State Mortality Rate (% of US population): 0.0%

Michigan:

  • Population: 9,986,857
  • Cases: 602,896
  • Deaths: 15,303
  • State Infection Rate: 6.04%
  • State Mortality Rate: 2.54%
  • State Mortality Rate (% of US deaths): 0.06%
  • State Infection Rate (% of US population): 0.18%
  • State Mortality Rate (% of US population): 0.0%

Minnesota:

  • Population: 5,639,632
  • Cases: 457,385
  • Deaths: 6,192
  • State Infection Rate: 8.11%
  • State Mortality Rate: 1.35%
  • State Mortality Rate (% of US deaths): 0.02%
  • State Infection Rate (% of US population): 0.14%
  • State Mortality Rate (% of US population): 0.0%

Mississippi:

  • Population: 2,976,149
  • Cases: 268,672
  • Deaths: 5,917
  • State Infection Rate: 9.03%
  • State Mortality Rate: 2.2%
  • State Mortality Rate (% of US deaths): 0.02%
  • State Infection Rate (% of US population): 0.08%
  • State Mortality Rate (% of US population): 0.0%

Missouri:

  • Population: 6,137,428
  • Cases: 487,273
  • Deaths: 7,118
  • State Infection Rate: 7.94%
  • State Mortality Rate: 1.46%
  • State Mortality Rate (% of US deaths): 0.03%
  • State Infection Rate (% of US population): 0.15%
  • State Mortality Rate (% of US population): 0.0%

Montana:

  • Population: 1,068,778
  • Cases: 92,619
  • Deaths: 1,202
  • State Infection Rate: 8.67%
  • State Mortality Rate: 1.3%
  • State Mortality Rate (% of US deaths): 0.0%
  • State Infection Rate (% of US population): 0.03%
  • State Mortality Rate (% of US population): 0.0%

Nebraska:

  • Population: 1,934,408
  • Cases: 188,407
  • Deaths: 1,989
  • State Infection Rate: 9.74%
  • State Mortality Rate: 1.06%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population): 0.06%
  • State Mortality Rate (% of US population): 0.0%

Nevada:

  • Population: 3,080,156
  • Cases: 274,024
  • Deaths: 4,137
  • State Infection Rate: 8.9%
  • State Mortality Rate: 1.51%
  • State Mortality Rate (% of US deaths): 0.02%
  • State Infection Rate (% of US population): 0.08%
  • State Mortality Rate (% of US population): 0.0%

New Hampshire:

  • Population: 1,359,711
  • Cases: 63,563
  • Deaths: 1,006
  • State Infection Rate: 4.67%
  • State Mortality Rate: 1.58%
  • State Mortality Rate (% of US deaths): 0.0%
  • State Infection Rate (% of US population): 0.02%
  • State Mortality Rate (% of US population): 0.0%

New Jersey:

  • Population: 8,882,190
  • Cases: 676,537
  • Deaths: 21,234
  • State Infection Rate: 7.62%
  • State Mortality Rate: 3.14%
  • State Mortality Rate (% of US deaths): 0.08%
  • State Infection Rate (% of US population): 0.2%
  • State Mortality Rate (% of US population): 0.01%

New Mexico:

  • Population: 2,096,829
  • Cases: 170,296
  • Deaths: 3,173
  • State Infection Rate: 8.12%
  • State Mortality Rate: 1.86%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population): 0.05%
  • State Mortality Rate (% of US population): 0.0%

New York:

  • Population: 19,453,561
  • Cases: 1,369,329
  • Deaths: 42,434
  • State Infection Rate: 7.04%
  • State Mortality Rate: 3.1%
  • State Mortality Rate (% of US deaths): 0.17%
  • State Infection Rate (% of US population): 0.41%
  • State Mortality Rate (% of US population): 0.01%

North Carolina:

  • Population: 10,488,084
  • Cases: 735,542
  • Deaths: 8,959
  • State Infection Rate: 7.01%
  • State Mortality Rate: 1.22%
  • State Mortality Rate (% of US deaths): 0.03%
  • State Infection Rate (% of US population): 0.22%
  • State Mortality Rate (% of US population): 0.0%

North Dakota:

  • Population: 762,062
  • Cases: 97,185
  • Deaths: 1,441
  • State Infection Rate: 12.75%
  • State Mortality Rate: 1.48%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population): 0.03%
  • State Mortality Rate (% of US population): 0.0%

Northern Mariana Islands:

  • Population: 55,194
  • Cases: 131
  • Deaths: 2
  • State Infection Rate: 0.24%
  • State Mortality Rate: 1.53%
  • State Mortality Rate (% of US deaths): 0.0%
  • State Infection Rate (% of US population): 0.0%
  • State Mortality Rate (% of US population): 0.0%

Ohio:

  • Population: 11,689,100
  • Cases: 878,284
  • Deaths: 10,931
  • State Infection Rate: 7.51%
  • State Mortality Rate: 1.24%
  • State Mortality Rate (% of US deaths): 0.04%
  • State Infection Rate (% of US population): 0.26%
  • State Mortality Rate (% of US population): 0.0%

Oklahoma:

  • Population: 3,956,971
  • Cases: 379,110
  • Deaths: 3,388
  • State Infection Rate: 9.58%
  • State Mortality Rate: 0.89%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population): 0.11%
  • State Mortality Rate (% of US population): 0.0%

Oregon:

  • Population: 4,217,737
  • Cases: 140,063
  • Deaths: 1,936
  • State Infection Rate: 3.32%
  • State Mortality Rate: 1.38%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population): 0.04%
  • State Mortality Rate (% of US population): 0.0%

Pennsylvania:

  • Population: 12,801,989
  • Cases: 824,216
  • Deaths: 21,105
  • State Infection Rate: 6.44%
  • State Mortality Rate: 2.56%
  • State Mortality Rate (% of US deaths): 0.08%
  • State Infection Rate (% of US population): 0.25%
  • State Mortality Rate (% of US population): 0.01%

Puerto Rico:

  • Population: 3,193,694
  • Cases: 125,859
  • Deaths: 1,794
  • State Infection Rate: 3.94%
  • State Mortality Rate: 1.43%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population): 0.04%
  • State Mortality Rate (% of US population): 0.0%

Rhode Island:

  • Population: 1,059,361
  • Cases: 113,009
  • Deaths: 2,135
  • State Infection Rate: 10.67%
  • State Mortality Rate: 1.89%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population): 0.03%
  • State Mortality Rate (% of US population): 0.0%

South Carolina:

  • Population: 5,148,714
  • Cases: 427,231
  • Deaths: 6,673
  • State Infection Rate: 8.3%
  • State Mortality Rate: 1.56%
  • State Mortality Rate (% of US deaths): 0.03%
  • State Infection Rate (% of US population): 0.13%
  • State Mortality Rate (% of US population): 0.0%

South Dakota:

  • Population: 884,659
  • Cases: 107,608
  • Deaths: 1,739
  • State Infection Rate: 12.16%
  • State Mortality Rate: 1.62%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population): 0.03%
  • State Mortality Rate (% of US population): 0.0%

Tennessee:

  • Population: 6,833,174
  • Cases: 701,997
  • Deaths: 9,230
  • State Infection Rate: 10.27%
  • State Mortality Rate: 1.31%
  • State Mortality Rate (% of US deaths): 0.04%
  • State Infection Rate (% of US population): 0.21%
  • State Mortality Rate (% of US population): 0.0%

Texas:

  • Population: 28,995,881
  • Cases: 2,304,366
  • Deaths: 35,636
  • State Infection Rate: 7.95%
  • State Mortality Rate: 1.55%
  • State Mortality Rate (% of US deaths): 0.14%
  • State Infection Rate (% of US population): 0.69%
  • State Mortality Rate (% of US population): 0.01%

Utah:

  • Population: 3,205,958
  • Cases: 340,684
  • Deaths: 1,620
  • State Infection Rate: 10.63%
  • State Mortality Rate: 0.48%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population): 0.1%
  • State Mortality Rate (% of US population): 0.0%

Vermont:

  • Population: 623,989
  • Cases: 11,379
  • Deaths: 172
  • State Infection Rate: 1.82%
  • State Mortality Rate: 1.51%
  • State Mortality Rate (% of US deaths): 0.0%
  • State Infection Rate (% of US population): 0.0%
  • State Mortality Rate (% of US population): 0.0%

Virginia:

  • Population: 8,535,519
  • Cases: 488,553
  • Deaths: 6,228
  • State Infection Rate: 5.72%
  • State Mortality Rate: 1.27%
  • State Mortality Rate (% of US deaths): 0.02%
  • State Infection Rate (% of US population): 0.15%
  • State Mortality Rate (% of US population): 0.0%

Virgin Islands:

  • Population: 104,914
  • Cases: 2,373
  • Deaths: 24
  • State Infection Rate: 2.26%
  • State Mortality Rate: 1.01%
  • State Mortality Rate (% of US deaths): 0.0%
  • State Infection Rate (% of US population): 0.0%
  • State Mortality Rate (% of US population): 0.0%

Washington:

  • Population: 7,614,893
  • Cases: 308,691
  • Deaths: 4,251
  • State Infection Rate: 4.05%
  • State Mortality Rate: 1.38%
  • State Mortality Rate (% of US deaths): 0.02%
  • State Infection Rate (% of US population): 0.09%
  • State Mortality Rate (% of US population): 0.0%

West Virginia:

  • Population: 1,792,147
  • Cases: 117,775
  • Deaths: 1,953
  • State Infection Rate: 6.57%
  • State Mortality Rate: 1.66%
  • State Mortality Rate (% of US deaths): 0.01%
  • State Infection Rate (% of US population
Comments (5)
sorted by:
You're viewing a single comment thread. View all comments, or full comment thread.
2
dodgetimes2 2 points ago +2 / -0

Scripts are racist.

1
mrsucko [S] 1 point ago +1 / -0

But some of my best IDE themes are Dark Mode!