Postcode,In Use?,Latitude,Longitude,Easting,Northing,Grid Ref,Introduced,Terminated,Altitude,Population,Households,Nearest Station,Distance To Station (KM),Built Up Area,Built Up Area Sub-Division,Water Company,Sewage Company,District,Ward,County Electoral Division EH22 2FB,Yes,55.894795,-3.039220,335108,667340,NT351673,5/1/2012 12:00:00 AM,,84,,,Eskbank,3.1,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FD,Yes,55.893224,-3.040041,335054,667166,NT350671,12/1/2009 12:00:00 AM,,86,20,7,Eskbank,3.0,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FE,Yes,55.894945,-3.042726,334889,667360,NT348673,9/1/2008 12:00:00 AM,,69,73,37,Eskbank,2.9,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FF,Yes,55.894749,-3.044084,334804,667340,NT348673,10/1/2008 12:00:00 AM,,79,27,12,Eskbank,2.8,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FG,Yes,55.894770,-3.041026,334995,667339,NT349673,5/1/2011 12:00:00 AM,,76,,,Eskbank,3.0,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FH,Yes,55.896004,-3.041287,334981,667477,NT349674,1/1/2009 12:00:00 AM,,69,32,18,Eskbank,3.0,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FJ,Yes,55.895270,-3.039264,335106,667393,NT351673,7/1/2009 12:00:00 AM,,81,30,12,Eskbank,3.1,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FL,Yes,55.895676,-3.040155,335051,667439,NT350674,8/1/2010 12:00:00 AM,,75,47,18,Eskbank,3.1,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FN,Yes,55.895567,-3.038185,335174,667425,NT351674,8/1/2009 12:00:00 AM,,86,21,7,Eskbank,3.2,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FP,Yes,55.893173,-3.040807,335006,667161,NT350671,7/1/2008 12:00:00 AM,,84,26,7,Eskbank,2.9,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FQ,Yes,55.896821,-3.039706,335081,667566,NT350675,2/1/2012 12:00:00 AM,,70,,,Eskbank,3.2,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FR,Yes,55.897423,-3.040238,335049,667633,NT350676,2/1/2014 12:00:00 AM,,65,,,Eskbank,3.2,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FS,Yes,55.896195,-3.042583,334900,667499,NT349674,4/1/2015 12:00:00 AM,,64,,,Eskbank,3.0,,,Scottish Water,,Midlothian,Dalkeith, EH22 2FZ,Yes,55.889815,-3.024957,335992,666773,NT359667,4/1/2020 12:00:00 AM,,64,,,Eskbank,3.7,,,Scottish Water,,Midlothian,Midlothian East, EH22 2GA,Yes,55.888899,-3.054623,334135,666698,NT341666,12/1/2015 12:00:00 AM,,67,,,Eskbank,1.9,,,Scottish Water,,Midlothian,Midlothian East, EH22 2GL,Yes,55.904575,-3.002457,337423,668395,NT374683,5/1/2021 12:00:00 AM,,73,,,Wallyford,4.0,,,Scottish Water,,Midlothian,Midlothian East, EH22 2LB,Yes,55.890117,-3.056667,334009,666836,NT340668,1/1/1980 12:00:00 AM,,61,76,41,Eskbank,1.9,,,Scottish Water,,Midlothian,Dalkeith, EH22 2LD,Yes,55.890621,-3.058711,333882,666894,NT338668,1/1/1980 12:00:00 AM,,56,108,55,Eskbank,1.8,,,Scottish Water,,Midlothian,Dalkeith, EH22 2LE,Yes,55.890440,-3.059841,333811,666875,NT338668,1/1/1980 12:00:00 AM,,52,95,46,Eskbank,1.7,,,Scottish Water,,Midlothian,Dalkeith, EH22 2LF,Yes,55.889774,-3.056945,333991,666798,NT339667,1/1/1980 12:00:00 AM,,62,72,36,Eskbank,1.9,,,Scottish Water,,Midlothian,Dalkeith, EH22 2LG,Yes,55.889278,-3.048650,334509,666735,NT345667,6/1/1997 12:00:00 AM,,76,28,25,Eskbank,2.3,,,Scottish Water,,Midlothian,Dalkeith, EH22 2LH,Yes,55.889879,-3.047738,334567,666801,NT345668,1/1/1980 12:00:00 AM,,76,88,37,Eskbank,2.4,,,Scottish Water,,Midlothian,Dalkeith, EH22 2LJ,Yes,55.889960,-3.046637,334636,666809,NT346668,1/1/1980 12:00:00 AM,,79,131,54,Eskbank,2.4,,,Scottish Water,,Midlothian,Dalkeith, EH22 2LL,Yes,55.889577,-3.046259,334659,666766,NT346667,1/1/1980 12:00:00 AM,,83,38,17,Eskbank,2.5,,,Scottish Water,,Midlothian,Dalkeith, EH22 2LN,Yes,55.890810,-3.045045,334737,666902,NT347669,1/1/1980 12:00:00 AM,,81,50,27,Eskbank,2.6,,,Scottish Water,,Midlothian,Dalkeith, EH22 2NT,Yes,55.904785,-3.001371,337491,668417,NT374684,1/1/1980 12:00:00 AM,,147,14,4,Wallyford,4.0,,,Scottish Water,,Midlothian,Midlothian East, EH22 2NU,Yes,55.904426,-2.999202,337626,668375,NT376683,1/1/1980 12:00:00 AM,,153,26,11,Wallyford,4.1,,,Scottish Water,,Midlothian,Midlothian East, EH22 2NX,Yes,55.898110,-2.999136,337620,667672,NT376676,1/1/1980 12:00:00 AM,,166,13,6,Wallyford,4.8,,,Scottish Water,,Midlothian,Midlothian East, EH22 2NY,No,55.905120,-2.997844,337712,668451,NT377684,1/1/1980 12:00:00 AM,2/1/2005 12:00:00 AM,152,,,Wallyford,4.1,,,Scottish Water,,Midlothian,Midlothian East, EH22 2NZ,Yes,55.905273,-2.994441,337925,668465,NT379684,1/1/1980 12:00:00 AM,,155,46,21,Wallyford,4.1,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PA,Yes,55.904420,-2.996103,337820,668372,NT378683,1/1/1980 12:00:00 AM,,160,51,22,Wallyford,4.2,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PB,Yes,55.906138,-2.975609,339104,668545,NT391685,1/1/1980 12:00:00 AM,,132,3,2,Wallyford,4.5,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PD,Yes,55.906303,-2.967248,339627,668556,NT396685,1/1/1980 12:00:00 AM,,106,9,3,Wallyford,4.8,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PE,Yes,55.898905,-2.978382,338919,667742,NT389677,1/1/1980 12:00:00 AM,,119,5,3,Wallyford,5.1,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PF,Yes,55.894447,-2.967252,339608,667236,NT396672,1/1/1980 12:00:00 AM,,98,14,5,Wallyford,5.9,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PG,Yes,55.892717,-2.985869,338441,667060,NT384670,1/1/1980 12:00:00 AM,,145,6,3,Wallyford,5.6,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PH,Yes,55.889754,-3.024779,336003,666766,NT360667,1/1/1980 12:00:00 AM,,128,0,0,Eskbank,3.7,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PJ,Yes,55.902812,-3.007622,337097,668203,NT370682,1/1/1980 12:00:00 AM,,129,3,1,Wallyford,4.2,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PL,Yes,55.904138,-2.998703,337657,668343,NT376683,1/1/1980 12:00:00 AM,,156,11,4,Wallyford,4.1,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PN,Yes,55.903637,-3.000046,337572,668288,NT375682,1/1/1980 12:00:00 AM,,155,22,12,Wallyford,4.2,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PP,Yes,55.902945,-2.999004,337636,668210,NT376682,1/1/1980 12:00:00 AM,,162,17,8,Wallyford,4.3,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PQ,Yes,55.889997,-3.000126,337545,666770,NT375667,1/1/1980 12:00:00 AM,,177,18,7,Newtongrange,5.0,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PR,No,55.901406,-3.009248,336993,668048,NT369680,6/1/2002 12:00:00 AM,11/1/2005 12:00:00 AM,124,,,Wallyford,4.3,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PT,Yes,55.904684,-2.998377,337678,668403,NT376684,12/1/1982 12:00:00 AM,,153,3,1,Wallyford,4.1,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PU,Yes,55.888072,-3.053706,334191,666606,NT341666,1/1/1980 12:00:00 AM,,67,1,1,Eskbank,2.0,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PW,Yes,55.903508,-2.998251,337684,668272,NT376682,1/1/1980 12:00:00 AM,,160,34,16,Wallyford,4.2,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PX,Yes,55.885125,-3.046303,334649,666271,NT346662,1/1/1980 12:00:00 AM,,86,4,3,Eskbank,2.3,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PY,No,55.888391,-3.043126,334853,666631,NT348666,1/1/1980 12:00:00 AM,2/1/2008 12:00:00 AM,95,,,Eskbank,2.6,,,Scottish Water,,Midlothian,Midlothian East, EH22 2PZ,No,55.890063,-3.039829,335062,666814,NT350668,1/1/1980 12:00:00 AM,2/1/2009 12:00:00 AM,102,,,Eskbank,2.8,,,Scottish Water,,Midlothian,Dalkeith, EH22 2QA,Yes,55.893226,-3.039310,335100,667166,NT350671,1/1/1980 12:00:00 AM,,90,11,7,Eskbank,3.0,,,Scottish Water,,Midlothian,Dalkeith, EH22 2QB,Yes,55.889514,-3.039451,335085,666753,NT350667,1/1/1980 12:00:00 AM,,106,0,0,Eskbank,2.9,,,Scottish Water,,Midlothian,Midlothian East, EH22 2QD,Yes,55.887372,-3.032850,335494,666508,NT354665,1/1/1980 12:00:00 AM,,131,44,17,Eskbank,3.2,,,Scottish Water,,Midlothian,Midlothian East, EH22 2QE,Yes,55.880271,-3.010506,336880,665697,NT368656,1/1/1980 12:00:00 AM,,185,3,1,Newtongrange,4.0,,,Scottish Water,,Midlothian,Midlothian East, EH22 2QF,No,55.877032,-3.014258,336640,665340,NT366653,1/1/1980 12:00:00 AM,10/1/2003 12:00:00 AM,201,,,Newtongrange,3.6,,,Scottish Water,,Midlothian,Midlothian East, EH22 2QG,Yes,55.884454,-3.025662,335939,666177,NT359661,1/1/1980 12:00:00 AM,,166,3,2,Newtongrange,3.3,,,Scottish Water,,Midlothian,Midlothian East, EH22 2QH,Yes,55.886937,-3.035460,335330,666462,NT353664,12/1/2000 12:00:00 AM,,127,28,12,Eskbank,3.0,,,Scottish Water,,Midlothian,Midlothian East, EH22 2QJ,Yes,55.886715,-3.047845,334555,666449,NT345664,8/1/2003 12:00:00 AM,,89,31,12,Eskbank,2.3,,,Scottish Water,,Midlothian,Midlothian East, EH22 2QL,Yes,55.886907,-3.029384,335710,666453,NT357664,6/1/2001 12:00:00 AM,,136,16,5,Newtongrange,3.3,,,Scottish Water,,Midlothian,Midlothian East, EH22 2QP,Yes,55.905247,-2.999799,337590,668467,NT375684,4/1/2005 12:00:00 AM,,148,43,19,Wallyford,4.0,,,Scottish Water,,Midlothian,Midlothian East, EH22 2QQ,Yes,55.891948,-3.042246,334914,667026,NT349670,7/1/2006 12:00:00 AM,,85,46,16,Eskbank,2.8,,,Scottish Water,,Midlothian,Dalkeith, EH22 2QR,Yes,55.892051,-3.041641,334952,667037,NT349670,11/1/2007 12:00:00 AM,,87,12,4,Eskbank,2.8,,,Scottish Water,,Midlothian,Dalkeith, EH22 2QS,Yes,55.890070,-3.042163,334916,666817,NT349668,9/1/2007 12:00:00 AM,,91,35,11,Eskbank,2.7,,,Scottish Water,,Midlothian,Dalkeith, EH22 2QT,Yes,55.889851,-3.042621,334887,666793,NT348667,1/1/2007 12:00:00 AM,,91,24,6,Eskbank,2.7,,,Scottish Water,,Midlothian,Dalkeith, EH22 2QU,Yes,55.889763,-3.044458,334772,666785,NT347667,7/1/2006 12:00:00 AM,,87,36,11,Eskbank,2.6,,,Scottish Water,,Midlothian,Dalkeith, EH22 2QW,Yes,55.904200,-3.002144,337442,668353,NT374683,8/1/1983 12:00:00 AM,,147,6,2,Wallyford,4.1,,,Scottish Water,,Midlothian,Midlothian East, EH22 2QX,Yes,55.889673,-3.043432,334836,666774,NT348667,1/1/2006 12:00:00 AM,,89,52,14,Eskbank,2.6,,,Scottish Water,,Midlothian,Dalkeith, EH22 2QY,Yes,55.889373,-3.042800,334875,666740,NT348667,7/1/2006 12:00:00 AM,,92,37,11,Eskbank,2.6,,,Scottish Water,,Midlothian,Dalkeith, EH22 2QZ,Yes,55.889921,-3.043902,334807,666802,NT348668,9/1/2005 12:00:00 AM,,88,27,9,Eskbank,2.6,,,Scottish Water,,Midlothian,Dalkeith, EH22 2RA,Yes,55.891065,-3.041407,334965,666927,NT349669,9/1/2006 12:00:00 AM,,91,67,19,Eskbank,2.8,,,Scottish Water,,Midlothian,Dalkeith, EH22 2RB,Yes,55.891269,-3.039573,335080,666948,NT350669,9/1/2006 12:00:00 AM,,95,166,55,Eskbank,2.9,,,Scottish Water,,Midlothian,Dalkeith, EH22 2RD,Yes,55.891898,-3.038583,335143,667017,NT351670,6/1/2009 12:00:00 AM,,96,7,3,Eskbank,3.0,,,Scottish Water,,Midlothian,Dalkeith, EH22 2RE,Yes,55.903728,-2.997189,337751,668296,NT377682,4/1/2016 12:00:00 AM,,163,,,Wallyford,4.2,,,Scottish Water,,Midlothian,Midlothian East, EH22 4HS,Yes,55.888091,-3.050872,334368,666605,NT343666,1/1/1980 12:00:00 AM,,73,127,55,Eskbank,2.1,,,Scottish Water,,Midlothian,Midlothian East, EH22 4HT,Yes,55.887444,-3.051974,334298,666534,NT342665,1/1/1980 12:00:00 AM,,71,87,34,Eskbank,2.0,,,Scottish Water,,Midlothian,Midlothian East, EH22 4HU,Yes,55.886585,-3.052542,334261,666439,NT342664,1/1/1980 12:00:00 AM,,73,36,18,Eskbank,2.0,,,Scottish Water,,Midlothian,Midlothian East, EH22 4HX,Yes,55.886005,-3.053166,334221,666375,NT342663,1/1/1980 12:00:00 AM,,74,108,40,Eskbank,1.9,,,Scottish Water,,Midlothian,Midlothian East, EH22 4HY,Yes,55.885470,-3.052656,334252,666315,NT342663,1/1/1980 12:00:00 AM,,78,73,30,Eskbank,1.9,,,Scottish Water,,Midlothian,Midlothian East, EH22 4HZ,Yes,55.884392,-3.053697,334185,666196,NT341661,1/1/1980 12:00:00 AM,,83,95,41,Eskbank,1.9,,,Scottish Water,,Midlothian,Midlothian East, EH22 4JA,Yes,55.886670,-3.051073,334353,666447,NT343664,1/1/1980 12:00:00 AM,,77,60,22,Eskbank,2.1,,,Scottish Water,,Midlothian,Midlothian East, EH22 5DP,Yes,55.880624,-3.040875,334981,665764,NT349657,3/1/2012 12:00:00 AM,,143,,,Newtongrange,2.3,,,Scottish Water,,Midlothian,Midlothian East, EH22 5DW,Yes,55.880190,-3.040192,335023,665716,NT350657,4/1/2012 12:00:00 AM,,147,,,Newtongrange,2.3,,,Scottish Water,,Midlothian,Midlothian East, EH22 5NG,Yes,55.878596,-3.043215,334831,665541,NT348655,4/1/2012 12:00:00 AM,,139,,,Newtongrange,2.1,,,Scottish Water,,Midlothian,Midlothian East, EH22 5NH,Yes,55.879446,-3.042534,334875,665635,NT348656,2/1/2012 12:00:00 AM,,140,,,Newtongrange,2.2,,,Scottish Water,,Midlothian,Midlothian East, EH22 5NJ,Yes,55.879025,-3.043450,334817,665589,NT348655,4/1/2012 12:00:00 AM,,137,,,Newtongrange,2.1,,,Scottish Water,,Midlothian,Midlothian East, EH22 5NN,Yes,55.879957,-3.042232,334895,665692,NT348656,8/1/2012 12:00:00 AM,,141,,,Newtongrange,2.2,,,Scottish Water,,Midlothian,Midlothian East, EH22 5RQ,Yes,55.863768,-3.038103,335126,663886,NT351638,10/1/2013 12:00:00 AM,,197,,,Newtongrange,2.0,,,Scottish Water,,Midlothian,Midlothian East, EH22 5TE,Yes,55.878138,-3.030898,335601,665478,NT356654,9/1/2017 12:00:00 AM,,195,,,Newtongrange,2.7,,,Scottish Water,,Midlothian,Midlothian East, EH22 5TG,Yes,55.879459,-3.029251,335706,665624,NT357656,1/1/1980 12:00:00 AM,,196,7,3,Newtongrange,2.9,,,Scottish Water,,Midlothian,Midlothian East, EH22 5TH,Yes,55.871409,-3.024867,335967,664724,NT359647,1/1/1980 12:00:00 AM,,228,8,3,Newtongrange,2.8,,,Scottish Water,,Midlothian,Midlothian East, EH22 5TJ,Yes,55.863394,-3.039851,335016,663846,NT350638,1/1/1980 12:00:00 AM,,191,8,3,Newtongrange,1.9,,,Scottish Water,,Midlothian,Midlothian East, EH22 5TQ,Yes,55.873417,-3.022155,336140,664945,NT361649,1/1/1980 12:00:00 AM,,224,8,3,Newtongrange,3.0,,,Scottish Water,,Midlothian,Midlothian East, EH23 4EA,No,55.850255,-3.048604,334446,662392,NT344623,1/1/2007 12:00:00 AM,1/1/2007 12:00:00 AM,188,,,Gorebridge,1.1,,,Scottish Water,,Midlothian,Midlothian South, EH23 4EB,No,55.850763,-3.050136,334351,662450,NT343624,1/1/1980 12:00:00 AM,3/1/2002 12:00:00 AM,178,,,Gorebridge,1.2,,,Scottish Water,,Midlothian,Midlothian South, EH23 4EE,Yes,55.851277,-3.049942,334364,662507,NT343625,1/1/1980 12:00:00 AM,,177,7,3,Gorebridge,1.2,,,Scottish Water,,Midlothian,Midlothian South, EH23 4EF,No,55.851863,-3.050756,334314,662573,NT343625,1/1/1980 12:00:00 AM,3/1/2002 12:00:00 AM,172,,,Gorebridge,1.3,,,Scottish Water,,Midlothian,Midlothian South, EH23 4FE,Yes,55.850753,-3.050215,334346,662449,NT343624,8/1/2008 12:00:00 AM,,177,170,57,Gorebridge,1.2,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GH,No,55.846070,-3.039408,335015,661918,NT350619,1/1/2017 12:00:00 AM,3/1/2017 12:00:00 AM,206,,,Gorebridge,0.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GJ,Yes,55.846348,-3.040518,334946,661950,NT349619,10/1/2014 12:00:00 AM,,206,,,Gorebridge,0.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GL,Yes,55.844974,-3.039379,335015,661796,NT350617,12/1/2009 12:00:00 AM,,200,18,7,Gorebridge,0.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GN,Yes,55.845364,-3.039401,335014,661839,NT350618,2/1/2014 12:00:00 AM,,202,,,Gorebridge,0.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GP,Yes,55.845042,-3.040367,334953,661804,NT349618,4/1/2014 12:00:00 AM,,198,,,Gorebridge,0.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GQ,Yes,55.845395,-3.040604,334939,661844,NT349618,7/1/2016 12:00:00 AM,,162,,,Gorebridge,0.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GR,Yes,55.845858,-3.041079,334910,661896,NT349618,12/1/2015 12:00:00 AM,,201,,,Gorebridge,0.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GS,Yes,55.844925,-3.037170,335153,661788,NT351617,11/1/2008 12:00:00 AM,,205,26,9,Gorebridge,0.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GT,Yes,55.843945,-3.036170,335214,661678,NT352616,12/1/2008 12:00:00 AM,,204,53,19,Gorebridge,0.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GU,Yes,55.843456,-3.037706,335117,661625,NT351616,3/1/2011 12:00:00 AM,,197,,,Gorebridge,0.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GW,Yes,55.844192,-3.037725,335117,661707,NT351617,1/1/2010 12:00:00 AM,,200,65,22,Gorebridge,0.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GX,Yes,55.843123,-3.038735,335052,661589,NT350615,4/1/2012 12:00:00 AM,,193,,,Gorebridge,0.6,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GY,Yes,55.843467,-3.039590,334999,661628,NT349616,4/1/2013 12:00:00 AM,,192,,,Gorebridge,0.6,,,Scottish Water,,Midlothian,Midlothian South, EH23 4GZ,Yes,55.842746,-3.037623,335121,661546,NT351615,6/1/2011 12:00:00 AM,,195,,,Gorebridge,0.6,,,Scottish Water,,Midlothian,Midlothian South, EH23 4LB,No,55.843352,-3.035084,335281,661611,NT352616,9/1/2006 12:00:00 AM,10/1/2007 12:00:00 AM,207,,,Gorebridge,0.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4LD,Yes,55.839152,-3.041950,334844,661150,NT348611,4/1/2013 12:00:00 AM,,160,,,Gorebridge,0.3,,,Scottish Water,,Midlothian,Midlothian South, EH23 4LE,Yes,55.834872,-3.046023,334582,660678,NT345606,9/1/2017 12:00:00 AM,,152,,,Gorebridge,0.6,,,Scottish Water,,Midlothian,Midlothian South, EH23 4LF,Yes,55.834531,-3.043826,334719,660638,NT347606,10/1/2018 12:00:00 AM,,149,,,Gorebridge,0.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4NE,Yes,55.834277,-3.045160,334635,660611,NT346606,6/1/2018 12:00:00 AM,,154,,,Gorebridge,0.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4NF,Yes,55.833232,-3.045484,334613,660495,NT346604,12/1/2017 12:00:00 AM,,152,,,Gorebridge,0.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4NG,Yes,55.832616,-3.045004,334642,660426,NT346604,4/1/2018 12:00:00 AM,,152,,,Gorebridge,0.9,,,Scottish Water,,Midlothian,Midlothian South, EH23 4NJ,Yes,55.837699,-3.034746,335293,660982,NT352609,1/1/1980 12:00:00 AM,,183,2,1,Gorebridge,0.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4NL,Yes,55.845023,-3.035144,335280,661797,NT352617,1/1/1980 12:00:00 AM,,212,38,14,Gorebridge,0.9,,,Scottish Water,,Midlothian,Midlothian South, EH23 4NN,Yes,55.852956,-3.036892,335184,662682,NT351626,1/1/1980 12:00:00 AM,,202,0,0,Gorebridge,1.5,,,Scottish Water,,Midlothian,Midlothian South, EH23 4NP,Yes,55.854643,-3.025372,335908,662859,NT359628,1/1/1980 12:00:00 AM,,212,1,1,Gorebridge,2.1,,,Scottish Water,,Midlothian,Midlothian East, EH23 4NQ,Yes,55.832911,-3.044086,334700,660457,NT346604,1/1/2020 12:00:00 AM,,158,,,Gorebridge,0.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4NR,Yes,55.850827,-3.012473,336709,662422,NT367624,1/1/1980 12:00:00 AM,,192,4,2,Gorebridge,2.4,,,Scottish Water,,Midlothian,Midlothian East, EH23 4NS,Yes,55.852743,-3.011117,336797,662634,NT367626,1/1/1980 12:00:00 AM,,194,29,13,Gorebridge,2.6,,,Scottish Water,,Midlothian,Midlothian East, EH23 4NT,Yes,55.854240,-2.999020,337557,662790,NT375627,1/1/1980 12:00:00 AM,,179,9,3,Gorebridge,3.3,,,Scottish Water,,Midlothian,Midlothian East, EH23 4NU,Yes,55.857782,-2.997126,337681,663182,NT376631,1/1/1980 12:00:00 AM,,176,3,2,Gorebridge,3.6,,,Scottish Water,,Midlothian,Midlothian East, EH23 4NW,Yes,55.843967,-3.013560,336630,661660,NT366616,1/1/1980 12:00:00 AM,,215,13,3,Gorebridge,2.1,,,Scottish Water,,Midlothian,Midlothian East, EH23 4NX,Yes,55.866567,-2.994027,337889,664157,NT378641,1/1/1980 12:00:00 AM,,159,65,28,Gorebridge,4.4,,,Scottish Water,,Midlothian,Midlothian East, EH23 4NY,Yes,55.867639,-2.987683,338288,664271,NT382642,1/1/1980 12:00:00 AM,,151,5,2,Gorebridge,4.8,,,Scottish Water,,Midlothian,Midlothian East, EH23 4NZ,Yes,55.863672,-3.012999,336697,663852,NT366638,1/1/1980 12:00:00 AM,,208,8,4,Gorebridge,3.3,,,Scottish Water,,Midlothian,Midlothian East, EH23 4PA,Yes,55.852485,-3.007612,337016,662602,NT370626,1/1/1980 12:00:00 AM,,191,9,4,Gorebridge,2.8,,,Scottish Water,,Midlothian,Midlothian East, EH23 4PB,Yes,55.836533,-3.007411,337003,660827,NT370608,1/1/1980 12:00:00 AM,,202,6,3,Gorebridge,2.5,,,Scottish Water,,Midlothian,Midlothian South, EH23 4PD,Yes,55.841832,-3.029837,335607,661437,NT356614,1/1/1980 12:00:00 AM,,225,12,5,Gorebridge,1.1,,,Scottish Water,,Midlothian,Midlothian South, EH23 4PS,Yes,55.846843,-3.039856,334988,662004,NT349620,1/1/1980 12:00:00 AM,,210,12,4,Gorebridge,0.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4PT,Yes,55.846839,-3.039860,334988,662004,NT349620,7/1/2017 12:00:00 AM,,210,,,Gorebridge,0.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4PU,Yes,55.846839,-3.039860,334988,662004,NT349620,7/1/2017 12:00:00 AM,,210,,,Gorebridge,0.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4PY,Yes,55.845345,-3.035859,335236,661834,NT352618,7/1/2017 12:00:00 AM,,210,,,Gorebridge,0.9,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QA,Yes,55.831419,-3.039991,334954,660288,NT349602,1/1/1980 12:00:00 AM,,157,5,4,Gorebridge,1.1,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QB,Yes,55.834373,-3.048161,334447,660624,NT344606,1/1/1980 12:00:00 AM,,154,5,1,Gorebridge,0.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QD,Yes,55.832209,-3.046826,334527,660382,NT345603,1/1/1980 12:00:00 AM,,159,39,15,Gorebridge,0.9,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QE,No,55.831547,-3.042353,334806,660304,NT348603,2/1/1994 12:00:00 AM,12/1/1996 12:00:00 AM,160,,,Gorebridge,1.0,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QF,Yes,55.830893,-3.037866,335086,660227,NT350602,1/1/1980 12:00:00 AM,,148,21,8,Gorebridge,1.2,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QG,Yes,55.832504,-3.034831,335279,660403,NT352604,1/1/1980 12:00:00 AM,,168,4,2,Gorebridge,1.1,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QH,Yes,55.828248,-3.041419,334859,659936,NT348599,1/1/1980 12:00:00 AM,,166,5,1,Gorebridge,1.4,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QJ,Yes,55.827451,-3.035795,335210,659842,NT352598,1/1/1980 12:00:00 AM,,156,1,1,Gorebridge,1.6,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QL,Yes,55.825942,-3.036253,335179,659675,NT351596,1/1/1980 12:00:00 AM,,174,1,1,Gorebridge,1.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QN,Yes,55.824883,-3.037214,335117,659558,NT351595,1/1/1980 12:00:00 AM,,181,6,2,Gorebridge,1.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QP,Yes,55.815952,-3.030737,335508,658558,NT355585,1/1/1980 12:00:00 AM,,208,2,1,Gorebridge,2.9,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QQ,Yes,55.828384,-3.029514,335605,659940,NT356599,1/1/1980 12:00:00 AM,,167,7,3,Gorebridge,1.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QR,Yes,55.818133,-3.027762,335698,658798,NT356587,1/1/1980 12:00:00 AM,,202,5,2,Gorebridge,2.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QS,Yes,55.820130,-3.024304,335918,659017,NT359590,1/1/1980 12:00:00 AM,,201,63,33,Gorebridge,2.6,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QT,Yes,55.821247,-3.023340,335980,659140,NT359591,1/1/1980 12:00:00 AM,,205,15,7,Gorebridge,2.6,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QU,Yes,55.820410,-3.025664,335833,659049,NT358590,1/1/1980 12:00:00 AM,,203,111,45,Gorebridge,2.6,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QW,Yes,55.813808,-3.039920,334929,658328,NT349583,1/1/1980 12:00:00 AM,,241,8,4,Gorebridge,3.0,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QX,Yes,55.822579,-3.019388,336230,659285,NT362592,1/1/1980 12:00:00 AM,,192,4,2,Gorebridge,2.6,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QY,Yes,55.825662,-3.009984,336824,659619,NT368596,1/1/1980 12:00:00 AM,,168,7,2,Gorebridge,2.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4QZ,Yes,55.826475,-3.011553,336727,659711,NT367597,1/1/1980 12:00:00 AM,,155,5,3,Gorebridge,2.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4RA,Yes,55.829316,-3.007077,337012,660023,NT370600,1/1/1980 12:00:00 AM,,160,16,9,Gorebridge,2.7,,,Scottish Water,,Midlothian,Midlothian South, EH23 4RB,Yes,55.818937,-3.023407,335972,658883,NT359588,1/1/1980 12:00:00 AM,,203,59,24,Gorebridge,2.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4RD,No,55.812996,-3.010597,336765,658210,NT367582,1/1/1980 12:00:00 AM,1/1/2009 12:00:00 AM,239,,,Gorebridge,3.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4RE,Yes,55.812610,-3.016686,336383,658173,NT363581,1/1/1980 12:00:00 AM,,241,14,6,Gorebridge,3.6,,,Scottish Water,,Midlothian,Midlothian South, EH23 4RF,Yes,55.810100,-3.016394,336397,657893,NT363578,1/1/1980 12:00:00 AM,,250,22,12,Gorebridge,3.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4RH,Yes,55.809337,-3.006481,337017,657799,NT370577,1/1/1980 12:00:00 AM,,239,1,1,Gorebridge,4.3,,,Scottish Water,,Midlothian,Midlothian South, EH23 4RJ,Yes,55.816664,-2.999377,337474,658608,NT374586,1/1/1980 12:00:00 AM,,239,10,4,Gorebridge,3.9,,,Scottish Water,,Midlothian,Midlothian South, EH23 4RL,Yes,55.811633,-2.985497,338336,658036,NT383580,1/1/1980 12:00:00 AM,,257,4,1,Gorebridge,5.0,,,Scottish Water,,Midlothian,Midlothian South, EH23 4RN,Yes,55.830561,-3.037793,335090,660190,NT350601,2/1/1983 12:00:00 AM,,148,2,1,Gorebridge,1.2,,,Scottish Water,,Midlothian,Midlothian South, EH23 4RP,Yes,55.818224,-3.023819,335945,658804,NT359588,9/1/2002 12:00:00 AM,,206,49,18,Gorebridge,2.8,,,Scottish Water,,Midlothian,Midlothian South, EH23 4RU,Yes,55.832814,-3.052813,334153,660455,NT341604,1/1/1980 12:00:00 AM,,161,2,1,Gorebridge,0.9,,,Scottish Water,,Midlothian,Midlothian South, EH23 4SU,Yes,55.821047,-3.020960,336129,659116,NT361591,12/1/2019 12:00:00 AM,,245,,,Gorebridge,2.7,,,Scottish Water,,Midlothian,Midlothian South, EH37 5AH,Yes,55.864288,-2.966534,339606,663879,NT396638,12/1/1998 12:00:00 AM,,167,69,23,Gorebridge,5.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5PP,Yes,55.862500,-2.961936,339891,663676,NT398636,6/1/2001 12:00:00 AM,,175,,,Gorebridge,5.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5PT,Yes,55.866762,-2.966260,339627,664154,NT396641,1/1/1980 12:00:00 AM,,160,62,28,Gorebridge,5.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5PU,Yes,55.867193,-2.966287,339626,664202,NT396642,1/1/1980 12:00:00 AM,,159,5,4,Gorebridge,5.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5PX,Yes,55.866290,-2.966284,339625,664102,NT396641,1/1/1980 12:00:00 AM,,162,36,14,Gorebridge,5.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5PY,Yes,55.866853,-2.967141,339572,664165,NT395641,1/1/1980 12:00:00 AM,,159,6,2,Gorebridge,5.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5PZ,Yes,55.868301,-2.968763,339473,664328,NT394643,1/1/1980 12:00:00 AM,,150,51,23,Gorebridge,5.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QA,Yes,55.868880,-2.968853,339468,664392,NT394643,1/1/1980 12:00:00 AM,,148,0,0,Gorebridge,5.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QB,Yes,55.868013,-2.968884,339465,664296,NT394642,1/1/1980 12:00:00 AM,,148,52,22,Gorebridge,5.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QD,Yes,55.866635,-2.967487,339550,664141,NT395641,1/1/1980 12:00:00 AM,,158,34,17,Gorebridge,5.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QE,Yes,55.867256,-2.969137,339448,664212,NT394642,1/1/1980 12:00:00 AM,,151,36,16,Gorebridge,5.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QF,Yes,55.867831,-2.969626,339418,664276,NT394642,1/1/1980 12:00:00 AM,,149,8,4,Gorebridge,5.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QG,Yes,55.868395,-2.970507,339364,664340,NT393643,1/1/1980 12:00:00 AM,,144,7,4,Gorebridge,5.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QH,Yes,55.866960,-2.971318,339311,664181,NT393641,1/1/1980 12:00:00 AM,,143,58,22,Gorebridge,5.5,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QJ,Yes,55.865474,-2.971809,339278,664016,NT392640,1/1/1980 12:00:00 AM,,142,14,6,Gorebridge,5.4,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QL,Yes,55.866141,-2.972656,339226,664091,NT392640,1/1/1980 12:00:00 AM,,141,8,2,Gorebridge,5.4,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QN,Yes,55.866204,-2.971523,339297,664097,NT392640,1/1/1980 12:00:00 AM,,143,14,7,Gorebridge,5.5,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QP,Yes,55.865974,-2.970427,339365,664070,NT393640,1/1/1980 12:00:00 AM,,148,5,2,Gorebridge,5.5,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QQ,Yes,55.867792,-2.970700,339351,664273,NT393642,1/1/1980 12:00:00 AM,,142,34,16,Gorebridge,5.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QR,Yes,55.865672,-2.970551,339357,664036,NT393640,1/1/1980 12:00:00 AM,,149,3,2,Gorebridge,5.5,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QS,Yes,55.865098,-2.970521,339358,663973,NT393639,1/1/1980 12:00:00 AM,,149,37,14,Gorebridge,5.5,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QT,Yes,55.865353,-2.970000,339391,664001,NT393640,1/1/1980 12:00:00 AM,,150,16,8,Gorebridge,5.5,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QU,Yes,55.865854,-2.969673,339412,664056,NT394640,1/1/1980 12:00:00 AM,,151,24,10,Gorebridge,5.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QW,Yes,55.865532,-2.971299,339310,664022,NT393640,1/1/1980 12:00:00 AM,,145,16,6,Gorebridge,5.5,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QX,Yes,55.865629,-2.969176,339443,664031,NT394640,1/1/1980 12:00:00 AM,,153,7,3,Gorebridge,5.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QY,Yes,55.866287,-2.968921,339460,664104,NT394641,1/1/1980 12:00:00 AM,,153,54,25,Gorebridge,5.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5QZ,Yes,55.866520,-2.970141,339384,664131,NT393641,1/1/1980 12:00:00 AM,,149,72,26,Gorebridge,5.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RA,Yes,55.865947,-2.973259,339188,664069,NT391640,1/1/1980 12:00:00 AM,,140,11,5,Gorebridge,5.4,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RB,Yes,55.867612,-2.971782,339283,664253,NT392642,1/1/1980 12:00:00 AM,,140,77,28,Gorebridge,5.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RD,Yes,55.869116,-2.971420,339308,664421,NT393644,1/1/1980 12:00:00 AM,,138,4,4,Gorebridge,5.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RE,Yes,55.868904,-2.980012,338770,664405,NT387644,1/1/1980 12:00:00 AM,,116,29,14,Gorebridge,5.2,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RF,Yes,55.870895,-2.989411,338185,664634,NT381646,1/1/1980 12:00:00 AM,,148,4,2,Gorebridge,4.9,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RG,Yes,55.871990,-2.992344,338003,664759,NT380647,1/1/1980 12:00:00 AM,,154,4,1,Newtongrange,4.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RH,Yes,55.872672,-2.996441,337748,664839,NT377648,1/1/1980 12:00:00 AM,,170,2,2,Newtongrange,4.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RJ,Yes,55.874280,-3.000298,337509,665021,NT375650,1/1/1980 12:00:00 AM,,193,81,35,Newtongrange,4.4,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RL,Yes,55.875325,-3.002178,337393,665139,NT373651,1/1/1980 12:00:00 AM,,201,41,18,Newtongrange,4.3,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RN,Yes,55.876122,-3.000249,337515,665226,NT375652,1/1/1980 12:00:00 AM,,200,15,4,Newtongrange,4.4,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RP,Yes,55.876703,-3.005059,337215,665295,NT372652,1/1/1980 12:00:00 AM,,207,2,1,Newtongrange,4.2,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RQ,No,55.871887,-2.995106,337830,664750,NT378647,1/1/1980 12:00:00 AM,12/1/1999 12:00:00 AM,162,,,Newtongrange,4.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RR,Yes,55.875086,-3.005549,337182,665115,NT371651,1/1/1980 12:00:00 AM,,215,8,2,Newtongrange,4.1,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RS,No,55.875398,-3.003171,337331,665148,NT373651,7/1/2009 12:00:00 AM,5/1/2014 12:00:00 AM,204,4,1,Newtongrange,4.2,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RT,Yes,55.876696,-3.005399,337194,665295,NT371652,6/1/2015 12:00:00 AM,,209,,,Newtongrange,4.1,,,Scottish Water,,Midlothian,Midlothian East, EH37 5RW,Yes,55.875968,-3.003809,337292,665212,NT372652,1/1/1980 12:00:00 AM,,207,9,5,Newtongrange,4.2,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SG,Yes,55.864419,-2.964288,339747,663892,NT397638,1/1/1980 12:00:00 AM,,171,42,18,Gorebridge,5.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SH,Yes,55.862985,-2.961964,339890,663730,NT398637,1/1/1980 12:00:00 AM,,175,2,1,Gorebridge,5.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SJ,Yes,55.854145,-2.947960,340753,662734,NT407627,1/1/1980 12:00:00 AM,,202,5,2,Gorebridge,6.3,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SL,Yes,55.848271,-2.946475,340837,662079,NT408620,1/1/1980 12:00:00 AM,,218,4,2,Gorebridge,6.3,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SN,Yes,55.849036,-2.933317,341662,662153,NT416621,1/1/1980 12:00:00 AM,,203,1,1,Gorebridge,7.1,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SP,Yes,55.845182,-2.920145,342481,661713,NT424617,1/1/1980 12:00:00 AM,,209,2,1,Gorebridge,7.9,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SQ,Yes,55.864460,-2.963586,339791,663896,NT397638,1/1/1980 12:00:00 AM,,171,67,28,Gorebridge,5.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SR,Yes,55.858804,-2.927273,342055,663235,NT420632,1/1/1980 12:00:00 AM,,217,10,4,Gorebridge,7.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SS,Yes,55.853914,-2.907045,343314,662674,NT433626,1/1/1980 12:00:00 AM,,186,3,1,Gorebridge,8.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5ST,Yes,55.858020,-2.904584,343474,663129,NT434631,1/1/1980 12:00:00 AM,,181,8,2,Gorebridge,9.1,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SU,Yes,55.844214,-2.912520,342957,661599,NT429615,1/1/1980 12:00:00 AM,,192,27,11,Gorebridge,8.4,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SW,Yes,55.846961,-2.925653,342139,661916,NT421619,1/1/1980 12:00:00 AM,,196,6,2,Gorebridge,7.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SX,Yes,55.838181,-2.900962,343672,660918,NT436609,1/1/1980 12:00:00 AM,,240,5,2,Gorebridge,9.1,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SY,Yes,55.839058,-2.898986,343797,661014,NT437610,1/1/1980 12:00:00 AM,,239,40,21,Gorebridge,9.2,,,Scottish Water,,Midlothian,Midlothian East, EH37 5SZ,Yes,55.846249,-2.891906,344251,661809,NT442618,1/1/1980 12:00:00 AM,,199,6,4,Gorebridge,9.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5TA,Yes,55.842076,-2.886680,344572,661340,NT445613,1/1/1980 12:00:00 AM,,214,1,1,Gorebridge,10.0,,,Scottish Water,,Midlothian,Midlothian East, EH37 5TB,Yes,55.835637,-2.923548,342254,660654,NT422606,1/1/1980 12:00:00 AM,,223,5,3,Gorebridge,7.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5TD,Yes,55.832123,-2.893323,344142,660238,NT441602,1/1/1980 12:00:00 AM,,252,9,4,Gorebridge,9.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5TE,Yes,55.832423,-2.888376,344452,660267,NT444602,1/1/1980 12:00:00 AM,,253,2,1,Gorebridge,9.9,,,Scottish Water,,Midlothian,Midlothian East, EH37 5TF,Yes,55.824128,-2.874241,345326,659333,NT453593,12/1/2002 12:00:00 AM,,296,17,7,Gorebridge,10.9,,,Scottish Water,,Midlothian,Midlothian East, EH37 5TG,Yes,55.832044,-2.867214,345777,660208,NT457602,1/1/1980 12:00:00 AM,,241,4,2,Gorebridge,11.2,,,Scottish Water,,Midlothian,Midlothian East, EH37 5TH,Yes,55.864702,-2.965410,339677,663924,NT396639,3/1/1982 12:00:00 AM,,169,28,10,Gorebridge,5.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5TJ,Yes,55.865319,-2.966372,339618,663994,NT396639,3/1/1984 12:00:00 AM,,163,25,21,Gorebridge,5.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5TQ,Yes,55.838573,-2.868828,345685,660936,NT456609,1/1/1980 12:00:00 AM,,230,16,5,Gorebridge,11.1,,,Scottish Water,,Midlothian,Midlothian East, EH37 5TX,Yes,55.871507,-2.979786,338788,664694,NT387646,1/1/1980 12:00:00 AM,,133,8,2,Gorebridge,5.4,,,Scottish Water,,Midlothian,Midlothian East, EH37 5TY,Yes,55.877122,-2.986545,338374,665325,NT383653,1/1/1980 12:00:00 AM,,146,7,3,Newtongrange,5.3,,,Scottish Water,,Midlothian,Midlothian East, EH37 5TZ,Yes,55.880057,-2.989209,338212,665654,NT382656,1/1/1980 12:00:00 AM,,162,4,1,Newtongrange,5.2,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UA,Yes,55.884085,-2.990079,338164,666103,NT381661,1/1/1980 12:00:00 AM,,153,1,1,Newtongrange,5.3,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UB,Yes,55.879868,-2.984824,338486,665629,NT384656,1/1/1980 12:00:00 AM,,146,19,8,Newtongrange,5.5,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UD,No,55.878752,-2.979457,338820,665500,NT388655,1/1/1980 12:00:00 AM,12/1/1995 12:00:00 AM,130,,,Newtongrange,5.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UE,Yes,55.871775,-2.977699,338919,664722,NT389647,1/1/1980 12:00:00 AM,,131,1,1,Gorebridge,5.5,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UF,No,55.876183,-2.972440,339255,665208,NT392652,1/1/1980 12:00:00 AM,2/1/2009 12:00:00 AM,120,,,Gorebridge,6.1,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UG,Yes,55.881165,-2.969703,339434,665760,NT394657,1/1/1980 12:00:00 AM,,129,15,6,Newtongrange,6.4,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UH,Yes,55.878518,-2.953689,340432,665451,NT404654,1/1/1980 12:00:00 AM,,135,1,1,Gorebridge,7.2,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UN,Yes,55.879125,-2.944349,341017,665511,NT410655,1/1/1980 12:00:00 AM,,140,2,1,Gorebridge,7.7,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UP,Yes,55.875774,-2.954672,340366,665147,NT403651,1/1/1980 12:00:00 AM,,142,10,3,Gorebridge,7.0,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UQ,Yes,55.882133,-2.958585,340131,665858,NT401658,1/1/1980 12:00:00 AM,,138,17,9,Newtongrange,7.1,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UR,Yes,55.869023,-2.957431,340183,664398,NT401643,1/1/1980 12:00:00 AM,,169,5,3,Gorebridge,6.4,,,Scottish Water,,Midlothian,Midlothian East, EH37 5US,No,55.865084,-2.952093,340511,663955,NT405639,10/1/1992 12:00:00 AM,6/1/1997 12:00:00 AM,178,,,Gorebridge,6.5,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UT,Yes,55.861153,-2.946788,340837,663513,NT408635,1/1/1980 12:00:00 AM,,206,25,7,Gorebridge,6.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UU,Yes,55.854430,-2.960447,339972,662777,NT399627,1/1/1980 12:00:00 AM,,186,2,2,Gorebridge,5.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UW,Yes,55.877034,-2.962567,339874,665294,NT398652,1/1/1980 12:00:00 AM,,137,4,1,Gorebridge,6.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UX,Yes,55.851698,-2.959437,340031,662472,NT400624,1/1/1980 12:00:00 AM,,198,9,3,Gorebridge,5.6,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UY,Yes,55.847723,-2.978042,338860,662046,NT388620,1/1/1980 12:00:00 AM,,202,20,7,Gorebridge,4.4,,,Scottish Water,,Midlothian,Midlothian East, EH37 5UZ,Yes,55.847142,-2.982719,338566,661985,NT385619,1/1/1980 12:00:00 AM,,195,23,9,Gorebridge,4.1,,,Scottish Water,,Midlothian,Midlothian East, EH37 5XA,Yes,55.844145,-2.991107,338036,661659,NT380616,1/1/1980 12:00:00 AM,,172,3,1,Gorebridge,3.5,,,Scottish Water,,Midlothian,Midlothian East, EH37 5XB,Yes,55.855128,-2.981850,338633,662873,NT386628,1/1/1980 12:00:00 AM,,164,16,5,Gorebridge,4.4,,,Scottish Water,,Midlothian,Midlothian East, EH37 5XD,Yes,55.871642,-2.966141,339642,664697,NT396646,1/1/1980 12:00:00 AM,,141,3,1,Gorebridge,6.1,,,Scottish Water,,Midlothian,Midlothian East, EH37 5XP,Yes,55.840349,-2.933816,341618,661187,NT416611,1/1/1980 12:00:00 AM,,232,15,8,Gorebridge,7.0,,,Scottish Water,,Midlothian,Midlothian East, EH37 5XR,Yes,55.823171,-2.942210,341066,659282,NT410592,1/1/1980 12:00:00 AM,,235,15,5,Gorebridge,6.8,,,Scottish Water,,Midlothian,Midlothian East, EH37 5XS,Yes,55.823043,-2.967985,339451,659290,NT394592,1/1/1980 12:00:00 AM,,239,16,6,Gorebridge,5.3,,,Scottish Water,,Midlothian,Midlothian East, EH37 5XU,Yes,55.826459,-2.988778,338154,659689,NT381596,1/1/1980 12:00:00 AM,,233,4,2,Gorebridge,3.9,,,Scottish Water,,Midlothian,Midlothian South,