Log scale covid sewage stats, RNA copies/mL, MWRA N & S systems

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1		COPIED from https://www.mwra.com/biobot/biobotdata.htm (note "avg" = geomean). SEE ALSO https://biobot.io/data/								Experimenting with median of 7 days					Year-to-year comparisons
2	Sample Date	Southern (copies/mL)	Northern (copies/mL)	S 7 day avg (geomean)	N 7 day avg (geomean)	Southern Low Confidence Interval	Southern High Confidence Interval	Northern Low Confidence Interval	Northern High Confidence Interval	S 7-day median	N 7-day median	S wkly median growth ratio	N wkly median growth ratio	7-day N&S geomean-smoothed median growth ratio	S geomean higher than a year ago	N geomean higher than a year ago	mean of N,S 7-day medians	risk %ile within last year	fraction of average risk within last year	max(n/s, s/n)	S 7-day trimmed geomean	N 7-day trimmed geomean

3	3/10/2020	38	15	21	12	17	5	7
4	3/11/2020	31	65	34	31	10	15	21	30
5	3/12/2020	25	36	31	32	8	12	11	17			S wkly median growth ratio	N wkly median growth ratio	7-day N&S geomean-smoothed median growth ratio
6	3/13/2020	31	32	0	0	0	0
7	3/14/2020	16	27	26	31	5	7	9	13												29	31
8	3/15/2020	39	53	28	34	12	18	17	25					7-day N&S geomean-smoothed median growth ratio							31	36
9	3/16/2020	33	23	29	32	10	15	7	11	31	32						31.5				31	33
10	3/17/2020	106	78	35	43	33	49	24	36	31	36						33.5				31	40
11	3/18/2020	65	45	39	40	21	30	14	21	33	36						34.5				37	38
12	3/19/2020	19	49	37	42	6	9	16	23	33	45						39				35	40
13	3/20/2020	37	42	0	0	0	0			37	45						41				36	42
14	3/21/2020	44	46	0	0	0	0			39	46						42.5				42	47
15	3/22/2020	45	45	0	0	0	0			44	45						44.5				44	45
16	3/23/2020	146	380	66	90	46	68	120	176	45	46	1.45	1.44				45.5				55	51
17	3/24/2020	321	56	129	0	0	102	148		45	46	1.45	1.28				45.5				59	48
18	3/25/2020	30	228	43	192	9	14	72	105	44	49	1.33	1.36				46.5				50	66
19	3/26/2020	370	39	117	182	117	171	12	18	45	46	1.36	1.02				45.5				81	64
20	3/27/2020	34	299	86	201	11	16	95	138	45	56	1.22	1.24				50.5				79	95
21	3/28/2020	86	201	0	0	0	0			86	201	2.21	4.37				143.5				91	128
22	3/29/2020	86	201	0	0	0	0			86	201	1.95	4.47	1.66			143.5				103	173
23	3/30/2020	46	219	64	180	15	21	69	101	86	201	1.91	4.37	1.84			143.5				82	162
24	3/31/2020	64	155	0	0	0	0			64	201	1.42	4.37	2.00			132.5				59	199
25	4/1/2020	143	475	95	187	45	66	150	220	86	201	1.95	4.10	2.23			143.5				79	210
26	4/2/2020	61	315	0	0	0	0			64	219	1.42	4.76	2.49			141.5				67	242
27	4/3/2020	233	438	116	357	74	108	138	202	86	219	1.91	3.91	2.79			152.5				84	261
28	4/4/2020	116	357	0	0	0	0			86	315	1.00	1.57	2.45			200.5				89	293
29	4/5/2020	116	357	0	0	0	0			116	357	1.35	1.78	2.24			236.5				94	329
30	4/6/2020	182	456	0	0	0	0			116	357	1.35	1.78	2.05			236.5				118	381
31	4/7/2020	310	562	218	489	98	143	178	260	143	438	2.23	2.18	2.01			290.5				152	414
32	4/8/2020	269	496	0	0	0	0			182	438	2.12	2.18	1.93			310				173	417
33	4/9/2020	501	784	331	578	158	231	248	362	233	456	3.64	2.08	1.95			344.5				210	457
34	4/10/2020	394	664	0	0	0	0			269	496	3.13	2.26	1.94			382.5				233	496
35	4/11/2020	394	664	0	0	0	0			310	562	3.60	1.78	2.15			436				298	562
36	4/12/2020	394	664	0	0	0	0			394	664	3.40	1.86	2.30			529				348	606
37	4/13/2020	394	664	0	0	0	0			394	664	3.40	1.86	2.47			529				376	642
38	4/14/2020	389	702	441	742	123	180	222	324	394	664	2.76	1.52	2.44			529				393	671
39	4/15/2020	441	742	0	0	0	0			394	664	2.16	1.52	2.38			529				403	687
40	4/16/2020	138	321	232	474	44	64	101	148	394	664	1.69	1.46	2.20			529				393	671
41	4/17/2020	164	360	206	433	52	76	114	166	394	664	1.46	1.34	2.01			529				330	594
42	4/18/2020	206	433	0	0	0	0			389	664	1.25	1.18	1.81			526.5				290	545
43	4/19/2020	206	433	0	0	0	0			206	433	0.52	0.65	1.47			319.5				254	501
44	4/20/2020	206	433	0	0	0	0			206	433	0.52	0.65	1.19			319.5				224	460
45	4/21/2020	150	340	0	0	0	0			206	433	0.52	0.65	0.99			319.5				185	398
46	4/22/2020	220	541	171	397	70	102	171	250	206	433	0.52	0.65	0.85			319.5				185	398
47	4/23/2020	179	283	186	381	57	83	90	131	206	433	0.52	0.65	0.73			319.5				191	398
48	4/24/2020	199	391			0	0			206	433	0.52	0.65	0.65			319.5				199	404
49	4/25/2020	199	391			0	0			199	391	0.51	0.59	0.58			295				198	396
50	4/26/2020	199	391			0	0			199	391	0.97	0.90	0.62			295				196	388
51	4/27/2020	130	173	391	41	60	0	0		199	391	0.97	0.90	0.66			295				184	356
52	4/28/2020	97	293	149	355	31	45	93	135	199	391	0.97	0.90	0.71			295				179	346
53	4/29/2020	131	288			0	0			179	293	0.87	0.68	0.74			236				165	325
54	4/30/2020	112	293			0	0			131	293	0.64	0.68	0.75			212				150	328
55	5/1/2020	112	293			0	0			130	293	0.63	0.68	0.76			211.5				134	309
56	5/2/2020	112	293			0	0			112	293	0.56	0.75	0.78			202.5				119	292
57	5/3/2020	209	93	138	165	66	96	29	43	112	293	0.56	0.75	0.74			202.5				119	263
58	5/4/2020	142	165			0	0			112	293	0.56	0.75	0.70			202.5				121	260
59	5/5/2020	97	94	142	94	31	45	30	44	112	288	0.56	0.74	0.67			200				121	207
60	5/6/2020	5	22	47	58	2	2	7	10	112	165	0.63	0.56	0.64			138.5				114	165
61	5/7/2020	47	58			0	0			112	94	0.85	0.32	0.62			103				96	120
62	5/8/2020	47	58			0	0			97	93	0.75	0.32	0.60			95				81	87
63	5/9/2020	47	58			0	0			47	58	0.42	0.20	0.53			52.5				68	70
64	5/10/2020	22	46			0	0			47	58	0.42	0.20	0.47			52.5				47	61
65	5/11/2020	164	43	46	52	76	0	0		47	58	0.42	0.20	0.42			52.5				47	52
66	5/12/2020	29	22			0	0			47	46	0.42	0.16	0.37			46.5				37	43
67	5/13/2020									47	52			0.34			49.5				42	51
68	5/14/2020									47	46			0.31			46.5				40	49
69	5/15/2020									38	44.5			0.28			41.25				37	44
70	5/16/2020									29	43			0.28							29	43
71	5/17/2020									96.5	32.5			0.27							69	31
72	5/18/2020									29	22			0.26							29	22
73	5/19/2020									#ZAHL!	#ZAHL!			#ZAHL!
74	5/20/2020									#ZAHL!	#ZAHL!			#ZAHL!
75	5/21/2020	82	42	26	38	13	20			82	42			#ZAHL!							82	42
76	5/22/2020	426	244	135	197	77	113			254	143			#ZAHL!							187	101
77	5/23/2020	77	69	24	36	22	32			82	69			#ZAHL!							82	69
78	5/24/2020	79	52	121	78	25	36	16	24	80.5	60.5			#ZAHL!			70.5				80	60
79	5/25/2020	66	42	107	69	21	31	13	19	79	52			#ZAHL!			65.5				79	53
80	5/26/2020	97	38	105	62	31	45	12	17	80.5	47			#ZAHL!			63.75				83	50
81	5/27/2020	197	81	115	65	62	91	26	37	82	52	#ZAHL!	#ZAHL!	#ZAHL!			67				99	55
82	5/28/2020	50	35	107	63	16	23	11	16	79	52			#ZAHL!			65.5				95	54
83	5/29/2020	28	49	73	50	9	13	15	22	77	49			#ZAHL!			63				72	49
84	5/30/2020	66	71	47	21	31	0	0		66	49			#ZAHL!			57.5				70	49
85	5/31/2020	79	37	71	45	25	37	12	17	66	42	0.82	0.69	#ZAHL!			54				70	46
86	6/1/2020	82	60	73	48	26	38	19	28	79	49	1.00	0.94	#ZAHL!			64				73	49
87	6/2/2020	194	95	81	55	61	90	30	44	79	60	0.98	1.28	#ZAHL!			69.5				84	57
88	6/3/2020	35	40	63	49	11	16	13	18	66	49	0.80	0.94	0.9191899478			57.5				60	50
89	6/4/2020	47	32	63	49	15	22	10	15	66	49	0.84	0.94	0.9127149645			57.5				59	50
90	6/5/2020	44	45	67	48	14	20	14	21	66	45	0.86	0.92	0.9084167071			55.5				62	49
91	6/6/2020	19	46	56	48	6	9	15	21	47	45	0.71	0.92	0.89			46				54	45
92	6/7/2020	24	27	47	45	8	11	8	12	44	45	0.67	1.07	0.91			44.5				43	44
93	6/8/2020	26	19	40	39	8	12	6	9	35	40	0.44	0.82	0.85			37.5				34	37
94	6/9/2020	52	167	33	42	16	24	53	77	35	40	0.44	0.67	0.76			37.5				34	37
95	6/10/2020	75	68	37	45	24	35	21	31	44	45	0.67	0.92	0.75			44.5				37	41
96	6/11/2020	40	134	36	56	13	19	42	62	40	46	0.61	0.94	0.74			43				36	55
97	6/12/2020	45	78	36	60	14	21	25	36	40	68	0.61	1.51	0.74			54				36	62
98	6/13/2020	77	180	44	73	24	36	57	83	45	78	0.96	1.73	0.80			61.5				45	80
99	6/14/2020	36	47	86	11	17	0	0		45	78	1.02	1.73	0.85			61.5				48	89
100	6/15/2020	38	141	50	120	12	17	45	65	45	134	1.29	3.35	1.01			89.5				48	111