Postcode,In Use?,Latitude,Longitude,Easting,Northing,Grid Ref,Introduced,Terminated,Altitude,Population,Households,Nearest Station,Distance To Station (KM),Built Up Area,Water Company,Sewage Company,District,Ward,County Electoral Division EH19 3BF,Yes,55.868371,-3.093425,331672,664452,NT316644,8/1/2011 12:00:00 AM,,85,,,Newtongrange,1.5,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3BZ,Yes,55.863878,-3.100425,331226,663958,NT312639,3/1/2009 12:00:00 AM,,90,39,12,Newtongrange,2.0,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3DA,Yes,55.864937,-3.105632,330902,664082,NT309640,12/1/2009 12:00:00 AM,,101,92,41,Newtongrange,2.3,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3DB,Yes,55.864458,-3.102902,331072,664025,NT310640,10/1/2008 12:00:00 AM,,94,81,40,Newtongrange,2.1,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3DH,Yes,55.864539,-3.104949,330944,664037,NT309640,7/1/2008 12:00:00 AM,,100,40,12,Newtongrange,2.2,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3EY,Yes,55.865904,-3.099939,331260,664183,NT312641,1/1/2008 12:00:00 AM,,89,117,57,Newtongrange,1.9,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FA,Yes,55.869462,-3.090979,331827,664571,NT318645,6/1/1996 12:00:00 AM,,83,48,13,Newtongrange,1.4,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FB,Yes,55.869840,-3.091868,331772,664614,NT317646,6/1/1996 12:00:00 AM,,81,41,13,Newtongrange,1.4,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FE,Yes,55.870188,-3.089049,331949,664649,NT319646,6/1/1996 12:00:00 AM,,83,71,25,Newtongrange,1.3,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FH,Yes,55.865074,-3.101385,331168,664093,NT311640,9/1/2008 12:00:00 AM,,91,34,15,Newtongrange,2.0,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FJ,Yes,55.864334,-3.101780,331142,664011,NT311640,5/1/2010 12:00:00 AM,,92,28,9,Newtongrange,2.0,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FL,Yes,55.864711,-3.100736,331208,664051,NT312640,9/1/2010 12:00:00 AM,,90,26,11,Newtongrange,2.0,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FN,Yes,55.865047,-3.099403,331292,664088,NT312640,1/1/2008 12:00:00 AM,,88,92,31,Newtongrange,1.9,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FP,Yes,55.865130,-3.100157,331245,664098,NT312640,6/1/2008 12:00:00 AM,,89,35,14,Newtongrange,1.9,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FQ,Yes,55.864470,-3.098524,331346,664022,NT313640,6/1/2008 12:00:00 AM,,88,46,15,Newtongrange,1.8,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FR,Yes,55.865355,-3.097111,331436,664120,NT314641,3/1/2008 12:00:00 AM,,86,59,17,Newtongrange,1.7,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FS,Yes,55.866114,-3.100584,331220,664207,NT312642,11/1/2008 12:00:00 AM,,90,74,30,Newtongrange,1.9,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FT,Yes,55.866419,-3.101695,331151,664243,NT311642,6/1/2008 12:00:00 AM,,92,37,9,Newtongrange,2.0,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FW,Yes,55.866820,-3.100077,331253,664286,NT312642,7/1/2008 12:00:00 AM,,88,35,11,Newtongrange,1.9,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FX,Yes,55.866702,-3.098140,331374,664270,NT313642,6/1/2008 12:00:00 AM,,85,57,24,Newtongrange,1.8,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FY,Yes,55.867728,-3.098984,331323,664386,NT313643,8/1/2010 12:00:00 AM,,86,25,9,Newtongrange,1.8,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3FZ,Yes,55.869235,-3.093162,331690,664547,NT316645,8/1/2008 12:00:00 AM,,81,12,5,Newtongrange,1.5,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3GD,Yes,55.865830,-3.105258,330927,664181,NT309641,7/1/2011 12:00:00 AM,,101,,,Newtongrange,2.2,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3GJ,Yes,55.867515,-3.098738,331338,664362,NT313643,11/1/2010 12:00:00 AM,,85,12,4,Newtongrange,1.8,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3GP,Yes,55.865953,-3.102577,331095,664192,NT310641,5/1/2011 12:00:00 AM,,95,,,Newtongrange,2.1,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3GQ,Yes,55.866098,-3.103396,331044,664208,NT310642,4/1/2012 12:00:00 AM,,97,,,Newtongrange,2.1,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3GR,Yes,55.865552,-3.103157,331058,664147,NT310641,10/1/2011 12:00:00 AM,,96,,,Newtongrange,2.1,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3GS,Yes,55.867273,-3.094641,331594,664331,NT315643,12/1/2011 12:00:00 AM,,84,,,Newtongrange,1.6,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3GZ,Yes,55.868465,-3.093939,331640,664463,NT316644,11/1/2004 12:00:00 AM,,83,25,7,Newtongrange,1.5,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3HS,Yes,55.868086,-3.093065,331694,664419,NT316644,1/1/1980 12:00:00 AM,,81,2,1,Newtongrange,1.5,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3HT,Yes,55.865329,-3.090847,331828,664110,NT318641,1/1/1980 12:00:00 AM,,83,4,2,Newtongrange,1.4,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3HU,Yes,55.865671,-3.087772,332021,664145,NT320641,1/1/1980 12:00:00 AM,,79,6,2,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian South, EH19 3HX,Yes,55.864140,-3.090158,331869,663977,NT318639,1/1/1980 12:00:00 AM,,84,6,3,Newtongrange,1.3,,Scottish Water,,Midlothian,Midlothian South, EH19 3HY,Yes,55.861903,-3.090160,331865,663729,NT318637,1/1/1980 12:00:00 AM,,88,2,1,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian South, EH19 3HZ,Yes,55.857781,-3.096994,331430,663277,NT314632,1/1/1980 12:00:00 AM,,103,4,1,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian South, EH19 3JA,Yes,55.856169,-3.099392,331277,663100,NT312630,1/1/1980 12:00:00 AM,,107,16,7,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian South, EH19 3JB,Yes,55.860757,-3.082555,332339,663593,NT323635,1/1/1980 12:00:00 AM,,77,0,0,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH19 3JD,Yes,55.866597,-3.078531,332601,664239,NT326642,1/1/1980 12:00:00 AM,,73,6,1,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH19 3JE,Yes,55.858028,-3.077095,332676,663284,NT326632,1/1/1980 12:00:00 AM,,94,4,1,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH19 3JF,No,55.862205,-3.077258,332673,663749,NT326637,1/1/1980 12:00:00 AM,11/1/2018 12:00:00 AM,82,1,1,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH19 3JG,Yes,55.858669,-3.073694,332890,663352,NT328633,1/1/1980 12:00:00 AM,,95,11,6,Newtongrange,1.0,,Scottish Water,,Midlothian,Midlothian South, EH19 3JH,Yes,55.858192,-3.070677,333078,663296,NT330632,1/1/1980 12:00:00 AM,,100,4,2,Newtongrange,1.0,,Scottish Water,,Midlothian,Midlothian South, EH19 3JQ,Yes,55.861268,-3.071385,333039,663639,NT330636,9/1/1990 12:00:00 AM,,98,0,0,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH19 3NP,Yes,55.868497,-3.096337,331490,664468,NT314644,1/1/1980 12:00:00 AM,,83,111,48,Newtongrange,1.7,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3QP,Yes,55.864920,-3.108555,330719,664083,NT307640,12/1/2013 12:00:00 AM,,106,,,Newtongrange,2.5,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3SN,Yes,55.868366,-3.088839,331959,664446,NT319644,6/1/2023 12:00:00 AM,,73,,,Newtongrange,1.2,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3SP,Yes,55.868896,-3.088885,331957,664506,NT319645,2/1/2023 12:00:00 AM,,73,,,Newtongrange,1.2,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3SQ,Yes,55.868885,-3.088118,332005,664504,NT320645,1/1/2023 12:00:00 AM,,73,,,Newtongrange,1.2,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3SR,Yes,55.868493,-3.087724,332029,664460,NT320644,11/1/2023 12:00:00 AM,,73,,,Newtongrange,1.2,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3SS,Yes,55.865725,-3.103897,331012,664167,NT310641,10/1/2023 12:00:00 AM,,73,,,Newtongrange,2.2,,Scottish Water,,Midlothian,Bonnyrigg, EH19 3SZ,Yes,55.870609,-3.087176,332067,664694,NT320646,6/1/2024 12:00:00 AM,,115,,,Newtongrange,1.2,,,,Midlothian,Bonnyrigg, EH22 2PQ,Yes,55.889992,-3.000131,337545,666769,NT375667,1/1/1980 12:00:00 AM,,177,18,7,Newtongrange,5.0,,Scottish Water,,Midlothian,Midlothian East, EH22 2QE,Yes,55.880266,-3.010510,336880,665696,NT368656,1/1/1980 12:00:00 AM,,185,3,1,Newtongrange,4.0,,Scottish Water,,Midlothian,Midlothian East, EH22 2QF,No,55.877028,-3.014262,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.884529,-3.025249,335965,666184,NT359661,1/1/1980 12:00:00 AM,,166,3,2,Newtongrange,3.4,,Scottish Water,,Midlothian,Midlothian East, EH22 2QL,Yes,55.886903,-3.029388,335710,666453,NT357664,6/1/2001 12:00:00 AM,,136,16,5,Newtongrange,3.3,,Scottish Water,,Midlothian,Midlothian East, EH22 3LY,Yes,55.871465,-3.079848,332527,664783,NT325647,1/1/1980 12:00:00 AM,,64,2,1,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4AA,Yes,55.867559,-3.049347,334429,664318,NT344643,1/1/1980 12:00:00 AM,,136,,,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian East, EH22 4AB,No,55.871347,-3.047723,334537,664739,NT345647,1/1/1980 12:00:00 AM,11/1/2007 12:00:00 AM,129,,,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4AD,Yes,55.866856,-3.051677,334282,664242,NT342642,1/1/1980 12:00:00 AM,,134,0,0,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian East, EH22 4AE,Yes,55.867340,-3.050811,334337,664295,NT343642,1/1/1980 12:00:00 AM,,134,,,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian East, EH22 4AF,Yes,55.868160,-3.051600,334289,664388,NT342643,1/1/1980 12:00:00 AM,,130,,,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian East, EH22 4AG,No,55.865501,-3.057792,333897,664097,NT338640,7/1/1997 12:00:00 AM,1/1/1998 12:00:00 AM,115,,,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4AH,Yes,55.862833,-3.063998,333504,663807,NT335638,12/1/2001 12:00:00 AM,,106,36,15,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4AJ,No,55.865965,-3.054992,334073,664146,NT340641,1/1/1980 12:00:00 AM,8/1/2005 12:00:00 AM,126,,,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4AL,Yes,55.869240,-3.051437,334301,664508,NT343645,1/1/1980 12:00:00 AM,,126,6,3,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4AN,Yes,55.869255,-3.051773,334280,664510,NT342645,1/1/1980 12:00:00 AM,,124,5,2,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4AP,Yes,55.870435,-3.053499,334174,664643,NT341646,1/1/1980 12:00:00 AM,,116,4,1,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4AQ,Yes,55.862546,-3.062824,333577,663773,NT335637,6/1/2002 12:00:00 AM,,109,45,13,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4AR,Yes,55.870051,-3.051108,334323,664597,NT343645,1/1/1980 12:00:00 AM,,124,27,17,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4AS,Yes,55.869818,-3.052076,334262,664572,NT342645,1/1/1980 12:00:00 AM,,123,5,3,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4AT,Yes,55.870461,-3.051502,334299,664643,NT342646,1/1/1980 12:00:00 AM,,122,4,3,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4AU,Yes,55.870691,-3.051956,334271,664670,NT342646,1/1/1980 12:00:00 AM,,120,8,5,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4AW,Yes,55.869823,-3.052540,334233,664573,NT342645,1/1/1980 12:00:00 AM,,121,6,4,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4AX,Yes,55.870786,-3.053429,334179,664681,NT341646,1/1/1980 12:00:00 AM,,115,8,4,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4AY,Yes,55.870546,-3.053103,334199,664654,NT341646,1/1/1980 12:00:00 AM,,117,5,3,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4AZ,Yes,55.870632,-3.052562,334233,664664,NT342646,1/1/1980 12:00:00 AM,,118,4,1,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4BA,Yes,55.870233,-3.052966,334207,664620,NT342646,1/1/1980 12:00:00 AM,,119,2,1,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4BB,Yes,55.870402,-3.052092,334262,664637,NT342646,1/1/1980 12:00:00 AM,,121,13,9,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4BD,Yes,55.870782,-3.057057,333952,664685,NT339646,1/1/1980 12:00:00 AM,,106,40,19,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4BE,Yes,55.870533,-3.056762,333970,664657,NT339646,1/1/1980 12:00:00 AM,,107,31,15,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4BF,Yes,55.871305,-3.053635,334167,664739,NT341647,9/1/2008 12:00:00 AM,,114,41,12,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4BG,Yes,55.869815,-3.057701,333910,664578,NT339645,1/1/1980 12:00:00 AM,,107,13,7,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4BH,Yes,55.870289,-3.057938,333896,664630,NT338646,1/1/1980 12:00:00 AM,,105,11,3,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4BJ,Yes,55.870229,-3.058672,333850,664625,NT338646,1/1/1980 12:00:00 AM,,103,8,4,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4BL,Yes,55.870720,-3.059005,333830,664679,NT338646,1/1/1980 12:00:00 AM,,100,16,6,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4BN,Yes,55.870688,-3.059563,333795,664676,NT337646,1/1/1980 12:00:00 AM,,99,5,2,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4BP,Yes,55.870913,-3.057492,333925,664700,NT339646,1/1/1980 12:00:00 AM,,104,37,16,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4BQ,Yes,55.869954,-3.057162,333944,664592,NT339645,1/1/1980 12:00:00 AM,,107,1,1,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4BS,Yes,55.870739,-3.059964,333770,664683,NT337646,1/1/1980 12:00:00 AM,,98,7,4,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4BT,Yes,55.871146,-3.058553,333859,664726,NT338647,1/1/1980 12:00:00 AM,,100,21,10,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4BU,Yes,55.871572,-3.057062,333953,664772,NT339647,1/1/1980 12:00:00 AM,,104,11,4,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4BW,Yes,55.870945,-3.057988,333894,664704,NT338647,1/1/1980 12:00:00 AM,,102,32,11,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4BX,No,55.871374,-3.056146,334010,664750,NT340647,1/1/1980 12:00:00 AM,12/1/1995 12:00:00 AM,107,,,Newtongrange,1.0,,Scottish Water,,Midlothian,Midlothian South, EH22 4BY,Yes,55.871646,-3.052685,334227,664776,NT342647,1/1/1980 12:00:00 AM,,115,3,1,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4BZ,No,55.867600,-3.055021,334074,664328,NT340643,1/1/1980 12:00:00 AM,10/1/2007 12:00:00 AM,120,,,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4DB,No,55.868970,-3.050375,334367,664476,NT343644,4/1/1980 12:00:00 AM,1/1/2004 12:00:00 AM,129,,,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4DD,Yes,55.864777,-3.070826,333080,664029,NT330640,12/1/1999 12:00:00 AM,,89,116,37,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4DE,Yes,55.864209,-3.074150,332871,663969,NT328639,12/1/2000 12:00:00 AM,,89,103,31,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4DF,Yes,55.863978,-3.070772,333082,663940,NT330639,2/1/2003 12:00:00 AM,,89,87,26,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4DG,Yes,55.863601,-3.074900,332823,663903,NT328639,1/1/2004 12:00:00 AM,,87,144,38,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4DH,Yes,55.881095,-3.047842,334546,665823,NT345658,1/1/1980 12:00:00 AM,,110,11,6,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 4DJ,Yes,55.880628,-3.046758,334613,665770,NT346657,1/1/1980 12:00:00 AM,,117,0,0,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 4DL,Yes,55.879754,-3.048125,334526,665675,NT345656,1/1/1980 12:00:00 AM,,113,0,0,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 4DN,Yes,55.879298,-3.047809,334545,665623,NT345656,1/1/1980 12:00:00 AM,,116,2,1,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 4DP,Yes,55.876848,-3.049565,334431,665352,NT344653,1/1/1980 12:00:00 AM,,113,29,12,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 4DQ,Yes,55.881852,-3.047558,334565,665907,NT345659,6/1/2001 12:00:00 AM,,108,10,3,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 4DR,Yes,55.876062,-3.050135,334394,665266,NT343652,1/1/1980 12:00:00 AM,,114,4,2,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 4DS,Yes,55.876007,-3.049159,334455,665258,NT344652,1/1/1980 12:00:00 AM,,117,30,16,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 4DT,No,55.875952,-3.047192,334578,665251,NT345652,1/1/1980 12:00:00 AM,8/1/2009 12:00:00 AM,123,,,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 4DU,Yes,55.876772,-3.047981,334530,665343,NT345653,1/1/1980 12:00:00 AM,,120,6,3,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 4DW,Yes,55.878304,-3.048518,334499,665514,NT344655,1/1/1980 12:00:00 AM,,114,35,16,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 4DX,Yes,55.876803,-3.048509,334497,665346,NT344653,1/1/1980 12:00:00 AM,,117,37,18,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 4DY,Yes,55.877906,-3.047708,334549,665468,NT345654,1/1/1980 12:00:00 AM,,119,39,18,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 4DZ,Yes,55.877839,-3.047210,334580,665461,NT345654,1/1/1980 12:00:00 AM,,122,14,6,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 4EA,Yes,55.862437,-3.074437,332850,663773,NT328637,6/1/2005 12:00:00 AM,,89,89,29,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4EB,Yes,55.879591,-3.049304,334452,665657,NT344656,1/1/1980 12:00:00 AM,,109,18,8,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 4ED,Yes,55.880012,-3.049507,334440,665705,NT344657,1/1/1980 12:00:00 AM,,107,0,0,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 4EE,Yes,55.879181,-3.048861,334479,665611,NT344656,1/1/1980 12:00:00 AM,,112,45,21,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 4EF,Yes,55.879525,-3.050725,334363,665652,NT343656,1/1/1980 12:00:00 AM,,105,4,2,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 4EG,Yes,55.878885,-3.050979,334346,665581,NT343655,1/1/1980 12:00:00 AM,,106,8,2,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 4EH,Yes,55.878553,-3.052968,334221,665545,NT342655,1/1/1980 12:00:00 AM,,101,3,2,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 4EJ,No,55.877348,-3.051033,334340,665410,NT343654,1/1/1980 12:00:00 AM,9/1/2002 12:00:00 AM,107,,,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 4EL,Yes,55.878082,-3.053483,334188,665494,NT341654,1/1/1980 12:00:00 AM,,100,3,2,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 4EN,Yes,55.876551,-3.052818,334227,665323,NT342653,9/1/2002 12:00:00 AM,,105,0,0,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 4EP,Yes,55.879131,-3.052696,334239,665610,NT342656,1/1/1980 12:00:00 AM,,100,40,16,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 4EQ,Yes,55.879065,-3.051927,334287,665601,NT342656,1/1/1980 12:00:00 AM,,103,22,8,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 4ER,Yes,55.880369,-3.052873,334230,665747,NT342657,1/1/1980 12:00:00 AM,,95,32,15,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 4ES,Yes,55.880357,-3.052250,334269,665746,NT342657,1/1/1980 12:00:00 AM,,96,39,15,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 4ET,Yes,55.880973,-3.051595,334311,665813,NT343658,1/1/1980 12:00:00 AM,,94,20,8,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 4EW,Yes,55.876137,-3.053894,334159,665277,NT341652,1/1/1980 12:00:00 AM,,104,2,1,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 4EY,Yes,55.881116,-3.052782,334237,665831,NT342658,1/1/1980 12:00:00 AM,,92,19,8,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 4FA,Yes,55.871263,-3.052275,334252,664733,NT342647,9/1/2008 12:00:00 AM,,117,54,20,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4FB,Yes,55.871143,-3.050610,334356,664719,NT343647,10/1/2008 12:00:00 AM,,122,62,23,Newtongrange,1.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4FE,Yes,55.870199,-3.055810,334029,664618,NT340646,2/1/2012 12:00:00 AM,,109,,,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4FF,Yes,55.870878,-3.055269,334064,664693,NT340646,11/1/2010 12:00:00 AM,,110,37,19,Newtongrange,1.0,,Scottish Water,,Midlothian,Midlothian South, EH22 4FG,Yes,55.869672,-3.056515,333984,664560,NT339645,7/1/2014 12:00:00 AM,,109,,,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4FH,Yes,55.869710,-3.056340,333995,664565,NT339645,2/1/2016 12:00:00 AM,,109,,,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4FJ,Yes,55.867633,-3.057498,333919,664334,NT339643,8/1/2017 12:00:00 AM,,110,,,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4FL,Yes,55.868280,-3.057548,333917,664407,NT339644,3/1/2017 12:00:00 AM,,110,,,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4FN,Yes,55.860936,-3.075466,332783,663606,NT327636,11/1/2017 12:00:00 AM,,110,,,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4FP,Yes,55.862182,-3.076858,332698,663747,NT326637,1/1/2019 12:00:00 AM,,89,,,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4FQ,No,55.869672,-3.056515,333984,664560,NT339645,7/1/2018 12:00:00 AM,2/1/2022 12:00:00 AM,108,,,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4FR,Yes,55.863458,-3.077868,332637,663890,NT326638,1/1/2021 12:00:00 AM,,82,,,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4FS,Yes,55.873383,-3.054394,334123,664971,NT341649,4/1/2023 12:00:00 AM,,107,,,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4FT,Yes,55.874475,-3.057061,333958,665096,NT339650,9/1/2021 12:00:00 AM,,80,,,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4GA,Yes,55.877433,-3.046336,334634,665415,NT346654,9/1/2008 12:00:00 AM,,126,2,1,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 4HA,Yes,55.880499,-3.053452,334194,665762,NT341657,1/1/1980 12:00:00 AM,,94,34,15,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 4HB,Yes,55.879146,-3.054039,334155,665612,NT341656,1/1/1980 12:00:00 AM,,97,18,8,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 4HD,Yes,55.879771,-3.053529,334188,665682,NT341656,1/1/1980 12:00:00 AM,,97,16,7,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 4HE,Yes,55.879396,-3.052176,334272,665639,NT342656,1/1/1980 12:00:00 AM,,101,16,6,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 4HF,Yes,55.879837,-3.052044,334281,665687,NT342656,1/1/1980 12:00:00 AM,,100,14,5,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 4HG,Yes,55.880855,-3.049642,334433,665798,NT344657,1/1/1980 12:00:00 AM,,104,91,28,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 4HJ,Yes,55.881385,-3.050663,334370,665858,NT343658,1/1/1980 12:00:00 AM,,97,18,8,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 4HL,Yes,55.880610,-3.050994,334348,665773,NT343657,1/1/1980 12:00:00 AM,,99,25,9,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 4HN,Yes,55.880506,-3.051566,334312,665761,NT343657,1/1/1980 12:00:00 AM,,97,29,10,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 4HP,Yes,55.876830,-3.046464,334625,665348,NT346653,1/1/1980 12:00:00 AM,,125,17,15,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 4HQ,Yes,55.881003,-3.050253,334395,665816,NT343658,1/1/1980 12:00:00 AM,,101,70,23,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 4HR,Yes,55.877337,-3.047021,334591,665404,NT345654,1/1/1980 12:00:00 AM,,123,38,15,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 4HW,Yes,55.879420,-3.051393,334321,665640,NT343656,1/1/1980 12:00:00 AM,,103,18,7,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 4JB,Yes,55.875952,-3.047192,334578,665251,NT345652,4/1/1989 12:00:00 AM,,123,38,16,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 4JD,Yes,55.870404,-3.061313,333685,664647,NT336646,1/1/1980 12:00:00 AM,,96,35,16,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4JE,Yes,55.869934,-3.062691,333598,664596,NT335645,1/1/1980 12:00:00 AM,,93,6,4,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4JF,Yes,55.869959,-3.061860,333650,664598,NT336645,1/1/1980 12:00:00 AM,,98,42,16,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4JG,Yes,55.870054,-3.060217,333753,664607,NT337646,1/1/1980 12:00:00 AM,,100,37,18,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4JH,Yes,55.869902,-3.058007,333891,664587,NT338645,1/1/1980 12:00:00 AM,,104,4,2,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4JJ,Yes,55.869512,-3.059419,333802,664545,NT338645,1/1/1980 12:00:00 AM,,103,68,25,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4JL,Yes,55.869091,-3.061453,333674,664501,NT336645,1/1/1980 12:00:00 AM,,100,54,20,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4JN,Yes,55.869261,-3.062560,333605,664521,NT336645,1/1/1980 12:00:00 AM,,95,8,6,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4JP,Yes,55.868715,-3.061251,333686,664458,NT336644,1/1/1980 12:00:00 AM,,102,59,24,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4JQ,Yes,55.870332,-3.059170,333819,664636,NT338646,1/1/1980 12:00:00 AM,,101,12,4,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4JR,Yes,55.869229,-3.058996,333828,664514,NT338645,1/1/1980 12:00:00 AM,,105,58,29,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4JS,Yes,55.868565,-3.058898,333833,664440,NT338644,1/1/1980 12:00:00 AM,,107,54,25,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4JT,Yes,55.867856,-3.060812,333712,664362,NT337643,1/1/1980 12:00:00 AM,,104,47,21,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4JU,Yes,55.867960,-3.062333,333617,664376,NT336643,1/1/1980 12:00:00 AM,,100,13,6,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4JW,Yes,55.868677,-3.062480,333609,664455,NT336644,6/1/1997 12:00:00 AM,,98,13,6,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4JX,Yes,55.867405,-3.062094,333631,664314,NT336643,1/1/1980 12:00:00 AM,,101,8,4,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4JY,Yes,55.867017,-3.061253,333683,664270,NT336642,1/1/1980 12:00:00 AM,,103,58,22,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4JZ,Yes,55.867315,-3.059950,333765,664301,NT337643,1/1/1980 12:00:00 AM,,107,41,20,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4LA,Yes,55.867845,-3.058942,333829,664359,NT338643,1/1/1980 12:00:00 AM,,108,41,17,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4LB,Yes,55.866698,-3.062730,333590,664235,NT335642,1/1/1980 12:00:00 AM,,100,27,11,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4LD,Yes,55.866903,-3.063982,333512,664259,NT335642,1/1/1980 12:00:00 AM,,98,11,6,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4LE,Yes,55.866240,-3.064779,333461,664186,NT334641,1/1/1980 12:00:00 AM,,97,40,16,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4LF,Yes,55.866969,-3.064751,333464,664268,NT334642,1/1/1980 12:00:00 AM,,96,48,23,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4LG,Yes,55.867255,-3.065877,333394,664300,NT333643,1/1/1980 12:00:00 AM,,94,13,8,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4LH,Yes,55.867105,-3.066672,333344,664285,NT333642,1/1/1980 12:00:00 AM,,95,12,6,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4LJ,Yes,55.866531,-3.067551,333288,664221,NT332642,1/1/1980 12:00:00 AM,,94,0,0,Newtongrange,0.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4LL,Yes,55.865836,-3.067931,333263,664145,NT332641,1/1/1980 12:00:00 AM,,94,8,7,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4LN,Yes,55.866463,-3.068140,333251,664214,NT332642,1/1/1980 12:00:00 AM,,94,36,23,Newtongrange,0.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4LP,Yes,55.867206,-3.068512,333229,664298,NT332642,1/1/1980 12:00:00 AM,,93,17,12,Newtongrange,0.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4LQ,No,55.866437,-3.065919,333390,664209,NT333642,1/1/1980 12:00:00 AM,12/1/1995 12:00:00 AM,96,,,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4LR,Yes,55.867636,-3.067565,333289,664344,NT332643,1/1/1980 12:00:00 AM,,94,13,6,Newtongrange,0.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4LS,Yes,55.867866,-3.066917,333330,664369,NT333643,1/1/1980 12:00:00 AM,,93,6,1,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4LT,Yes,55.867502,-3.068489,333231,664330,NT332643,1/1/1980 12:00:00 AM,,93,22,12,Newtongrange,0.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4LU,Yes,55.868065,-3.067865,333271,664393,NT332643,1/1/1980 12:00:00 AM,,92,19,6,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4LW,Yes,55.867107,-3.067391,333299,664285,NT332642,1/1/1980 12:00:00 AM,,94,23,6,Newtongrange,0.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4LX,Yes,55.867986,-3.068710,333218,664385,NT332643,1/1/1980 12:00:00 AM,,92,27,11,Newtongrange,0.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4LY,Yes,55.868483,-3.068308,333244,664439,NT332644,1/1/1980 12:00:00 AM,,92,16,6,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4LZ,Yes,55.868423,-3.069089,333195,664434,NT331644,1/1/1980 12:00:00 AM,,91,17,9,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4NA,Yes,55.869135,-3.068773,333216,664512,NT332645,1/1/1980 12:00:00 AM,,91,4,1,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4NB,Yes,55.869191,-3.069590,333165,664520,NT331645,1/1/1980 12:00:00 AM,,90,28,15,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4ND,Yes,55.869239,-3.068185,333253,664523,NT332645,1/1/1980 12:00:00 AM,,90,22,8,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4NE,Yes,55.869521,-3.068784,333216,664555,NT332645,1/1/1980 12:00:00 AM,,90,2,1,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4NF,Yes,55.869704,-3.069444,333175,664576,NT331645,1/1/1980 12:00:00 AM,,89,0,0,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4NG,Yes,55.870890,-3.071506,333048,664710,NT330647,9/1/2016 12:00:00 AM,,88,,,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4NH,Yes,55.865629,-3.067990,333259,664122,NT332641,7/1/1991 12:00:00 AM,,93,12,9,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4NJ,Yes,55.860532,-3.061986,333626,663549,NT336635,10/1/1992 12:00:00 AM,,119,23,8,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4NL,Yes,55.869905,-3.073253,332937,664603,NT329646,2/1/1994 12:00:00 AM,,81,63,28,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4NN,Yes,55.869370,-3.072743,332968,664542,NT329645,2/1/1994 12:00:00 AM,,84,78,40,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4NP,Yes,55.868736,-3.072294,332995,664471,NT329644,2/1/1994 12:00:00 AM,,87,50,16,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4NQ,Yes,55.867537,-3.066508,333355,664332,NT333643,3/1/1983 12:00:00 AM,,94,39,36,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4NR,Yes,55.867243,-3.071486,333043,664305,NT330643,2/1/1994 12:00:00 AM,,89,105,34,Newtongrange,0.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4NS,Yes,55.868216,-3.071193,333063,664413,NT330644,2/1/1994 12:00:00 AM,,90,64,21,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4NT,Yes,55.867700,-3.070555,333102,664355,NT331643,2/1/1994 12:00:00 AM,,90,77,27,Newtongrange,0.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4NU,Yes,55.859700,-3.063593,333524,663457,NT335634,1/1/1980 12:00:00 AM,,115,0,0,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4NX,Yes,55.860405,-3.063133,333554,663535,NT335635,1/1/1980 12:00:00 AM,,114,6,3,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4NY,Yes,55.861257,-3.064323,333481,663631,NT334636,1/1/1980 12:00:00 AM,,109,23,12,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4NZ,Yes,55.877958,-3.054311,334136,665481,NT341654,4/1/2006 12:00:00 AM,,99,105,31,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 4PA,Yes,55.863147,-3.065077,333437,663843,NT334638,1/1/1980 12:00:00 AM,,104,24,8,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4PB,Yes,55.864128,-3.065967,333383,663953,NT333639,1/1/1980 12:00:00 AM,,101,29,10,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4PD,Yes,55.864665,-3.067180,333308,664013,NT333640,1/1/1980 12:00:00 AM,,96,6,4,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4PE,Yes,55.864322,-3.067411,333293,663976,NT332639,1/1/1980 12:00:00 AM,,97,0,0,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4PF,Yes,55.864580,-3.066587,333345,664003,NT333640,1/1/1980 12:00:00 AM,,97,47,28,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4PG,Yes,55.865561,-3.066470,333354,664113,NT333641,1/1/1980 12:00:00 AM,,95,6,3,Newtongrange,0.2,,Scottish Water,,Midlothian,Midlothian South, EH22 4PH,Yes,55.865686,-3.064460,333480,664124,NT334641,1/1/1980 12:00:00 AM,,98,68,33,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4PJ,Yes,55.866413,-3.062514,333603,664204,NT336642,1/1/1980 12:00:00 AM,,101,63,26,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4PL,Yes,55.866955,-3.060052,333758,664261,NT337642,1/1/1980 12:00:00 AM,,107,93,42,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4PN,Yes,55.866292,-3.059875,333768,664188,NT337641,1/1/1980 12:00:00 AM,,108,76,29,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4PP,Yes,55.865291,-3.064433,333481,664080,NT334640,1/1/1980 12:00:00 AM,,99,95,40,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4PQ,Yes,55.865745,-3.065996,333384,664133,NT333641,1/1/1980 12:00:00 AM,,96,22,8,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4PR,Yes,55.865134,-3.066011,333382,664065,NT333640,1/1/1980 12:00:00 AM,,96,19,9,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4PS,Yes,55.864648,-3.066013,333381,664010,NT333640,1/1/1980 12:00:00 AM,,97,7,2,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4PT,Yes,55.864230,-3.065586,333407,663964,NT334639,1/1/1980 12:00:00 AM,,101,27,12,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4PU,Yes,55.864758,-3.063747,333523,664021,NT335640,1/1/1980 12:00:00 AM,,102,57,23,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4PW,Yes,55.865852,-3.061924,333639,664141,NT336641,1/1/1980 12:00:00 AM,,104,61,17,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4PX,Yes,55.865271,-3.062547,333599,664076,NT335640,1/1/1980 12:00:00 AM,,104,9,6,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4PY,Yes,55.865664,-3.060784,333710,664118,NT337641,1/1/1980 12:00:00 AM,,108,16,6,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4PZ,Yes,55.865627,-3.059825,333770,664113,NT337641,1/1/1980 12:00:00 AM,,110,32,15,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4QA,Yes,55.865021,-3.060319,333738,664046,NT337640,1/1/1980 12:00:00 AM,,110,14,6,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4QB,Yes,55.864702,-3.059783,333771,664010,NT337640,1/1/1980 12:00:00 AM,,113,12,5,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4QD,Yes,55.864441,-3.060927,333699,663983,NT336639,1/1/1980 12:00:00 AM,,111,72,17,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4QE,Yes,55.864691,-3.062116,333625,664011,NT336640,1/1/1980 12:00:00 AM,,107,16,6,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4QF,Yes,55.864327,-3.062649,333591,663971,NT335639,1/1/1980 12:00:00 AM,,106,24,12,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4QG,Yes,55.863979,-3.064413,333480,663934,NT334639,1/1/1980 12:00:00 AM,,103,41,26,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4QH,Yes,55.864045,-3.060948,333697,663938,NT336639,1/1/1980 12:00:00 AM,,111,52,21,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4QJ,Yes,55.863323,-3.061328,333672,663858,NT336638,1/1/1980 12:00:00 AM,,112,33,15,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4QL,Yes,55.864165,-3.059561,333784,663950,NT337639,1/1/1980 12:00:00 AM,,114,74,25,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4QN,Yes,55.859865,-3.066330,333353,663478,NT333634,3/1/1984 12:00:00 AM,,107,0,0,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4QP,Yes,55.861514,-3.062700,333583,663658,NT335636,7/1/1989 12:00:00 AM,,112,44,18,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4QQ,Yes,55.863591,-3.062597,333593,663890,NT335638,1/1/1980 12:00:00 AM,,108,57,23,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4QR,Yes,55.860163,-3.061002,333687,663506,NT336635,3/1/1990 12:00:00 AM,,122,15,8,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4QS,Yes,55.860732,-3.060618,333712,663569,NT337635,6/1/1990 12:00:00 AM,,123,17,8,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4QT,Yes,55.861407,-3.059454,333786,663643,NT337636,9/1/1990 12:00:00 AM,,123,22,12,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4QU,Yes,55.861338,-3.061273,333672,663638,NT336636,6/1/1990 12:00:00 AM,,118,24,8,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4QW,Yes,55.861596,-3.063565,333529,663668,NT335636,6/1/1989 12:00:00 AM,,109,59,29,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4QX,Yes,55.862050,-3.061037,333688,663717,NT336637,12/1/1990 12:00:00 AM,,117,21,11,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4QY,Yes,55.861769,-3.060215,333739,663684,NT337636,6/1/1990 12:00:00 AM,,121,23,9,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4QZ,Yes,55.862204,-3.059763,333768,663732,NT337637,12/1/1990 12:00:00 AM,,120,20,9,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4RA,Yes,55.870413,-3.068569,333231,664655,NT332646,1/1/1980 12:00:00 AM,,88,0,0,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4RB,Yes,55.870175,-3.068019,333265,664627,NT332646,1/1/1980 12:00:00 AM,,88,10,5,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4RD,Yes,55.869967,-3.067102,333322,664603,NT333646,1/1/1980 12:00:00 AM,,89,27,11,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4RE,Yes,55.869727,-3.067815,333277,664577,NT332645,1/1/1980 12:00:00 AM,,90,2,1,Newtongrange,0.3,,Scottish Water,,Midlothian,Midlothian South, EH22 4RF,Yes,55.870103,-3.064917,333459,664616,NT334646,1/1/1980 12:00:00 AM,,90,5,2,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4RG,Yes,55.870212,-3.065878,333399,664630,NT333646,1/1/1980 12:00:00 AM,,89,16,8,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4RH,Yes,55.870625,-3.066897,333336,664676,NT333646,1/1/1980 12:00:00 AM,,89,22,10,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4RJ,Yes,55.870355,-3.066953,333332,664646,NT333646,1/1/1980 12:00:00 AM,,89,20,9,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4RL,Yes,55.870724,-3.067954,333270,664689,NT332646,1/1/1980 12:00:00 AM,,87,13,4,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4RN,Yes,55.870871,-3.068549,333233,664705,NT332647,1/1/1980 12:00:00 AM,,87,11,6,Newtongrange,0.4,,Scottish Water,,Midlothian,Midlothian South, EH22 4RP,Yes,55.870887,-3.066680,333350,664705,NT333647,1/1/1980 12:00:00 AM,,89,34,18,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4RQ,Yes,55.870924,-3.065626,333416,664709,NT334647,1/1/1980 12:00:00 AM,,89,19,8,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4RR,Yes,55.871482,-3.066537,333360,664772,NT333647,1/1/1980 12:00:00 AM,,89,60,31,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4RS,Yes,55.871774,-3.063876,333527,664801,NT335648,1/1/1980 12:00:00 AM,,89,62,32,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4RT,Yes,55.872647,-3.062669,333604,664897,NT336648,1/1/1980 12:00:00 AM,,89,60,36,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4RU,Yes,55.871861,-3.062168,333634,664809,NT336648,1/1/1980 12:00:00 AM,,91,19,8,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4RW,Yes,55.871191,-3.067919,333273,664740,NT332647,1/1/1980 12:00:00 AM,,77,5,1,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4RX,Yes,55.871705,-3.061445,333679,664791,NT336647,1/1/1980 12:00:00 AM,,92,30,10,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4RY,Yes,55.871354,-3.062634,333604,664754,NT336647,1/1/1980 12:00:00 AM,,91,53,27,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4RZ,Yes,55.870622,-3.064100,333511,664673,NT335646,1/1/1980 12:00:00 AM,,90,35,14,Newtongrange,0.5,,Scottish Water,,Midlothian,Midlothian South, EH22 4SA,Yes,55.870857,-3.061837,333653,664697,NT336646,1/1/1980 12:00:00 AM,,93,30,13,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4SB,Yes,55.871153,-3.060934,333710,664730,NT337647,1/1/1980 12:00:00 AM,,94,5,2,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4SD,Yes,55.871319,-3.060395,333744,664747,NT337647,1/1/1980 12:00:00 AM,,95,2,2,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4SE,Yes,55.871928,-3.060684,333727,664816,NT337648,1/1/1980 12:00:00 AM,,94,43,20,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4SF,Yes,55.872057,-3.059201,333820,664828,NT338648,1/1/1980 12:00:00 AM,,97,33,13,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4SG,Yes,55.871451,-3.059712,333787,664762,NT337647,1/1/1980 12:00:00 AM,,97,14,8,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4SH,Yes,55.872333,-3.058537,333862,664859,NT338648,1/1/1980 12:00:00 AM,,98,34,18,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4SJ,Yes,55.872624,-3.060175,333760,664892,NT337648,1/1/1980 12:00:00 AM,,94,37,20,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4SL,Yes,55.873016,-3.060521,333739,664936,NT337649,1/1/1980 12:00:00 AM,,93,3,1,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4SN,Yes,55.873093,-3.058941,333838,664944,NT338649,1/1/1980 12:00:00 AM,,95,21,10,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4SP,Yes,55.872921,-3.056955,333962,664922,NT339649,1/1/1980 12:00:00 AM,,101,87,38,Newtongrange,1.0,,Scottish Water,,Midlothian,Midlothian South, EH22 4SQ,Yes,55.871895,-3.058190,333883,664809,NT338648,1/1/1980 12:00:00 AM,,100,15,6,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4SR,Yes,55.872716,-3.057796,333909,664900,NT339649,1/1/1980 12:00:00 AM,,99,24,10,Newtongrange,1.0,,Scottish Water,,Midlothian,Midlothian South, EH22 4SS,Yes,55.872011,-3.056179,334009,664820,NT340648,1/1/1980 12:00:00 AM,,106,4,1,Newtongrange,1.0,,Scottish Water,,Midlothian,Midlothian South, EH22 4ST,Yes,55.872649,-3.055189,334072,664891,NT340648,1/1/1980 12:00:00 AM,,106,14,6,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH22 4SU,Yes,55.873102,-3.061019,333708,664947,NT337649,11/1/1991 12:00:00 AM,,92,53,25,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian South, EH22 4SW,Yes,55.873697,-3.058686,333855,665010,NT338650,1/1/1980 12:00:00 AM,,95,144,45,Newtongrange,1.0,,Scottish Water,,Midlothian,Midlothian South, EH22 4SX,Yes,55.874448,-3.048669,334483,665085,NT344650,7/1/2018 12:00:00 AM,,92,,,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 4TJ,Yes,55.874964,-3.068071,333270,665161,NT332651,1/1/1980 12:00:00 AM,,69,19,5,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian East, EH22 4TL,No,55.872891,-3.067694,333290,664929,NT332649,8/1/1973 12:00:00 AM,2/1/1993 12:00:00 AM,77,,,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian East, EH22 4TN,Yes,55.861974,-3.054117,334121,663701,NT341637,1/1/1980 12:00:00 AM,,143,5,2,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian East, EH22 4TP,Yes,55.871888,-3.077655,332665,664827,NT326648,1/1/1980 12:00:00 AM,,64,20,6,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4TR,Yes,55.872836,-3.078208,332632,664934,NT326649,1/1/1980 12:00:00 AM,,60,2,1,Newtongrange,0.9,,Scottish Water,,Midlothian,Midlothian East, EH22 4TS,Yes,55.870521,-3.076738,332720,664674,NT327646,1/1/1980 12:00:00 AM,,65,2,1,Newtongrange,0.6,,Scottish Water,,Midlothian,Midlothian South, EH22 4TT,No,55.866723,-3.053622,334160,664230,NT341642,7/1/1992 12:00:00 AM,12/1/1994 12:00:00 AM,129,,,Newtongrange,1.0,,Scottish Water,,Midlothian,Midlothian South, EH22 4TW,Yes,55.863109,-3.058062,333876,663832,NT338638,1/1/1980 12:00:00 AM,,123,19,7,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4TZ,Yes,55.880816,-3.048953,334476,665793,NT344657,10/1/1989 12:00:00 AM,,106,18,12,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 4UD,Yes,55.882441,-3.048038,334536,665973,NT345659,12/1/2005 12:00:00 AM,,100,36,11,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 4UE,Yes,55.862550,-3.059325,333796,663771,NT337637,7/1/1991 12:00:00 AM,,120,28,9,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4UF,Yes,55.862885,-3.061028,333690,663809,NT336638,11/1/1991 12:00:00 AM,,114,22,11,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4UG,Yes,55.863071,-3.060378,333731,663830,NT337638,9/1/1990 12:00:00 AM,,115,9,4,Newtongrange,0.7,,Scottish Water,,Midlothian,Midlothian South, EH22 4YA,No,55.871767,-3.059528,333799,664797,NT337647,12/1/1996 12:00:00 AM,6/1/1999 12:00:00 AM,96,,,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4YB,No,55.871767,-3.059528,333799,664797,NT337647,12/1/1996 12:00:00 AM,12/1/1999 12:00:00 AM,96,,,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4YD,No,55.871767,-3.059528,333799,664797,NT337647,6/1/1997 12:00:00 AM,6/1/1998 12:00:00 AM,96,,,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4YN,No,55.871767,-3.059528,333799,664797,NT337647,12/1/1999 12:00:00 AM,9/1/2000 12:00:00 AM,96,,,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 4YP,No,55.871767,-3.059528,333799,664797,NT337647,6/1/2000 12:00:00 AM,11/1/2000 12:00:00 AM,96,,,Newtongrange,0.8,,Scottish Water,,Midlothian,Midlothian South, EH22 5AA,Yes,55.875166,-3.041273,334947,665157,NT349651,1/1/1980 12:00:00 AM,,145,53,20,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5AB,Yes,55.875788,-3.042105,334896,665227,NT348652,1/1/1980 12:00:00 AM,,141,13,7,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5AD,Yes,55.876835,-3.043715,334797,665345,NT347653,1/1/1980 12:00:00 AM,,137,89,42,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5AE,Yes,55.877936,-3.044256,334765,665469,NT347654,1/1/1980 12:00:00 AM,,135,15,6,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5AF,Yes,55.878157,-3.045701,334675,665494,NT346654,1/1/1980 12:00:00 AM,,129,33,14,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5AG,Yes,55.879013,-3.045388,334696,665589,NT346655,1/1/1980 12:00:00 AM,,130,15,7,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5AH,Yes,55.878417,-3.044669,334740,665522,NT347655,1/1/1980 12:00:00 AM,,134,28,9,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5AJ,Yes,55.879372,-3.044406,334758,665628,NT347656,1/1/1980 12:00:00 AM,,134,43,15,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5AL,Yes,55.879395,-3.044919,334726,665632,NT347656,1/1/1980 12:00:00 AM,,132,17,8,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5AN,Yes,55.879562,-3.045307,334702,665650,NT347656,1/1/1980 12:00:00 AM,,129,71,30,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5AP,Yes,55.880340,-3.043617,334809,665735,NT348657,1/1/1980 12:00:00 AM,,134,15,7,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5AQ,Yes,55.878269,-3.045176,334708,665506,NT347655,1/1/1980 12:00:00 AM,,131,24,10,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5AR,Yes,55.881095,-3.041527,334941,665818,NT349658,1/1/1980 12:00:00 AM,,138,79,30,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5AS,Yes,55.880955,-3.041060,334970,665802,NT349658,1/1/1980 12:00:00 AM,,140,68,29,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5AT,Yes,55.878980,-3.044076,334778,665585,NT347655,1/1/1980 12:00:00 AM,,135,73,27,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5AU,Yes,55.878120,-3.043670,334802,665488,NT348654,1/1/1980 12:00:00 AM,,137,5,2,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5AW,Yes,55.880077,-3.043882,334792,665706,NT347657,1/1/1980 12:00:00 AM,,133,12,5,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5AX,Yes,55.877531,-3.043190,334831,665422,NT348654,1/1/1980 12:00:00 AM,,139,47,18,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5AY,Yes,55.877135,-3.043371,334819,665379,NT348653,1/1/1980 12:00:00 AM,,138,33,12,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5AZ,Yes,55.877708,-3.042492,334875,665441,NT348654,1/1/1980 12:00:00 AM,,141,36,16,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5BA,Yes,55.876477,-3.042475,334874,665304,NT348653,1/1/1980 12:00:00 AM,,141,19,9,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5BB,Yes,55.876458,-3.041515,334934,665301,NT349653,1/1/1980 12:00:00 AM,,144,9,4,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5BD,Yes,55.876145,-3.041331,334945,665266,NT349652,1/1/1980 12:00:00 AM,,145,6,3,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5BE,Yes,55.876410,-3.040906,334972,665296,NT349652,1/1/1980 12:00:00 AM,,147,12,7,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5BF,Yes,55.875202,-3.042440,334874,665163,NT348651,6/1/2021 12:00:00 AM,,146,,,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5BG,Yes,55.876050,-3.040929,334970,665255,NT349652,1/1/1980 12:00:00 AM,,147,1,1,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5BH,Yes,55.875776,-3.041433,334938,665225,NT349652,1/1/1980 12:00:00 AM,,144,6,3,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5BJ,Yes,55.875360,-3.040687,334984,665178,NT349651,1/1/1980 12:00:00 AM,,147,18,7,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5BL,Yes,55.875575,-3.039685,335047,665201,NT350652,1/1/1980 12:00:00 AM,,152,11,6,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5BN,Yes,55.875499,-3.039188,335078,665193,NT350651,1/1/1980 12:00:00 AM,,154,12,5,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5BP,Yes,55.874684,-3.039837,335036,665102,NT350651,1/1/1980 12:00:00 AM,,150,21,9,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5BQ,Yes,55.875535,-3.040244,335012,665198,NT350651,1/1/1980 12:00:00 AM,,150,18,7,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5BS,Yes,55.874103,-3.039582,335051,665038,NT350650,1/1/1980 12:00:00 AM,,150,7,3,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5BT,Yes,55.874801,-3.038802,335101,665114,NT351651,1/1/1980 12:00:00 AM,,154,38,19,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5BU,Yes,55.874922,-3.038325,335131,665128,NT351651,1/1/1980 12:00:00 AM,,157,36,11,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5BW,Yes,55.874789,-3.039169,335078,665114,NT350651,1/1/1980 12:00:00 AM,,153,45,17,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5BX,Yes,55.875356,-3.036898,335221,665174,NT352651,1/1/1980 12:00:00 AM,,159,4,2,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5BY,Yes,55.875918,-3.038464,335124,665238,NT351652,1/1/1980 12:00:00 AM,,159,32,12,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5BZ,Yes,55.875707,-3.038938,335094,665215,NT350652,1/1/1980 12:00:00 AM,,156,8,4,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5DA,Yes,55.876188,-3.039478,335061,665269,NT350652,1/1/1980 12:00:00 AM,,154,3,2,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5DB,Yes,55.876264,-3.040007,335028,665278,NT350652,1/1/1980 12:00:00 AM,,152,9,3,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5DD,Yes,55.876099,-3.040498,334997,665261,NT349652,1/1/1980 12:00:00 AM,,149,18,5,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5DE,Yes,55.875841,-3.040124,335020,665231,NT350652,1/1/1980 12:00:00 AM,,151,11,5,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5DF,No,55.874507,-3.041655,334922,665084,NT349650,3/1/2024 12:00:00 AM,3/1/2025 12:00:00 AM,140,0,0,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5DG,Yes,55.874596,-3.042808,334850,665095,NT348650,1/1/1980 12:00:00 AM,,140,29,12,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5DH,Yes,55.874846,-3.031371,335566,665113,NT355651,12/1/2024 12:00:00 AM,,137,,,Newtongrange,2.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5DJ,Yes,55.874850,-3.029725,335669,665111,NT356651,2/1/2024 12:00:00 AM,,154,,,Newtongrange,2.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5DL,No,55.871586,-3.038620,335107,664757,NT351647,1/1/2001 12:00:00 AM,2/1/2001 12:00:00 AM,156,,,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5DN,Yes,55.868155,-3.044744,334718,664380,NT347643,9/1/2008 12:00:00 AM,,148,105,40,Newtongrange,1.5,,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 5DQ,Yes,55.875420,-3.043181,334828,665188,NT348651,2/1/2017 12:00:00 AM,,139,1,1,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5DR,Yes,55.875046,-3.037498,335183,665141,NT351651,8/1/2024 12:00:00 AM,,140,,,Newtongrange,2.2,,,,Midlothian,Midlothian East, EH22 5DT,Yes,55.870188,-3.042402,334868,664604,NT348646,6/1/1998 12:00:00 AM,,149,40,15,Newtongrange,1.7,,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 5DX,Yes,55.874476,-3.040103,335019,665080,NT350650,1/1/1980 12:00:00 AM,,149,50,19,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5DY,Yes,55.873635,-3.040688,334981,664987,NT349649,1/1/1980 12:00:00 AM,,146,32,17,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5DZ,Yes,55.872553,-3.040004,335022,664865,NT350648,1/1/1980 12:00:00 AM,,150,43,19,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5EA,Yes,55.871542,-3.040648,334980,664754,NT349647,1/1/1980 12:00:00 AM,,151,44,28,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5EB,Yes,55.872307,-3.041548,334925,664840,NT349648,1/1/1980 12:00:00 AM,,146,0,0,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 5ED,Yes,55.872511,-3.040722,334977,664861,NT349648,1/1/1980 12:00:00 AM,,148,42,17,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5EE,Yes,55.873623,-3.040992,334962,664985,NT349649,1/1/1980 12:00:00 AM,,146,8,4,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5EF,Yes,55.873222,-3.040613,334985,664940,NT349649,1/1/1980 12:00:00 AM,,147,5,4,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5EG,Yes,55.873503,-3.039342,335065,664971,NT350649,1/1/1980 12:00:00 AM,,150,13,6,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5EH,Yes,55.872108,-3.038506,335115,664815,NT351648,1/1/1980 12:00:00 AM,,155,16,4,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5EJ,Yes,55.871586,-3.038620,335107,664757,NT351647,1/1/1980 12:00:00 AM,,156,25,11,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5EL,Yes,55.871801,-3.037619,335170,664780,NT351647,1/1/1980 12:00:00 AM,,158,6,2,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5EN,Yes,55.872782,-3.038460,335119,664889,NT351648,1/1/1980 12:00:00 AM,,154,44,17,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5EP,Yes,55.873627,-3.038467,335120,664984,NT351649,1/1/1980 12:00:00 AM,,154,45,17,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5EQ,Yes,55.872707,-3.038826,335096,664881,NT350648,1/1/1980 12:00:00 AM,,153,53,19,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5ER,Yes,55.873936,-3.038043,335147,665018,NT351650,1/1/1980 12:00:00 AM,,155,15,6,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5ES,Yes,55.874139,-3.037441,335185,665040,NT351650,1/1/1980 12:00:00 AM,,158,26,8,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5ET,Yes,55.874093,-3.036401,335250,665033,NT352650,1/1/1980 12:00:00 AM,,162,16,8,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5EU,Yes,55.873805,-3.036458,335246,665001,NT352650,1/1/1980 12:00:00 AM,,162,11,6,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5EW,Yes,55.872448,-3.037620,335171,664852,NT351648,1/1/1980 12:00:00 AM,,156,23,11,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5EY,Yes,55.873572,-3.037506,335180,664977,NT351649,1/1/1980 12:00:00 AM,,157,45,18,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5EZ,Yes,55.873685,-3.036886,335219,664988,NT352649,1/1/1980 12:00:00 AM,,160,32,12,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5GA,Yes,55.874466,-3.033774,335415,665073,NT354650,6/1/1997 12:00:00 AM,,173,44,17,Newtongrange,2.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5GB,Yes,55.874211,-3.032009,335525,665042,NT355650,6/1/1997 12:00:00 AM,,180,37,15,Newtongrange,2.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5HA,Yes,55.873349,-3.036206,335261,664950,NT352649,1/1/1980 12:00:00 AM,,163,24,10,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5HB,Yes,55.873063,-3.036038,335271,664918,NT352649,1/1/1980 12:00:00 AM,,163,30,13,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5HD,Yes,55.874073,-3.035650,335297,665031,NT352650,1/1/1980 12:00:00 AM,,165,16,5,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5HE,Yes,55.874288,-3.034680,335358,665054,NT353650,1/1/1980 12:00:00 AM,,169,46,18,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5HF,Yes,55.873683,-3.034952,335340,664986,NT353649,1/1/1980 12:00:00 AM,,168,15,4,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5HG,Yes,55.873421,-3.035217,335323,664958,NT353649,1/1/1980 12:00:00 AM,,167,9,3,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5HH,Yes,55.873059,-3.034408,335373,664917,NT353649,1/1/1980 12:00:00 AM,,169,13,4,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5HJ,Yes,55.872512,-3.035384,335311,664857,NT353648,1/1/1980 12:00:00 AM,,166,20,6,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5HL,Yes,55.872858,-3.035857,335282,664895,NT352648,1/1/1980 12:00:00 AM,,164,46,16,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5HN,Yes,55.872343,-3.037234,335195,664839,NT351648,1/1/1980 12:00:00 AM,,158,12,5,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5HP,Yes,55.871815,-3.035957,335274,664780,NT352647,1/1/1980 12:00:00 AM,,164,34,14,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5HQ,Yes,55.873625,-3.034455,335371,664980,NT353649,1/1/1980 12:00:00 AM,,169,7,3,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5HR,Yes,55.871796,-3.037171,335198,664779,NT351647,1/1/1980 12:00:00 AM,,160,25,11,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5HS,Yes,55.871281,-3.036438,335243,664721,NT352647,1/1/1980 12:00:00 AM,,164,28,10,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5HT,Yes,55.871466,-3.036875,335216,664742,NT352647,1/1/1980 12:00:00 AM,,162,15,5,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5HU,Yes,55.870902,-3.036588,335233,664678,NT352646,1/1/1980 12:00:00 AM,,164,12,4,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5HW,Yes,55.872283,-3.035874,335280,664832,NT352648,1/1/1980 12:00:00 AM,,165,21,10,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5HX,Yes,55.870657,-3.036853,335216,664651,NT352646,1/1/1980 12:00:00 AM,,165,8,4,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5HY,Yes,55.871505,-3.037515,335176,664746,NT351647,1/1/1980 12:00:00 AM,,159,20,7,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5HZ,Yes,55.871527,-3.038155,335136,664750,NT351647,1/1/1980 12:00:00 AM,,157,8,3,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5JA,Yes,55.871353,-3.038502,335114,664730,NT351647,1/1/1980 12:00:00 AM,,157,26,11,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5JB,Yes,55.871154,-3.037665,335166,664708,NT351647,1/1/1980 12:00:00 AM,,161,11,3,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5JD,Yes,55.870883,-3.037754,335160,664677,NT351646,1/1/1980 12:00:00 AM,,161,26,12,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5JE,Yes,55.870310,-3.037579,335170,664614,NT351646,1/1/1980 12:00:00 AM,,163,14,5,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5JF,Yes,55.870851,-3.038344,335123,664674,NT351646,1/1/1980 12:00:00 AM,,158,11,4,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5JG,Yes,55.872811,-3.041417,334934,664895,NT349648,1/1/1980 12:00:00 AM,,144,8,4,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5JH,Yes,55.872296,-3.042874,334842,664840,NT348648,5/1/1992 12:00:00 AM,,143,57,48,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 5JQ,No,55.871577,-3.038620,335107,664756,NT351647,12/1/1990 12:00:00 AM,12/1/1997 12:00:00 AM,156,,,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5JT,Yes,55.869499,-3.036710,335223,664522,NT352645,1/1/1980 12:00:00 AM,,170,10,3,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5JU,Yes,55.869642,-3.036874,335213,664539,NT352645,1/1/1980 12:00:00 AM,,168,23,12,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5JX,Yes,55.870351,-3.036957,335209,664618,NT352646,1/1/1980 12:00:00 AM,,165,17,6,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5JY,Yes,55.870196,-3.036090,335263,664599,NT352645,1/1/1980 12:00:00 AM,,170,25,11,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5JZ,Yes,55.871185,-3.036116,335263,664710,NT352647,1/1/1980 12:00:00 AM,,166,33,11,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5LA,Yes,55.872416,-3.035014,335334,664846,NT353648,1/1/1980 12:00:00 AM,,167,49,19,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5LB,No,55.872723,-3.034767,335350,664879,NT353648,1/1/1980 12:00:00 AM,11/1/2000 12:00:00 AM,168,,,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5LD,Yes,55.872825,-3.034386,335374,664890,NT353648,1/1/1980 12:00:00 AM,,170,19,6,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5LE,Yes,55.873328,-3.033424,335435,664946,NT354649,1/1/1980 12:00:00 AM,,174,61,25,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5LF,Yes,55.872982,-3.032920,335466,664907,NT354649,1/1/1980 12:00:00 AM,,177,59,26,Newtongrange,2.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5LG,Yes,55.873086,-3.032283,335506,664918,NT355649,1/1/1980 12:00:00 AM,,181,74,30,Newtongrange,2.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5LH,Yes,55.872067,-3.034813,335346,664806,NT353648,1/1/1980 12:00:00 AM,,169,26,10,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5LJ,Yes,55.871154,-3.035444,335305,664705,NT353647,1/1/1980 12:00:00 AM,,169,25,12,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5LL,Yes,55.870830,-3.035563,335297,664670,NT352646,1/1/1980 12:00:00 AM,,169,12,4,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5LN,Yes,55.870978,-3.033953,335398,664684,NT353646,1/1/1980 12:00:00 AM,,176,89,41,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5LP,Yes,55.869609,-3.032271,335501,664531,NT355645,1/1/1980 12:00:00 AM,,190,8,4,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5LQ,Yes,55.872105,-3.032481,335492,664809,NT354648,1/1/1980 12:00:00 AM,,182,71,28,Newtongrange,2.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5LR,Yes,55.870397,-3.031429,335555,664617,NT355646,1/1/1980 12:00:00 AM,,193,62,31,Newtongrange,2.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5LS,Yes,55.870473,-3.032102,335513,664627,NT355646,1/1/1980 12:00:00 AM,,189,64,31,Newtongrange,2.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5LT,Yes,55.869643,-3.030354,335621,664533,NT356645,1/1/1980 12:00:00 AM,,204,47,19,Newtongrange,2.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5LU,Yes,55.870859,-3.029987,335646,664668,NT356646,1/1/1980 12:00:00 AM,,203,46,20,Newtongrange,2.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5LW,Yes,55.870270,-3.032688,335476,664605,NT354646,1/1/1980 12:00:00 AM,,186,112,43,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5LX,Yes,55.870547,-3.030729,335599,664634,NT355646,1/1/1980 12:00:00 AM,,198,65,26,Newtongrange,2.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5LY,Yes,55.870880,-3.029540,335674,664669,NT356646,1/1/1980 12:00:00 AM,,206,35,16,Newtongrange,2.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5LZ,Yes,55.871954,-3.030079,335642,664789,NT356647,1/1/1980 12:00:00 AM,,198,47,17,Newtongrange,2.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5NA,Yes,55.872393,-3.029212,335697,664838,NT356648,1/1/1980 12:00:00 AM,,201,58,25,Newtongrange,2.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5NB,Yes,55.872369,-3.028812,335722,664834,NT357648,1/1/1980 12:00:00 AM,,204,47,21,Newtongrange,2.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5ND,Yes,55.873022,-3.029117,335704,664907,NT357649,1/1/1980 12:00:00 AM,,200,11,5,Newtongrange,2.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5NE,Yes,55.872562,-3.030399,335623,664857,NT356648,1/1/1980 12:00:00 AM,,193,50,24,Newtongrange,2.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5NF,Yes,55.872962,-3.031017,335585,664903,NT355649,1/1/1980 12:00:00 AM,,188,71,25,Newtongrange,2.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5NG,Yes,55.878591,-3.043219,334831,665540,NT348655,4/1/2012 12:00:00 AM,,139,,,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5NH,Yes,55.879442,-3.042538,334875,665635,NT348656,2/1/2012 12:00:00 AM,,140,,,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5NJ,Yes,55.879021,-3.043454,334817,665589,NT348655,4/1/2012 12:00:00 AM,,137,,,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5NL,Yes,55.870961,-3.044452,334741,664692,NT347646,4/1/2010 12:00:00 AM,,139,30,9,Newtongrange,1.6,,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 5NQ,Yes,55.871542,-3.045954,334648,664759,NT346647,4/1/2010 12:00:00 AM,,131,130,47,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5NR,Yes,55.871494,-3.043124,334825,664751,NT348647,1/1/1980 12:00:00 AM,,144,4,1,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 5NS,No,55.871237,-3.040560,334985,664720,NT349647,1/1/1980 12:00:00 AM,2/1/2005 12:00:00 AM,152,,,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5NT,Yes,55.871442,-3.039639,335043,664741,NT350647,1/1/1980 12:00:00 AM,,154,24,11,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5NU,No,55.870561,-3.040814,334968,664645,NT349646,1/1/1980 12:00:00 AM,12/1/1998 12:00:00 AM,152,,,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 5NW,Yes,55.871824,-3.044443,334743,664788,NT347647,1/1/2010 12:00:00 AM,,137,67,21,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5NX,Yes,55.870531,-3.040142,335010,664641,NT350646,1/1/1980 12:00:00 AM,,154,40,15,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5NY,Yes,55.870400,-3.039627,335042,664625,NT350646,1/1/1980 12:00:00 AM,,155,34,12,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5NZ,Yes,55.870319,-3.038634,335104,664616,NT351646,1/1/1980 12:00:00 AM,,158,26,12,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5PA,Yes,55.869995,-3.038657,335102,664579,NT351645,1/1/1980 12:00:00 AM,,159,44,21,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5PB,Yes,55.868907,-3.040897,334960,664461,NT349644,1/1/1980 12:00:00 AM,,155,0,0,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 5PD,Yes,55.869525,-3.042176,334881,664530,NT348645,1/1/1980 12:00:00 AM,,151,58,28,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 5PE,No,55.871355,-3.042529,334862,664734,NT348647,1/1/1980 12:00:00 AM,11/1/2020 12:00:00 AM,146,0,0,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 5PF,Yes,55.870381,-3.042902,334837,664626,NT348646,1/1/1980 12:00:00 AM,,146,32,14,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 5PG,Yes,55.870008,-3.043532,334797,664586,NT347645,1/1/1980 12:00:00 AM,,145,35,16,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5PH,Yes,55.869080,-3.043747,334782,664482,NT347644,1/1/1980 12:00:00 AM,,148,2,2,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5PJ,Yes,55.869098,-3.044834,334714,664485,NT347644,1/1/1980 12:00:00 AM,,144,29,14,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5PL,Yes,55.868614,-3.045763,334655,664432,NT346644,1/1/1980 12:00:00 AM,,143,3,2,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5PN,Yes,55.868487,-3.045872,334648,664418,NT346644,1/1/1980 12:00:00 AM,,143,6,4,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5PP,Yes,55.867295,-3.044450,334735,664284,NT347642,1/1/1980 12:00:00 AM,,153,16,9,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5PQ,Yes,55.869292,-3.043145,334820,664505,NT348645,1/1/1980 12:00:00 AM,,149,22,7,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 5PR,Yes,55.867308,-3.045089,334695,664287,NT346642,1/1/1980 12:00:00 AM,,151,8,5,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5PS,Yes,55.867516,-3.043848,334773,664308,NT347643,1/1/1980 12:00:00 AM,,154,5,2,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5PT,Yes,55.867579,-3.042795,334839,664315,NT348643,1/1/1980 12:00:00 AM,,156,11,6,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 5PU,Yes,55.866947,-3.043098,334819,664244,NT348642,1/1/1980 12:00:00 AM,,159,48,19,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5PW,Yes,55.868762,-3.043131,334820,664446,NT348644,1/1/1980 12:00:00 AM,,152,45,16,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5PX,Yes,55.866919,-3.042218,334874,664241,NT348642,1/1/1980 12:00:00 AM,,161,35,14,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 5PY,Yes,55.867400,-3.041640,334911,664293,NT349642,1/1/1980 12:00:00 AM,,159,38,15,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 5PZ,Yes,55.866675,-3.041253,334934,664212,NT349642,1/1/1980 12:00:00 AM,,165,32,14,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 5QA,Yes,55.866805,-3.039755,335028,664226,NT350642,1/1/1980 12:00:00 AM,,167,59,25,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 5QB,Yes,55.867367,-3.040201,335001,664288,NT350642,1/1/1980 12:00:00 AM,,163,23,13,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 5QD,Yes,55.867692,-3.038979,335078,664323,NT350643,1/1/1980 12:00:00 AM,,165,56,22,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5QE,Yes,55.868742,-3.039087,335073,664440,NT350644,1/1/1980 12:00:00 AM,,162,50,25,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5QF,Yes,55.869350,-3.038400,335117,664507,NT351645,1/1/1980 12:00:00 AM,,162,10,4,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5QG,Yes,55.868927,-3.038485,335111,664460,NT351644,1/1/1980 12:00:00 AM,,163,20,8,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5QH,Yes,55.868006,-3.036958,335205,664357,NT352643,1/1/1980 12:00:00 AM,,171,43,16,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5QJ,Yes,55.868166,-3.036084,335260,664374,NT352643,1/1/1980 12:00:00 AM,,174,66,23,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5QL,Yes,55.868816,-3.035653,335288,664445,NT352644,1/1/1980 12:00:00 AM,,175,11,4,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5QN,Yes,55.868608,-3.034737,335345,664421,NT353644,1/1/1980 12:00:00 AM,,180,31,17,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5QP,Yes,55.867567,-3.035668,335285,664306,NT352643,1/1/1980 12:00:00 AM,,179,31,14,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5QQ,Yes,55.868205,-3.037810,335152,664379,NT351643,1/1/1980 12:00:00 AM,,168,44,16,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5QR,Yes,55.867186,-3.037224,335187,664266,NT351642,1/1/1980 12:00:00 AM,,174,48,22,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5QS,Yes,55.866612,-3.037065,335196,664201,NT351642,1/1/1980 12:00:00 AM,,177,20,8,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5QT,Yes,55.866299,-3.037935,335141,664167,NT351641,1/1/1980 12:00:00 AM,,176,40,14,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5QU,Yes,55.865732,-3.038048,335133,664104,NT351641,1/1/1980 12:00:00 AM,,179,27,14,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5QW,Yes,55.867839,-3.035372,335304,664336,NT353643,1/1/1980 12:00:00 AM,,179,33,15,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5QX,Yes,55.866112,-3.038793,335087,664147,NT350641,1/1/1980 12:00:00 AM,,175,52,22,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5QY,Yes,55.872210,-3.043431,334807,664830,NT348648,1/1/1980 12:00:00 AM,,141,3,1,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian East, EH22 5QZ,Yes,55.865532,-3.036221,335247,664081,NT352640,1/1/1980 12:00:00 AM,,188,100,36,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5RA,Yes,55.866165,-3.036749,335215,664151,NT352641,1/1/1980 12:00:00 AM,,181,63,19,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5RB,Yes,55.866094,-3.035597,335287,664142,NT352641,1/1/1980 12:00:00 AM,,186,52,14,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5RD,Yes,55.865446,-3.034685,335343,664070,NT353640,10/1/1980 12:00:00 AM,,199,33,14,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5RE,Yes,55.866854,-3.034946,335329,664226,NT353642,10/1/1980 12:00:00 AM,,184,61,23,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5RF,Yes,55.865613,-3.034082,335381,664088,NT353640,12/1/1982 12:00:00 AM,,202,81,28,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5RG,No,55.865966,-3.033724,335404,664126,NT354641,7/1/1997 12:00:00 AM,1/1/1998 12:00:00 AM,200,,,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5RH,Yes,55.866311,-3.033366,335427,664165,NT354641,5/1/1990 12:00:00 AM,,199,57,22,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5RJ,Yes,55.866415,-3.034838,335335,664177,NT353641,10/1/1989 12:00:00 AM,,189,24,8,Newtongrange,2.2,,Scottish Water,,Midlothian,Midlothian East, EH22 5RL,Yes,55.867965,-3.048127,334506,664363,NT345643,1/1/1980 12:00:00 AM,,139,5,4,Newtongrange,1.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5RN,Yes,55.867652,-3.046936,334580,664327,NT345643,1/1/1980 12:00:00 AM,,144,10,4,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5RP,Yes,55.866956,-3.044217,334749,664247,NT347642,1/1/1980 12:00:00 AM,,155,7,4,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5RQ,Yes,55.863764,-3.038107,335126,663886,NT351638,10/1/2013 12:00:00 AM,,197,,,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5RR,Yes,55.867620,-3.046360,334616,664322,NT346643,1/1/1980 12:00:00 AM,,147,22,9,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5RS,Yes,55.867855,-3.047261,334560,664349,NT345643,1/1/1980 12:00:00 AM,,142,16,8,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5RU,Yes,55.868159,-3.048532,334481,664384,NT344643,1/1/1980 12:00:00 AM,,137,5,4,Newtongrange,1.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5RW,Yes,55.867330,-3.045649,334660,664289,NT346642,1/1/1980 12:00:00 AM,,149,14,4,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5RX,Yes,55.867941,-3.045665,334660,664358,NT346643,1/1/1980 12:00:00 AM,,146,22,11,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5RY,Yes,55.868270,-3.047145,334568,664396,NT345643,1/1/1980 12:00:00 AM,,139,6,2,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5RZ,Yes,55.868555,-3.048431,334488,664428,NT344644,1/1/1980 12:00:00 AM,,135,6,3,Newtongrange,1.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5SA,Yes,55.868469,-3.046958,334580,664417,NT345644,1/1/1980 12:00:00 AM,,140,16,7,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5SB,Yes,55.868510,-3.046352,334618,664421,NT346644,1/1/1980 12:00:00 AM,,142,17,10,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5SD,Yes,55.869253,-3.045605,334666,664503,NT346645,1/1/1980 12:00:00 AM,,142,23,13,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5SE,Yes,55.869593,-3.045806,334654,664541,NT346645,1/1/1980 12:00:00 AM,,139,30,15,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5SF,Yes,55.869319,-3.044264,334750,664510,NT347645,1/1/1980 12:00:00 AM,,145,11,6,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5SG,Yes,55.869565,-3.043776,334781,664536,NT347645,1/1/1980 12:00:00 AM,,145,5,2,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5SH,Yes,55.870175,-3.043952,334771,664605,NT347646,1/1/1980 12:00:00 AM,,143,42,20,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5SJ,Yes,55.870442,-3.045237,334691,664635,NT346646,1/1/1980 12:00:00 AM,,138,83,33,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5SL,Yes,55.870777,-3.045997,334644,664673,NT346646,1/1/1980 12:00:00 AM,,134,15,6,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5SN,Yes,55.870944,-3.046465,334615,664692,NT346646,1/1/1980 12:00:00 AM,,132,24,9,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5SP,Yes,55.869723,-3.046401,334617,664557,NT346645,1/1/1980 12:00:00 AM,,137,31,14,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian East, EH22 5SQ,Yes,55.869855,-3.044534,334734,664569,NT347645,1/1/1980 12:00:00 AM,,142,16,6,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian East, EH22 5SR,Yes,55.868867,-3.047656,334537,664462,NT345644,1/1/1980 12:00:00 AM,,136,32,17,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5SS,Yes,55.869226,-3.046723,334596,664502,NT345645,1/1/1980 12:00:00 AM,,138,2,1,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5ST,Yes,55.868855,-3.047000,334578,664460,NT345644,1/1/1980 12:00:00 AM,,139,13,4,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5SU,Yes,55.868601,-3.047329,334557,664433,NT345644,1/1/1980 12:00:00 AM,,138,14,7,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5SW,Yes,55.870031,-3.047080,334575,664591,NT345645,1/1/1980 12:00:00 AM,,134,72,36,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5SX,No,55.868469,-3.046958,334580,664417,NT345644,12/1/1986 12:00:00 AM,7/1/1992 12:00:00 AM,140,,,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian East, EH22 5TA,Yes,55.870561,-3.040830,334967,664645,NT349646,12/1/2000 12:00:00 AM,,152,0,0,Newtongrange,1.8,,Scottish Water,,Midlothian,Midlothian East, EH22 5TE,Yes,55.878138,-3.030899,335601,665478,NT356654,9/1/2017 12:00:00 AM,,195,,,Newtongrange,2.7,,Scottish Water,,Midlothian,Midlothian East, EH22 5TG,Yes,55.879455,-3.029255,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.871405,-3.024871,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.863390,-3.039855,335016,663846,NT350638,1/1/1980 12:00:00 AM,,191,8,3,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH22 5TP,Yes,55.865144,-3.033223,335434,664035,NT354640,3/1/1991 12:00:00 AM,,213,26,9,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5TQ,Yes,55.873413,-3.022159,336140,664945,NT361649,1/1/1980 12:00:00 AM,,224,8,3,Newtongrange,3.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5TR,Yes,55.864604,-3.035461,335293,663977,NT352639,5/1/1992 12:00:00 AM,,203,34,15,Newtongrange,2.1,,Scottish Water,,Midlothian,Midlothian East, EH22 5TT,Yes,55.867147,-3.033244,335436,664257,NT354642,12/1/1982 12:00:00 AM,,193,36,12,Newtongrange,2.3,,Scottish Water,,Midlothian,Midlothian East, EH22 5YA,No,55.871586,-3.038620,335107,664757,NT351647,6/1/1996 12:00:00 AM,6/1/2000 12:00:00 AM,156,,,Newtongrange,2.0,,Scottish Water,,Midlothian,Midlothian East, EH22 5ZX,No,55.876692,-3.043663,334800,665330,NT347653,10/1/1994 12:00:00 AM,6/1/1996 12:00:00 AM,137,,,Newtongrange,1.9,,Scottish Water,,Midlothian,Midlothian East, EH23 4BJ,Yes,55.853358,-3.060289,333720,662748,NT337627,1/1/1980 12:00:00 AM,,143,43,25,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian South, EH23 4BL,No,55.854402,-3.061132,333669,662865,NT336628,1/1/1980 12:00:00 AM,2/1/2001 12:00:00 AM,137,,,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian South, EH23 4FA,No,55.854623,-3.061586,333641,662891,NT336628,10/1/2006 12:00:00 AM,1/1/2007 12:00:00 AM,135,,,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian South, EH23 4FB,Yes,55.854622,-3.061681,333635,662890,NT336628,8/1/2002 12:00:00 AM,,135,38,18,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian South, EH23 4FD,Yes,55.857201,-3.063749,333510,663179,NT335631,6/1/2009 12:00:00 AM,,118,155,53,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH23 4FP,Yes,55.852559,-3.062328,333591,662662,NT335626,3/1/2012 12:00:00 AM,,135,,,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian South, EH23 4FQ,Yes,55.853589,-3.063698,333507,662777,NT335627,11/1/2011 12:00:00 AM,,130,,,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian South, EH23 4FS,Yes,55.852755,-3.061487,333644,662683,NT336626,2/1/2012 12:00:00 AM,,138,,,Newtongrange,1.7,,Scottish Water,,Midlothian,Midlothian South, EH23 4FT,Yes,55.853562,-3.061621,333637,662772,NT336627,5/1/2013 12:00:00 AM,,142,,,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian South, EH23 4LZ,Yes,55.856994,-3.064845,333441,663158,NT334631,1/1/1980 12:00:00 AM,,115,8,4,Newtongrange,1.1,,Scottish Water,,Midlothian,Midlothian South, EH23 4NA,No,55.858449,-3.064901,333440,663319,NT334633,11/1/1994 12:00:00 AM,12/1/1995 12:00:00 AM,114,,,Newtongrange,1.0,,Scottish Water,,Midlothian,Midlothian South, EH23 4NB,Yes,55.855607,-3.064184,333480,663003,NT334630,1/1/1980 12:00:00 AM,,117,2,1,Newtongrange,1.3,,Scottish Water,,Midlothian,Midlothian South, EH23 4ND,Yes,55.855607,-3.064184,333480,663003,NT334630,1/1/1980 12:00:00 AM,,120,2,1,Newtongrange,1.3,,Scottish Water,,Midlothian,Midlothian South, EH23 4PE,Yes,55.855197,-3.054381,334093,662947,NT340629,1/1/1980 12:00:00 AM,,157,2,1,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian South, EH23 4PF,Yes,55.855974,-3.055999,333993,663036,NT339630,1/1/1980 12:00:00 AM,,149,4,2,Newtongrange,1.5,,Scottish Water,,Midlothian,Midlothian South, EH23 4PG,Yes,55.857632,-3.057514,333901,663221,NT339632,1/1/1980 12:00:00 AM,,141,69,26,Newtongrange,1.3,,Scottish Water,,Midlothian,Midlothian South, EH23 4PH,Yes,55.857236,-3.056609,333957,663177,NT339631,1/1/1980 12:00:00 AM,,145,43,12,Newtongrange,1.3,,Scottish Water,,Midlothian,Midlothian South, EH23 4PJ,Yes,55.857367,-3.056005,333995,663191,NT339631,1/1/1980 12:00:00 AM,,146,7,2,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian South, EH23 4PL,Yes,55.858110,-3.056265,333980,663273,NT339632,1/1/1980 12:00:00 AM,,143,11,7,Newtongrange,1.3,,Scottish Water,,Midlothian,Midlothian South, EH23 4PN,Yes,55.859107,-3.056372,333975,663385,NT339633,1/1/1980 12:00:00 AM,,140,2,1,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian South, EH23 4PP,Yes,55.858635,-3.054809,334072,663331,NT340633,1/1/1980 12:00:00 AM,,147,91,47,Newtongrange,1.3,,Scottish Water,,Midlothian,Midlothian South, EH23 4PQ,Yes,55.858202,-3.057082,333929,663284,NT339632,1/1/1980 12:00:00 AM,,141,21,9,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian South, EH23 4PR,Yes,55.857942,-3.054870,334067,663253,NT340632,1/1/1980 12:00:00 AM,,149,76,37,Newtongrange,1.4,,Scottish Water,,Midlothian,Midlothian South, EH23 4PW,Yes,55.858754,-3.056666,333956,663346,NT339633,1/1/1980 12:00:00 AM,,140,6,4,Newtongrange,1.2,,Scottish Water,,Midlothian,Midlothian South, EH23 4RW,Yes,55.853490,-3.058504,333832,662761,NT338627,11/1/2021 12:00:00 AM,,149,,,Newtongrange,1.6,,Scottish Water,,Midlothian,Midlothian South, EH24 9AA,Yes,55.850659,-3.137140,328904,662524,NT289625,1/1/1980 12:00:00 AM,,155,3,2,Newtongrange,4.6,,Scottish Water,,Midlothian,Midlothian West, EH24 9AB,Yes,55.851221,-3.139552,328754,662590,NT287625,1/1/1980 12:00:00 AM,,157,12,4,Newtongrange,4.7,,Scottish Water,,Midlothian,Midlothian West, EH24 9AD,Yes,55.852060,-3.140216,328714,662684,NT287626,1/1/1980 12:00:00 AM,,157,54,25,Newtongrange,4.7,,Scottish Water,,Midlothian,Midlothian West, EH24 9AE,Yes,55.852383,-3.139267,328774,662719,NT287627,1/1/1980 12:00:00 AM,,154,7,3,Newtongrange,4.7,,Scottish Water,,Midlothian,Midlothian West, EH24 9AF,Yes,55.851778,-3.138594,328815,662651,NT288626,1/1/1980 12:00:00 AM,,156,24,13,Newtongrange,4.6,,Scottish Water,,Midlothian,Midlothian West, EH24 9AG,Yes,55.851853,-3.137255,328899,662657,NT288626,1/1/1980 12:00:00 AM,,154,21,8,Newtongrange,4.6,,Scottish Water,,Midlothian,Midlothian West, EH24 9AH,Yes,55.850104,-3.136916,328917,662462,NT289624,1/1/1980 12:00:00 AM,,153,37,23,Newtongrange,4.6,,Scottish Water,,Midlothian,Midlothian West, EH24 9AJ,Yes,55.851497,-3.135934,328981,662617,NT289626,1/1/1980 12:00:00 AM,,152,26,14,Newtongrange,4.5,,Scottish Water,,Midlothian,Midlothian West, EH24 9AL,Yes,55.851736,-3.136373,328954,662644,NT289626,1/1/1980 12:00:00 AM,,153,24,12,Newtongrange,4.5,,Scottish Water,,Midlothian,Midlothian West, EH24 9AN,Yes,55.852745,-3.135092,329036,662755,NT290627,1/1/1980 12:00:00 AM,,148,11,5,Newtongrange,4.4,,Scottish Water,,Midlothian,Midlothian West, EH24 9AP,Yes,55.853722,-3.134418,329080,662863,NT290628,1/1/1980 12:00:00 AM,,147,17,9,Newtongrange,4.3,,Scottish Water,,Midlothian,Midlothian West, EH24 9AQ,Yes,55.851580,-3.137726,328869,662628,NT288626,1/1/1980 12:00:00 AM,,154,2,1,Newtongrange,4.6,,Scottish Water,,Midlothian,Midlothian West, EH24 9AR,Yes,55.853870,-3.134933,329048,662880,NT290628,1/1/1980 12:00:00 AM,,148,21,14,Newtongrange,4.3,,Scottish Water,,Midlothian,Midlothian West, EH24 9AS,Yes,55.854936,-3.133319,329151,662997,NT291629,1/1/1980 12:00:00 AM,,147,35,14,Newtongrange,4.2,,Scottish Water,,Midlothian,Midlothian West, EH24 9AT,Yes,55.854618,-3.134668,329066,662963,NT290629,1/1/1980 12:00:00 AM,,147,1,1,Newtongrange,4.3,,Scottish Water,,Midlothian,Midlothian West, EH24 9AU,Yes,55.856777,-3.130497,329331,663199,NT293631,1/1/1980 12:00:00 AM,,147,8,2,Newtongrange,4.0,,Scottish Water,,Midlothian,Midlothian West, EH24 9AW,Yes,55.852783,-3.135844,328989,662760,NT289627,1/1/1980 12:00:00 AM,,149,8,4,Newtongrange,4.4,,Scottish Water,,Midlothian,Midlothian West, EH24 9AX,Yes,55.854088,-3.125835,329618,662895,NT296628,1/1/1980 12:00:00 AM,,143,0,0,Newtongrange,3.8,,Scottish Water,,Midlothian,Midlothian South, EH24 9AY,Yes,55.858808,-3.128447,329463,663422,NT294634,1/1/1980 12:00:00 AM,,141,1,1,Newtongrange,3.8,,Scottish Water,,Midlothian,Midlothian West, EH24 9AZ,No,55.859345,-3.127744,329508,663482,NT295634,1/1/1980 12:00:00 AM,6/1/2015 12:00:00 AM,140,1,1,Newtongrange,3.7,,Scottish Water,,Midlothian,Midlothian West, EH24 9BA,Yes,55.852341,-3.137045,328913,662712,NT289627,1/1/1980 12:00:00 AM,,152,30,16,Newtongrange,4.5,,Scottish Water,,Midlothian,Midlothian West, EH24 9BB,Yes,55.852804,-3.136532,328946,662763,NT289627,1/1/1980 12:00:00 AM,,150,30,13,Newtongrange,4.5,,Scottish Water,,Midlothian,Midlothian West, EH24 9BD,Yes,55.853227,-3.136432,328953,662810,NT289628,1/1/1980 12:00:00 AM,,149,26,11,Newtongrange,4.5,,Scottish Water,,Midlothian,Midlothian West, EH24 9BE,Yes,55.853556,-3.135819,328992,662846,NT289628,1/1/1980 12:00:00 AM,,148,4,2,Newtongrange,4.4,,Scottish Water,,Midlothian,Midlothian West, EH24 9BF,Yes,55.856710,-3.134825,329060,663196,NT290631,5/1/2016 12:00:00 AM,,149,,,Newtongrange,4.2,,Scottish Water,,Midlothian,Midlothian West, EH24 9BG,Yes,55.854562,-3.136855,328929,662959,NT289629,1/1/1980 12:00:00 AM,,149,60,21,Newtongrange,4.4,,Scottish Water,,Midlothian,Midlothian West, EH24 9BH,Yes,55.855072,-3.138083,328853,663017,NT288630,1/1/1980 12:00:00 AM,,149,39,18,Newtongrange,4.5,,Scottish Water,,Midlothian,Midlothian West, EH24 9BJ,Yes,55.855356,-3.138475,328829,663049,NT288630,1/1/1980 12:00:00 AM,,149,121,46,Newtongrange,4.5,,Scottish Water,,Midlothian,Midlothian West, EH24 9BL,Yes,55.854346,-3.139835,328742,662938,NT287629,1/1/1980 12:00:00 AM,,150,50,19,Newtongrange,4.6,,Scottish Water,,Midlothian,Midlothian West, EH24 9BN,Yes,55.853178,-3.139721,328747,662807,NT287628,1/1/1980 12:00:00 AM,,153,7,3,Newtongrange,4.6,,Scottish Water,,Midlothian,Midlothian West, EH24 9BP,Yes,55.853150,-3.138922,328797,662804,NT287628,1/1/1980 12:00:00 AM,,152,23,8,Newtongrange,4.6,,Scottish Water,,Midlothian,Midlothian West, EH24 9BQ,Yes,55.854650,-3.136074,328978,662968,NT289629,1/1/1980 12:00:00 AM,,148,71,32,Newtongrange,4.4,,Scottish Water,,Midlothian,Midlothian West, EH24 9BS,Yes,55.853831,-3.138143,328847,662879,NT288628,1/1/1980 12:00:00 AM,,150,34,24,Newtongrange,4.5,,Scottish Water,,Midlothian,Midlothian West, EH24 9BT,Yes,55.853372,-3.137299,328899,662827,NT288628,1/1/1980 12:00:00 AM,,150,42,20,Newtongrange,4.5,,Scottish Water,,Midlothian,Midlothian West, EH24 9BU,Yes,55.852644,-3.138204,328841,662746,NT288627,1/1/1980 12:00:00 AM,,153,28,14,Newtongrange,4.6,,Scottish Water,,Midlothian,Midlothian West, EH24 9BW,Yes,55.852905,-3.139218,328778,662777,NT287627,1/1/1980 12:00:00 AM,,153,6,3,Newtongrange,4.6,,Scottish Water,,Midlothian,Midlothian West, EH24 9BX,Yes,55.853781,-3.140602,328693,662875,NT286628,10/1/1980 12:00:00 AM,,152,17,8,Newtongrange,4.7,,Scottish Water,,Midlothian,Midlothian West, EH24 9BY,Yes,55.856103,-3.134407,329085,663128,NT290631,7/1/2015 12:00:00 AM,,149,,,Newtongrange,4.2,,Scottish Water,,Midlothian,Midlothian West, EH24 9BZ,Yes,55.855690,-3.134379,329086,663082,NT290630,3/1/2015 12:00:00 AM,,148,,,Newtongrange,4.2,,Scottish Water,,Midlothian,Midlothian West, EH24 9DA,Yes,55.851682,-3.142137,328593,662643,NT285626,4/1/2017 12:00:00 AM,,158,,,Newtongrange,4.8,,Scottish Water,,Midlothian,Midlothian West, EH24 9DB,Yes,55.851140,-3.144469,328446,662586,NT284625,5/1/2018 12:00:00 AM,,157,,,Newtongrange,5.0,,Scottish Water,,Midlothian,Midlothian West, EH24 9DD,Yes,55.851360,-3.144955,328416,662611,NT284626,7/1/2017 12:00:00 AM,,155,,,Newtongrange,5.0,,Scottish Water,,Midlothian,Midlothian West, EH24 9DE,Yes,55.849672,-3.140928,328665,662419,NT286624,5/1/2018 12:00:00 AM,,157,,,Newtongrange,4.9,,Scottish Water,,Midlothian,Midlothian West, EH24 9DF,Yes,55.850240,-3.140658,328683,662481,NT286624,8/1/2022 12:00:00 AM,,158,,,Newtongrange,4.8,,Scottish Water,,Midlothian,Midlothian West, EH24 9DG,Yes,55.850180,-3.141359,328639,662476,NT286624,12/1/2021 12:00:00 AM,,160,,,Newtongrange,4.9,,Scottish Water,,Midlothian,Midlothian West, EH24 9DH,Yes,55.846726,-3.140810,328667,662091,NT286620,6/1/1999 12:00:00 AM,,158,50,15,Newtongrange,5.0,,Scottish Water,,Midlothian,Midlothian West, EH24 9DJ,Yes,55.845089,-3.141896,328596,661910,NT285619,12/1/1995 12:00:00 AM,,161,9,5,Newtongrange,5.1,,Scottish Water,,Midlothian,Midlothian West, EH24 9DL,Yes,55.849500,-3.136164,328963,662394,NT289623,1/1/1980 12:00:00 AM,,148,19,9,Newtongrange,4.6,,Scottish Water,,Midlothian,Midlothian West, EH24 9DN,Yes,55.848799,-3.138204,328834,662319,NT288623,1/1/1980 12:00:00 AM,,150,49,24,Newtongrange,4.7,,Scottish Water,,Midlothian,Midlothian West, EH24 9DP,Yes,55.846906,-3.137829,328854,662108,NT288621,1/1/1980 12:00:00 AM,,150,12,4,Newtongrange,4.8,,Scottish Water,,Midlothian,Midlothian West, EH24 9DQ,Yes,55.846013,-3.142083,328586,662013,NT285620,12/1/1999 12:00:00 AM,,160,47,21,Newtongrange,5.1,,Scottish Water,,Midlothian,Midlothian West, EH24 9DR,Yes,55.846634,-3.139067,328776,662079,NT287620,1/1/1980 12:00:00 AM,,154,16,6,Newtongrange,4.9,,Scottish Water,,Midlothian,Midlothian West, EH24 9DS,No,55.845690,-3.141083,328648,661976,NT286619,1/1/1980 12:00:00 AM,12/1/2022 12:00:00 AM,159,0,0,Newtongrange,5.1,,Scottish Water,,Midlothian,Midlothian West, EH24 9DT,Yes,55.845267,-3.141087,328647,661928,NT286619,1/1/1980 12:00:00 AM,,159,12,5,Newtongrange,5.1,,Scottish Water,,Midlothian,Midlothian West, EH24 9DU,Yes,55.840025,-3.150243,328064,661355,NT280613,1/1/1980 12:00:00 AM,,182,11,5,Newtongrange,5.9,,Scottish Water,,Midlothian,Midlothian West, EH24 9DW,Yes,55.848973,-3.138784,328798,662339,NT287623,1/1/1980 12:00:00 AM,,152,54,22,Newtongrange,4.8,,Scottish Water,,Midlothian,Midlothian West, EH24 9DX,Yes,55.831937,-3.143554,328468,660448,NT284604,1/1/1980 12:00:00 AM,,209,5,3,Newtongrange,6.0,,Scottish Water,,Midlothian,Midlothian South, EH24 9DY,Yes,55.831488,-3.155977,327689,660410,NT276604,1/1/1980 12:00:00 AM,,215,9,3,Newtongrange,6.7,,Scottish Water,,Midlothian,Midlothian West, EH24 9DZ,Yes,55.838119,-3.141612,328601,661134,NT286611,1/1/1980 12:00:00 AM,,181,7,3,Newtongrange,5.5,,Scottish Water,,Midlothian,Midlothian South, EH24 9EA,Yes,55.836346,-3.124332,329680,660918,NT296609,1/1/1980 12:00:00 AM,,178,2,1,Newtongrange,4.8,,Scottish Water,,Midlothian,Midlothian South, EH24 9EE,Yes,55.843858,-3.118432,330063,661749,NT300617,1/1/1980 12:00:00 AM,,152,10,4,Newtongrange,4.0,,Scottish Water,,Midlothian,Midlothian South, EH24 9EF,Yes,55.841629,-3.129323,329377,661512,NT293615,1/1/1980 12:00:00 AM,,166,10,4,Newtongrange,4.7,,Scottish Water,,Midlothian,Midlothian South, EH24 9EG,Yes,55.846070,-3.126162,329583,662003,NT295620,1/1/1980 12:00:00 AM,,143,3,1,Newtongrange,4.2,,Scottish Water,,Midlothian,Midlothian South, EH24 9EH,Yes,55.848453,-3.132795,329172,662275,NT291622,1/1/1980 12:00:00 AM,,139,2,1,Newtongrange,4.5,,Scottish Water,,Midlothian,Midlothian South, EH24 9EJ,Yes,55.847395,-3.143194,328519,662167,NT285621,2/1/2005 12:00:00 AM,,162,72,27,Newtongrange,5.1,,Scottish Water,,Midlothian,Midlothian West, EH24 9EL,Yes,55.848754,-3.143984,328472,662320,NT284623,1/1/2007 12:00:00 AM,,163,33,9,Newtongrange,5.1,,Scottish Water,,Midlothian,Midlothian West, EH24 9EN,Yes,55.849008,-3.143736,328488,662348,NT284623,3/1/2005 12:00:00 AM,,162,90,29,Newtongrange,5.1,,Scottish Water,,Midlothian,Midlothian West, EH24 9EP,Yes,55.849005,-3.143991,328472,662347,NT284623,3/1/2005 12:00:00 AM,,163,87,29,Newtongrange,5.1,,Scottish Water,,Midlothian,Midlothian West, EH24 9EQ,Yes,55.847707,-3.131799,329233,662190,NT292621,1/1/1980 12:00:00 AM,,139,8,1,Newtongrange,4.4,,Scottish Water,,Midlothian,Midlothian South, EH24 9ER,Yes,55.848587,-3.142654,328555,662300,NT285622,9/1/2005 12:00:00 AM,,161,37,10,Newtongrange,5.0,,Scottish Water,,Midlothian,Midlothian West, EH24 9ES,Yes,55.847840,-3.143654,328491,662217,NT284622,3/1/2006 12:00:00 AM,,162,80,26,Newtongrange,5.1,,Scottish Water,,Midlothian,Midlothian West, EH24 9ET,Yes,55.847787,-3.124135,329713,662192,NT297621,1/1/2015 12:00:00 AM,,135,,,Newtongrange,4.0,,Scottish Water,,Midlothian,Midlothian South, EH24 9EU,Yes,55.848398,-3.124073,329718,662259,NT297622,10/1/2015 12:00:00 AM,,162,,,Newtongrange,4.0,,Scottish Water,,Midlothian,Midlothian South, EH24 9EW,Yes,55.850544,-3.141817,328611,662517,NT286625,10/1/2020 12:00:00 AM,,164,,,Newtongrange,4.9,,Scottish Water,,Midlothian,Midlothian West, EH24 9EX,Yes,55.852317,-3.140527,328695,662712,NT286627,1/1/2018 12:00:00 AM,,155,,,Newtongrange,4.7,,Scottish Water,,Midlothian,Midlothian West, EH24 9EY,Yes,55.852679,-3.143157,328531,662755,NT285627,4/1/2017 12:00:00 AM,,154,,,Newtongrange,4.9,,Scottish Water,,Midlothian,Midlothian West, EH24 9EZ,Yes,55.857611,-3.131624,329262,663293,NT292632,11/1/2023 12:00:00 AM,,156,,,Newtongrange,4.0,,Scottish Water,,Midlothian,Midlothian West, EH24 9FA,Yes,55.856853,-3.132944,329178,663210,NT291632,10/1/2023 12:00:00 AM,,101,,,Newtongrange,4.1,,Scottish Water,,Midlothian,Midlothian West, EH25 9PY,Yes,55.848047,-3.165701,327111,662264,NT271622,1/1/1980 12:00:00 AM,,155,8,3,Newtongrange,6.4,,Scottish Water,,Midlothian,Midlothian West, EH25 9PZ,Yes,55.847351,-3.163236,327264,662183,NT272621,1/1/1980 12:00:00 AM,,167,13,3,Newtongrange,6.2,,Scottish Water,,Midlothian,Midlothian West, EH25 9QA,Yes,55.845317,-3.164613,327174,661959,NT271619,1/1/1980 12:00:00 AM,,175,9,4,Newtongrange,6.4,,Scottish Water,,Midlothian,Midlothian West, EH25 9QB,Yes,55.842127,-3.171241,326753,661611,NT267616,1/1/1980 12:00:00 AM,,182,9,5,Newtongrange,6.9,,Scottish Water,,Midlothian,Midlothian West, EH25 9QD,No,55.836143,-3.170214,326806,660944,NT268609,1/1/1980 12:00:00 AM,9/1/2005 12:00:00 AM,209,,,Newtongrange,7.2,,Scottish Water,,Midlothian,Midlothian West, EH25 9QE,No,55.834810,-3.173383,326605,660799,NT266607,1/1/1980 12:00:00 AM,6/1/2011 12:00:00 AM,214,,,Newtongrange,7.4,,Scottish Water,,Midlothian,Midlothian West, EH25 9QF,Yes,55.834807,-3.171851,326701,660797,NT267607,1/1/1980 12:00:00 AM,,215,4,1,Newtongrange,7.3,,Scottish Water,,Midlothian,Midlothian West, EH25 9QG,No,55.833198,-3.170924,326756,660617,NT267606,1/1/1980 12:00:00 AM,8/1/2010 12:00:00 AM,219,,,Newtongrange,7.4,,Scottish Water,,Midlothian,Midlothian West, EH25 9QH,Yes,55.838073,-3.189194,325621,661179,NT256611,1/1/1980 12:00:00 AM,,180,6,3,Newtongrange,8.1,,Scottish Water,,Midlothian,Midlothian West, EH25 9QQ,Yes,55.832947,-3.184982,325875,660604,NT258606,1/1/1980 12:00:00 AM,,185,18,7,Newtongrange,8.1,,Scottish Water,,Midlothian,Midlothian West, EH25 9QT,Yes,55.837481,-3.171308,326740,661094,NT267610,9/1/2024 12:00:00 AM,,151,,,Newtongrange,7.2,,,,Midlothian,Midlothian West, EH26 8BD,Yes,55.833461,-3.214311,324039,660693,NT240606,7/1/2013 12:00:00 AM,,184,,,Newtongrange,9.8,,Scottish Water,,Midlothian,Penicuik, EH26 8BF,Yes,55.833082,-3.215369,323972,660652,NT239606,9/1/2013 12:00:00 AM,,184,,,Newtongrange,9.9,,Scottish Water,,Midlothian,Penicuik, EH26 8DA,Yes,55.830891,-3.211549,324207,660404,NT242604,12/1/2009 12:00:00 AM,,185,16,10,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8DE,Yes,55.831664,-3.215213,323979,660494,NT239604,1/1/1980 12:00:00 AM,,191,81,36,Newtongrange,9.9,,Scottish Water,,Midlothian,Penicuik, EH26 8DF,Yes,55.830597,-3.215850,323937,660376,NT239603,1/1/1980 12:00:00 AM,,200,156,62,Newtongrange,10.0,,Scottish Water,,Midlothian,Penicuik, EH26 8DL,Yes,55.832193,-3.215245,323978,660553,NT239605,1/1/1980 12:00:00 AM,,188,80,38,Newtongrange,9.9,,Scottish Water,,Midlothian,Penicuik, EH26 8DN,Yes,55.832001,-3.213834,324066,660530,NT240605,1/1/1980 12:00:00 AM,,187,58,27,Newtongrange,9.8,,Scottish Water,,Midlothian,Penicuik, EH26 8DP,Yes,55.830707,-3.212852,324125,660385,NT241603,1/1/1980 12:00:00 AM,,190,30,12,Newtongrange,9.8,,Scottish Water,,Midlothian,Penicuik, EH26 8DR,Yes,55.831466,-3.211583,324206,660468,NT242604,1/1/1980 12:00:00 AM,,185,37,18,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8DS,Yes,55.830805,-3.212025,324177,660395,NT241603,1/1/1980 12:00:00 AM,,187,0,0,Newtongrange,9.8,,Scottish Water,,Midlothian,Penicuik, EH26 8DT,Yes,55.831482,-3.210881,324250,660469,NT242604,1/1/1980 12:00:00 AM,,182,30,15,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8DU,Yes,55.832156,-3.211796,324194,660545,NT241605,1/1/1980 12:00:00 AM,,184,14,5,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8DW,Yes,55.830678,-3.212149,324169,660381,NT241603,1/1/1980 12:00:00 AM,,187,6,3,Newtongrange,9.8,,Scottish Water,,Midlothian,Penicuik, EH26 8DX,Yes,55.832442,-3.211869,324190,660577,NT241605,1/1/1980 12:00:00 AM,,184,20,9,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8DY,Yes,55.831908,-3.212299,324162,660518,NT241605,1/1/1980 12:00:00 AM,,185,40,18,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8DZ,Yes,55.832441,-3.213816,324068,660579,NT240605,1/1/1980 12:00:00 AM,,185,32,15,Newtongrange,9.8,,Scottish Water,,Midlothian,Penicuik, EH26 8EA,Yes,55.832565,-3.213054,324116,660592,NT241605,1/1/1980 12:00:00 AM,,184,19,9,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8EB,Yes,55.833286,-3.213779,324072,660673,NT240606,1/1/1980 12:00:00 AM,,183,36,12,Newtongrange,9.8,,Scottish Water,,Midlothian,Penicuik, EH26 8ED,Yes,55.833130,-3.213231,324106,660655,NT241606,1/1/1980 12:00:00 AM,,183,31,12,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8EE,Yes,55.834091,-3.214139,324051,660763,NT240607,1/1/1980 12:00:00 AM,,183,26,12,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8EG,Yes,55.833770,-3.212117,324177,660725,NT241607,1/1/1980 12:00:00 AM,,181,33,12,Newtongrange,9.6,,Scottish Water,,Midlothian,Penicuik, EH26 8EH,Yes,55.833407,-3.211547,324212,660684,NT242606,1/1/1980 12:00:00 AM,,181,6,3,Newtongrange,9.6,,Scottish Water,,Midlothian,Penicuik, EH26 8EJ,Yes,55.833201,-3.212387,324159,660662,NT241606,1/1/1980 12:00:00 AM,,183,47,20,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8EL,Yes,55.832889,-3.211196,324233,660626,NT242606,1/1/1980 12:00:00 AM,,182,30,11,Newtongrange,9.6,,Scottish Water,,Midlothian,Penicuik, EH26 8EN,Yes,55.834921,-3.211115,324242,660852,NT242608,1/1/1980 12:00:00 AM,,177,66,27,Newtongrange,9.5,,Scottish Water,,Midlothian,Penicuik, EH26 8EP,Yes,55.834953,-3.210542,324278,660855,NT242608,1/1/1980 12:00:00 AM,,175,89,38,Newtongrange,9.5,,Scottish Water,,Midlothian,Penicuik, EH26 8EQ,Yes,55.833560,-3.212462,324155,660702,NT241607,1/1/1980 12:00:00 AM,,182,10,4,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8ET,Yes,55.834320,-3.212837,324133,660787,NT241607,1/1/1980 12:00:00 AM,,180,85,27,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8EW,Yes,55.832958,-3.210575,324272,660633,NT242606,1/1/1980 12:00:00 AM,,180,25,15,Newtongrange,9.6,,Scottish Water,,Midlothian,Penicuik, EH26 8FA,Yes,55.829560,-3.214445,324023,660259,NT240602,12/1/2020 12:00:00 AM,,174,,,Newtongrange,10.0,,Scottish Water,,Midlothian,Penicuik, EH26 8GZ,Yes,55.833135,-3.208122,324426,660650,NT244606,12/1/1996 12:00:00 AM,,167,19,6,Newtongrange,9.4,,Scottish Water,,Midlothian,Penicuik, EH26 8HT,Yes,55.830492,-3.210116,324296,660358,NT242603,9/1/1990 12:00:00 AM,,179,11,5,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8JA,Yes,55.827443,-3.217715,323814,660027,NT238600,1/1/1980 12:00:00 AM,,195,12,8,Newtongrange,10.2,,Scottish Water,,Midlothian,Penicuik, EH26 8JB,Yes,55.828656,-3.216715,323879,660161,NT238601,1/1/1980 12:00:00 AM,,205,47,16,Newtongrange,10.1,,Scottish Water,,Midlothian,Penicuik, EH26 8JD,Yes,55.829161,-3.214720,324005,660215,NT240602,1/1/1980 12:00:00 AM,,203,10,4,Newtongrange,10.0,,Scottish Water,,Midlothian,Penicuik, EH26 8JE,Yes,55.828157,-3.215455,323957,660104,NT239601,1/1/1980 12:00:00 AM,,204,48,23,Newtongrange,10.1,,Scottish Water,,Midlothian,Penicuik, EH26 8JF,Yes,55.829399,-3.213386,324089,660240,NT240602,1/1/1980 12:00:00 AM,,198,106,37,Newtongrange,9.9,,Scottish Water,,Midlothian,Penicuik, EH26 8JG,Yes,55.831596,-3.210262,324289,660481,NT242604,1/1/1980 12:00:00 AM,,180,40,19,Newtongrange,9.6,,Scottish Water,,Midlothian,Penicuik, EH26 8JH,Yes,55.832721,-3.209099,324364,660605,NT243606,1/1/1980 12:00:00 AM,,173,54,27,Newtongrange,9.5,,Scottish Water,,Midlothian,Penicuik, EH26 8JJ,Yes,55.833621,-3.208952,324375,660705,NT243607,1/1/1980 12:00:00 AM,,171,42,17,Newtongrange,9.5,,Scottish Water,,Midlothian,Penicuik, EH26 8JL,Yes,55.834505,-3.209586,324337,660804,NT243608,1/1/1980 12:00:00 AM,,173,48,24,Newtongrange,9.5,,Scottish Water,,Midlothian,Penicuik, EH26 8JN,Yes,55.835260,-3.207661,324459,660886,NT244608,1/1/1980 12:00:00 AM,,168,67,31,Newtongrange,9.3,,Scottish Water,,Midlothian,Penicuik, EH26 8JQ,Yes,55.833306,-3.209979,324310,660671,NT243606,1/1/1980 12:00:00 AM,,177,57,24,Newtongrange,9.5,,Scottish Water,,Midlothian,Penicuik, EH26 8JW,Yes,55.835272,-3.209210,324362,660889,NT243608,1/1/1980 12:00:00 AM,,173,130,54,Newtongrange,9.4,,Scottish Water,,Midlothian,Penicuik, EH26 8LA,Yes,55.827636,-3.213571,324074,660044,NT240600,1/1/1980 12:00:00 AM,,189,54,26,Newtongrange,10.0,,Scottish Water,,Midlothian,Penicuik, EH26 8LB,Yes,55.828208,-3.213940,324052,660108,NT240601,1/1/1980 12:00:00 AM,,196,10,4,Newtongrange,10.0,,Scottish Water,,Midlothian,Penicuik, EH26 8LD,Yes,55.827394,-3.215351,323962,660019,NT239600,1/1/1980 12:00:00 AM,,200,23,13,Newtongrange,10.1,,Scottish Water,,Midlothian,Penicuik, EH26 8LG,Yes,55.826877,-3.216740,323874,659963,NT238599,3/1/1991 12:00:00 AM,,195,25,9,Newtongrange,10.2,,Scottish Water,,Midlothian,Penicuik, EH26 8LP,Yes,55.823667,-3.216065,323910,659605,NT239596,10/1/1989 12:00:00 AM,,182,28,10,Newtongrange,10.3,,Scottish Water,,Midlothian,Penicuik, EH26 8LS,Yes,55.823608,-3.219255,323710,659602,NT237596,1/1/1980 12:00:00 AM,,172,14,7,Newtongrange,10.5,,Scottish Water,,Midlothian,Penicuik, EH26 8LT,Yes,55.823147,-3.218682,323745,659550,NT237595,1/1/1980 12:00:00 AM,,176,25,11,Newtongrange,10.5,,Scottish Water,,Midlothian,Penicuik, EH26 8NS,Yes,55.825319,-3.218878,323737,659792,NT237597,6/1/1997 12:00:00 AM,,169,78,24,Newtongrange,10.4,,Scottish Water,,Midlothian,Penicuik, EH26 8NT,Yes,55.825287,-3.215748,323933,659785,NT239597,6/1/1997 12:00:00 AM,,170,121,40,Newtongrange,10.2,,Scottish Water,,Midlothian,Penicuik, EH26 8NU,Yes,55.826200,-3.217980,323795,659889,NT237598,6/1/1997 12:00:00 AM,,175,125,51,Newtongrange,10.3,,Scottish Water,,Midlothian,Penicuik, EH26 8PA,Yes,55.831710,-3.208701,324387,660492,NT243604,1/1/1980 12:00:00 AM,,167,16,7,Newtongrange,9.5,,Scottish Water,,Midlothian,Penicuik, EH26 8PB,Yes,55.834565,-3.202499,324781,660803,NT247608,1/1/1980 12:00:00 AM,,177,4,3,Newtongrange,9.1,,Scottish Water,,Midlothian,Penicuik, EH26 8PD,Yes,55.837248,-3.201017,324879,661100,NT248610,1/1/1980 12:00:00 AM,,152,4,2,Newtongrange,8.9,,Scottish Water,,Midlothian,Penicuik, EH26 8PG,Yes,55.831959,-3.196048,325180,660506,NT251605,1/1/1980 12:00:00 AM,,201,20,7,Newtongrange,8.8,,Scottish Water,,Midlothian,Midlothian South, EH26 8PH,Yes,55.828956,-3.201799,324814,660178,NT248601,1/1/1980 12:00:00 AM,,208,28,14,Newtongrange,9.3,,Scottish Water,,Midlothian,Penicuik, EH26 8PJ,Yes,55.820010,-3.209662,324304,659191,NT243591,1/1/1980 12:00:00 AM,,227,22,8,Newtongrange,10.2,,Scottish Water,,Midlothian,Penicuik, EH26 8PQ,Yes,55.831759,-3.201885,324814,660490,NT248604,1/1/1980 12:00:00 AM,,191,4,2,Newtongrange,9.1,,Scottish Water,,Midlothian,Penicuik, EH26 8PW,Yes,55.809791,-3.220770,323588,658066,NT235580,1/1/1980 12:00:00 AM,,236,5,2,Newtongrange,11.4,,Scottish Water,,Midlothian,Penicuik, EH26 8QL,No,55.831601,-3.208809,324380,660480,NT243604,12/1/1990 12:00:00 AM,12/1/1994 12:00:00 AM,168,,,Newtongrange,9.5,,Scottish Water,,Midlothian,Penicuik, EH26 8QN,No,55.830776,-3.208624,324390,660388,NT243603,1/1/1992 12:00:00 AM,12/1/1998 12:00:00 AM,165,,,Newtongrange,9.6,,Scottish Water,,Midlothian,Penicuik, EH26 8QR,Yes,55.829707,-3.209501,324333,660270,NT243602,3/1/2007 12:00:00 AM,,167,176,72,Newtongrange,9.7,,Scottish Water,,Midlothian,Penicuik, EH26 8YR,No,55.831122,-3.215483,323961,660434,NT239604,6/1/1999 12:00:00 AM,6/1/2000 12:00:00 AM,196,,,Newtongrange,9.9,,Scottish Water,,Midlothian,Penicuik, EH26 8YS,No,55.831122,-3.215483,323961,660434,NT239604,12/1/1998 12:00:00 AM,9/1/2000 12:00:00 AM,196,,,Newtongrange,9.9,,Scottish Water,,Midlothian,Penicuik, EH26 8YT,No,55.831122,-3.215483,323961,660434,NT239604,6/1/1997 12:00:00 AM,7/1/2000 12:00:00 AM,196,,,Newtongrange,9.9,,Scottish Water,,Midlothian,Penicuik, EH37 5RG,Yes,55.871986,-2.992348,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.872744,-2.996347,337754,664847,NT377648,1/1/1980 12:00:00 AM,,170,2,2,Newtongrange,4.6,,Scottish Water,,Midlothian,Midlothian East, EH37 5RJ,Yes,55.874276,-3.000302,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.875320,-3.002183,337393,665138,NT373651,1/1/1980 12:00:00 AM,,201,41,18,Newtongrange,4.3,,Scottish Water,,Midlothian,Midlothian East, EH37 5RN,Yes,55.876118,-3.000253,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.876699,-3.005063,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.871883,-2.995110,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.875393,-3.003175,337331,665147,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.875963,-3.003813,337292,665212,NT372652,1/1/1980 12:00:00 AM,,207,9,5,Newtongrange,4.2,,Scottish Water,,Midlothian,Midlothian East, EH37 5TY,Yes,55.877118,-2.986549,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.880053,-2.989213,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.884080,-2.990083,338164,666102,NT381661,1/1/1980 12:00:00 AM,,153,1,1,Newtongrange,5.3,,Scottish Water,,Midlothian,Midlothian East, EH37 5UB,Yes,55.879863,-2.984828,338486,665628,NT384656,1/1/1980 12:00:00 AM,,146,19,8,Newtongrange,5.5,,Scottish Water,,Midlothian,Midlothian East, EH37 5UD,No,55.878747,-2.979461,338820,665500,NT388654,1/1/1980 12:00:00 AM,12/1/1995 12:00:00 AM,130,,,Newtongrange,5.8,,Scottish Water,,Midlothian,Midlothian East, EH37 5UG,Yes,55.881161,-2.969707,339434,665760,NT394657,1/1/1980 12:00:00 AM,,129,15,6,Newtongrange,6.4,,Scottish Water,,Midlothian,Midlothian East, EH37 5UQ,Yes,55.882128,-2.958589,340131,665857,NT401658,1/1/1980 12:00:00 AM,,138,17,9,Newtongrange,7.1,,Scottish Water,,Midlothian,Midlothian East,