2026 Kings Beach Water Quality.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Stacy's Time (AM)	Stacey's Brooks	Eastern Ave	Pierce Rd	Kimball Rd	exceed w/o geomean	% days open	exceed incl. Geomean	% days	Swampscott	Eastern Ave	3-site	high tide lynn harbor AM	27BV rain "	Notes/Questions
2	Tester	DCR outfall	DCR	DCR	DCR			days =	open	DPH Kings	GeoMean DCR	geomean	morning	24-h starting	Swa,pscott Kings is the weekly Jeff sample for MADPH, not the BOH supplemental sampling
3	Sample Type	See note tab!	Beach water	Beach water	Beach water	33	70	53	52.3	Beach water	Beach water	for flags	for DCR	at midnight

4	5/18/2026 9:29	830	8	1	2	0		0						0	(27BV rain has +10% correction applied)
5	5/19/2026 8:53	315	1	2	1	0		0						0.01
6	5/20/2026 7:05	1,030	8	2	1	0		0						0
7	5/21/2026 7:45	800	2	177	262	1		1						0	no rain for a week. Not Drain cleaning or hydrant flushing per LWSC. Data problem? Eastern at 2 suggests that.
8	5/22/2026 7:30	2,600	23	18	17	0		0			5	5.9		0
9	5/23/2026 8:15	323	10	6	1	0		0			5	6.4	5:18	0
10	5/24/2026 6:58	185	19	22	20	0		0			9	11.2	6:23	0.52	rain mid-day and evening
11	5/25/2026 6:35	45	33	12	40	0		0			12	17.7	7:28	0.08	rain morning
12	5/26/2026 6:40	62	38	70	137	1		1			22	19.4	8:30	0
13	5/27/2026 7:20	77	22	10	2	0		0			22	16.1		0
14	5/28/2026 7:55	2600	246	6	8	1		1			42	22.9		0.17	.05" early morning and 0.12" noon-3pm; KFL culvers 600,000 at 4:15 pm
15	5/29/2026 8:05	930	22	10	10	0		0			43	21.0		0.02
16	5/30/2026 6:30	2600	83	20	17	0		0			52	21.8		0.58	8-10am and 12-1pm
17	5/31/2026 7:20	1,730	25	10	18	0		0			48	16.2		0.08	4-5 pm
18	6/1/2026 8:45	477	7	20	7	0		0			38	17.1		0
19	6/2/2026 8:10	670	12	10	1	0		0			21	12.6		0
20	6/3/2026 8:04	930	35	4	4	0		0			23	11.5		0
21	6/4/2026 7:11	370	2	12	1	0		0			11	7.2		0
22	6/5/2026 8:15	900	12	1	2	0		0			9	5.1	5:08	0
23	6/6/2026 9:07	1330	71	30	33	0		0			15	6.7	6:01	0.06	11 PM
24	6/7/2026 7:30	2600	1	1	5	0		0			9	5.5	6:56	0.07	6 to 9 pm
25	6/8/2026 6:20	1,330	75	1	10	0		0			11	5.6	7:50	0
26	6/9/2026 8:20	2600	13	10	1	0		0			15	6.2	8:45	0
27	6/10/2026 8:10	1,100	55	1	1	0		0		20	21	6.6	9:39	0
28	6/11/2026 8:21	767	57	2	4	0		0			20	4.7		0
29	6/12/2026 6:35	1830	51	113	48	1		1			44	9.7		0
30	6/13/2026 6:30	2167	18	2	2	0		0			33	8.3		0
31	6/14/2026 8:52	1270	148	16	5	1		1			53	11.3		0.01
32	6/15/2026 9:08	2600	102	71	58	0		0			60	20.4		0
33	6/16/2026 7:08	2600	32	12	8	0		0			54	23.2		0
34	6/17/2026 8:15	654	13	17	7	0		0		10	41	16.4		0
35	6/18/2026 6:45	867	94	13	1	0		0			57	19.8		0.80	6:15 to 7:00 pm
36	6/19/2026 8:48	2600	1470	70	19	1		1			90	27.9		0
37	6/20/2026 8:00	4106	52	5	5	0		0			79	19.0		0
38	6/21/2026 9:35	6490	31	20	10	0		0			78	19.9	4:57	0
39	6/22/2026 6:40	173	135	20	5	1		1			125	23.0	5:57	0.40	light rain starting at 2pm; steady 5-7pm
40	6/23/2026 9:20	24200	2910	31	30	1		1			248	38.4	6:58	0.20	mostly 4-6am. 0.05" in light showers after that.
41	6/24/2026 7:50	120	96	5	10	0		0		5	143	25.7	7:58	0
42	6/25/2026 8:20	392	30	5	6	0		0			129	25.1	8:56	0
43	6/26/2026 8:55	2230	92	10	6	0		0			160	24.9	9:50	0.18	0.09" 7-9am; 0.09" 930-10pm
44	6/27/2026 11:31	301	528	5	5	1		1			210	24.9	10:40	0
45	6/28/2026 6:30	588	20	20	5	0		0			78	15.4		0
46	6/29/2026 7:55	1620	10	10	10	0		0			49	13.8		0
47	6/30/2026 6:30	404	10	96	10	0		0			40	16.2		0.95	6:05 to 6:45 pm, downpour
48	7/1/2026 8:02	24200	6490	504	110	1		1		2489	93	33.9		0	rain event dug a deep channel allowing more tidal influence.
49	7/2/2026 8:15	2600	1000	52	17	1		1		213	105	44.9		0
50	7/3/2026 9:35	2600	59	42	8	0		1			131	52.3		0	Closed ONLY from GeoMean!
51	7/4/2026 6:50	1600	98	74	20	0		1			206	72.9		0.06	930-10pm
52	7/5/2026 9:55	8660	594	122	20	1		1			467	101.9		0
53	7/6/2026 8:25	1860	20	146	10	1		1			147	54.4	4:05	0
54	7/7/2026 10:20	24200	24200	19900	14100	1		1		BOH: 8635	278	156.5	4:53	1.9	0.35" 6-9am, rest 2-9pm; EasternAve offscale
55	7/8/2026 8:18	6870	246	420	145	1		1		97	370	243.5	5:46	0
56	7/9/2026 7:00	50	43	10	90	0		1			314	223.0	6:43	0	GeoMean will be > 35 until the 7/12 or 13 results are in
57	7/10/2026 10:02	2600	156	1	1	1		1			240	121.2	7:43	0.10	10-min shower, 6 to 615 pm
58	7/11/2026 9:20	215	25	8	4	0		1			251	95.4	8:46	0
59	7/12/2026 8:52	1050	72	10	10	0		0			78	24.1	9:48	0
60	7/13/2026 7:35	733	10	30	5	0		0			41	13.0	10:49	0
61	7/14/2026 8:25	404	5	5	10	0		0			27	9.3	11:46	0
62	7/15/2026 6:45	546	31	5	5	0		0		10	19	10.4		0
63	7/16/2026 8:50	2600	15	4	1	0		0			18	8.7		0
64	7/17/2026 7:20	730	32	10	10	0		0			15	8.3		0
65	7/18/2026 7:45	1050	98	84	52	0		0			24	12.0		0.20	rain 3 to 5 pm (after samples taken)
66	7/19/2026 9:02	3870	61	10	5	0		0			39	14.2		0
67	7/20/2026 8:05	155	20	20	41	0		0			36	17.4		0
68	7/21/2026 9:10	2910	74	5	5	0		0			49	21.9	5:26	1.20	530-8pm, most between 530 and 7
69	7/22/2026 11:35	6490	350	30	145	1		1			79	33.0	6:24	0.60	4:15 to 4:45 pm
70	7/23/2026 7:10	269	97	70	52	0		0		63	79	32.6	7:24	0
71	7/24/2026 7:35	177	35	12	20	0		0			71	34.9	8:23	0
72	7/25/2026 8:00	341	85	20	30	0		1			94	37.6	9:19	0
73	7/26/2026 8:10	243	51	5	5	0		1			88	36.7	10:11	0
74	7/27/2026 6:40	468	10	131	120	1		1			43	31.5	10:56	0
75	7/28/2026 10:42	548	41	30	30	0		0			36	27.1	11:37	0
76	7/29/2026 9:32	7270	285	211	199	1		1		10	55	44.0		0.85	0.06" between 1130 and 1pm; rest between 6pm and midnight.
77	7/30/2026 9:28	2600	2600	223	169	1		1			109	72.9		0.40	.35" midnight-3am; .05 7 to 715pm; KLF culverts 100 and 300 at 9:48
78	7/31/2026 9:20	2600	1	1	2	0		1			50	47.4		0
79	8/1/2026 8:31	2190	10	10	20	0		1			50	35.4		0.01	DCR considers this out on geomean; they do not round to whole digits as they should given the "35" limit.
80	8/2/2026 8:50	24200	41	10	5	0		0			50	29.2		0
81	8/3/2026 8:10	393	20	5	10	0		0			29	15.6		0.65	heavy rain 930-10am; steady rain mid-day; 5-min downpour 7pm
82	8/4/2026 9:22	3290	62	5	5	0		0			14	7.5		0
83	8/5/2026 7:20	1700	24200	24200	24200	1		1		30	104.2	53.8	4:28	0	24200 suspect. KLF culverts 600 and 300 at 9:48am
84	8/6/2026 8:31	867	41	10	4	0		1			138.2	53.0	5:22	0
85	8/7/2026 7:15	162	60	100	105	1		1			149.2	77.7	6:22	0	very deep channel; seawater in outfall 3h from hightide
86	8/8/2026 8:20	52	10	5	10	0		1			129.8	74.2	7:26	0
87	8/9/2026 7:10	135	20	10	10	0		1			103.6	75.5	8:32	0
88	8/10/2026 10:07	86	41	10	5	0		0			28.9	16.7	9:36	0
89	8/11/2026 7:55	119	116	41	74	1		1			35.6	23.8	10:37	0
90	8/12/2026 10:00	24200	24200	24200	108	1		1		5	118.1	51.4	11:32	0	KLF culverts < 1000@3pm; outfall is seawater; no rain for > a week;
91	8/13/2026 6:55	308	16	22	5	0		1			129.8	55.9		0
92	8/14/2026 8:40	767	33	4	4	0		1			143.5	51.1		0
93	8/16/2026 9:05	1660	336	10	5	1		2			218.5	58.8		0	NO TEST for 8/15
94	8/17/2026 8:40	4880	24200	24200	41	1		1			635.8	123.5		0.09	light rain between 3 and 7 am; KLF culverts 700 and 800 at 7:10am
95	8/18/2026 6:35	1180	187	108	96	1		1			240.4	61.8	4:00	0
96	8/19/2026 7:05	565	40	5	10	0		1		10	288.7	62.3	4:53	0
97	8/20/2026 9:18	2600	15	1	2	0		1			246.6	51.5	5:49	0.07	light rain 10pm to midnight
98	8/21/2026 6:05	238	27	44	33	0		1			148.9	54.5	6:48	0.04	between 530 and 830 am
99	8/22/2026 6:50	62	10	10	10	0		0			31.4	17.5	7:47	0.02
100	8/23/2026 9:12	455	10	20	5	0		0			17.5	10.6	8:44	0.45	heavy rain between 115 and 215 pm