Postcode,In Use?,Latitude,Longitude,Easting,Northing,Grid Ref,County,District,Ward,District Code,Ward Code,Country,County Code,Constituency,Introduced,Terminated,Parish,National Park,Population,Households,Built up area,Built up sub-division,Lower layer super output area,Rural/urban,Region,Altitude,London zone,LSOA Code,Local authority,MSOA Code,Middle layer super output area,Parish Code,Census output area,Constituency Code,Index of Multiple Deprivation,Quality,User Type,Last updated,Nearest station,Distance to station,Postcode area,Postcode district,Police force,Water company,Plus Code,Average Income,Sewage Company,Travel To Work Area,ITL level 2,ITL level 3,UPRNs,Distance to sea,LSOA21 Code,Lower layer super output area 2021,MSOA21 Code,Middle layer super output area 2021,Census output area 2021,IMD decile,Constituency Code 2024,Constituency Name 2024 EH22 5AA,Yes,55.875171,-3.041269,334947,665158,NT349651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",53,20,"","","Easthouses - 03","Other urban area",Scotland,145,,S01011023,,S02002068,"Easthouses",,S00120833,S14000045,2160,1,0,2024-05-24,"Newtongrange",1.97301,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+3F,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031131,120031132,120031133,120031134,120031135,120031136,120031137,120031138,120031139,120031140,120031141,120031142,120031143,120031144,120031145,120031146,120031147,120031148,120031238,120031239,120052474,10025427615,10025427630",7.91064,,"",,"",,4,S14000045,"Midlothian" EH22 5AB,Yes,55.875788,-3.042104,334896,665227,NT348652,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",13,7,"","","Easthouses - 03","Other urban area",Scotland,141,,S01011023,,S02002068,"Easthouses",,S00120833,S14000045,2160,1,0,2024-05-24,"Newtongrange",1.96016,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+85,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025404,120025405,120025406,120025407,120025408,120025409,120025410,120032608,120041629,120042375",7.83375,,"",,"",,4,S14000045,"Midlothian" EH22 5AD,Yes,55.876840,-3.043711,334797,665346,NT347653,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",89,42,"","","Easthouses - 03","Other urban area",Scotland,137,,S01011023,,S02002068,"Easthouses",,S00120836,S14000045,2160,1,0,2024-05-24,"Newtongrange",1.93742,EH,EH22,"Scotland","Scottish Water",9C7RVXG4+PG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031149,120031150,120031151,120031152,120031153,120031154,120031155,120031156,120031157,120031158,120031159,120031160,120031161,120031162,120031163,120031164,120031165,120031166,120031167,120031168,120031169,120031170,120031171,120031172,120031173,120031174,120031175,120031176,120031177,120031178,120031179,120031180,120031181,120031182,120031183,120031184,120031185,120031186,120031187,120031188,120031189,120031190,120031191,120031192,120031193,120031194,120031240,120031241,120041722,10025271265",7.70115,,"",,"",,4,S14000045,"Midlothian" EH22 5AE,Yes,55.877940,-3.044252,334765,665469,NT347654,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",15,6,"","","Easthouses - 02","Other urban area",Scotland,135,,S01011022,,S02002068,"Easthouses",,S00120838,S14000045,1034,1,0,2024-05-24,"Newtongrange",1.98217,EH,EH22,"Scotland","Scottish Water",9C7RVXH4+57,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025411,120025412,120025413,120025414,120025415,120025416,120041897",7.57497,,"",,"",,2,S14000045,"Midlothian" EH22 5AF,Yes,55.878162,-3.045696,334675,665495,NT346654,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",33,14,"","","Easthouses - 02","Other urban area",Scotland,129,,S01011022,,S02002068,"Easthouses",,S00120838,S14000045,1034,1,0,2024-05-24,"Newtongrange",1.92763,EH,EH22,"Scotland","Scottish Water",9C7RVXH3+7P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025417,120025418,120025419,120025420,120025421,120025422,120025423,120025424,120025425,120025426,120025427,120025428,120025429,120025430,120042237,120042326,10025428179",7.536,,"",,"",,2,S14000045,"Midlothian" EH22 5AG,Yes,55.879018,-3.045384,334696,665590,NT346655,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",15,7,"","","Easthouses - 02","Other urban area",Scotland,130,,S01011022,,S02002068,"Easthouses",,S00120840,S14000045,1034,1,0,2024-05-24,"Newtongrange",2.00462,EH,EH22,"Scotland","Scottish Water",9C7RVXH3+JR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025431,120025432,120025433,120025434,120025435,120025436,120025437,120025438,120042811",7.44519,,"",,"",,2,S14000045,"Midlothian" EH22 5AH,Yes,55.878422,-3.044664,334740,665523,NT347655,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",28,9,"","","Easthouses - 02","Other urban area",Scotland,134,,S01011022,,S02002068,"Easthouses",,S00120838,S14000045,1034,1,0,2024-05-24,"Newtongrange",1.99556,EH,EH22,"Scotland","Scottish Water",9C7RVXH4+94,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025439,120025440,120025441,120025442,120025443,120025444,120025445,120025446,120025447,120025448",7.51788,,"",,"",,2,S14000045,"Midlothian" EH22 5AJ,Yes,55.879377,-3.044402,334758,665629,NT347656,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",43,15,"","","Easthouses - 02","Other urban area",Scotland,134,,S01011022,,S02002068,"Easthouses",,S00120840,S14000045,1034,1,0,2024-05-24,"Newtongrange",2.07687,EH,EH22,"Scotland","Scottish Water",9C7RVXH4+Q6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025449,120025450,120025451,120025452,120025453,120025454,120025455,120025456,120025457,120025458,120025459,120025460,120025461,120025462,120025463,120025464",7.41602,,"",,"",,2,S14000045,"Midlothian" EH22 5AL,Yes,55.879399,-3.044914,334726,665632,NT347656,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",17,8,"","","Easthouses - 02","Other urban area",Scotland,132,,S01011022,,S02002068,"Easthouses",,S00120840,S14000045,1034,1,0,2024-05-24,"Newtongrange",2.0547,EH,EH22,"Scotland","Scottish Water",9C7RVXH4+Q2,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025465,120025466,120025467,120025468,120025469,120025470,120025471,120025472,120025473,120025474",7.40823,,"",,"",,2,S14000045,"Midlothian" EH22 5AN,Yes,55.879567,-3.045303,334702,665651,NT347656,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",71,30,"","","Easthouses - 02","Other urban area",Scotland,129,,S01011022,,S02002068,"Easthouses",,S00120840,S14000045,1034,1,0,2024-05-24,"Newtongrange",2.04944,EH,EH22,"Scotland","Scottish Water",9C7RVXH3+RV,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031195,120031196,120031197,120031198,120031199,120031200,120031201,120031202,120031203,120031204,120031205,120031206,120031207,120031208,120031209,120031210,120031211,120031212,120031213,120031214,120031215,120031216,120031217,120031218,120031219,120031220,120031221,120031222,120031242,120031243",7.38582,,"",,"",,2,S14000045,"Midlothian" EH22 5AP,Yes,55.880345,-3.043613,334809,665736,NT348657,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",15,7,"","","Easthouses - 02","Other urban area",Scotland,134,,S01011022,,S02002068,"Easthouses",,S00120839,S14000045,1034,1,0,2024-05-24,"Newtongrange",2.18547,EH,EH22,"Scotland","Scottish Water",9C7RVXJ4+4H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025475,120025476,120031223,120031224,120031225,120031226,120031227,120031244,120036191",7.31872,,"",,"",,2,S14000045,"Midlothian" EH22 5AQ,Yes,55.878274,-3.045172,334708,665507,NT347655,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",24,10,"","","Easthouses - 02","Other urban area",Scotland,131,,S01011022,,S02002068,"Easthouses",,S00120838,S14000045,1034,1,0,2024-05-24,"Newtongrange",1.96068,EH,EH22,"Scotland","Scottish Water",9C7RVXH3+8W,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025477,120025478,120025479,120025480,120025481,120025482,120025483,120025484,120025485,120025486",7.52891,,"",,"",,2,S14000045,"Midlothian" EH22 5AR,Yes,55.881099,-3.041523,334941,665818,NT349658,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",79,30,"","","Easthouses - 02","Other urban area",Scotland,138,,S01011022,,S02002068,"Easthouses",,S00120839,S14000045,1034,1,0,2024-05-24,"Newtongrange",2.33817,EH,EH22,"Scotland","Scottish Water",9C7RVXJ5+C9,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025487,120025488,120025489,120025490,120025491,120025492,120025493,120025494,120025495,120025496,120025497,120025498,120025499,120025500,120025501,120025502,120025503,120025504,120025505,120025506,120025507,120025508,120025509,120025510,120025511,120025512,120028950,120028951,120028952,120028953,120028954,120028955",7.26108,,"",,"",,2,S14000045,"Midlothian" EH22 5AS,Yes,55.880959,-3.041056,334970,665802,NT349658,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",68,29,"","","Easthouses - 02","Other urban area",Scotland,140,,S01011022,,S02002068,"Easthouses",,S00120839,S14000045,1034,1,0,2024-05-24,"Newtongrange",2.34957,EH,EH22,"Scotland","Scottish Water",9C7RVXJ5+9H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025513,120025514,120025515,120025516,120025517,120025518,120025519,120025520,120025521,120025522,120025523,120025524,120025525,120025526,120025527,120025528,120025529,120025530,120025531,120028956,120028957,120028958,120028959,120028960,120028961,120028962,120028963,120028964,120028965,120028966,120042358",7.28216,,"",,"",,2,S14000045,"Midlothian" EH22 5AT,Yes,55.878984,-3.044072,334778,665585,NT347655,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",73,27,"","","Easthouses - 02","Other urban area",Scotland,135,,S01011022,,S02002068,"Easthouses",,S00120837,S14000045,1034,1,0,2024-05-24,"Newtongrange",2.0639,EH,EH22,"Scotland","Scottish Water",9C7RVXH4+H9,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025532,120025533,120025534,120025535,120025536,120025537,120025538,120025539,120025540,120025541,120025542,120025543,120025544,120025545,120025546,120025547,120025548,120025549,120025550,120025551,120025552,120025553,120025554,120025555,120025556,120025557,120025558,120025559",7.46257,,"",,"",,2,S14000045,"Midlothian" EH22 5AU,Yes,55.878183,-3.043687,334801,665495,NT348654,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",5,2,"","","Easthouses - 02","Other urban area",Scotland,137,,S01011022,,S02002068,"Easthouses",,S00120837,S14000045,1034,1,0,2024-05-24,"Newtongrange",2.02654,EH,EH22,"Scotland","Scottish Water",9C7RVXH4+7G,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025560,120025561,120032485,120032491",7.55438,,"",,"",,2,S14000045,"Midlothian" EH22 5AW,Yes,55.880082,-3.043878,334792,665707,NT347657,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",12,5,"","","Easthouses - 02","Other urban area",Scotland,133,,S01011022,,S02002068,"Easthouses",,S00120840,S14000045,1034,1,0,2024-05-24,"Newtongrange",2.15353,EH,EH22,"Scotland","Scottish Water",9C7RVXJ4+2C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025562,120025563,120025564,120025565,120025566",7.34453,,"",,"",,2,S14000045,"Midlothian" EH22 5AX,Yes,55.877536,-3.043186,334831,665423,NT348654,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",47,18,"","","Easthouses - 02","Other urban area",Scotland,139,,S01011022,,S02002068,"Easthouses",,S00120837,S14000045,1034,1,0,2024-05-24,"Newtongrange",2.00858,EH,EH22,"Scotland","Scottish Water",9C7RVXH4+2P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025567,120025568,120025569,120025570,120025571,120025572,120025573,120025574,120025575,120025576,120025577,120025578,120025579,120025580,120025581,120025582,120025583,120025584,120042359,120053822",7.63062,,"",,"",,2,S14000045,"Midlothian" EH22 5AY,Yes,55.877139,-3.043367,334819,665379,NT348653,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",33,12,"","","Easthouses - 03","Other urban area",Scotland,138,,S01011023,,S02002068,"Easthouses",,S00120836,S14000045,2160,1,0,2024-05-24,"Newtongrange",1.97393,EH,EH22,"Scotland","Scottish Water",9C7RVXG4+VM,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025585,120025586,120025587,120025588,120025589,120025590,120025591,120025592,120025593,120025594,120025595,120025596",7.67209,,"",,"",,4,S14000045,"Midlothian" EH22 5AZ,Yes,55.877713,-3.042488,334875,665442,NT348654,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",36,16,"","","Easthouses - 02","Other urban area",Scotland,141,,S01011022,,S02002068,"Easthouses",,S00120837,S14000045,1034,1,0,2024-05-24,"Newtongrange",2.05542,EH,EH22,"Scotland","Scottish Water",9C7RVXH5+32,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025597,120025598,120025599,120025600,120025601,120025602,120025603,120025604,120025605,120025606,120025607,120025608,120025609,120025610,120025611,120025612,120025613,120025614,10024913910",7.61904,,"",,"",,2,S14000045,"Midlothian" EH22 5BA,Yes,55.876482,-3.042471,334874,665305,NT348653,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",19,9,"","","Easthouses - 03","Other urban area",Scotland,141,,S01011023,,S02002068,"Easthouses",,S00120835,S14000045,2160,1,0,2024-05-24,"Newtongrange",1.98027,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+H2,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025615,120025616,120025617,120025618,120025619,120025620,120031228,120031229,120031230,120031231,120031232,120031245",7.75378,,"",,"",,4,S14000045,"Midlothian" EH22 5BB,Yes,55.876463,-3.041511,334934,665302,NT349653,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",9,4,"","","Easthouses - 03","Other urban area",Scotland,144,,S01011023,,S02002068,"Easthouses",,S00120835,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.0301,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+H9,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025621,120025622,120025623,120025624,120038648,120048656,10015453831",7.76677,,"",,"",,4,S14000045,"Midlothian" EH22 5BD,Yes,55.876150,-3.041327,334945,665267,NT349652,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",6,3,"","","Easthouses - 03","Other urban area",Scotland,145,,S01011023,,S02002068,"Easthouses",,S00120835,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.02222,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+FF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025644,120025645,120025646,120041628,120042546",7.80307,,"",,"",,4,S14000045,"Midlothian" EH22 5BE,Yes,55.876414,-3.040902,334972,665296,NT349652,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",12,7,"","","Easthouses - 03","Other urban area",Scotland,147,,S01011023,,S02002068,"Easthouses",,S00120835,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.05991,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+HJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025625,120025626,120025627,120025628,120025629,120025630,120025631",7.77926,,"",,"",,4,S14000045,"Midlothian" EH22 5BF,Yes,55.875202,-3.042440,334874,665163,NT348651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2021-06-01,,"","",,,"","","Mayfield - 03","Other urban area",Scotland,146,,S01011027,,S02002069,"Mayfield",,S00120811,S14000045,775,1,0,2024-05-24,"Newtongrange",1.91012,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+32,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120055451,120055452,120055453,120055454,120055455,120055456,120055457,120055458,120055459,120055460,120055461,120055462,120055463,120055464,120055465,120055466,120055467,120055468,120055469,120055470,10015396235",7.89411,,"",,"",,2,S14000045,"Midlothian" EH22 5BG,Yes,55.876055,-3.040925,334970,665256,NT349652,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",1,1,"","","Easthouses - 03","Other urban area",Scotland,147,,S01011023,,S02002068,"Easthouses",,S00120835,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.0387,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+CJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025647,10025271266",7.81815,,"",,"",,4,S14000045,"Midlothian" EH22 5BH,Yes,55.875781,-3.041429,334938,665226,NT349652,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",6,3,"","","Easthouses - 03","Other urban area",Scotland,144,,S01011023,,S02002068,"Easthouses",,S00120835,S14000045,2160,1,0,2024-05-24,"Newtongrange",1.99638,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+8C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025648,120025649,120025650",7.84218,,"",,"",,4,S14000045,"Midlothian" EH22 5BJ,Yes,55.875365,-3.040682,334984,665179,NT349651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",18,7,"","","Easthouses - 03","Other urban area",Scotland,147,,S01011023,,S02002068,"Easthouses",,S00120834,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.01541,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+4P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025651,120025652,120025653,120025654,120025655,120025656,120025657,120029049,120041893,120042269",7.89631,,"",,"",,4,S14000045,"Midlothian" EH22 5BL,Yes,55.875580,-3.039681,335047,665202,NT350652,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,6,"","","Easthouses - 03","Other urban area",Scotland,152,,S01011023,,S02002068,"Easthouses",,S00120834,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.08182,EH,EH22,"Scotland","Scottish Water",9C7RVXG6+64,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120029050,120029051,120029052,120029053,120029054,120029055,120029056",7.88494,,"",,"",,4,S14000045,"Midlothian" EH22 5BN,Yes,55.875503,-3.039184,335078,665193,NT350651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",12,5,"","","Easthouses - 04","Other urban area",Scotland,154,,S01011024,,S02002068,"Easthouses",,S00120830,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.10556,EH,EH22,"Scotland","Scottish Water",9C7RVXG6+68,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120029057,120029058,120029059,120029060,120029061",7.8995,,"",,"",,2,S14000045,"Midlothian" EH22 5BP,Yes,55.874689,-3.039833,335036,665103,NT350651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",21,9,"","","Easthouses - 04","Other urban area",Scotland,150,,S01011024,,S02002068,"Easthouses",,S00120831,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.0298,EH,EH22,"Scotland","Scottish Water",9C7RVXF6+V3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120029062,120029063,120029064,120029065,120029066,120029067,120029068,120029069,120029070",7.98018,,"",,"",,2,S14000045,"Midlothian" EH22 5BQ,Yes,55.875539,-3.040240,335012,665198,NT350651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",18,7,"","","Easthouses - 03","Other urban area",Scotland,150,,S01011023,,S02002068,"Easthouses",,S00120834,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.04878,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+6W,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025658,120025659,120029071,120029072,120029073,120029074,120029075",7.8826,,"",,"",,4,S14000045,"Midlothian" EH22 5BS,Yes,55.874107,-3.039578,335051,665038,NT350650,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",7,3,"","","Easthouses - 04","Other urban area",Scotland,150,,S01011024,,S02002068,"Easthouses",,S00120831,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.01807,EH,EH22,"Scotland","Scottish Water",9C7RVXF6+J5,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031490,120031491,120031509",8.04671,,"",,"",,2,S14000045,"Midlothian" EH22 5BT,Yes,55.874806,-3.038798,335101,665115,NT351651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",38,19,"","","Easthouses - 04","Other urban area",Scotland,154,,S01011024,,S02002068,"Easthouses",,S00120830,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.09386,EH,EH22,"Scotland","Scottish Water",9C7RVXF6+WF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120029076,120029077,120029078,120029079,120029080,120029081,120029082,120029083,120029084,120029085,120029086,120029087,120029088,120029089,120031512,120031513,120031514,120031515,120031516,120031517,120042765",7.98022,,"",,"",,2,S14000045,"Midlothian" EH22 5BU,Yes,55.874926,-3.038321,335131,665128,NT351651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",36,11,"","","Easthouses - 04","Other urban area",Scotland,157,,S01011024,,S02002068,"Easthouses",,S00120830,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.12644,EH,EH22,"Scotland","Scottish Water",9C7RVXF6+XM,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120029090,120029091,120029092,120029093,120029094,120029095,120029096,120029097,120029098,120029099,120029100,120051859,120056226",7.97323,,"",,"",,2,S14000045,"Midlothian" EH22 5BW,Yes,55.874793,-3.039165,335078,665114,NT350651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",45,17,"","","Easthouses - 04","Other urban area",Scotland,153,,S01011024,,S02002068,"Easthouses",,S00120831,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.07245,EH,EH22,"Scotland","Scottish Water",9C7RVXF6+W8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120029101,120029102,120029103,120029104,120029105,120029106,120029107,120031518,120031519,120031520,120031521,120031522,120031523,120031524,120031525,120031526,120031527",7.97704,,"",,"",,2,S14000045,"Midlothian" EH22 5BX,Yes,55.875534,-3.038166,335142,665195,NT351651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",4,2,"","","Easthouses - 04","Other urban area",Scotland,159,,S01011024,,S02002068,"Easthouses",,S00120830,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.16397,EH,EH22,"Scotland","Scottish Water",9C7RVXG6+6P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028967,120028968",7.90914,,"",,"",,2,S14000045,"Midlothian" EH22 5BY,Yes,55.875923,-3.038460,335124,665239,NT351652,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",32,12,"","","Easthouses - 03","Other urban area",Scotland,159,,S01011023,,S02002068,"Easthouses",,S00120834,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.16693,EH,EH22,"Scotland","Scottish Water",9C7RVXG6+9J,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028969,120028970,120028971,120028972,120028973,120028974,120028975,120028976,120028977,120028978,120028979,120028980,120028981,120029108,120036131,10024862522",7.86305,,"",,"",,4,S14000045,"Midlothian" EH22 5BZ,Yes,55.875712,-3.038934,335094,665216,NT350652,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,4,"","","Easthouses - 03","Other urban area",Scotland,156,,S01011023,,S02002068,"Easthouses",,S00120834,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.12995,EH,EH22,"Scotland","Scottish Water",9C7RVXG6+7C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028982,120028983,120028984,120028985",7.87992,,"",,"",,4,S14000045,"Midlothian" EH22 5DA,Yes,55.876224,-3.039495,335060,665274,NT350652,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",3,2,"","","Easthouses - 03","Other urban area",Scotland,154,,S01011023,,S02002068,"Easthouses",,S00120835,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.12568,EH,EH22,"Scotland","Scottish Water",9C7RVXG6+F6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028986,120028987",7.81713,,"",,"",,4,S14000045,"Midlothian" EH22 5DB,Yes,55.876269,-3.040003,335028,665279,NT350652,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",9,3,"","","Easthouses - 03","Other urban area",Scotland,152,,S01011023,,S02002068,"Easthouses",,S00120835,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.10044,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+GX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028988,120028989,120028990,120041641",7.80593,,"",,"",,4,S14000045,"Midlothian" EH22 5DD,Yes,55.876103,-3.040494,334997,665261,NT349652,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",18,5,"","","Easthouses - 03","Other urban area",Scotland,149,,S01011023,,S02002068,"Easthouses",,S00120835,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.06472,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+CR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025632,120025633,120025634,120028991,120028992",7.81805,,"",,"",,4,S14000045,"Midlothian" EH22 5DE,Yes,55.875846,-3.040120,335020,665232,NT350652,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,5,"","","Easthouses - 03","Other urban area",Scotland,151,,S01011023,,S02002068,"Easthouses",,S00120834,S14000045,2160,1,0,2024-05-24,"Newtongrange",2.07138,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+8X,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120025635,120028993,120028994,120028995,120028996",7.85059,,"",,"",,4,S14000045,"Midlothian" EH22 5DF,Yes,55.875219,-3.041466,334935,665164,NT349651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2024-03-01,,"","",0,0,"","","Easthouses - 03","Other urban area",Scotland,140,,S01011023,,S02002068,"Easthouses",,S00120833,S14000045,2160,5,0,2024-05-24,"Newtongrange",1.96458,EH,EH22,"Scotland","Scottish Water",9C7RVXG5+3C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",7.90314,,"",,"",,4,S14000045,"Midlothian" EH22 5DG,Yes,55.874601,-3.042804,334850,665096,NT348650,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",29,12,"","","Mayfield - 03","Other urban area",Scotland,140,,S01011027,,S02002069,"Mayfield",,S00120811,S14000045,775,1,0,2024-05-24,"Newtongrange",1.85895,EH,EH22,"Scotland","Scottish Water",9C7RVXF4+RV,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024960,120024961,120025636,120025637,120025638,120025660,120025661,120025662,120025664,120025665,120025666,120031124,120031247,120031248,120031249,120031250,120031251,120031252,120031253,120031254,120031255,120031256,120031257,120031258,120032486,120032490,120033754,120035021,120036585,120037939,120037940,120038065,120050948,10092048032",7.95594,,"",,"",,2,S14000045,"Midlothian" EH22 5DH,No,55.876696,-3.043659,334800,665330,NT348653,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1990-12-01,1992-07-01,"","",,,"","","Easthouses - 03","Other urban area",Scotland,137,,S01011023,,S02002068,"Easthouses",,S00120836,S14000045,2160,8,1,2024-05-24,"Newtongrange",1.93112,EH,EH22,"Scotland","Scottish Water",9C7RVXG4+MG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",7.71747,,"",,"",,4,S14000045,"Midlothian" EH22 5DJ,Yes,55.875420,-3.043181,334828,665188,NT348651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2024-02-01,,"","",,,"","","Easthouses - 03","Other urban area",Scotland,154,,S01011023,,S02002068,"Easthouses",,S00120836,S14000045,2160,5,0,2024-05-24,"Newtongrange",1.88158,EH,EH22,"Scotland","Scottish Water",9C7RVXG4+5P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",7.86226,,"",,"",,4,S14000045,"Midlothian" EH22 5DL,No,55.871590,-3.038616,335107,664757,NT351647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2001-01-01,2001-02-01,"","",,,"","","Mayfield - 03","Other urban area",Scotland,156,,S01011027,,S02002069,"Mayfield",,S00120816,S14000045,775,6,1,2024-05-24,"Newtongrange",1.98387,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+JH,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.33272,,"",,"",,2,S14000045,"Midlothian" EH22 5DN,Yes,55.868160,-3.044740,334718,664381,NT347643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2008-09-01,,"","",105,40,"","","Mayfield - 04","Other urban area",Scotland,148,,S01011028,,S02002069,"Mayfield",,S00120804,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.54085,EH,EH22,"Scotland","Scottish Water",9C7RVX94+74,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120036668,120039383,120039384,120039385,120039386,120039387,120039388,120039389,120039390,120039391,120041081,120041082,120041083,120041084,120041085,120041086,120041087,120041088,120041089,120041090,120041091,120041092,120041093,120041094,120041095,120041096,120041097,120041098,120041099,120041100,120041101,120041102,120041103,120041104,120041105,120041106,120041107,120041108,120041109,120041110,120041111,120041112,120041118,120041119,120041120,120041121,120041122,120041860,120041861,120041994,120043650,120043651,120043652,120043653",8.64376,,"",,"",,3,S14000045,"Midlothian" EH22 5DP,Yes,55.880624,-3.040875,334981,665764,NT349657,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2012-03-01,,"","",,,"","","Pathhead and Rural East Midlothian - 04","Accessible rural area",Scotland,143,,S01011017,,S02002067,"Pathhead and Rural East Midlothian",,S00120914,S14000045,2943,1,0,2024-05-24,"Newtongrange",2.33374,EH,EH22,"Scotland","Scottish Water",9C7RVXJ5+6M,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120045808,120045809,120045889,120045890,120046232,120046233,120046326,120046327,120046380,120046402,120046449,120046450,120046451,120046452,120046453,120046454,120046455,120046456,120046577,120046578,120046579,120046580,120046581,120046582,120046583,120046584,120046585,120046586,120046587,120046588,120046589,120046590,120046591,120046592,120046593,120046594,120046595,120046596",7.3209,,"",,"",,5,S14000045,"Midlothian" EH22 5DQ,Yes,55.875420,-3.043181,334828,665188,NT348651,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2017-02-01,,"","",1,1,"","","Easthouses - 03","Other urban area",Scotland,139,,S01011023,,S02002068,"Easthouses",,S00120836,S14000045,2160,1,0,2024-05-24,"Newtongrange",1.88158,EH,EH22,"Scotland","Scottish Water",9C7RVXG4+5P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031123,120032488,120032489,120042236,120046669,120046670,120046671,120046672,120046673,120046674,120046675,120050121,120051141,120051142,120051143,120051144,120051145,120051146,10024913909,10025271267",7.86226,,"",,"",,4,S14000045,"Midlothian" EH22 5DT,Yes,55.870193,-3.042398,334868,664605,NT348646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1998-06-01,,"","",40,15,"","","Mayfield - 03","Other urban area",Scotland,149,,S01011027,,S02002069,"Mayfield",,S00120810,S14000045,775,1,0,2024-05-24,"Newtongrange",1.71845,EH,EH22,"Scotland","Scottish Water",9C7RVXC5+32,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024420,120024421,120024422,120024423,120024424,120024425,120024426,120024427,120024428,120024429,120024430,120024431,120024432,120024433,120024434",8.44305,,"",,"",,2,S14000045,"Midlothian" EH22 5DW,Yes,55.880190,-3.040192,335023,665716,NT350657,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2012-04-01,,"","",,,"","","Pathhead and Rural East Midlothian - 04","Accessible rural area",Scotland,147,,S01011017,,S02002067,"Pathhead and Rural East Midlothian",,S00120914,S14000045,2943,1,0,2024-05-24,"Newtongrange",2.33576,EH,EH22,"Scotland","Scottish Water",9C7RVXJ5+3W,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120035525,120045927,120045938,120045939,120045940,120045941,120045942,120045943,120045944,120045945,120046012,120046117,120046125,120046152,120046153,120046154,120046155,120046156,120046157,120046348,120046349,120046350,120046351,120046352,120046353,120046532,120046551,120046552,120046553,120046556,120046557,120046597,120046598,120046599,120046600,120046601,120046602,120046603,120046604,120046605,120046606,120046607,120046608,120046609,120046610,120046611,120046612,120046613,120046614,120046615,120046616",7.37682,,"",,"",,5,S14000045,"Midlothian" EH22 5DX,Yes,55.874480,-3.040099,335019,665080,NT350650,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",50,19,"","","Easthouses - 04","Other urban area",Scotland,149,,S01011024,,S02002068,"Easthouses",,S00120831,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.00503,EH,EH22,"Scotland","Scottish Water",9C7RVXF5+QX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031233,120031234,120031235,120031236,120031237,120031246,120031492,120031493,120031494,120031495,120031496,120031497,120031498,120031499,120031500,120031501,120031502,120031503,120031510,120042484",7.99977,,"",,"",,2,S14000045,"Midlothian" EH22 5DY,Yes,55.873640,-3.040684,334981,664987,NT349649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",32,17,"","","Mayfield - 03","Other urban area",Scotland,146,,S01011027,,S02002069,"Mayfield",,S00120813,S14000045,775,1,0,2024-05-24,"Newtongrange",1.93443,EH,EH22,"Scotland","Scottish Water",9C7RVXF5+FP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024503,120024504,120024505,120025639,120025640,120025641,120025642,120025643,120027721,120027722,120027723,120031013,120031014,120031015,120031016,120031017,120031018,120032484,120032487,120033147,120041977,120043533,120044269,120044270,120051151,10025271272",8.08458,,"",,"",,2,S14000045,"Midlothian" EH22 5DZ,Yes,55.872558,-3.040000,335022,664866,NT350648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",43,19,"","","Mayfield - 03","Other urban area",Scotland,150,,S01011027,,S02002069,"Mayfield",,S00120813,S14000045,775,1,0,2024-05-24,"Newtongrange",1.93223,EH,EH22,"Scotland","Scottish Water",9C7RVXF6+22,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024506,120024507,120027724,120027725,120027726,120027727,120027728,120027729,120027730,120027731,120027732,120027733,120031272,120031273,120031274,120031275,120031276,120031277,120032606,10024905851",8.21064,,"",,"",,2,S14000045,"Midlothian" EH22 5EA,Yes,55.871546,-3.040644,334980,664754,NT349647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",44,28,"","","Mayfield - 03","Other urban area",Scotland,151,,S01011027,,S02002069,"Mayfield",,S00120810,S14000045,775,1,0,2024-05-24,"Newtongrange",1.86063,EH,EH22,"Scotland","Scottish Water",9C7RVXC5+JP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024508,120024509,120024510,120024511,120024512,120024513,120024514,120024515,120031278,120031279,120031280,120031281,120031440,120032468,120032622,120034181,120035941,120035942,120035943,120035944,120035945,120035946,120035947,120035948,120035949,120035950,120035951,120035952,120035953,120035954,120035955,120035958,120041688,120052910",8.3138,,"",,"",,2,S14000045,"Midlothian" EH22 5EB,Yes,55.872311,-3.041544,334925,664840,NT349648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",0,0,"","","Mayfield - 03","Other urban area",Scotland,146,,S01011027,,S02002069,"Mayfield",,S00120810,S14000045,775,1,0,2024-05-24,"Newtongrange",1.83225,EH,EH22,"Scotland","Scottish Water",9C7RVXC5+W9,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024955",8.22017,,"",,"",,2,S14000045,"Midlothian" EH22 5ED,Yes,55.872516,-3.040718,334977,664862,NT349648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",42,17,"","","Mayfield - 03","Other urban area",Scotland,148,,S01011027,,S02002069,"Mayfield",,S00120811,S14000045,775,1,0,2024-05-24,"Newtongrange",1.88835,EH,EH22,"Scotland","Scottish Water",9C7RVXF5+2P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024516,120024517,120024518,120024519,120024520,120024521,120024522,120024523,120024524,120024525,120024526,120031019,120031020,120031021,120031022,120031023,120031024,120033155,120042074",8.20697,,"",,"",,2,S14000045,"Midlothian" EH22 5EE,Yes,55.873628,-3.040988,334962,664986,NT349649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,4,"","","Mayfield - 03","Other urban area",Scotland,146,,S01011027,,S02002069,"Mayfield",,S00120811,S14000045,775,1,0,2024-05-24,"Newtongrange",1.91641,EH,EH22,"Scotland","Scottish Water",9C7RVXF5+FJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024527,120024528,120024529,120024530,120024531,120024532,120024533,120024534,120024535,120031025,120031026,120031259,120042485,120046055,120047622",8.0824,,"",,"",,2,S14000045,"Midlothian" EH22 5EF,Yes,55.873227,-3.040609,334985,664941,NT349649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",5,4,"","","Mayfield - 03","Other urban area",Scotland,147,,S01011027,,S02002069,"Mayfield",,S00120811,S14000045,775,1,0,2024-05-24,"Newtongrange",1.92177,EH,EH22,"Scotland","Scottish Water",9C7RVXF5+7Q,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024536,120024537,120024538,120024539",8.13054,,"",,"",,2,S14000045,"Midlothian" EH22 5EG,Yes,55.873507,-3.039338,335065,664971,NT350649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",13,6,"","","Mayfield - 03","Other urban area",Scotland,150,,S01011027,,S02002069,"Mayfield",,S00120813,S14000045,775,1,0,2024-05-24,"Newtongrange",2.00689,EH,EH22,"Scotland","Scottish Water",9C7RVXF6+C7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031282,120031283,120031284,120031285,120031286,120031441,120031442",8.11502,,"",,"",,2,S14000045,"Midlothian" EH22 5EH,Yes,55.872112,-3.038502,335115,664815,NT351648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",16,4,"","","Easthouses - 04","Other urban area",Scotland,155,,S01011024,,S02002068,"Easthouses",,S00120812,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.00637,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+RH,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031480,120031481,120031482,120031483",8.27723,,"",,"",,2,S14000045,"Midlothian" EH22 5EJ,Yes,55.871590,-3.038616,335107,664757,NT351647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",25,11,"","","Mayfield - 03","Other urban area",Scotland,156,,S01011027,,S02002069,"Mayfield",,S00120816,S14000045,775,1,0,2024-05-24,"Newtongrange",1.98387,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+JH,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027734,120027735,120027736,120027737,120027738,120031484,120031485,120031486,120031487,120031488,120031489,120047889,120048192",8.33272,,"",,"",,2,S14000045,"Midlothian" EH22 5EL,Yes,55.871829,-3.037491,335178,664783,NT351647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",6,2,"","","Easthouses - 04","Other urban area",Scotland,158,,S01011024,,S02002068,"Easthouses",,S00120812,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.05849,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+P2,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027739,120027740,120041770",8.32067,,"",,"",,2,S14000045,"Midlothian" EH22 5EN,Yes,55.872787,-3.038456,335119,664890,NT351648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",44,17,"","","Easthouses - 04","Other urban area",Scotland,154,,S01011024,,S02002068,"Easthouses",,S00120812,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.03158,EH,EH22,"Scotland","Scottish Water",9C7RVXF6+4J,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027741,120027742,120027743,120027744,120027745,120027746,120027747,120027748,120027749,120027750,120027751,120027752,120027753,120027754,120027755,120027756,120027757,120035387",8.20428,,"",,"",,2,S14000045,"Midlothian" EH22 5EP,Yes,55.873631,-3.038462,335120,664984,NT351649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",45,17,"","","Easthouses - 04","Other urban area",Scotland,154,,S01011024,,S02002068,"Easthouses",,S00120827,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.06281,EH,EH22,"Scotland","Scottish Water",9C7RVXF6+FJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027758,120027759,120027760,120027761,120027762,120031287,120031288,120031289,120031290,120031291,120031292,120031504,120031505,120031506,120031507,120031508,120031511",8.11232,,"",,"",,2,S14000045,"Midlothian" EH22 5EQ,Yes,55.872712,-3.038822,335096,664882,NT350648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",53,19,"","","Easthouses - 04","Other urban area",Scotland,153,,S01011024,,S02002068,"Easthouses",,S00120812,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.0073,EH,EH22,"Scotland","Scottish Water",9C7RVXF6+3F,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027763,120027764,120027765,120027766,120027767,120027768,120031293,120031294,120031295,120031296,120031297,120031298,120031299,120031300,120031301,120031302,120031303,120031304,120031305,120031306,120044850,10015423511,10025427928",8.20794,,"",,"",,2,S14000045,"Midlothian" EH22 5ER,Yes,55.873940,-3.038039,335147,665018,NT351650,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",15,6,"","","Easthouses - 04","Other urban area",Scotland,155,,S01011024,,S02002068,"Easthouses",,S00120832,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.09982,EH,EH22,"Scotland","Scottish Water",9C7RVXF6+HQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028997,120028998,120028999,120029000,120029001,120029002,120029003,10025427788",8.08407,,"",,"",,2,S14000045,"Midlothian" EH22 5ES,Yes,55.874143,-3.037437,335185,665040,NT351650,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",26,8,"","","Easthouses - 04","Other urban area",Scotland,158,,S01011024,,S02002068,"Easthouses",,S00120832,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.14302,EH,EH22,"Scotland","Scottish Water",9C7RVXF7+M2,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120029004,120029005,120029006,120029007,120029008,120029009,120029010,120029011",8.06981,,"",,"",,2,S14000045,"Midlothian" EH22 5ET,Yes,55.874098,-3.036397,335250,665034,NT352650,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",16,8,"","","Easthouses - 04","Other urban area",Scotland,162,,S01011024,,S02002068,"Easthouses",,S00120832,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.20159,EH,EH22,"Scotland","Scottish Water",9C7RVXF7+JC,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120029012,120029013,120029014,120029015,120029016,120029017,120029018,120029019",8.08857,,"",,"",,2,S14000045,"Midlothian" EH22 5EU,Yes,55.873807,-3.036330,335254,665002,NT352650,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,6,"","","Easthouses - 04","Other urban area",Scotland,162,,S01011024,,S02002068,"Easthouses",,S00120832,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.19414,EH,EH22,"Scotland","Scottish Water",9C7RVXF7+GF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120029020,120029021,120029022,120029023,120029024,120029025",8.12104,,"",,"",,2,S14000045,"Midlothian" EH22 5EW,Yes,55.872448,-3.037620,335171,664852,NT351648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",23,11,"","","Easthouses - 04","Other urban area",Scotland,156,,S01011024,,S02002068,"Easthouses",,S00120826,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.06977,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+XX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031307,120031308,120031309,120031310,120031311,120031312,120031313,120031314,120031315,120031316,120031443,120031444,10024905850",8.25169,,"",,"",,2,S14000045,"Midlothian" EH22 5EY,Yes,55.873577,-3.037502,335180,664977,NT351649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",45,18,"","","Easthouses - 04","Other urban area",Scotland,157,,S01011024,,S02002068,"Easthouses",,S00120827,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.11675,EH,EH22,"Scotland","Scottish Water",9C7RVXF6+CX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027769,120027770,120027771,120027772,120027773,120027774,120031317,120031318,120031319,120031320,120031321,120031322,120031323,120031324,120031325,120031326,120031327,120031445",8.13046,,"",,"",,2,S14000045,"Midlothian" EH22 5EZ,Yes,55.873685,-3.036886,335219,664988,NT352649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",32,12,"","","Easthouses - 04","Other urban area",Scotland,160,,S01011024,,S02002068,"Easthouses",,S00120827,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.15693,EH,EH22,"Scotland","Scottish Water",9C7RVXF7+F6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031328,120031329,120031330,120031331,120031332,120031333,120031334,120031335,120031336,120031337,120031446,120031447",8.12682,,"",,"",,2,S14000045,"Midlothian" EH22 5GA,Yes,55.874471,-3.033770,335415,665073,NT354650,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1997-06-01,,"","",44,17,"","","Easthouses - 04","Other urban area",Scotland,173,,S01011024,,S02002068,"Easthouses",,S00120829,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.36942,EH,EH22,"Scotland","Scottish Water",9C7RVXF8+QF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028918,120028919,120028920,120028921,120028922,120028923,120028924,120028925,120028926,120028927,120028928,120028929,120028930,120028931,120028932,120028933,120028934",8.08557,,"",,"",,2,S14000045,"Midlothian" EH22 5GB,Yes,55.874216,-3.032005,335525,665043,NT355650,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1997-06-01,,"","",37,15,"","","Mayfield - 01","Other urban area",Scotland,180,,S01011025,,S02002069,"Mayfield",,S00120825,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.46343,EH,EH22,"Scotland","Scottish Water",9C7RVXF9+M5,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028935,120028936,120028937,120028938,120028939,120028940,120028941,120028942,120028943,120028944,120028945,120028946,120028947,120028948,120028949,120039165,120041951,120041952,120042584,120047326",8.13991,,"",,"",,3,S14000045,"Midlothian" EH22 5HA,Yes,55.873354,-3.036202,335261,664951,NT352649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",24,10,"","","Easthouses - 04","Other urban area",Scotland,163,,S01011024,,S02002068,"Easthouses",,S00120826,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.18487,EH,EH22,"Scotland","Scottish Water",9C7RVXF7+8G,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027775,120027776,120027777,120027778,120027779,120027780,120027781,120027782,120027783,120027784,120041923,120042347",8.17191,,"",,"",,2,S14000045,"Midlothian" EH22 5HB,Yes,55.873068,-3.036034,335271,664919,NT352649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",30,13,"","","Easthouses - 04","Other urban area",Scotland,163,,S01011024,,S02002068,"Easthouses",,S00120826,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.18477,EH,EH22,"Scotland","Scottish Water",9C7RVXF7+6H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027785,120027786,120027787,120027788,120027789,120027790,120027791,120027792,120027793,120027794,120027795,120027796,120027797,120027798",8.20521,,"",,"",,2,S14000045,"Midlothian" EH22 5HD,Yes,55.874077,-3.035645,335297,665031,NT352650,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",16,5,"","","Easthouses - 04","Other urban area",Scotland,165,,S01011024,,S02002068,"Easthouses",,S00120832,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.24461,EH,EH22,"Scotland","Scottish Water",9C7RVXF7+JP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120029026,120029027,120029028,120029029,120029030",8.10119,,"",,"",,2,S14000045,"Midlothian" EH22 5HE,Yes,55.874292,-3.034676,335358,665054,NT353650,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",46,18,"","","Easthouses - 04","Other urban area",Scotland,169,,S01011024,,S02002068,"Easthouses",,S00120829,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.30955,EH,EH22,"Scotland","Scottish Water",9C7RVXF8+P4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120029031,120029032,120029033,120029034,120029035,120029036,120029037,120029038,120029039,120029040,120029041,120029042,120029043,120029044,120029045,120029046,120029047,120029048,120041817",8.09165,,"",,"",,2,S14000045,"Midlothian" EH22 5HF,Yes,55.873604,-3.034822,335348,664978,NT353649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",15,4,"","","Easthouses - 04","Other urban area",Scotland,168,,S01011024,,S02002068,"Easthouses",,S00120832,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.27526,EH,EH22,"Scotland","Scottish Water",9C7RVXF8+C3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027799,120027800,120027801,120027802",8.16397,,"",,"",,2,S14000045,"Midlothian" EH22 5HG,Yes,55.873425,-3.035213,335323,664958,NT353649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",9,3,"","","Easthouses - 04","Other urban area",Scotland,167,,S01011024,,S02002068,"Easthouses",,S00120826,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.2458,EH,EH22,"Scotland","Scottish Water",9C7RVXF7+9W,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027803,120027804,120027805",8.17783,,"",,"",,2,S14000045,"Midlothian" EH22 5HH,Yes,55.873063,-3.034404,335373,664917,NT353649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",13,4,"","","Mayfield - 03","Other urban area",Scotland,169,,S01011027,,S02002069,"Mayfield",,S00120828,S14000045,775,1,0,2024-05-24,"Newtongrange",2.28149,EH,EH22,"Scotland","Scottish Water",9C7RVXF8+66,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027806,120027807,120027808,120027809",8.22845,,"",,"",,2,S14000045,"Midlothian" EH22 5HJ,Yes,55.872516,-3.035380,335311,664857,NT353648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",20,6,"","","Mayfield - 03","Other urban area",Scotland,166,,S01011027,,S02002069,"Mayfield",,S00120828,S14000045,775,1,0,2024-05-24,"Newtongrange",2.20578,EH,EH22,"Scotland","Scottish Water",9C7RVXF7+2R,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027810,120027811,120027812,120027813,120036040,120038588,120038589,10025293816",8.27399,,"",,"",,2,S14000045,"Midlothian" EH22 5HL,Yes,55.872863,-3.035853,335282,664896,NT352648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",46,16,"","","Easthouses - 04","Other urban area",Scotland,164,,S01011024,,S02002068,"Easthouses",,S00120826,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.18863,EH,EH22,"Scotland","Scottish Water",9C7RVXF7+4M,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027814,120027815,120027816,120027817,120027818,120027819,120027820,120027821,120027822,120027823,120027824,120027825,120027826,120027827,120027828,120027829,120042371",8.2299,,"",,"",,2,S14000045,"Midlothian" EH22 5HN,Yes,55.872348,-3.037230,335195,664840,NT351648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",12,5,"","","Mayfield - 03","Other urban area",Scotland,158,,S01011027,,S02002069,"Mayfield",,S00120828,S14000045,775,1,0,2024-05-24,"Newtongrange",2.08985,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+W4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027830,120027831,120027832,120027833,120027834",8.26757,,"",,"",,2,S14000045,"Midlothian" EH22 5HP,Yes,55.871819,-3.035953,335274,664780,NT352647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",34,14,"","","Mayfield - 03","Other urban area",Scotland,164,,S01011027,,S02002069,"Mayfield",,S00120819,S14000045,775,1,0,2024-05-24,"Newtongrange",2.15093,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+PJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031338,120031339,120031340,120031341,120031342,120031343,120031344,120031345,120031346,120031347,120031348,120031349,120031448,120031449",8.34181,,"",,"",,2,S14000045,"Midlothian" EH22 5HQ,Yes,55.873629,-3.034451,335371,664980,NT353649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",7,3,"","","Easthouses - 04","Other urban area",Scotland,169,,S01011024,,S02002068,"Easthouses",,S00120832,S14000045,1302,1,0,2024-05-24,"Newtongrange",2.29805,EH,EH22,"Scotland","Scottish Water",9C7RVXF8+F6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027835,120027836,120027837",8.16657,,"",,"",,2,S14000045,"Midlothian" EH22 5HR,Yes,55.871796,-3.037171,335198,664779,NT351647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",25,11,"","","Mayfield - 03","Other urban area",Scotland,160,,S01011027,,S02002069,"Mayfield",,S00120828,S14000045,775,1,0,2024-05-24,"Newtongrange",2.07681,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+P4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031350,120031351,120031352,120031353,120031354,120031355,120031356,120031357,120031358,120031359,120031450,120031451,120042370",8.32835,,"",,"",,2,S14000045,"Midlothian" EH22 5HS,Yes,55.871285,-3.036434,335243,664721,NT352647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",28,10,"","","Mayfield - 03","Other urban area",Scotland,164,,S01011027,,S02002069,"Mayfield",,S00120819,S14000045,775,1,0,2024-05-24,"Newtongrange",2.10772,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+GC,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027838,120027839,120027840,120027841,120027842,120027843,120027844,120027845,120027846,120027847",8.39344,,"",,"",,2,S14000045,"Midlothian" EH22 5HT,Yes,55.871470,-3.036871,335216,664742,NT352647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",15,5,"","","Mayfield - 03","Other urban area",Scotland,162,,S01011027,,S02002069,"Mayfield",,S00120828,S14000045,775,1,0,2024-05-24,"Newtongrange",2.08598,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+H7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027848,120027849,120027850,120027851,120027852,120027853",8.36765,,"",,"",,2,S14000045,"Midlothian" EH22 5HU,Yes,55.870907,-3.036584,335233,664679,NT352646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",12,4,"","","Mayfield - 03","Other urban area",Scotland,164,,S01011027,,S02002069,"Mayfield",,S00120819,S14000045,775,1,0,2024-05-24,"Newtongrange",2.0895,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+99,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027854,120027855,120027856,120027857,120042657,120052945",8.43256,,"",,"",,2,S14000045,"Midlothian" EH22 5HW,Yes,55.872283,-3.035873,335280,664832,NT352648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",21,10,"","","Mayfield - 03","Other urban area",Scotland,165,,S01011027,,S02002069,"Mayfield",,S00120828,S14000045,775,1,0,2024-05-24,"Newtongrange",2.16913,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+WM,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027858,120027859,120031360,120031361,120031362,120031363,120031364,120031452,120036528,120037820,120037821",8.29254,,"",,"",,2,S14000045,"Midlothian" EH22 5HX,Yes,55.870662,-3.036849,335216,664652,NT352646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,4,"","","Mayfield - 03","Other urban area",Scotland,165,,S01011027,,S02002069,"Mayfield",,S00120814,S14000045,775,1,0,2024-05-24,"Newtongrange",2.06781,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+77,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027860,120027861,120027862,120027863",8.45579,,"",,"",,2,S14000045,"Midlothian" EH22 5HY,Yes,55.871510,-3.037511,335176,664747,NT351647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",20,7,"","","Mayfield - 03","Other urban area",Scotland,159,,S01011027,,S02002069,"Mayfield",,S00120814,S14000045,775,1,0,2024-05-24,"Newtongrange",2.04833,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+JX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027864,120027865,120027866,120027867,120027868,120027869,120027870,120042655",8.35513,,"",,"",,2,S14000045,"Midlothian" EH22 5HZ,Yes,55.871531,-3.038151,335136,664750,NT351647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,3,"","","Mayfield - 03","Other urban area",Scotland,157,,S01011027,,S02002069,"Mayfield",,S00120816,S14000045,775,1,0,2024-05-24,"Newtongrange",2.01025,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+JP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027871,120027872,120027873,120027874",8.34484,,"",,"",,2,S14000045,"Midlothian" EH22 5JA,Yes,55.871358,-3.038498,335114,664731,NT351647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",26,11,"","","Mayfield - 03","Other urban area",Scotland,157,,S01011027,,S02002069,"Mayfield",,S00120814,S14000045,775,1,0,2024-05-24,"Newtongrange",1.98454,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+GJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027875,120027876,120027877,120027878,120027879,120027880,120027881,120027882,120027883,120027884,120027885,120027886",8.35944,,"",,"",,2,S14000045,"Midlothian" EH22 5JB,Yes,55.871100,-3.037600,335170,664701,NT351647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,3,"","","Mayfield - 03","Other urban area",Scotland,161,,S01011027,,S02002069,"Mayfield",,S00120814,S14000045,775,1,0,2024-05-24,"Newtongrange",2.03227,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+CX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027887,120027888,120027889,120027890",8.39863,,"",,"",,2,S14000045,"Midlothian" EH22 5JD,Yes,55.870888,-3.037750,335160,664678,NT351646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",26,12,"","","Mayfield - 03","Other urban area",Scotland,161,,S01011027,,S02002069,"Mayfield",,S00120814,S14000045,775,1,0,2024-05-24,"Newtongrange",2.01799,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+9W,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027891,120027892,120027893,120027894,120027895,120027896,120027897,120027898,120027899,120027900,120027901,120027902",8.41984,,"",,"",,2,S14000045,"Midlothian" EH22 5JE,Yes,55.870314,-3.037575,335170,664614,NT351646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",14,5,"","","Mayfield - 03","Other urban area",Scotland,163,,S01011027,,S02002069,"Mayfield",,S00120814,S14000045,775,1,0,2024-05-24,"Newtongrange",2.01604,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+4X,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027903,120027904,120027905,120027906,120027907,120042583,10025428503",8.48452,,"",,"",,2,S14000045,"Midlothian" EH22 5JF,Yes,55.870856,-3.038340,335123,664675,NT351646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,4,"","","Mayfield - 03","Other urban area",Scotland,158,,S01011027,,S02002069,"Mayfield",,S00120815,S14000045,775,1,0,2024-05-24,"Newtongrange",1.9813,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+8M,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027908,120027909,120027910,120027911",8.41607,,"",,"",,2,S14000045,"Midlothian" EH22 5JG,Yes,55.872811,-3.041417,334934,664895,NT349648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,4,"","","Mayfield - 03","Other urban area",Scotland,144,,S01011027,,S02002069,"Mayfield",,S00120811,S14000045,775,1,0,2024-05-24,"Newtongrange",1.85831,EH,EH22,"Scotland","Scottish Water",9C7RVXF5+4C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024954,120025663,120041363,120041364,120041365,120041366,120048125,10015269504,10015293204,10015342574,10015366283,10015402537,10015438838",8.16688,,"",,"",,2,S14000045,"Midlothian" EH22 5JH,Yes,55.872300,-3.042870,334842,664840,NT348648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1992-05-01,,"","",57,48,"","","Mayfield - 03","Other urban area",Scotland,143,,S01011027,,S02002069,"Mayfield",,S00120786,S14000045,775,1,0,2024-05-24,"Newtongrange",1.75378,EH,EH22,"Scotland","Scottish Water",9C7RVXC4+WV,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024911,120024912,120024913,120024914,120024915,120024916,120024917,120024918,120024919,120024920,120024921,120024922,120024923,120024924,120024925,120024926,120024927,120024928,120024929,120024930,120024931,120024932,120024933,120024934,120024935,120024936,120024937,120024938,120024939,120024940,120024941,120024942,120024943,120024944,120024945,120024946,120024947,120024948,120024949,120024950,120024951,120024952,120034962,120038022,120041357,120041358,120041359,120041360,120041361,120041362,120042783,120049222,120051745,120054952,10024907990",8.20728,,"",,"",,2,S14000045,"Midlothian" EH22 5JQ,No,55.871581,-3.038616,335107,664756,NT351647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1990-12-01,1997-12-01,"","",,,"","","Mayfield - 03","Other urban area",Scotland,156,,S01011027,,S02002069,"Mayfield",,S00120816,S14000045,775,6,1,2024-05-24,"Newtongrange",1.98361,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+JH,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.3337,,"",,"",,2,S14000045,"Midlothian" EH22 5JT,Yes,55.869504,-3.036706,335223,664523,NT352645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",10,3,"","","Mayfield - 05","Other urban area",Scotland,170,,S01011029,,S02002069,"Mayfield",,S00120798,S14000045,1635,1,0,2024-05-24,"Newtongrange",2.05525,EH,EH22,"Scotland","Scottish Water",9C7RVX97+R8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027912,120027913,120027914,120043091",8.58358,,"",,"",,3,S14000045,"Midlothian" EH22 5JU,Yes,55.869642,-3.036874,335213,664539,NT352645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",23,12,"","","Mayfield - 05","Other urban area",Scotland,168,,S01011029,,S02002069,"Mayfield",,S00120798,S14000045,1635,1,0,2024-05-24,"Newtongrange",2.04702,EH,EH22,"Scotland","Scottish Water",9C7RVX97+V7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031365,120031366,120031367,120031368,120031369,120031370,120031371,120031372,120031373,120031374,120031453,120031454,120036295",8.56644,,"",,"",,3,S14000045,"Midlothian" EH22 5JX,Yes,55.870355,-3.036953,335209,664618,NT352646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",17,6,"","","Mayfield - 03","Other urban area",Scotland,165,,S01011027,,S02002069,"Mayfield",,S00120814,S14000045,775,1,0,2024-05-24,"Newtongrange",2.05501,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+46,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027915,120027916,120027917,120027918,120027919,120027920,120027921,120032502,10025428214",8.48786,,"",,"",,2,S14000045,"Midlothian" EH22 5JY,Yes,55.870201,-3.036086,335263,664600,NT352646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",25,11,"","","Mayfield - 05","Other urban area",Scotland,170,,S01011029,,S02002069,"Mayfield",,S00120798,S14000045,1635,1,0,2024-05-24,"Newtongrange",2.10523,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+3H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027922,120027923,120027924,120027925,120027926,120027927,120027928,120027929,120027930,120027931,120027932",8.51576,,"",,"",,3,S14000045,"Midlothian" EH22 5JZ,Yes,55.871189,-3.036112,335263,664710,NT352647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",33,11,"","","Mayfield - 03","Other urban area",Scotland,166,,S01011027,,S02002069,"Mayfield",,S00120819,S14000045,775,1,0,2024-05-24,"Newtongrange",2.12493,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+FH,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027933,120027934,120027935,120027936,120027937,120027938,120027939,120027940,120027941,120027942,120027943,120042656",8.40809,,"",,"",,2,S14000045,"Midlothian" EH22 5LA,Yes,55.872420,-3.035010,335334,664846,NT353648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",49,19,"","","Mayfield - 01","Other urban area",Scotland,167,,S01011025,,S02002069,"Mayfield",,S00120825,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.22504,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+XX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027944,120027945,120027946,120027947,120027948,120027949,120027950,120027951,120027952,120027953,120027954,120027955,120027956,120027957,120037838,120037839,120037840,120037841,120037842,120037843,120037844",8.28951,,"",,"",,3,S14000045,"Midlothian" EH22 5LB,No,55.872728,-3.034763,335350,664880,NT353648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,2000-11-01,"","",,,"","","Mayfield - 03","Other urban area",Scotland,168,,S01011027,,S02002069,"Mayfield",,S00120828,S14000045,775,2,0,2024-05-24,"Newtongrange",2.24931,EH,EH22,"Scotland","Scottish Water",9C7RVXF8+33,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.25961,,"",,"",,2,S14000045,"Midlothian" EH22 5LD,Yes,55.872830,-3.034382,335374,664891,NT353648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",19,6,"","","Mayfield - 01","Other urban area",Scotland,170,,S01011025,,S02002069,"Mayfield",,S00120825,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.2753,EH,EH22,"Scotland","Scottish Water",9C7RVXF8+46,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027958,120027959,120027960,120027961,120027962,120027963",8.25397,,"",,"",,3,S14000045,"Midlothian" EH22 5LE,Yes,55.873332,-3.033420,335435,664946,NT354649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",61,25,"","","Mayfield - 01","Other urban area",Scotland,174,,S01011025,,S02002069,"Mayfield",,S00120825,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.34894,EH,EH22,"Scotland","Scottish Water",9C7RVXF8+8J,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027964,120027965,120027966,120027967,120027968,120027969,120027970,120027971,120027972,120027973,120027974,120027975,120027976,120027977,120027978,120027979,120027980,120027981,120027982,120027983,120027984,120027985,120027986,120027987,120027988",8.21369,,"",,"",,3,S14000045,"Midlothian" EH22 5LF,Yes,55.872986,-3.032915,335466,664907,NT354649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",59,26,"","","Mayfield - 01","Other urban area",Scotland,177,,S01011025,,S02002069,"Mayfield",,S00120823,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.36793,EH,EH22,"Scotland","Scottish Water",9C7RVXF8+5R,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027989,120027990,120027991,120027992,120027993,120027994,120027995,120027996,120027997,120027998,120027999,120028000,120028001,120028002,120028003,120028004,120028005,120028006,120028007,120028008,120028009,120028010,120028011,120028012,120028013,120028014,120041950",8.25854,,"",,"",,3,S14000045,"Midlothian" EH22 5LG,Yes,55.873090,-3.032279,335506,664918,NT355649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",74,30,"","","Mayfield - 01","Other urban area",Scotland,181,,S01011025,,S02002069,"Mayfield",,S00120823,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.40923,EH,EH22,"Scotland","Scottish Water",9C7RVXF9+63,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028015,120028016,120028017,120028018,120028019,120028020,120028021,120028022,120028023,120028024,120028025,120028026,120028027,120028028,120028029,120028030,120028031,120028032,120028033,120028034,120028035,120028036,120028037,120028038,120028039,120028040,120028041,120028042,120028043,120028044,120028045,120028046,120042386,120056004",8.25692,,"",,"",,3,S14000045,"Midlothian" EH22 5LH,Yes,55.872072,-3.034809,335346,664807,NT353648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",26,10,"","","Mayfield - 01","Other urban area",Scotland,169,,S01011025,,S02002069,"Mayfield",,S00120824,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.22702,EH,EH22,"Scotland","Scottish Water",9C7RVXC8+R3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028047,120028048,120028049,120028050,120028051,120028052,120028053,120028054,120028055,120028056,120028057,120028058,120028059,120028060,120032501,120041857",8.33,,"",,"",,3,S14000045,"Midlothian" EH22 5LJ,Yes,55.871159,-3.035440,335305,664706,NT353647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",25,12,"","","Mayfield - 03","Other urban area",Scotland,169,,S01011027,,S02002069,"Mayfield",,S00120819,S14000045,775,1,0,2024-05-24,"Newtongrange",2.16511,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+FR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028061,120028062,120028063,120028064,120028065,120028066,120031375,120031376,120031377,120031378,120031379,120031380",8.42032,,"",,"",,2,S14000045,"Midlothian" EH22 5LL,Yes,55.870834,-3.035559,335297,664670,NT352646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",12,4,"","","Mayfield - 02","Other urban area",Scotland,169,,S01011026,,S02002069,"Mayfield",,S00120817,S14000045,1200,1,0,2024-05-24,"Newtongrange",2.15043,EH,EH22,"Scotland","Scottish Water",9C7RVXC7+8Q,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028067,120028068,120028069,120028070,120028071,120028916",8.45399,,"",,"",,2,S14000045,"Midlothian" EH22 5LN,Yes,55.870983,-3.033949,335398,664685,NT353646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",89,41,"","","Mayfield - 02","Other urban area",Scotland,176,,S01011026,,S02002069,"Mayfield",,S00120817,S14000045,1200,1,0,2024-05-24,"Newtongrange",2.2521,EH,EH22,"Scotland","Scottish Water",9C7RVXC8+9C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028072,120028073,120028074,120028075,120028076,120028077,120028078,120028079,120028080,120028081,120028082,120028083,120028084,120028085,120028086,120028087,120028088,120028089,120028090,120028091,120028092,120028093,120028094,120028095,120028096,120028097,120028098,120028099,120028100,120028101,120028102,120028103,120028104,120028105,120028106,120028107,120028108,120028109,120028110,120028111,120028112,120028113,120028114,120028115,120028116,120043118",8.45997,,"",,"",,2,S14000045,"Midlothian" EH22 5LP,Yes,55.869613,-3.032267,335501,664531,NT355645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,4,"","","Mayfield - 02","Other urban area",Scotland,190,,S01011026,,S02002069,"Mayfield",,S00120820,S14000045,1200,1,0,2024-05-24,"Newtongrange",2.33125,EH,EH22,"Scotland","Scottish Water",9C7RVX99+R3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028117,120028118,120028119,120028120,120042883",8.63225,,"",,"",,2,S14000045,"Midlothian" EH22 5LQ,Yes,55.872109,-3.032477,335492,664809,NT354648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",71,28,"","","Mayfield - 01","Other urban area",Scotland,182,,S01011025,,S02002069,"Mayfield",,S00120824,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.36895,EH,EH22,"Scotland","Scottish Water",9C7RVXC9+R2,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028121,120028122,120028123,120028124,120028125,120028126,120028127,120028128,120028129,120028130,120028131,120028132,120028133,120028134,120028135,120028136,120028137,120028138,120028139,120028140,120028141,120028142,120028143,120028144,120028145,120028146,120028147,120028148,120028149,120042387,120053296,10015445551",8.35969,,"",,"",,3,S14000045,"Midlothian" EH22 5LR,Yes,55.870402,-3.031425,335555,664618,NT355646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",62,31,"","","Mayfield - 02","Other urban area",Scotland,193,,S01011026,,S02002069,"Mayfield",,S00120820,S14000045,1200,1,0,2024-05-24,"Newtongrange",2.39558,EH,EH22,"Scotland","Scottish Water",9C7RVXC9+5C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028150,120028151,120028152,120028153,120028154,120028155,120028156,120028157,120028158,120028159,120028160,120028161,120028162,120028163,120028164,120028165,120028166,120028167,120028168,120028169,120028170,120028171,120028172,120028173,120028174,120028175,120028176,120028177,120028178,120028179,120028180",8.55959,,"",,"",,2,S14000045,"Midlothian" EH22 5LS,Yes,55.870477,-3.032098,335513,664627,NT355646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",64,31,"","","Mayfield - 02","Other urban area",Scotland,189,,S01011026,,S02002069,"Mayfield",,S00120820,S14000045,1200,1,0,2024-05-24,"Newtongrange",2.35551,EH,EH22,"Scotland","Scottish Water",9C7RVXC9+55,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028181,120028182,120028183,120028184,120028185,120028186,120028187,120028188,120028189,120028190,120028191,120028192,120028193,120028194,120028195,120028196,120028197,120028198,120028199,120028200,120028201,120028202,120028203,120028204,120028205,120028206,120028207,120028208,120028209,120028210,120028211,120028212",8.54144,,"",,"",,2,S14000045,"Midlothian" EH22 5LT,Yes,55.869647,-3.030350,335621,664533,NT356645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",47,19,"","","Mayfield - 02","Other urban area",Scotland,204,,S01011026,,S02002069,"Mayfield",,S00121068,S14000045,1200,1,0,2024-05-24,"Newtongrange",2.45034,EH,EH22,"Scotland","Scottish Water",9C7RVX99+VV,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028213,120028214,120028215,120028216,120028217,120028218,120028219,120028220,120028221,120028222,120028223,120028224,120028225,120028226,120028227,120028228,120028229,120028230,120028231,120028232,120028233",8.65733,,"",,"",,2,S14000045,"Midlothian" EH22 5LU,Yes,55.870863,-3.029983,335646,664668,NT356646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",46,20,"","","Mayfield - 02","Other urban area",Scotland,203,,S01011026,,S02002069,"Mayfield",,S00121067,S14000045,1200,1,0,2024-05-24,"Newtongrange",2.4927,EH,EH22,"Scotland","Scottish Water",9C7RVXCC+82,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028234,120028235,120028236,120028237,120028238,120028239,120028240,120028241,120028242,120028243,120028244,120028245,120028246,120028247,120028248,120028249,120028250,120028251,120028252,120028253,120042279",8.53223,,"",,"",,2,S14000045,"Midlothian" EH22 5LW,Yes,55.870274,-3.032684,335476,664605,NT354646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",112,43,"","","Mayfield - 02","Other urban area",Scotland,186,,S01011026,,S02002069,"Mayfield",,S00120818,S14000045,1200,1,0,2024-05-24,"Newtongrange",2.31583,EH,EH22,"Scotland","Scottish Water",9C7RVXC8+4W,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028254,120028255,120028256,120028257,120028258,120028259,120028260,120028261,120028262,120028263,120028264,120028265,120028266,120028267,120028268,120028269,120028270,120028271,120028272,120028273,120028274,120028275,120028276,120028277,120028278,120028279,120028280,120028281,120028282,120028283,120028284,120028285,120028286,120028287,120028288,120028289,120028290,120028291,120028292,120028293,120028294,120028295,120028917,120042680",8.55476,,"",,"",,2,S14000045,"Midlothian" EH22 5LX,Yes,55.870551,-3.030725,335599,664634,NT355646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",65,26,"","","Mayfield - 02","Other urban area",Scotland,198,,S01011026,,S02002069,"Mayfield",,S00121068,S14000045,1200,1,0,2024-05-24,"Newtongrange",2.44131,EH,EH22,"Scotland","Scottish Water",9C7RVXC9+6P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028296,120028297,120028298,120028299,120028300,120028301,120028302,120028303,120028304,120028305,120028306,120028307,120028308,120028309,120028310,120028311,120028312,120028313,120028314,120028315,120028316,120028317,120028318,120028319,120028320,120028321,120028322,120028323,120028324,10025271269,10025428535",8.55421,,"",,"",,2,S14000045,"Midlothian" EH22 5LY,Yes,55.870885,-3.029536,335674,664670,NT356646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",35,16,"","","Mayfield - 02","Other urban area",Scotland,206,,S01011026,,S02002069,"Mayfield",,S00121067,S14000045,1200,1,0,2024-05-24,"Newtongrange",2.52057,EH,EH22,"Scotland","Scottish Water",9C7RVXCC+95,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028325,120028326,120028327,120028328,120028329,120028330,120028331,120028332,120028333,120028334,120028335,120028336,120028337,120028338,120028339,120028340",8.53697,,"",,"",,2,S14000045,"Midlothian" EH22 5LZ,Yes,55.871959,-3.030075,335642,664790,NT356647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",47,17,"","","Mayfield - 01","Other urban area",Scotland,198,,S01011025,,S02002069,"Mayfield",,S00120821,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.5109,EH,EH22,"Scotland","Scottish Water",9C7RVXC9+QX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028341,120028342,120028343,120028344,120028345,120028346,120028347,120028348,120028349,120028350,120028351,120028352,120028353,120028354,120028355,120028356,120028357,120028358",8.413,,"",,"",,3,S14000045,"Midlothian" EH22 5NA,Yes,55.872397,-3.029208,335697,664838,NT356648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",58,25,"","","Mayfield - 01","Other urban area",Scotland,201,,S01011025,,S02002069,"Mayfield",,S00120821,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.57455,EH,EH22,"Scotland","Scottish Water",9C7RVXCC+X8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028359,120028360,120028361,120028362,120028363,120028364,120028365,120028366,120028367,120028368,120028369,120028370,120028371,120028372,120028373,120028374,120028375,120028376,120028377,120028378,120028379,120028380,120028381,120028382,120028383,120042361",8.38005,,"",,"",,3,S14000045,"Midlothian" EH22 5NB,Yes,55.872374,-3.028808,335722,664835,NT357648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",47,21,"","","Mayfield - 01","Other urban area",Scotland,204,,S01011025,,S02002069,"Mayfield",,S00120821,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.59822,EH,EH22,"Scotland","Scottish Water",9C7RVXCC+WF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028384,120028385,120028386,120028387,120028388,120028389,120028390,120028391,120028392,120028393,120028394,120028395,120028396,120028397,120028398,120028399,120028400,120028401,120028402,120028403,120028404,120028405,120028406,120038356",8.38913,,"",,"",,3,S14000045,"Midlothian" EH22 5ND,Yes,55.873027,-3.029113,335704,664908,NT357649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,5,"","","Mayfield - 01","Other urban area",Scotland,200,,S01011025,,S02002069,"Mayfield",,S00120822,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.59745,EH,EH22,"Scotland","Scottish Water",9C7RVXFC+69,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028407,120028408,120028409,120028410,120028411,120028412",8.31412,,"",,"",,3,S14000045,"Midlothian" EH22 5NE,Yes,55.872567,-3.030395,335623,664858,NT356648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",50,24,"","","Mayfield - 01","Other urban area",Scotland,193,,S01011025,,S02002069,"Mayfield",,S00120822,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.50722,EH,EH22,"Scotland","Scottish Water",9C7RVXF9+2R,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028413,120028414,120028415,120028416,120028417,120028418,120028419,120028420,120028421,120028422,120028423,120028424,120028425,120028426,120028427,120028428,120028429,120028430,120028431,120028432,120028433,120028434,120028435,120028436,120028437,120028438,120028439,120042124",8.34258,,"",,"",,3,S14000045,"Midlothian" EH22 5NF,Yes,55.872966,-3.031013,335585,664903,NT355649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",71,25,"","","Mayfield - 01","Other urban area",Scotland,188,,S01011025,,S02002069,"Mayfield",,S00120822,S14000045,1418,1,0,2024-05-24,"Newtongrange",2.48137,EH,EH22,"Scotland","Scottish Water",9C7RVXF9+5H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028440,120028441,120028442,120028443,120028444,120028445,120028446,120028447,120028448,120028449,120028450,120028451,120028452,120028453,120028454,120028455,120028456,120028457,120028458,120028459,120028460,120028461,120028462,120028463,120028464,120028465,120028466,120028467,120055768",8.2899,,"",,"",,3,S14000045,"Midlothian" EH22 5NG,Yes,55.878596,-3.043215,334831,665541,NT348655,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2012-04-01,,"","",,,"","","Pathhead and Rural East Midlothian - 04","Accessible rural area",Scotland,139,,S01011017,,S02002067,"Pathhead and Rural East Midlothian",,S00120914,S14000045,2943,1,0,2024-05-24,"Newtongrange",2.078,EH,EH22,"Scotland","Scottish Water",9C7RVXH4+CP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120045881,120045882,120045883,120045884,120045885,120045886,120045887,120045888,120046013",7.51437,,"",,"",,5,S14000045,"Midlothian" EH22 5NH,Yes,55.879446,-3.042534,334875,665635,NT348656,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2012-02-01,,"","",,,"","","Pathhead and Rural East Midlothian - 04","Accessible rural area",Scotland,140,,S01011017,,S02002067,"Pathhead and Rural East Midlothian",,S00120914,S14000045,2943,1,0,2024-05-24,"Newtongrange",2.17039,EH,EH22,"Scotland","Scottish Water",9C7RVXH4+QX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120045782,120045783,120045785,120045787,120045789,120045791,120045793,120045795,120046014,120046016,120046222,120046223,120046224,120046225,120046226,120046227,120046228,120046229",7.42922,,"",,"",,5,S14000045,"Midlothian" EH22 5NJ,Yes,55.879025,-3.043450,334817,665589,NT348655,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2012-04-01,,"","",,,"","","Pathhead and Rural East Midlothian - 04","Accessible rural area",Scotland,137,,S01011017,,S02002067,"Pathhead and Rural East Midlothian",,S00120914,S14000045,2943,1,0,2024-05-24,"Newtongrange",2.09657,EH,EH22,"Scotland","Scottish Water",9C7RVXH4+JJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120041548,120045846,120045847,120045848,120045849,120045879,120045880,120046230,120046231,120046304,120046305",7.46485,,"",,"",,5,S14000045,"Midlothian" EH22 5NL,Yes,55.870966,-3.044448,334741,664693,NT347646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2010-04-01,,"","",30,9,"","","Mayfield - 04","Other urban area",Scotland,139,,S01011028,,S02002069,"Mayfield",,S00120785,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.61488,EH,EH22,"Scotland","Scottish Water",9C7RVXC4+96,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120044409,120044410,120044411,120044412,120044413,120044414,120044415,120044416,120044417,120044418",8.33805,,"",,"",,3,S14000045,"Midlothian" EH22 5NN,Yes,55.879957,-3.042232,334895,665692,NT348656,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2012-08-01,,"","",,,"","","Pathhead and Rural East Midlothian - 04","Accessible rural area",Scotland,141,,S01011017,,S02002067,"Pathhead and Rural East Midlothian",,S00120914,S14000045,2943,1,0,2024-05-24,"Newtongrange",2.2213,EH,EH22,"Scotland","Scottish Water",9C7RVXH5+X4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120046015,120046328,120046329,120046330,120046331,120046332,120046333,120046334,120046335,120046405,120046406,120046407,120046408",7.37698,,"",,"",,5,S14000045,"Midlothian" EH22 5NQ,Yes,55.871546,-3.045950,334648,664759,NT346647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2010-04-01,,"","",130,47,"","","Mayfield - 04","Other urban area",Scotland,131,,S01011028,,S02002069,"Mayfield",,S00120785,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.54484,EH,EH22,"Scotland","Scottish Water",9C7RVXC3+JJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120038359,120042107,120044023,120044024,120044025,120044026,120044027,120044028,120044029,120044030,120044035,120044036,120044063,120044064,120044065,120044066,120044067,120044068,120044069,120044070,120044129,120044130,120044132,120044172,120044173,120044174,120044175,120044176,120044177,120044178,120044179,120044280,120044281,120044282,120044283,120044284,120044285,120044286,120044287,120044288,120044289,120044290,120044291,120044318,120044319,120044384,120044385,120044386,120044387,120044388,120044389,120044394,120044395,120052447",8.26059,,"",,"",,3,S14000045,"Midlothian" EH22 5NR,Yes,55.871498,-3.043120,334825,664751,NT348647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",4,1,"","","Mayfield - 04","Other urban area",Scotland,144,,S01011028,,S02002069,"Mayfield",,S00120784,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.711,EH,EH22,"Scotland","Scottish Water",9C7RVXC4+HQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032465,120042898",8.29264,,"",,"",,3,S14000045,"Midlothian" EH22 5NS,No,55.871241,-3.040556,334985,664720,NT349647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,2005-02-01,"","",,,"","","Mayfield - 03","Other urban area",Scotland,152,,S01011027,,S02002069,"Mayfield",,S00120810,S14000045,775,1,0,2024-05-24,"Newtongrange",1.85703,EH,EH22,"Scotland","Scottish Water",9C7RVXC5+FQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.34813,,"",,"",,2,S14000045,"Midlothian" EH22 5NT,Yes,55.871447,-3.039635,335043,664742,NT350647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",24,11,"","","Mayfield - 03","Other urban area",Scotland,154,,S01011027,,S02002069,"Mayfield",,S00120816,S14000045,775,1,0,2024-05-24,"Newtongrange",1.91839,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+H4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028468,120028469,120028470,120028471,120028472,120028473,120028474,120031381,120031382,120031383,120031384,120031385,120031455",8.33618,,"",,"",,2,S14000045,"Midlothian" EH22 5NU,No,55.870565,-3.040810,334968,664645,NT349646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,1998-12-01,"","",,,"","","Mayfield - 03","Other urban area",Scotland,152,,S01011027,,S02002069,"Mayfield",,S00120810,S14000045,775,1,0,2024-05-24,"Newtongrange",1.82396,EH,EH22,"Scotland","Scottish Water",9C7RVXC5+6M,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.41922,,"",,"",,2,S14000045,"Midlothian" EH22 5NW,Yes,55.871829,-3.044439,334743,664789,NT347647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2010-01-01,,"","",67,21,"","","Mayfield - 04","Other urban area",Scotland,137,,S01011028,,S02002069,"Mayfield",,S00120784,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.64415,EH,EH22,"Scotland","Scottish Water",9C7RVXC4+P6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120042781,120043707,120043708,120043709,120043710,120043711,120043712,120043713,120043714,120043715,120043716,120044118,120044119,120044120,120044121,120044122,120044123,120044124,120044125,120044131,120044133,120044134,120044135,120044136",8.24336,,"",,"",,3,S14000045,"Midlothian" EH22 5NX,Yes,55.870535,-3.040138,335010,664641,NT350646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",40,15,"","","Mayfield - 03","Other urban area",Scotland,154,,S01011027,,S02002069,"Mayfield",,S00120816,S14000045,775,1,0,2024-05-24,"Newtongrange",1.86417,EH,EH22,"Scotland","Scottish Water",9C7RVXC5+6W,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024540,120024541,120024542,120024543,120028475,120028476,120028477,120028478,120028479,120028480,120028481,120028482,120028483,120028484,120028485,120042894,120042895,120042896,120042923",8.43,,"",,"",,2,S14000045,"Midlothian" EH22 5NY,Yes,55.870405,-3.039623,335042,664626,NT350646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",34,12,"","","Mayfield - 03","Other urban area",Scotland,155,,S01011027,,S02002069,"Mayfield",,S00120815,S14000045,775,1,0,2024-05-24,"Newtongrange",1.89264,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+55,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028486,120028487,120028488,120028489,120028490,120028491,120028492,120028493,120028494,120028495,120028496,120028497",8.45008,,"",,"",,2,S14000045,"Midlothian" EH22 5NZ,Yes,55.870323,-3.038630,335104,664616,NT351646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",26,12,"","","Mayfield - 03","Other urban area",Scotland,158,,S01011027,,S02002069,"Mayfield",,S00120815,S14000045,775,1,0,2024-05-24,"Newtongrange",1.9516,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+4G,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028498,120028499,120028500,120028501,120028502,120028503,120028504,120028505,120028506,120028507,120028508,120028509,120028510,120028511",8.47068,,"",,"",,2,S14000045,"Midlothian" EH22 5PA,Yes,55.870000,-3.038653,335102,664580,NT351645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",44,21,"","","Mayfield - 03","Other urban area",Scotland,159,,S01011027,,S02002069,"Mayfield",,S00120815,S14000045,775,1,0,2024-05-24,"Newtongrange",1.94372,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+2G,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028512,120028513,120028514,120028515,120028516,120028517,120028518,120028519,120028520,120028521,120028522,120028523,120028524,120028525,120028526,120031386,120031387,120031388,120031389,120031390,120031456",8.50564,,"",,"",,2,S14000045,"Midlothian" EH22 5PB,Yes,55.868911,-3.040893,334960,664461,NT349644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",0,0,"","","Mayfield - 05","Other urban area",Scotland,155,,S01011029,,S02002069,"Mayfield",,S00120800,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.78795,EH,EH22,"Scotland","Scottish Water",9C7RVX95+HJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032466,120032470,120032472,120032474,120033534,120033791,120035179,10024907992",8.59928,,"",,"",,3,S14000045,"Midlothian" EH22 5PD,Yes,55.869530,-3.042172,334881,664531,NT348645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",58,28,"","","Mayfield - 05","Other urban area",Scotland,151,,S01011029,,S02002069,"Mayfield",,S00120808,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.71868,EH,EH22,"Scotland","Scottish Water",9C7RVX95+R4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024544,120024545,120024546,120024547,120024548,120024549,120024550,120024551,120024552,120024553,120024554,120024555,120024556,120024557,120024558,120024559,120024560,120024561,120024562,120024563,120024564,120024565,120024566,120024567,120024568,120024569,120024570,120024571,120024572,120024573,120032467",8.51804,,"",,"",,3,S14000045,"Midlothian" EH22 5PE,No,55.871360,-3.042525,334862,664735,NT348647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,2020-11-01,"","",0,0,"","","Mayfield - 03","Other urban area",Scotland,146,,S01011027,,S02002069,"Mayfield",,S00120810,S14000045,775,1,0,2024-05-24,"Newtongrange",1.74219,EH,EH22,"Scotland","Scottish Water",9C7RVXC4+GX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.31385,,"",,"",,2,S14000045,"Midlothian" EH22 5PF,Yes,55.870386,-3.042898,334837,664627,NT348646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",32,14,"","","Mayfield - 03","Other urban area",Scotland,146,,S01011027,,S02002069,"Mayfield",,S00120810,S14000045,775,1,0,2024-05-24,"Newtongrange",1.69259,EH,EH22,"Scotland","Scottish Water",9C7RVXC4+5R,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024574,120024575,120024576,120024577,120024578,120031011,120031012,120032417,120032418,120032419,120032420,120032421,120032422,120032423,120032424,120032469,120034309,10024907988",8.41682,,"",,"",,2,S14000045,"Midlothian" EH22 5PG,Yes,55.870012,-3.043528,334797,664586,NT347645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",35,16,"","","Mayfield - 04","Other urban area",Scotland,145,,S01011028,,S02002069,"Mayfield",,S00120807,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.64537,EH,EH22,"Scotland","Scottish Water",9C7RVXC4+2H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024579,120024580,120024581,120024582,120024583,120024584,120024585,120024586,120024587,120024588,120024589,120024590,120024591,120024592,120032471,120032473,120033466,120033469,120037348,120042900,120043951,120044403,120044404,120046011",8.45162,,"",,"",,3,S14000045,"Midlothian" EH22 5PH,Yes,55.869152,-3.043732,334783,664490,NT347644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",2,2,"","","Mayfield - 04","Other urban area",Scotland,148,,S01011028,,S02002069,"Mayfield",,S00120809,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.61606,EH,EH22,"Scotland","Scottish Water",9C7RVX94+MG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024593,120024594",8.54407,,"",,"",,3,S14000045,"Midlothian" EH22 5PJ,Yes,55.869103,-3.044830,334714,664486,NT347644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",29,14,"","","Mayfield - 04","Other urban area",Scotland,144,,S01011028,,S02002069,"Mayfield",,S00120809,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.54756,EH,EH22,"Scotland","Scottish Water",9C7RVX94+J3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024595,120024596,120024597,120024598,120024599,120024600,120024601,120024602,120024603,120024604,120024605,120024606,120024607,120024608",8.53926,,"",,"",,3,S14000045,"Midlothian" EH22 5PL,Yes,55.868822,-3.045577,334667,664455,NT346644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",3,2,"","","Mayfield - 04","Other urban area",Scotland,143,,S01011028,,S02002069,"Mayfield",,S00120809,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.497,EH,EH22,"Scotland","Scottish Water",9C7RVX93+GQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024609,120024610",8.56355,,"",,"",,3,S14000045,"Midlothian" EH22 5PN,Yes,55.868492,-3.045868,334648,664419,NT346644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",6,4,"","","Mayfield - 04","Other urban area",Scotland,143,,S01011028,,S02002069,"Mayfield",,S00120809,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.47446,EH,EH22,"Scotland","Scottish Water",9C7RVX93+9M,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024611,120024612,120024613,120024614",8.59737,,"",,"",,3,S14000045,"Midlothian" EH22 5PP,Yes,55.867300,-3.044446,334735,664285,NT347642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",16,9,"","","Mayfield - 04","Other urban area",Scotland,153,,S01011028,,S02002069,"Mayfield",,S00120805,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.55416,EH,EH22,"Scotland","Scottish Water",9C7RVX84+W6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024615,120024616,120024617,120024618,120024619,120024620,120024621,120024622,120024623,10025286147",8.74096,,"",,"",,3,S14000045,"Midlothian" EH22 5PQ,Yes,55.869297,-3.043141,334820,664506,NT348645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",22,7,"","","Mayfield - 05","Other urban area",Scotland,149,,S01011029,,S02002069,"Mayfield",,S00120808,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.65492,EH,EH22,"Scotland","Scottish Water",9C7RVX94+PP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024624,120024625,120024626,120024627,120024628,120024629,120024630,120024631",8.53386,,"",,"",,3,S14000045,"Midlothian" EH22 5PR,Yes,55.867312,-3.045085,334695,664287,NT346642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,5,"","","Mayfield - 04","Other urban area",Scotland,151,,S01011028,,S02002069,"Mayfield",,S00120805,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.51436,EH,EH22,"Scotland","Scottish Water",9C7RVX83+WX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024632,120024633,120024634,120024635,120024636",8.73398,,"",,"",,3,S14000045,"Midlothian" EH22 5PS,Yes,55.867521,-3.043844,334773,664309,NT347643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",5,2,"","","Mayfield - 05","Other urban area",Scotland,154,,S01011029,,S02002069,"Mayfield",,S00120802,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.59239,EH,EH22,"Scotland","Scottish Water",9C7RVX94+2F,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024637,120024638,120024639",8.72218,,"",,"",,3,S14000045,"Midlothian" EH22 5PT,Yes,55.867583,-3.042791,334839,664315,NT348643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,6,"","","Mayfield - 05","Other urban area",Scotland,156,,S01011029,,S02002069,"Mayfield",,S00120802,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.65825,EH,EH22,"Scotland","Scottish Water",9C7RVX94+2V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031027,120031028,120031029,120031030,120031031,120031032,120031033,120031103",8.72539,,"",,"",,3,S14000045,"Midlothian" EH22 5PU,Yes,55.866952,-3.043094,334819,664245,NT348642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",48,19,"","","Mayfield - 05","Other urban area",Scotland,159,,S01011029,,S02002069,"Mayfield",,S00120802,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.63812,EH,EH22,"Scotland","Scottish Water",9C7RVX84+QQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024640,120024641,120024642,120024643,120024644,120024645,120024646,120024910,120031111,120031112,120031113,120031114,120031115,120031116,120031117,120031118,120031119,120031120,120031121,120031122,120041993",8.79174,,"",,"",,3,S14000045,"Midlothian" EH22 5PW,Yes,55.868194,-3.043387,334803,664384,NT348643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",45,16,"","","Mayfield - 05","Other urban area",Scotland,152,,S01011029,,S02002069,"Mayfield",,S00120802,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.62523,EH,EH22,"Scotland","Scottish Water",9C7RVX94+7J,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031034,120031035,120031036,120031037,120031038,120031039,120031040,120031041,120031042,120031043,120031044,120031045,120031046,120031047,120031104,120031105,120042899,120051027",8.65256,,"",,"",,3,S14000045,"Midlothian" EH22 5PX,Yes,55.866923,-3.042214,334874,664241,NT348642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",35,14,"","","Mayfield - 05","Other urban area",Scotland,161,,S01011029,,S02002069,"Mayfield",,S00120801,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.693,EH,EH22,"Scotland","Scottish Water",9C7RVX85+Q4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024647,120024648,120024649,120024650,120024651,120024652,120024653,120024654,120024655,120024656,120024657,120024658,120024659,120024660,120024661,120024662",8.80349,,"",,"",,3,S14000045,"Midlothian" EH22 5PY,Yes,55.867405,-3.041636,334911,664294,NT349642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",38,15,"","","Mayfield - 05","Other urban area",Scotland,159,,S01011029,,S02002069,"Mayfield",,S00120800,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.72959,EH,EH22,"Scotland","Scottish Water",9C7RVX85+X8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024663,120024664,120024665,120024666,120024667,120024668,120024669,120024670,120024671,120031048,120031049,120031050,120031051,120031052,120031053,120031054,120031106",8.75645,,"",,"",,3,S14000045,"Midlothian" EH22 5PZ,Yes,55.866680,-3.041249,334934,664213,NT349642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",32,14,"","","Mayfield - 05","Other urban area",Scotland,165,,S01011029,,S02002069,"Mayfield",,S00120801,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.75352,EH,EH22,"Scotland","Scottish Water",9C7RVX85+MG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024672,120024673,120024674,120024675,120024676,120024677,120024678,120024679,120024680,120024681,120024682,120024683,120024684,120024685,120041894,120041995,10024907993",8.83989,,"",,"",,3,S14000045,"Midlothian" EH22 5QA,Yes,55.866809,-3.039751,335028,664226,NT350642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",59,25,"","","Mayfield - 05","Other urban area",Scotland,167,,S01011029,,S02002069,"Mayfield",,S00120799,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.84668,EH,EH22,"Scotland","Scottish Water",9C7RVX86+P3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024686,120024687,120024688,120024689,120024690,120028527,120028528,120028529,120028530,120028531,120028532,120028533,120028534,120028535,120028536,120028537,120028538,120028539,120028540,120028541,120028542,120028543,120028544,120028545,120028546,120028547",8.84169,,"",,"",,3,S14000045,"Midlothian" EH22 5QB,Yes,55.867372,-3.040197,335001,664289,NT350642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",23,13,"","","Mayfield - 05","Other urban area",Scotland,163,,S01011029,,S02002069,"Mayfield",,S00120801,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.8192,EH,EH22,"Scotland","Scottish Water",9C7RVX85+WW,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024691,120024692,120024693,120024694,120028548,120028549,120028550,120028551,120028552,120028553,120028554,120028555,120031055,120031056,120031057,120031107",8.77523,,"",,"",,3,S14000045,"Midlothian" EH22 5QD,Yes,55.867697,-3.038975,335078,664324,NT350643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",56,22,"","","Mayfield - 05","Other urban area",Scotland,165,,S01011029,,S02002069,"Mayfield",,S00120799,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.8965,EH,EH22,"Scotland","Scottish Water",9C7RVX96+3C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028556,120028557,120028558,120028559,120028560,120028561,120028562,120028563,120028564,120028565,120028566,120028567,120028568,120028569,120028570,120028571,120028572,120028573,120028574,120028575,120031391,120031392,120031393,120031457,120041818",8.75329,,"",,"",,3,S14000045,"Midlothian" EH22 5QE,Yes,55.868742,-3.039087,335073,664440,NT350644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",50,25,"","","Mayfield - 05","Other urban area",Scotland,162,,S01011029,,S02002069,"Mayfield",,S00120800,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.8978,EH,EH22,"Scotland","Scottish Water",9C7RVX96+F9,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028576,120028577,120028578,120028579,120028580,120028581,120028582,120028583,120028584,120028585,120028586,120028587,120028588,120031394,120031395,120031396,120031397,120031398,120031399,120031400,120031401,120031402,120031403,120031458,120031459,120041701,120042256",8.63787,,"",,"",,3,S14000045,"Midlothian" EH22 5QF,Yes,55.869350,-3.038400,335117,664507,NT351645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",10,4,"","","Mayfield - 05","Other urban area",Scotland,162,,S01011029,,S02002069,"Mayfield",,S00120800,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.9483,EH,EH22,"Scotland","Scottish Water",9C7RVX96+PJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028778,120028779,120028780,120028781",8.57955,,"",,"",,3,S14000045,"Midlothian" EH22 5QG,Yes,55.868932,-3.038481,335111,664461,NT351644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",20,8,"","","Mayfield - 05","Other urban area",Scotland,163,,S01011029,,S02002069,"Mayfield",,S00120798,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.93761,EH,EH22,"Scotland","Scottish Water",9C7RVX96+HJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028589,120028590,120028591,120028592,120028593,120028594,120028595,120028596",8.62419,,"",,"",,3,S14000045,"Midlothian" EH22 5QH,Yes,55.868010,-3.036954,335205,664357,NT352643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",43,16,"","","Mayfield - 06","Other urban area",Scotland,171,,S01011030,,S02002069,"Mayfield",,S00120796,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.02403,EH,EH22,"Scotland","Scottish Water",9C7RVX97+66,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028782,120028783,120028784,120028785,120028786,120028787,120028788,120028789,120028790,120028791,120028792,120028793,120028794,120028795,120028796,120028797,120028798,10024905853",8.74313,,"",,"",,6,S14000045,"Midlothian" EH22 5QJ,Yes,55.868170,-3.036080,335260,664374,NT352643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",66,23,"","","Mayfield - 06","Other urban area",Scotland,174,,S01011030,,S02002069,"Mayfield",,S00120796,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.07947,EH,EH22,"Scotland","Scottish Water",9C7RVX97+7H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028597,120028598,120028599,120028600,120028601,120028602,120028603,120028604,120028605,120028606,120028607,120028608,120028609,120028610,120028611,120028612,120031404,120031405,120031406,120031407,120031408,120031409,120031410,120031411,120042775,120053228",8.73666,,"",,"",,6,S14000045,"Midlothian" EH22 5QL,Yes,55.868821,-3.035649,335288,664446,NT352644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,4,"","","Mayfield - 06","Other urban area",Scotland,175,,S01011030,,S02002069,"Mayfield",,S00120796,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.11197,EH,EH22,"Scotland","Scottish Water",9C7RVX97+GP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028799,120028800,120028801,120028802,120043089",8.67142,,"",,"",,6,S14000045,"Midlothian" EH22 5QN,Yes,55.868613,-3.034733,335345,664422,NT353644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",31,17,"","","Mayfield - 06","Other urban area",Scotland,180,,S01011030,,S02002069,"Mayfield",,S00120797,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.1668,EH,EH22,"Scotland","Scottish Water",9C7RVX98+C4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028613,120028614,120028615,120028616,120028617,120028618,120028619,120028620,120028621,120028622,120028623,120028624,120028625,120031412,120031413,120031414,120031460,120043092",8.70608,,"",,"",,6,S14000045,"Midlothian" EH22 5QP,Yes,55.867572,-3.035664,335285,664307,NT352643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",31,14,"","","Mayfield - 06","Other urban area",Scotland,179,,S01011030,,S02002069,"Mayfield",,S00120797,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.10232,EH,EH22,"Scotland","Scottish Water",9C7RVX97+2P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028626,120028627,120028628,120028629,120028630,120028631,120028632,120028633,120028634,120028635,120028636,120028637,120031415,120031416,120031417,120031461,120042492",8.80701,,"",,"",,6,S14000045,"Midlothian" EH22 5QQ,Yes,55.868210,-3.037806,335152,664380,NT351643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",44,16,"","","Mayfield - 05","Other urban area",Scotland,168,,S01011029,,S02002069,"Mayfield",,S00120798,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.97238,EH,EH22,"Scotland","Scottish Water",9C7RVX96+7V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028638,120028639,120028640,120028641,120028642,120028643,120028644,120028645,120028646,120028647,120028648,120028649,120028650,120028651,120028652,120028653,120028654",8.71098,,"",,"",,3,S14000045,"Midlothian" EH22 5QR,Yes,55.867190,-3.037220,335187,664266,NT351642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",48,22,"","","Mayfield - 06","Other urban area",Scotland,174,,S01011030,,S02002069,"Mayfield",,S00120794,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.00447,EH,EH22,"Scotland","Scottish Water",9C7RVX87+V4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028655,120028656,120028657,120028658,120028659,120028660,120028661,120028662,120028663,120028664,120028665,120028666,120028667,120028668,120031418,120031419,120031420,120031421,120031422,120031423,120031462,120031463,10025428968",8.82924,,"",,"",,6,S14000045,"Midlothian" EH22 5QS,Yes,55.866617,-3.037061,335196,664202,NT351642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",20,8,"","","Mayfield - 06","Other urban area",Scotland,177,,S01011030,,S02002069,"Mayfield",,S00120795,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.01474,EH,EH22,"Scotland","Scottish Water",9C7RVX87+J5,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028669,120028670,120028671,120028672,120028673,120031424,120031425,120031426,120031464,120043093",8.89363,,"",,"",,6,S14000045,"Midlothian" EH22 5QT,Yes,55.866304,-3.037931,335141,664168,NT351641,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",40,14,"","","Mayfield - 06","Other urban area",Scotland,176,,S01011030,,S02002069,"Mayfield",,S00120795,S14000045,3955,1,0,2024-05-24,"Newtongrange",1.96158,EH,EH22,"Scotland","Scottish Water",9C7RVX86+GR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028674,120028675,120028676,120028677,120028678,120028679,120028680,120028681,120028682,120028683,120031427,120031428,120031429,120031465,120034312",8.91745,,"",,"",,6,S14000045,"Midlothian" EH22 5QU,Yes,55.865737,-3.038044,335133,664105,NT351641,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",27,14,"","","Mayfield - 06","Other urban area",Scotland,179,,S01011030,,S02002069,"Mayfield",,S00121066,S14000045,3955,1,0,2024-05-24,"Newtongrange",1.95806,EH,EH22,"Scotland","Scottish Water",9C7RVX86+7Q,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028684,120028685,120028686,120028687,120028688,120028689,120031430,120031431,120031432,120031433,120031434,120031435,120031436,120031466,120041804,120042726,120043090",8.97805,,"",,"",,6,S14000045,"Midlothian" EH22 5QW,Yes,55.867844,-3.035368,335304,664337,NT353643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",33,15,"","","Mayfield - 06","Other urban area",Scotland,179,,S01011030,,S02002069,"Mayfield",,S00120797,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.12188,EH,EH22,"Scotland","Scottish Water",9C7RVX97+4V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028690,120028691,120028692,120028693,120028694,120028695,120028696,120028697,120028698,120028699,120028700,120028701,120031437,120031438,120031439,120031467",8.78125,,"",,"",,6,S14000045,"Midlothian" EH22 5QX,Yes,55.866117,-3.038789,335087,664148,NT350641,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",52,22,"","","Mayfield - 06","Other urban area",Scotland,175,,S01011030,,S02002069,"Mayfield",,S00120794,S14000045,3955,1,0,2024-05-24,"Newtongrange",1.90908,EH,EH22,"Scotland","Scottish Water",9C7RVX86+CF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028803,120028804,120028805,120028806,120028807,120028808,120028809,120028810,120028811,120028812,120031468,120031469,120031470,120031471,120031472,120031473,120031474,120031475,120031476,120031477,120031478,120031479,120042314,120050838,10015372848,10025429102",8.92804,,"",,"",,6,S14000045,"Midlothian" EH22 5QY,Yes,55.872215,-3.043427,334807,664831,NT348648,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",3,1,"","","Mayfield - 03","Other urban area",Scotland,141,,S01011027,,S02002069,"Mayfield",,S00120786,S14000045,775,1,0,2024-05-24,"Newtongrange",1.7179,EH,EH22,"Scotland","Scottish Water",9C7RVXC4+VJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024695,120056197",8.21092,,"",,"",,2,S14000045,"Midlothian" EH22 5QZ,Yes,55.865536,-3.036217,335247,664081,NT352640,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",100,36,"","","Mayfield - 06","Other urban area",Scotland,188,,S01011030,,S02002069,"Mayfield",,S00121066,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.07334,EH,EH22,"Scotland","Scottish Water",9C7RVX87+6G,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028813,120028814,120028815,120028816,120028817,120028818,120028819,120028820,120028821,120028822,120028823,120028824,120028825,120028826,120028827,120028828,120028829,120028830,120028831,120028832,120028833,120028834,120028835,120028836,120028837,120028838,120028839,120028840,120028841,120028842,120028843,120028844,120028845,120028846,120028847,120028848,120054036,120055019",9.0217,,"",,"",,6,S14000045,"Midlothian" EH22 5RA,Yes,55.866170,-3.036745,335215,664152,NT352641,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",63,19,"","","Mayfield - 06","Other urban area",Scotland,181,,S01011030,,S02002069,"Mayfield",,S00120795,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.03609,EH,EH22,"Scotland","Scottish Water",9C7RVX87+F8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028702,120028703,120028704,120028705,120028706,120028707,120028708,120028709,120028710,120028711,120028712,120028713,120028714,120028715,120028716,120028717,120028718,120028719,120028720,120028721,120042246,120042704,120042708",8.94618,,"",,"",,6,S14000045,"Midlothian" EH22 5RB,Yes,55.866099,-3.035593,335287,664143,NT352641,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",52,14,"","","Mayfield - 06","Other urban area",Scotland,186,,S01011030,,S02002069,"Mayfield",,S00120954,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.10821,EH,EH22,"Scotland","Scottish Water",9C7RVX87+CQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028722,120028723,120028724,120028725,120028726,120028727,120028728,120028729,120028730,120028731,120028732,120028733,120028734,120028735,120042306,10025271273",8.96816,,"",,"",,6,S14000045,"Midlothian" EH22 5RD,Yes,55.865451,-3.034681,335343,664070,NT353640,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-10-01,,"","",33,14,"","","Mayfield - 06","Other urban area",Scotland,199,,S01011030,,S02002069,"Mayfield",,S00121065,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.16956,EH,EH22,"Scotland","Scottish Water",9C7RVX88+54,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027697,120027698,120027699,120027700,120027701,120028736,120028737,120028738,120028739,120028907,120028908,120028909,120028910,120028911,120028912,120041703,120043054",9.05026,,"",,"",,6,S14000045,"Midlothian" EH22 5RE,Yes,55.866859,-3.034942,335329,664227,NT353642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-10-01,,"","",61,23,"","","Mayfield - 06","Other urban area",Scotland,184,,S01011030,,S02002069,"Mayfield",,S00120953,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.14646,EH,EH22,"Scotland","Scottish Water",9C7RVX88+P2,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028740,120028741,120028742,120028743,120028744,120028745,120028746,120028747,120028748,120028749,120028750,120028751,120028752,120028753,120028754,120028755,120028756,120028757,120028758,120028759,120028760,120028761,120028859",8.89383,,"",,"",,6,S14000045,"Midlothian" EH22 5RF,Yes,55.865617,-3.034078,335381,664088,NT353640,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1982-12-01,,"","",81,28,"","","Mayfield - 06","Other urban area",Scotland,202,,S01011030,,S02002069,"Mayfield",,S00120955,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.20567,EH,EH22,"Scotland","Scottish Water",9C7RVX88+69,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027702,120027703,120027704,120027705,120027706,120027707,120027708,120028762,120028763,120028764,120028765,120028857,120028858,120028860,120028861,120028862,120028863,120028864,120028865,120028866,120028867,120028891,120028892,120028893,120028894,120028895,120028896,120028897,120041645,120041702",9.04007,,"",,"",,6,S14000045,"Midlothian" EH22 5RG,No,55.865971,-3.033720,335404,664127,NT354641,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1997-07-01,1998-01-01,"","",,,"","","Mayfield - 06","Other urban area",Scotland,200,,S01011030,,S02002069,"Mayfield",,S00120955,S14000045,3955,8,1,2024-05-24,"Newtongrange",2.22556,EH,EH22,"Scotland","Scottish Water",9C7RVX88+9G,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",9.00638,,"",,"",,6,S14000045,"Midlothian" EH22 5RH,Yes,55.866315,-3.033362,335427,664165,NT354641,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1990-05-01,,"","",57,22,"","","Mayfield - 06","Other urban area",Scotland,199,,S01011030,,S02002069,"Mayfield",,S00120955,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.24622,EH,EH22,"Scotland","Scottish Water",9C7RVX88+GM,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028868,120028869,120028870,120028871,120028872,120028873,120028874,120028875,120028876,120028877,120028878,120028879,120028880,120028881,120028882,120028883,120028884,120028885,120028886,120028887,120028888,120028889,120028890,120035526,120053837",8.97387,,"",,"",,6,S14000045,"Midlothian" EH22 5RJ,Yes,55.866420,-3.034834,335335,664178,NT353641,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1989-10-01,,"","",24,8,"","","Mayfield - 06","Other urban area",Scotland,189,,S01011030,,S02002069,"Mayfield",,S00120954,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.15411,EH,EH22,"Scotland","Scottish Water",9C7RVX88+H3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028849,120028850,120028851,120028852,120028853,120028854,120028855,120028856,120041969",8.94295,,"",,"",,6,S14000045,"Midlothian" EH22 5RL,Yes,55.867969,-3.048123,334506,664363,NT345643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",5,4,"","","Mayfield - 04","Other urban area",Scotland,139,,S01011028,,S02002069,"Mayfield",,S00120803,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.32889,EH,EH22,"Scotland","Scottish Water",9C7RVX92+5Q,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024696,120024697,120024698,120024699",8.63701,,"",,"",,3,S14000045,"Midlothian" EH22 5RN,Yes,55.867656,-3.046932,334580,664327,NT345643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",10,4,"","","Mayfield - 04","Other urban area",Scotland,144,,S01011028,,S02002069,"Mayfield",,S00120805,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.40069,EH,EH22,"Scotland","Scottish Water",9C7RVX93+36,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024700,120024701,120024702,120024703",8.6807,,"",,"",,3,S14000045,"Midlothian" EH22 5RP,Yes,55.866960,-3.044213,334749,664247,NT347642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",7,4,"","","Mayfield - 05","Other urban area",Scotland,155,,S01011029,,S02002069,"Mayfield",,S00120802,S14000045,1635,1,0,2024-05-24,"Newtongrange",1.56835,EH,EH22,"Scotland","Scottish Water",9C7RVX84+Q8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024704,120024705,120024706,120024707",8.78045,,"",,"",,3,S14000045,"Midlothian" EH22 5RQ,Yes,55.863768,-3.038103,335126,663886,NT351638,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2013-10-01,,"","",,,"","","Pathhead and Rural East Midlothian - 04","Accessible rural area",Scotland,197,,S01011017,,S02002067,"Pathhead and Rural East Midlothian",,S00120914,S14000045,2943,1,0,2024-05-24,"Newtongrange",1.98221,EH,EH22,"Scotland","Scottish Water",9C7RVX76+GQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120045497,120046963,120047758,120047814,120047815,120047845,120047893,120047894,120047994,120048001,120048002,120048024,120048025,120048028,120048091,120048092,120048101,120048109,120048110,120048111,120048112,120048118,120048123,120048260,120048361,120048362,120048363,120048434,120048435,120048436,120048548,120048555,120048580,120048590,120048614,120048615,120048616,120048669,120048670,120048697,120048698,120048699,120048708,120048711,120048744,120048890,120048999,120049014,120049015,120049032,120049060,120049068,120049069,120049084,120049085,120049122,120049125,120049269,120049297,120049452,120049523,120049666,120051994,120052533",9.1925,,"",,"",,5,S14000045,"Midlothian" EH22 5RR,Yes,55.867625,-3.046356,334616,664323,NT346643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",22,9,"","","Mayfield - 04","Other urban area",Scotland,147,,S01011028,,S02002069,"Mayfield",,S00120805,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.43638,EH,EH22,"Scotland","Scottish Water",9C7RVX93+3F,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024708,120024709,120024710,120024711,120024712,120024713,120024714,120024715,120024716,120024717",8.68877,,"",,"",,3,S14000045,"Midlothian" EH22 5RS,Yes,55.867860,-3.047257,334560,664350,NT345643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",16,8,"","","Mayfield - 04","Other urban area",Scotland,142,,S01011028,,S02002069,"Mayfield",,S00120803,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.38183,EH,EH22,"Scotland","Scottish Water",9C7RVX93+43,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024718,120024719,120024720,120024721,120024722,120024723,120024724,120024725,120024726,120043067",8.65565,,"",,"",,3,S14000045,"Midlothian" EH22 5RU,Yes,55.868164,-3.048528,334481,664385,NT344643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",5,4,"","","Mayfield - 04","Other urban area",Scotland,137,,S01011028,,S02002069,"Mayfield",,S00120803,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.30569,EH,EH22,"Scotland","Scottish Water",9C7RVX92+7H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024727,120024728,120024729,120024730",8.61251,,"",,"",,3,S14000045,"Midlothian" EH22 5RW,Yes,55.867335,-3.045645,334660,664290,NT346642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",14,4,"","","Mayfield - 04","Other urban area",Scotland,149,,S01011028,,S02002069,"Mayfield",,S00120805,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.47951,EH,EH22,"Scotland","Scottish Water",9C7RVX83+WP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024731,120024732,120024733,120024734",8.72663,,"",,"",,3,S14000045,"Midlothian" EH22 5RX,Yes,55.867945,-3.045662,334660,664358,NT346643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",22,11,"","","Mayfield - 04","Other urban area",Scotland,146,,S01011028,,S02002069,"Mayfield",,S00120805,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.48169,EH,EH22,"Scotland","Scottish Water",9C7RVX93+5P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024735,120024736,120024737,120031058,120031059,120031060,120031061,120031062,120031063,120031064,120031108",8.65934,,"",,"",,3,S14000045,"Midlothian" EH22 5RY,Yes,55.868270,-3.047144,334568,664396,NT345643,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",6,2,"","","Mayfield - 04","Other urban area",Scotland,139,,S01011028,,S02002069,"Mayfield",,S00120805,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.39272,EH,EH22,"Scotland","Scottish Water",9C7RVX93+84,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024738,120024739",8.61135,,"",,"",,3,S14000045,"Midlothian" EH22 5RZ,Yes,55.868560,-3.048427,334488,664429,NT344644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",6,3,"","","Mayfield - 04","Other urban area",Scotland,135,,S01011028,,S02002069,"Mayfield",,S00120803,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.31701,EH,EH22,"Scotland","Scottish Water",9C7RVX92+CJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024740,120024741,120024742,120041712,10015393856,10025428794",8.56955,,"",,"",,3,S14000045,"Midlothian" EH22 5SA,Yes,55.868474,-3.046954,334580,664418,NT345644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",16,7,"","","Mayfield - 04","Other urban area",Scotland,140,,S01011028,,S02002069,"Mayfield",,S00120803,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.40696,EH,EH22,"Scotland","Scottish Water",9C7RVX93+96,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024743,120024744,120024745,120024746,120024747,120024748,120024953,120041714",8.59038,,"",,"",,3,S14000045,"Midlothian" EH22 5SB,Yes,55.868515,-3.046348,334618,664422,NT346644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",17,10,"","","Mayfield - 04","Other urban area",Scotland,142,,S01011028,,S02002069,"Mayfield",,S00120809,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.44502,EH,EH22,"Scotland","Scottish Water",9C7RVX93+CF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024749,120024750,120024751,120024752,120024753,120024754,120024755,120024756,120024757,120024758,120041859",8.59081,,"",,"",,3,S14000045,"Midlothian" EH22 5SD,Yes,55.869258,-3.045601,334666,664504,NT346645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",23,13,"","","Mayfield - 04","Other urban area",Scotland,142,,S01011028,,S02002069,"Mayfield",,S00120809,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.50283,EH,EH22,"Scotland","Scottish Water",9C7RVX93+PQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024759,120024760,120024761,120024762,120024763,120024764,120024765,120024766,120024767,120024768,120024769,120024770,120024771,120024772",8.51537,,"",,"",,3,S14000045,"Midlothian" EH22 5SE,Yes,55.869598,-3.045802,334654,664542,NT346645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",30,15,"","","Mayfield - 04","Other urban area",Scotland,139,,S01011028,,S02002069,"Mayfield",,S00120956,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.49729,EH,EH22,"Scotland","Scottish Water",9C7RVX93+RM,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024773,120024774,120024775,120024776,120024777,120024778,120024779,120024780,120024781,120024782,120024783,120024784,120024785,120024786,120024787",8.47621,,"",,"",,3,S14000045,"Midlothian" EH22 5SF,Yes,55.869323,-3.044260,334750,664510,NT347645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,6,"","","Mayfield - 04","Other urban area",Scotland,145,,S01011028,,S02002069,"Mayfield",,S00120807,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.58649,EH,EH22,"Scotland","Scottish Water",9C7RVX94+P7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024788,120024789,120024790,120024791,120024792,120024793,120043063",8.52031,,"",,"",,3,S14000045,"Midlothian" EH22 5SG,Yes,55.869565,-3.043775,334781,664536,NT347645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",5,2,"","","Mayfield - 04","Other urban area",Scotland,145,,S01011028,,S02002069,"Mayfield",,S00120807,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.62084,EH,EH22,"Scotland","Scottish Water",9C7RVX94+RF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024794,120024795,10015352728,10025428534",8.49831,,"",,"",,3,S14000045,"Midlothian" EH22 5SH,Yes,55.870179,-3.043948,334771,664605,NT347646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",42,20,"","","Mayfield - 04","Other urban area",Scotland,143,,S01011028,,S02002069,"Mayfield",,S00120807,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.62367,EH,EH22,"Scotland","Scottish Water",9C7RVXC4+3C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024796,120024797,120024798,120024799,120024800,120024801,120024802,120024803,120024804,120024805,120024806,120024807,120024808,120024809,120024810,120024811,120024812,120024813,120024814,120024815",8.42923,,"",,"",,3,S14000045,"Midlothian" EH22 5SJ,Yes,55.870447,-3.045233,334691,664636,NT346646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",83,33,"","","Mayfield - 04","Other urban area",Scotland,138,,S01011028,,S02002069,"Mayfield",,S00120956,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.55264,EH,EH22,"Scotland","Scottish Water",9C7RVXC3+5W,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024816,120024817,120024818,120024819,120024820,120024821,120024822,120024823,120024824,120024825,120024826,120024827,120024828,120024829,120024830,120024831,120024832,120024833,120024834,120024835,120024836,120024837,120024838,120024839,120024840,120024841,120024842,120024843,120024844,120024845,120024846,120024847,120024848,120024849",8.38785,,"",,"",,3,S14000045,"Midlothian" EH22 5SL,Yes,55.870782,-3.045993,334644,664674,NT346646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",15,6,"","","Mayfield - 04","Other urban area",Scotland,134,,S01011028,,S02002069,"Mayfield",,S00120956,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.51665,EH,EH22,"Scotland","Scottish Water",9C7RVXC3+8J,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024850,120024851,120024852,120024853,120024854,120024855,120043068",8.34427,,"",,"",,3,S14000045,"Midlothian" EH22 5SN,Yes,55.870949,-3.046461,334615,664693,NT346646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",24,9,"","","Mayfield - 04","Other urban area",Scotland,132,,S01011028,,S02002069,"Mayfield",,S00120806,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.49397,EH,EH22,"Scotland","Scottish Water",9C7RVXC3+9C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024856,120024857,120024858,120024859,120024860,120024861,120024862,120024863,120024864",8.32186,,"",,"",,3,S14000045,"Midlothian" EH22 5SP,Yes,55.869727,-3.046397,334617,664557,NT346645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",31,14,"","","Mayfield - 04","Other urban area",Scotland,137,,S01011028,,S02002069,"Mayfield",,S00120806,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.4638,EH,EH22,"Scotland","Scottish Water",9C7RVX93+VC,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024865,120024866,120024867,120024868,120024869,120024870,120024871,120024872,120024873,120024874,120024875,120024876,120024877,120024878,120024879",8.45693,,"",,"",,3,S14000045,"Midlothian" EH22 5SQ,Yes,55.869860,-3.044530,334734,664570,NT347645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",16,6,"","","Mayfield - 04","Other urban area",Scotland,142,,S01011028,,S02002069,"Mayfield",,S00120807,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.58078,EH,EH22,"Scotland","Scottish Water",9C7RVX94+W5,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024880,120024881,120024882,120024883,120024884,120024885",8.4588,,"",,"",,3,S14000045,"Midlothian" EH22 5SR,Yes,55.868872,-3.047652,334537,664463,NT345644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",32,17,"","","Mayfield - 04","Other urban area",Scotland,136,,S01011028,,S02002069,"Mayfield",,S00120803,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.36976,EH,EH22,"Scotland","Scottish Water",9C7RVX92+GW,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024886,120024887,120024888,120024889,120024890,120024891,120024892,120024893,120024894,120024895,120024896,120024897,120024898,120024899,120024900,120024901,120024902,120041715,120051028",8.541,,"",,"",,3,S14000045,"Midlothian" EH22 5SS,Yes,55.869230,-3.046719,334596,664502,NT345645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",2,1,"","","Mayfield - 04","Other urban area",Scotland,138,,S01011028,,S02002069,"Mayfield",,S00120809,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.43361,EH,EH22,"Scotland","Scottish Water",9C7RVX93+M8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120038914,10024913878",8.50899,,"",,"",,3,S14000045,"Midlothian" EH22 5ST,Yes,55.868860,-3.046996,334578,664461,NT345644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",13,4,"","","Mayfield - 04","Other urban area",Scotland,139,,S01011028,,S02002069,"Mayfield",,S00120809,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.41,EH,EH22,"Scotland","Scottish Water",9C7RVX93+G6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120035521,120036194,120036418,120036673",8.5475,,"",,"",,3,S14000045,"Midlothian" EH22 5SU,Yes,55.868605,-3.047325,334557,664433,NT345644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",14,7,"","","Mayfield - 04","Other urban area",Scotland,138,,S01011028,,S02002069,"Mayfield",,S00120803,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.38579,EH,EH22,"Scotland","Scottish Water",9C7RVX93+C3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120024903,120024904,120024905,120024906,120024907,120024908,120024909",8.57299,,"",,"",,3,S14000045,"Midlothian" EH22 5SW,Yes,55.870036,-3.047076,334575,664592,NT345645,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",72,36,"","","Mayfield - 04","Other urban area",Scotland,134,,S01011028,,S02002069,"Mayfield",,S00120806,S14000045,1606,1,0,2024-05-24,"Newtongrange",1.43011,EH,EH22,"Scotland","Scottish Water",9C7RVXC3+25,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120031065,120031066,120031067,120031068,120031069,120031070,120031071,120031072,120031073,120031074,120031075,120031076,120031077,120031078,120031079,120031080,120031081,120031082,120031083,120031084,120031085,120031086,120031087,120031088,120031089,120031090,120031091,120031092,120031093,120031094,120031095,120031096,120031097,120031098,120031099,120031100,120031101,120031102,120031109,120031110",8.41728,,"",,"",,3,S14000045,"Midlothian" EH22 5SX,No,55.868474,-3.046954,334580,664418,NT345644,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1986-12-01,1992-07-01,"","",,,"","","Mayfield - 04","Other urban area",Scotland,140,,S01011028,,S02002069,"Mayfield",,S00120803,S14000045,1606,8,1,2024-05-24,"Newtongrange",1.40696,EH,EH22,"Scotland","Scottish Water",9C7RVX93+96,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.59038,,"",,"",,3,S14000045,"Midlothian" EH22 5TA,Yes,55.870565,-3.040826,334967,664645,NT349646,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2000-12-01,,"","",0,0,"","","Mayfield - 03","Other urban area",Scotland,152,,S01011027,,S02002069,"Mayfield",,S00120810,S14000045,775,1,0,2024-05-24,"Newtongrange",1.82298,EH,EH22,"Scotland","Scottish Water",9C7RVXC5+6M,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120033179,120036623,120038152,120039269,120044566,120047115,120047116,120047117,120047118,120047119,120047638,120049017,120050066,120050395,120051422",8.41904,,"",,"",,2,S14000045,"Midlothian" EH22 5TE,Yes,55.878138,-3.030898,335601,665478,NT356654,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",2017-09-01,,"","",,,"","","Pathhead and Rural East Midlothian - 04","Accessible rural area",Scotland,195,,S01011017,,S02002067,"Pathhead and Rural East Midlothian",,S00120914,S14000045,2943,1,0,2024-05-24,"Newtongrange",2.69869,EH,EH22,"Scotland","Scottish Water",9C7RVXH9+7J,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120036884,120042374,120049577,120050695,120051334,120051893,120051894,120051997,120052028,120052183,120052555,120054534,120055623,120055849,120056436",7.7372,,"",,"",,5,S14000045,"Midlothian" EH22 5TG,Yes,55.879459,-3.029251,335706,665624,NT357656,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",7,3,"","","Pathhead and Rural East Midlothian - 04","Accessible rural area",Scotland,196,,S01011017,,S02002067,"Pathhead and Rural East Midlothian",,S00120914,S14000045,2943,1,0,2024-05-24,"Newtongrange",2.85843,EH,EH22,"Scotland","Scottish Water",9C7RVXHC+Q7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120036080,120036193,120036885,120036887,120037318,120045407,120051049",7.62513,,"",,"",,5,S14000045,"Midlothian" EH22 5TH,Yes,55.871409,-3.024867,335967,664724,NT359647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,3,"","","Pathhead and Rural East Midlothian - 04","Accessible rural area",Scotland,228,,S01011017,,S02002067,"Pathhead and Rural East Midlothian",,S00120914,S14000045,2943,1,0,2024-05-24,"Newtongrange",2.81734,EH,EH22,"Scotland","Scottish Water",9C7RVXCG+H3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120036141,120036260,120036888,120036889,120036890,10015469994",8.56046,,"",,"",,5,S14000045,"Midlothian" EH22 5TJ,Yes,55.863394,-3.039851,335016,663846,NT350638,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,3,"","","Pathhead and Rural East Midlothian - 04","Accessible rural area",Scotland,191,,S01011017,,S02002067,"Pathhead and Rural East Midlothian",,S00120914,S14000045,2943,1,0,2024-05-24,"Newtongrange",1.88353,EH,EH22,"Scotland","Scottish Water",9C7RVX76+93,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120035724,120044254,120044255,120051993,120052532",9.21445,,"",,"",,5,S14000045,"Midlothian" EH22 5TP,Yes,55.865148,-3.033219,335434,664035,NT354640,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1991-03-01,,"","",26,9,"","","Mayfield - 06","Other urban area",Scotland,213,,S01011030,,S02002069,"Mayfield",,S00121065,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.26327,EH,EH22,"Scotland","Scottish Water",9C7RVX88+3P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028898,120028899,120028900,120028901,120028902,120028903,120028904,120028905,120028906,120044433",9.10241,,"",,"",,6,S14000045,"Midlothian" EH22 5TQ,Yes,55.873417,-3.022155,336140,664945,NT361649,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,3,"","","Pathhead and Rural East Midlothian - 04","Accessible rural area",Scotland,224,,S01011017,,S02002067,"Pathhead and Rural East Midlothian",,S00120914,S14000045,2943,1,0,2024-05-24,"Newtongrange",3.02856,EH,EH22,"Scotland","Scottish Water",9C7RVXFH+94,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120036192,120037280,120037281,120037282",8.39893,,"",,"",,5,S14000045,"Midlothian" EH22 5TR,Yes,55.864608,-3.035457,335293,663977,NT352639,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1992-05-01,,"","",34,15,"","","Mayfield - 06","Other urban area",Scotland,203,,S01011030,,S02002069,"Mayfield",,S00121065,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.131,EH,EH22,"Scotland","Scottish Water",9C7RVX77+RR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120027709,120027710,120027711,120027712,120027713,120027714,120027715,120027716,120027717,120027718,120027719,120027720,120028913,120028914,120028915",9.13217,,"",,"",,6,S14000045,"Midlothian" EH22 5TT,Yes,55.867152,-3.033240,335436,664258,NT354642,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1982-12-01,,"","",36,12,"","","Mayfield - 06","Other urban area",Scotland,193,,S01011030,,S02002069,"Mayfield",,S00120955,S14000045,3955,1,0,2024-05-24,"Newtongrange",2.25258,EH,EH22,"Scotland","Scottish Water",9C7RVX88+VP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120028766,120028767,120028768,120028769,120028770,120028771,120028772,120028773,120028774,120028775,120028776,120028777",8.88479,,"",,"",,6,S14000045,"Midlothian" EH22 5WX,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2004-09-01,2006-10-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-05-24,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8,S14000045,"Midlothian" EH22 5YA,No,55.871590,-3.038616,335107,664757,NT351647,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1996-06-01,2000-06-01,"","",,,"","","Mayfield - 03","Other urban area",Scotland,156,,S01011027,,S02002069,"Mayfield",,S00120816,S14000045,775,6,1,2024-05-24,"Newtongrange",1.98387,EH,EH22,"Scotland","Scottish Water",9C7RVXC6+JH,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.33272,,"",,"",,2,S14000045,"Midlothian" EH22 5YB,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2002-10-01,2006-11-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-05-24,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8,S14000045,"Midlothian" EH22 5YD,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1997-06-01,2005-10-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-05-24,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8,S14000045,"Midlothian" EH22 5YE,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1998-06-01,2005-09-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-05-24,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8,S14000045,"Midlothian" EH22 5YH,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2003-08-01,2018-12-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-05-24,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8,S14000045,"Midlothian" EH22 5YL,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2003-08-01,2004-06-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,5,1,2024-05-24,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8,S14000045,"Midlothian" EH22 5ZX,No,55.876696,-3.043659,334800,665330,NT348653,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1994-10-01,1996-06-01,"","",,,"","","Easthouses - 03","Other urban area",Scotland,137,,S01011023,,S02002068,"Easthouses",,S00120836,S14000045,2160,8,1,2024-05-24,"Newtongrange",1.93112,EH,EH22,"Scotland","Scottish Water",9C7RVXG4+MG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",7.71747,,"",,"",,4,S14000045,"Midlothian"