Preliminary iFR - Covid - Google Sheets

	A	B	C	D	E	F	G	H	I	J	L
1	This information is being collected for personal use only and is being shared for informational purposes. I cannot assure its accuracy as it is collected from third parties. I'll try and include references where possible. See comments for links etc... Feel free to comment, ask questions, or point to mistakes :)		Early April						2 week lag
2		Geography	Prevalence	Population (M)	Date	Dx +ve	Deaths	Prevalence (M)	CFR	Dx Rates	Actual Numbers
3		NY State	14%	19.45	4/18/2020	225323	11815	2.723	0.43%	1.16%	Projected Figures
4		"1 in 5 for NY City?"	20.00%	19.45	4/23/2020	269756	19551	3.89	0.50%	1.39%	Secondary Sources
5		Santa Clara County	2.49%	1.928	4/18/2020	1870	72	0.05	0.15%	0.10%
6		Upper CI	4.16%	1.928	4/18/2020	1870	72	0.08	0.09%	0.10%
7		California	2.49%	39.51	4/18/2020	29157	1037	0.98	0.11%	0.07%
8		Upper CI	4.16%	39.51	4/18/2020	29157	1037	1.64	0.06%	0.07%
9
10
11		Netherlands	3%	17.3	4/18/2020	30619	3459	0.52	0.66% ?	0.18%
12
13
14
15
16
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