{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["metal2.csv"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"metal2.csv","index":0,"n_rows":49,"n_cols":30,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,29],[0,0,0,29],[11,3,13,3]],"flags":["formulas_cached_only"]}
["Table S4. Summary of the physical and chemical characteristics of the homes and water samples collected in this study"]
["Home","Approximate time of sampling ","Number of individuals residing in home","Have repairs to the home plumbing been performed within last 6 month?","Pressure district","Sample type","Home age (years)","PP or DS material","Water main age (years)","Stagnation time in PP (h)","Residence time in DS (h)","Water age = stagnation time + residence time (h)","DS residence time group","Free chlorine (mg/L as Cl2)","Total chlorine (mg/L as Cl2)","Monochloramine (mg/L as Cl2)","Ct (mg.min/L)","Cell count (cells/L) ","DOC (mg/L)","DO (mg/L)","Dissolved copper (μg/L) ","Dissolved iron (μg/L) ","Dissolved lead (μg/L) ","NDMA (ng/L ) ","Ammonium (mg/L as N)","Nitrate (mg/L as N)","Nitrite (mg/L as N)","Orthophosphate (mg/L as P)","pH","Temperature (oC)"]
[1,"1PM",3,"No","West High","Cold water PP*",46,"Copper",76,6,37.4,43.4,"long",1.26,2.9,1.6,4166,608000000,1.557,8.2,23.198,1.118,0.276,5,0.438,0.916,0.019,4.4,8.02,20]
[1,"1PM",3,"No","West High","DS water",46,"Cast iron 1920-1949",76,"NA",37.4,43.4,"long",0.346,2.1,1.754,3935.976,104000000,0.604,7.7,1.883,10.858,0,0,0.333,1.806,0.059,1.243,8.15,19]
[1,"1PM",3,"No","West High","Hot water",46,"Copper",76,6,37.4,43.4,"long",0.207,1.7,1.493,3887.7720000000004,10900000,0.404,4.6,1.41,2.66,0,60.1,0.324,1.806,0.032,3.285,7.98,60]
[2,"3PM",5,"No","Geddes","Cold water PP*",53,"Copper",36,6,37.3,43.3,"long",0,0.5,0.5,1299,1680000000,2.54,6.3,8.734,2.465,0.018,42.31,0.05,1.272,0.024,0.779,8.28,20]
[2,"3PM",5,"No","Geddes","DS water",53,"Cast iron after 1949",36,"NA",37.3,43.3,"long",0.346,2.1,1.754,3925.452,231000000,2.81,7.5,10.006,28.121,0.303,117.53,0.291,1.628,0,5.516,8.35,18]
[2,"3PM",5,"No","Geddes","Hot water",53,"Copper",36,6,37.3,43.3,"long",0.323,1.9,1.577,4097.046,10700000,2.58,4.3,5.447,10.69,0.216,9.9,0.27,1.806,0,5.327,8.65,47]
[3,"3PM",3,"No","Geddes","Cold water PP*",126,"Copper",96,6,27.3,33.3,"long",0.975,2,1.025,2047.9499999999996,363000000,3.29,7.5,24.511,2.002,0.041,0,0.353,1.806,0,0.527,8.87,19]
[3,"3PM",3,"No","Geddes","DS water",126,"Ductile Iron",96,"NA",27.3,33.3,"long",0.253,3.1,2.847,4663.3859999999995,106000000,3.25,8.2,3.036,5.97,0.026,14.85,0.323,1.628,0,0.569,8.75,18]
[3,"3PM",3,"No","Geddes","Hot water",126,"Copper",96,6,27.3,33.3,"long",1.371,2.4,1.029,2055.9419999999996,12500000,3.16,4.5,2.219,1.795,0,0,0.333,1.628,0,0.421,8.66,47]
[4,"6AM",2,"Aerators had been changed in downstairsbathroom","Geddes","Cold water PP*",89,"Copper",56,6.5,27.5,34,"long",0.183,1.9,1.717,3502.6800000000003,626000000,2.94,8.7,47.825,3.701,0.045,0,0.507,1.628,0,2.885,7.53,20]
[4,"6AM",2,null,"Geddes","DS water",89,"Ductile Iron",56,"NA",27.5,34,"long",0.114,2.9,2.786,4596.9,111000000,3.04,8.7,3.803,5.786,0.016,0,0.348,1.331,0,0.821,8.34,17]
[4,"6AM",2,null,"Geddes","Hot water",89,"Copper",56,6.5,27.5,34,"long",0.114,1.6,1.436,2929.44,8370000,2.93,3.4,6.712,1.778,0.031,103.81,0.431,1.806,0,0.485,8.65,57]
[5,"7AM",5,"No","Gravity","Cold water PP*",77,"Unknown",16,13,126.2,139.2,"long",0.894,1.3,0.406,3390.9120000000003,304000000,2.733,8.2,27.842,12.511,0.525,29.06,0.26,1.865,0,1.811,8.37,22]
[5,"7AM",5,"No","Gravity","DS water",77,"Ductile Iron",16,"NA",126.2,139.2,"long",0.405,2.1,1.695,12834.54,133000000,2.767,8.1,2.865,23.666,0.292,19.88,0.288,1.094,0,0.474,8.59,18]
[5,"7AM",5,"No","Gravity","Hot water",77,"Unknown",16,13,126.2,139.2,"long",0.149,1,0.801,6689.952,10900000,2.542,3.4,3.905,13.18,0.149,82.92,0.319,1.094,0.135,0.548,8.53,46]
[6,"9AM",4,"No","Southeast High","Cold water PP*",50,"Copper",56,6.5,110.2,116.7,"long",0.416,2.2,1.784,12491.568000000001,757000000,2.672,7.6,1.412,9.116,0.163,22.22,0.254,1.806,0.106,3.425,7.73,19]
[6,"9AM",4,"No","Southeast High","DS water",50,"Ductile Iron",56,"NA",110.2,116.7,"long",0.253,2.4,2.147,14195.963999999998,107000000,2.645,8.7,0.346,14.185,0.045,15.38,0.304,1.687,0,1.214,8.3,13]
[6,"9AM",4,"No","Southeast High","Hot water",50,"Copper",56,6.5,110.2,116.7,"long",0.897,1.6,0.703,4922.406,99100000,2.865,3.4,0.389,4.75,0,28.27,0.356,1.628,0,0.478,7.58,53]
[7,"3PM",4,"No","Gravity","Cold water PP*",88,"Plastic",96,6,63.64,69.64,"long",0.16,2.7,2.54,10613.135999999999,1550000000,2.634,7.5,8.089,75.632,0,15.85,0.394,1.094,0,0.414,8.33,21]
[7,"3PM",4,"No","Gravity","DS water",88,"Cast iron 1920-1949",96,"NA",63.64,69.64,"long",0.137,2.9,2.763,10550.2392,93100000,2.936,8.9,1.042,10.934,0,7.33,0.36,1.094,0,0.428,8.41,13]
[7,"3PM",4,"No","Gravity","Hot water",88,"Plastic",96,6,63.64,69.64,"long",0.114,2.2,2.086,8716.142399999999,11000000,2.814,3.2,2.569,7.18,0,18.3,0.425,1.806,0,0.506,8.59,49]
[8,"3PM",4,"No","Gravity","Cold water PP*",66,"Plastic",56,7.5,17.04,24.54,"short",0.137,1.6,1.463,2154.1212,2850000000,1.827,9.2,19.037,38.47,0,10.86,0.275,1.272,0,0.464,9.11,20]
[8,"3PM",4,"No","Gravity","DS water",66,"Ductile Iron",56,"NA",17.04,24.54,"short",0.137,3,2.863,2927.1312,106000000,2.365,10.7,1.851,28.845,0,0,0.261,1.628,0,0.379,9.32,17]
[8,"3PM",4,"No","Gravity","Hot water",66,"Plastic",56,7.5,17.04,24.54,"short",0.09,1.7,1.61,2370.564,8830000,2.077,5.4,4.699,6.353,0,19.81,0.285,1.806,0,0.611,8.89,60]
[9,"6AM",4,"No","Northeast High","Cold water PP*",101,"Copper",116,8,15.92,23.92,"short",0.09,2.6,2.51,3602.352,871000000,3.458,10.1,14.089,4.213,0.325,10.69,0.331,1.628,0,1.025,8.93,20]
[9,"6AM",4,"No","Northeast High","DS water",101,"Cast iron before 1920",116,"NA",15.92,23.92,"short",0.37,3.1,2.73,2607.696,63900000,3.11,10.6,1.252,3.664,0.082,9.74,0.014,1.806,0,5.797,9.47,11]
[9,"6AM",4,"No","Northeast High","Hot water",101,"Copper",116,8,15.92,23.92,"short",0.277,2.4,2.123,3046.9296000000004,6250000,2.838,5.3,1.635,2.964,0.092,27.36,0.365,1.628,0,0.632,8.99,52]
[10,"2PM",3,"No","Gravity","Cold water PP*",66,"Copper",76,10.5,14.75,25.25,"short",1.6,2.5,0.9,1364,118000000,3.788,9.3,3.66,1.197,1.109,8.81,0.363,1.45,0,0.337,7.98,20]
[10,"2PM",3,"No","Gravity","DS water",66,"Cast iron 1920-1949",76,"NA",14.75,25.25,"short",0.37,3,2.63,2327.5499999999997,64900000,3.332,9.4,0.813,2.015,0.222,7.52,0.387,1.45,0,1.579,9,18]
[10,"2PM",3,"No","Gravity","Hot water",66,"Copper",76,10.5,14.75,25.25,"short",0.183,2.1,1.917,2904.255,60600000,3.552,3.9,0.834,0.711,0.268,30.8,0.51,1.628,0,0.344,8.37,52]
[11,"7AM",3,"No","Gravity","Cold water PP*",4,"Plastic",116,7,20.98,27.98,"short",0.11,2.2,2.1,3528,739000000,2.801,12.2,4.987,17.035,0,10.71,0.753,0.1,0.014,0.187,9.11,19]
[11,"7AM",3,"No","Gravity","DS water",4,"Cast iron before 1920",116,"NA",20.98,27.98,"short",0.16,2,1.84,2316.192,72200000,2.519,13.3,1.86,24.544,0,8.38,0.696,1.2,0.009,0.54,9.14,14]
[11,"7AM",3,"No","Gravity","Hot water",4,"Plastic",116,7,20.98,27.98,"short",0.525,1.5,0.975,1636.83,29800000,2.503,10.3,4.491,7.188,0,47.5,0.73,0.7,0.016,0.42,8.56,65]
[12,"7AM",3,"No","Northeast High","Cold water PP*",46,"Copper",56,6.5,13.9,20.4,"short",0.08,2.1,2,2448,1930000000,3.191,11.7,5.718,2.392,0.202,4.04,0.4,1.1,0.025,0.49,8.35,23]
[12,"7AM",3,"No","Northeast High","DS water",46,"Cast iron after 1949",56,"NA",13.9,20.4,"short",0.105,2.2,2.095,1747.2300000000002,899000000,3.024,13.8,0.658,46.686,0,6.07,0.29,1.3,0.014,0.35,8.81,13]
[12,"7AM",3,"No","Northeast High","Hot water",46,"Copper",56,6.5,13.9,20.4,"short",0.145,1.9,1.755,2148.12,92100000,2.879,9.3,1.484,4.107,0,11.39,0.318,0.9,0.017,0.54,8.21,56]
[13,"3PM",4,"No","Geddes","Cold water PP*",10,"Plastic",36,6,33.5,39.5,"long",0.04,2.3,2.3,5451,550000000,2.911,10.9,36.503,13.357,0.002,7.88,0.312,0.35,0.013,0.87,9.13,25]
[13,"3PM",4,"No","Geddes","DS water",10,"Cast iron after 1949",36,"NA",33.5,39.5,"long",0.075,3.2,3.125,6281.25,55300000,2.81,13.7,3.407,19.945,0,3.47,0.247,1.5,0,0.265,9.65,13]
[13,"3PM",4,"No","Geddes","Hot water",10,"Plastic",36,6,33.5,39.5,"long",0.065,0.6,0.485,1149.45,11100000,2.709,4.2,4.77,0.518,0.039,29.74,0.515,0.95,0.043,0.375,8.67,80]
[14,"2PM",4,"No","Northeast High","Cold water PP*",94,"Copper",96,10,13.89,23.89,"short",0.04,1.5,1.43,2008,93800000,2.804,12.199999999999998,35.938,0.695,0.115,15.56,1.07,0.667,0,0.403,9.3,17]
[14,"2PM",4,"No","Northeast High","DS water",94,"Cast iron 1920-1949",96,"NA",13.89,23.89,"short",0.045,2.9,2.855,2379.3570000000004,78000000,2.806,12.9,3.134,1.646,0,7.531,0.638,1.5,0,0.267,9.55,10]
[14,"2PM",4,"No","Northeast High","Hot water",94,"Copper",96,10,13.89,23.89,"short",0.07,1.5,1.463,2097.0642000000003,33200000,3.181,6.9,13.393,1.245,0.005,14.12,0.743,0.6,0.011,0.545,8.83,46]
[15,"7AM",3,"No","Northeast High","Cold water PP*",26,"Copper",56,6.5,23.94,30.44,"short",1.39,2.3,0.9,1644,85100000,1.959,11,14.623,16.5,0.089,11.66,0.926,0.767,0,0.67,9.16,20]
[15,"7AM",3,"No","Northeast High","DS water",26,"Ductile Iron",56,"NA",23.94,30.44,"short",0.04,2.5,2.46,3533.5440000000003,64600000,2.308,13.5,2.823,41.624,0,10.38,0.499,0.533,0.004,0.307,9.34,11]
[15,"7AM",3,"No","Northeast High","Hot water",26,"Copper",56,6.5,23.94,30.44,"short",0.135,1.3,1.165,2127.7560000000003,39000000,2.157,5.5,4.459,6.992,0,36.64,0.595,0.567,0.007,0.503,8.48,63]
[]
["*Cold water PP refers to the first 1 L of stagnated water collected after at least 6 h of stagnation"]