sample-id	year	month	day	date	Name-ID	Type	Batch	Type-Batch	BatcC-Contamintion-concentration	Blank-specific	Contamination-Conc-num	Contamination-Conc-cat	E.coli-conc-(CFU/ml)-num	E.coli-conc-(CFU/ml)-cat	total-cell-(cell/ml)-num	total-cell-(cell/ml)-cat	live-cell-(cell/ml)-num	live-cell-(cell/ml)-cat	dead-cell-(cell/ml)-num	dead-cell-(cell/ml)-cat
#q2:types	categorical	categorical	categorical	categorical	categorical	categorical	categorical	categorical	categorical	categorical	numeric	categorical	numeric	categorical	numeric	categorical	numeric	categorical	numeric	categorical
BlancA	2019	5	9	5-2019	BlancA	Blank	Sewage_contamintion	Sewage_contamintion_Blank	Sewage_contamintion_B_Blank	Blank	0.00E+00	B_Blank	0.00E+00	B_Blank	0.00E+00	B_Blank	0.00E+00	B_Blank	0.00E+00	B_Blank
BlancB	2019	5	9	5-2019	BlancB	Blank	Sewage_contamintion	Sewage_contamintion_Blank	Sewage_contamintion_B_Blank	Blank	0.00E+00	B_Blank	0.00E+00	B_Blank	0.00E+00	B_Blank	0.00E+00	B_Blank	0.00E+00	B_Blank
BlancC	2019	5	9	5-2019	BlancC	Blank	Sewage_contamintion	Sewage_contamintion_Blank	Sewage_contamintion_B_Blank	Blank	0.00E+00	B_Blank	0.00E+00	B_Blank	0.00E+00	B_Blank	0.00E+00	B_Blank	0.00E+00	B_Blank
Inf-100000000A	2019	5	9	5-2019	Inf-100000000A	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_D_1.00E-08	non-blank	1.00E-08	D_1.00E-08	7.50E-03	D_7.50E-03	4.58E+04	D_4.58E+04	4.30E+04	D_4.30E+04	2.83E+03	D_2.83E+03
Inf-100000000B	2019	5	9	5-2019	Inf-100000000B	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_D_1.00E-08	non-blank	1.00E-08	D_1.00E-08	7.50E-03	D_7.50E-03	4.58E+04	D_4.58E+04	4.30E+04	D_4.30E+04	2.83E+03	D_2.83E+03
Inf-100000000C	2019	5	9	5-2019	Inf-100000000C	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_D_1.00E-08	non-blank	1.00E-08	D_1.00E-08	7.50E-03	D_7.50E-03	4.58E+04	D_4.58E+04	4.30E+04	D_4.30E+04	2.83E+03	D_2.83E+03
Inf-10000000A	2019	5	9	5-2019	Inf-10000000A	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_E_1.00E-07	non-blank	1.00E-07	E_1.00E-07	7.50E-02	E_7.50E-02	4.66E+04	E_4.66E+04	4.37E+04	E_4.37E+04	2.92E+03	E_2.92E+03
Inf-10000000B	2019	5	9	5-2019	Inf-10000000B	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_E_1.00E-07	non-blank	1.00E-07	E_1.00E-07	7.50E-02	E_7.50E-02	4.66E+04	E_4.66E+04	4.37E+04	E_4.37E+04	2.92E+03	E_2.92E+03
Inf-10000000C	2019	5	9	5-2019	Inf-10000000C	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_E_1.00E-07	non-blank	1.00E-07	E_1.00E-07	7.50E-02	E_7.50E-02	4.66E+04	E_4.66E+04	4.37E+04	E_4.37E+04	2.92E+03	E_2.92E+03
Inf-1000000A	2019	5	9	5-2019	Inf-1000000A	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_F_1.00E-06	non-blank	1.00E-06	F_1.00E-06	7.50E-01	F_7.50E-01	4.61E+04	F_4.61E+04	4.39E+04	F_4.39E+04	2.25E+03	F_2.25E+03
Inf-1000000B	2019	5	9	5-2019	Inf-1000000B	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_F_1.00E-06	non-blank	1.00E-06	F_1.00E-06	7.50E-01	F_7.50E-01	4.61E+04	F_4.61E+04	4.39E+04	F_4.39E+04	2.25E+03	F_2.25E+03
Inf-1000000C	2019	5	9	5-2019	Inf-1000000C	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_F_1.00E-06	non-blank	1.00E-06	F_1.00E-06	7.50E-01	F_7.50E-01	4.61E+04	F_4.61E+04	4.39E+04	F_4.39E+04	2.25E+03	F_2.25E+03
Inf-100000A	2019	5	9	5-2019	Inf-100000A	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_G_1.00E-05	non-blank	1.00E-05	G_1.00E-05	7.50E+00	G_7.50E+00	4.76E+04	G_4.76E+04	4.41E+04	G_4.41E+04	3.50E+03	G_3.50E+03
Inf-100000B	2019	5	9	5-2019	Inf-100000B	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_G_1.00E-05	non-blank	1.00E-05	G_1.00E-05	7.50E+00	G_7.50E+00	4.76E+04	G_4.76E+04	4.41E+04	G_4.41E+04	3.50E+03	G_3.50E+03
Inf-100000C	2019	5	9	5-2019	Inf-100000C	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_G_1.00E-05	non-blank	1.00E-05	G_1.00E-05	7.50E+00	G_7.50E+00	4.76E+04	G_4.76E+04	4.41E+04	G_4.41E+04	3.50E+03	G_3.50E+03
Inf-10000A	2019	5	9	5-2019	Inf-10000A	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_H_1.00E-04	non-blank	1.00E-04	H_1.00E-04	7.50E+01	H_7.50E+01	5.50E+04	H_5.50E+04	4.72E+04	H_4.72E+04	7.71E+03	H_7.71E+03
Inf-10000B	2019	5	9	5-2019	Inf-10000B	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_H_1.00E-04	non-blank	1.00E-04	H_1.00E-04	7.50E+01	H_7.50E+01	5.50E+04	H_5.50E+04	4.72E+04	H_4.72E+04	7.71E+03	H_7.71E+03
Inf-10000C	2019	5	9	5-2019	Inf-10000C	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_H_1.00E-04	non-blank	1.00E-04	H_1.00E-04	7.50E+01	H_7.50E+01	5.50E+04	H_5.50E+04	4.72E+04	H_4.72E+04	7.71E+03	H_7.71E+03
Inf-1000A	2019	5	9	5-2019	Inf-1000A	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_I_1.00E-03	non-blank	1.00E-03	I_1.00E-03	7.50E+02	I_7.50E+02	1.25E+05	I_1.25E+05	7.08E+04	I_7.08E+04	5.44E+04	I_5.44E+04
Inf-1000B	2019	5	9	5-2019	Inf-1000B	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_I_1.00E-03	non-blank	1.00E-03	I_1.00E-03	7.50E+02	I_7.50E+02	1.25E+05	I_1.25E+05	7.08E+04	I_7.08E+04	5.44E+04	I_5.44E+04
Inf-1000C	2019	5	9	5-2019	Inf-1000C	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_I_1.00E-03	non-blank	1.00E-03	I_1.00E-03	7.50E+02	I_7.50E+02	1.25E+05	I_1.25E+05	7.08E+04	I_7.08E+04	5.44E+04	I_5.44E+04
Inf-100A	2019	5	9	5-2019	Inf-100A	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_J_1.00E-02	non-blank	1.00E-02	J_1.00E-02	7.50E+03	J_7.50E+03	7.32E+05	J_7.32E+05	2.71E+05	J_2.71E+05	4.61E+05	J_4.61E+05
Inf-100B	2019	5	9	5-2019	Inf-100B	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_J_1.00E-02	non-blank	1.00E-02	J_1.00E-02	7.50E+03	J_7.50E+03	7.32E+05	J_7.32E+05	2.71E+05	J_2.71E+05	4.61E+05	J_4.61E+05
Inf-100C	2019	5	9	5-2019	Inf-100C	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_J_1.00E-02	non-blank	1.00E-02	J_1.00E-02	7.50E+03	J_7.50E+03	7.32E+05	J_7.32E+05	2.71E+05	J_2.71E+05	4.61E+05	J_4.61E+05
Inf-10A	2019	5	9	5-2019	Inf-10A	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_K_1.00E-01	non-blank	1.00E-01	K_1.00E-01	7.50E+04	K_7.50E+04	6.49E+06	K_6.49E+06	4.07E+06	K_4.07E+06	2.48E+06	K_2.48E+06
Inf-10B	2019	5	9	5-2019	Inf-10B	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_K_1.00E-01	non-blank	1.00E-01	K_1.00E-01	7.50E+04	K_7.50E+04	6.49E+06	K_6.49E+06	4.07E+06	K_4.07E+06	2.48E+06	K_2.48E+06
Inf-10C	2019	5	9	5-2019	Inf-10C	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_K_1.00E-01	non-blank	1.00E-01	K_1.00E-01	7.50E+04	K_7.50E+04	6.49E+06	K_6.49E+06	4.07E+06	K_4.07E+06	2.48E+06	K_2.48E+06
InF-A	2019	5	9	5-2019	Inf-A	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_L_1.00E+00	non-blank	1.00E+00	L_1.00E+00	7.50E+05	L_7.50E+05	6.26E+07	L_6.26E+07	1.44E+07	L_1.44E+07	4.82E+07	L_4.82E+07
Inf-B	2019	5	9	5-2019	Inf-B	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_L_1.00E+00	non-blank	1.00E+00	L_1.00E+00	7.50E+05	L_7.50E+05	6.26E+07	L_6.26E+07	1.44E+07	L_1.44E+07	4.82E+07	L_4.82E+07
Inf-C	2019	5	9	5-2019	Inf-C	Sample	Sewage_contamintion	Sewage_contamintion_Sample	Sewage_contamintion_L_1.00E+00	non-blank	1.00E+00	L_1.00E+00	7.50E+05	L_7.50E+05	6.26E+07	L_6.26E+07	1.44E+07	L_1.44E+07	4.82E+07	L_4.82E+07
Mock-Cell	2019	5	9	5-2019	Mock-Cell	Mock	Sewage_contamintion	Sewage_contamintion_Mock	Sewage_contamintion_A_Mock	non-blank	0.00E+00	A_Mock	0.00E+00	A_Mock_0.00E+00	0.00E+00	A_Mock	0.00E+00	A_Mock	0.00E+00	A_Mock
sewageDrinkA	2019	5	9	5-2019	SewintodDrinkA	Drinkingwater	Sewage_contamintion	Sewage_contamintion_Drinkingwater	Sewage_contamintion_C_Dw	non-blank	0.00E+00	C_Dw	0.00E+00	C_Dw_0.00E+00	1.27E+05	C_Dw_1.27E+05	1.19E+05	C_Dw_1.19E+05	8.17E+04	C_Dw_8.17E+04
sewageDrinkB	2019	5	9	5-2019	SewintodDrinkB	Drinkingwater	Sewage_contamintion	Sewage_contamintion_Drinkingwater	Sewage_contamintion_C_Dw	non-blank	0.00E+00	C_Dw	0.00E+00	C_Dw_0.00E+00	1.27E+05	C_Dw_1.27E+05	1.19E+05	C_Dw_1.19E+05	8.17E+04	C_Dw_8.17E+04
sewageDrinkC	2019	5	9	5-2019	SewintodDrinkC	Drinkingwater	Sewage_contamintion	Sewage_contamintion_Drinkingwater	Sewage_contamintion_C_Dw	non-blank	0.00E+00	C_Dw	0.00E+00	C_Dw_0.00E+00	1.27E+05	C_Dw_1.27E+05	1.19E+05	C_Dw_1.19E+05	8.17E+04	C_Dw_8.17E+04