COVID-19 Alternate Prevalance Estimates

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	COVID-19 Alternate Prevalance and Fatality Rate Tracker										Confrimed cases sources	International confirmed cases source
2	This spreadsheet tracks comparisons between the confirmed case count of COVID-19 and associated fatality rates, and alternate estimates using antibody testing or other methods.										https://covid-19.direct/	https://gisanddata.maps.arcgis.com/apps/opsdashboard/index.html#/bda7594740fd40299423467b48e9ecf6
3
4	Data recorded	Region	Population	Confirmed cases	Confirmed %	Deaths	Fatality/confirmed (CFR)	Alternate prevelance %	Fatality/alternate (IFR estimate)	Ratio	Detection rate	Alternate estimate type	Notes	Source

5	4/15	New York City	8,400,000	118,000	1.40%	10,899	9%	15.40%	0.84%	11.0	9.12%	Infection test	Pregnant women tested	https://mobile.twitter.com/ct_bergstrom/status/1249836446569181186
6	4/15	Sweden	10,230,000	11,000	0.11%	1,580	14%	2.50%	0.62%	23.3	4.30%	Infection test?	1100 randomly selected in the age interval 2 to 86 years, 738 agreed to take part in the study. Report is in Swedish. Test type taken from reading "Proverna analyserades sedan vid Folkhälsomyndighetens laboratorium för att se om proverna innehöll SARS-CoV-2 som är det virus som orsakar covid-19.," which is automatically translated as "The samples were then analyzed at the Public Health Agency's laboratory to see if the samples contained SARS-CoV-2, which is the virus that causes covid-19."	https://www.reddit.com/r/Coronavirus/comments/fxs73d/the_swedish_health_agency_just_released_the/
7	4/15	Austria	8,859,000	14,350	0.16%	470	3%	0.32%	1.66%	2.0	50.62%	Infection test	Austria randomly tested 1544 people ...found 5 infections	https://www.reddit.com/r/Coronavirus/comments/fybz5d/europe_austria_did_random_sample_testing_2x/
8	4/17	Santa Clara County	1,928,000	1,400	0.07%	73	5%	2.80%	0.14%	38.6	2.59%	Antibody	n=3300, Stanford antibody testing, midpoint of confidence interval	https://www.medrxiv.org/content/10.1101/2020.04.14.20062463v1
9	4/20	Los Angles County	4,000,000	12,300	0.31%	501	4%	3.35%	0.37%	10.9	9.18%	Antibody	n=1000, same kit as Stanford, midpoint of confidence interval	https://pressroom.usc.edu/what-a-usc-la-county-antibody-study-can-teach-us-about-covid-19/
10	4/23	New York City	8,400,000	147,000	1.75%	15,074	10%	0.21	0.85%	12.0	8.33%	Antibody	n=3000, test subjects from grocery stores	https://www.6sqft.com/new-york-covid-antibody-test-preliminary-results/
11	4/23	Netherlands	17,280,000	35,900	0.21%	4,177	12%	3.21%	0.75%	15.4	6.48%	Antibody		https://www.reddit.com/r/COVID19/comments/g4tqvk/dutch_antibody_study_of_blood_donors_reveals_3/
12	4/24	Miami-Dade County	2,710,000	10,000	0.37%	278	3%	6.09%	0.17%	16.5	6.06%	Antibody	n=1800	https://www.miamidade.gov/releases/2020-04-24-sample-testing-results.asp
13	4/25	Gengalt		1,513		48	3%		0.37%	8.6	11.67%	Antibody	Pulled data from reddit user translation, n=??	https://old.reddit.com/r/Coronavirus/comments/fxpeaz/interim_result_of_first_large_scale_study_in/
14	5/3	New York State	19,450,000	316,400	1.63%	24,710	3%	12.30%	1.03%	7.6	13.23%	Antibody	n=15000	https://www.governor.ny.gov/news/amid-ongoing-covid-19-pandemic-governor-cuomo-announces-results-completed-antibody-testing
15
16
17
18
19
20					Median				Median	Median	Median
21					0.26%				0.37%	12	8.33%
22					68% confidence interval				68% confidence interval	68% confidence interval	68% confidence interval
23					(0.12%, 1.56%)				(0.17%, 0.86%)	(8, 20.3)	(5.08%, 12.54%)
24
25					Mean				Mean	Mean	Mean
26					0.55%				0.44%	15.35019628	12.04%
27					sample stdev				sample stdev	geometric sample stdev	sample stdev
28					0.71%				0.35%	10.17762128	13.89%
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