ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Estimate of at least partial immunity, John F. Raffensperger. Use at your own risk, no promises made, etc.
2
Instructions: gray cells are formulas. You input reported cases and Total vaccinated.
3
USALA CountyMassachusettsCook County
4
As of2021-12-282021-05-172021-05-072021-05-07
5
Total population331,893,74510,400,0006,980,0005,106,780
6
Ratio unreported/reported cases4
https://www.cdc.gov/coronavirus/2019-ncov/cases-updates/burden.html
444.3
7
8
Totals% of pop% of pop% of pop% of pop >=18
9
Reported cases52,280,337
https://covid.cdc.gov/covid-data-tracker/#vaccinations
1,237,411
http://publichealth.lacounty.gov/media/coronavirus/data/index.htm#
993,038243,156
10
Total sick209,121,34863.0%4,949,64447.6%3,972,15256.9%1,045,57120.5%
11
Total vaccinated at least once242,433,62073.0%
https://covid.cdc.gov/covid-data-tracker/#vaccinations
4,940,82047.5%
>= 16 yrs, http://publichealth.lacounty.gov/media/coronavirus/vaccine/vaccine-dashboard.htm
5,522,35279.1%1,028,58620.1%
12
Vaccinated, sick152,753,84446.0%2,351,47122.6%3,142,63945.0%210,5944.1%
13
Vaccinated, not sick89,679,77627.0%2,589,34924.9%2,379,71334.1%817,99216.0%
14
Not vaccinated, sick56,367,50417.0%2,598,17325.0%829,51311.9%834,97616.4%
15
Not vaccinated, not sick33,092,62110.0%2,861,00727.5%628,1359.0%3,243,21863.5%
16
At least one shot and/or previously sick298,801,12490.0%7,538,99372.5%6,351,86591.0%1,863,56236.5%
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100