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 EH22 1AA,Yes,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032337",5.81605,,"",,"",,8 EH22 1AB,Yes,55.892199,-3.069547,333207,667080,NT332670,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",22,14,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121039,S14000045,404,1,0,2024-03-01,"Eskbank",1.42982,EH,EH22,"Scotland","Scottish Water",9C7RVWRJ+V5,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021060,120021071,120030837,120030838,120030839,120030840,120030841,120030842,120030843,120030844,120030845,120030846,120030847,120030848,120030849,120030882",5.89014,,"",,"",,1 EH22 1AD,Yes,55.897326,-3.065770,333452,667647,NT334676,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2011-01-01,,"","",,,"","","Thornybank - 01","Other urban area",Scotland,57,,S01011005,,S02002065,"Thornybank",,S00120682,S14000045,1554,1,0,2024-03-01,"Eskbank",2.03395,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+WM,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021112,120021113,120021226,120030836,120033685,120042250,120042810,120044967,120044968,120045336,120045337,120045338,120045339,120045480,120045681,120045777,120045778,120046093,120046147,120046149,120046887,120049206,120051384",5.31316,,"",,"",,3 EH22 1AE,Yes,55.893074,-3.070147,333171,667178,NT331671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",0,0,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121041,S14000045,404,1,0,2024-03-01,"Eskbank",1.48888,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+6W,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021589,120021590,120021591,120021797,120021843,120032390,120032392,120036181",5.7951,,"",,"",,1 EH22 1AF,No,55.893001,-3.070321,333160,667170,NT331671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1992-07-01,1995-12-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121041,S14000045,404,8,1,2024-03-01,"Eskbank",1.4762,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+6V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.80384,,"",,"",,1 EH22 1AG,Yes,55.893157,-3.069877,333188,667187,NT331671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",24,16,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121039,S14000045,404,1,0,2024-03-01,"Eskbank",1.50576,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+72,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021064,120021072,120021073,120021074,120021075,120021076,120021077,120021078,120021079,120021080,120021081,120021082,120021083,120021084,120021085,120021086,120021087,120021088,120021089,120021090,120021091,120021092,120021093,120021094,120021789,120021798,120021801,120021804,120021811,120035048,120036125,120045423,120046086,10091912098",5.78494,,"",,"",,1 EH22 1AH,Yes,55.893728,-3.069317,333224,667250,NT332672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,5,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00120680,S14000045,404,1,0,2024-03-01,"Eskbank",1.57798,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021095,120021096,120021097,120021098,120021796,120021803,120032389,120033140,120033141,120033809,120034171,120034666,120034670,120034676,120034683,120035156,120038715,120038716,120042864,120047808",5.71973,,"",,"",,1 EH22 1AJ,No,55.893001,-3.070321,333160,667170,NT331671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1992-07-01,1996-12-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121041,S14000045,404,8,1,2024-03-01,"Eskbank",1.4762,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+6V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.80384,,"",,"",,1 EH22 1AL,Yes,55.893694,-3.069045,333241,667246,NT332672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",5,3,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00120680,S14000045,404,1,0,2024-03-01,"Eskbank",1.5841,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+F9,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021592,120021593,120021594,120021640,120021806,120043100",5.72269,,"",,"",,1 EH22 1AN,Yes,55.893463,-3.068846,333253,667220,NT332672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",4,1,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00121039,S14000045,404,1,0,2024-03-01,"Eskbank",1.56973,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+9F,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021595,120021680,120021836,120033264,120037808,120044271,120044272,120044471,120044472,120044473,120044474,120044475,120045417,120045986,120047991,120048000",5.74776,,"",,"",,1 EH22 1AP,Yes,55.894233,-3.067561,333335,667304,NT333673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",0,0,"","","Dalkeith - 01","Other urban area",Scotland,58,,S01011010,,S02002066,"Dalkeith",,S00120680,S14000045,404,1,0,2024-03-01,"Eskbank",1.68566,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+MX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021596,120021597,120021662,120021790,120021851,120045428",5.65922,,"",,"",,1 EH22 1AQ,Yes,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","10092759892",5.81605,,"",,"",,8 EH22 1AR,Yes,55.894304,-3.068166,333297,667313,NT332673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",24,14,"","","Dalkeith - 02","Other urban area",Scotland,58,,S01011011,,S02002066,"Dalkeith",,S00120678,S14000045,336,1,0,2024-03-01,"Eskbank",1.67087,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+PP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021598,120021718,120021719,120021720,120021721,120021722,120021723,120021724,120021725,120021726,120021834,120030850,120030851,120030852,120030853,120030854,120038741,120039423,120039424,120039425,120039426,120039427,120039428,120039429,120039430,120039431,120042729",5.65264,,"",,"",,1 EH22 1AS,Yes,55.894627,-3.068723,333263,667349,NT332673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",2,1,"","","Dalkeith - 02","Other urban area",Scotland,58,,S01011011,,S02002066,"Dalkeith",,S00120679,S14000045,336,1,0,2024-03-01,"Eskbank",1.68211,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+VG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021099",5.6182,,"",,"",,1 EH22 1AT,Yes,55.894844,-3.068069,333304,667373,NT333673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",36,17,"","","Dalkeith - 02","Other urban area",Scotland,59,,S01011011,,S02002066,"Dalkeith",,S00120678,S14000045,336,1,0,2024-03-01,"Eskbank",1.72434,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+WQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021100,120021101,120021102,120021641,120021642,120021643,120021644,120021663,120030575,120030576,120030577,120030578,120030579,120030580,120030581,120030871,120030908,120033747,120034173,120034174,120034175,120034176,120038491,120047627",5.59245,,"",,"",,1 EH22 1AU,Yes,55.894640,-3.068767,333260,667351,NT332673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,5,"","","Dalkeith - 02","Other urban area",Scotland,58,,S01011011,,S02002066,"Dalkeith",,S00120679,S14000045,336,1,0,2024-03-01,"Eskbank",1.68188,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+VF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021062,120021715,120021716,120021730,120021731,120021813,120030900,120034151,120034153,120034154,120034155,120044561,120047625",5.61688,,"",,"",,1 EH22 1AW,Yes,55.894215,-3.069091,333239,667304,NT332673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,8,"","","Dalkeith - 02","Other urban area",Scotland,59,,S01011011,,S02002066,"Dalkeith",,S00120678,S14000045,336,1,0,2024-03-01,"Eskbank",1.63116,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+M9,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021103,120034139,120034140,120034141,120034142,120034144,120034145,120034146,120034469",5.66499,,"",,"",,1 EH22 1AX,Yes,55.894824,-3.069316,333226,667372,NT332673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",16,9,"","","Dalkeith - 02","Other urban area",Scotland,57,,S01011011,,S02002066,"Dalkeith",,S00120677,S14000045,336,1,0,2024-03-01,"Eskbank",1.68156,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+W7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021104,120021315,120021732,120021733,120021734,120021735,120021736,120021814,120021815,120021844,120030582,120030583,120030584,120030585,120030586,120030587,120030588,120030589,120030590,120030591,120032897,120036237,120041765,120042058,120045209,120045214,120045258,120055593",5.5981,,"",,"",,1 EH22 1AY,Yes,55.895277,-3.067889,333316,667421,NT333674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",5,2,"","","Dalkeith - 02","Other urban area",Scotland,59,,S01011011,,S02002066,"Dalkeith",,S00120679,S14000045,336,1,0,2024-03-01,"Eskbank",1.77092,EH,EH22,"Scotland","Scottish Water",9C7RVWWJ+4R,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021057,120021105,120021635,120021737,120021738,120021739,120021792,120021793,120032333,120034156,120034157,120034158,120036104,120038430,120042255,120042926,120047125,120047126,120047127,120047128,120047129,120047130,10015287181,10091963146",5.54396,,"",,"",,1 EH22 1AZ,Yes,55.896156,-3.067081,333368,667518,NT333675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",45,26,"","","Thornybank - 01","Other urban area",Scotland,57,,S01011005,,S02002065,"Thornybank",,S00120681,S14000045,1554,1,0,2024-03-01,"Eskbank",1.88041,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+F5,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021066,120021106,120021107,120021108,120021109,120021110,120021111,120021740,120021741,120021742,120021816,120021821,120030592,120030593,120030594,120030595,120030596,120030597,120030598,120030599,120030600,120030601,120030602,120030603,120030604,120030605,120030606,120030607,120030608,120030609,120030610,120030611,120030612,120030903,120031916,120033310,120034741,120042011,120050287,10015276225,10025271253",5.44475,,"",,"",,3 EH22 1BA,No,55.897362,-3.065755,333453,667651,NT334676,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,2009-05-01,"","",,,"","","Thornybank - 01","Other urban area",Scotland,57,,S01011005,,S02002065,"Thornybank",,S00120682,S14000045,1554,1,0,2024-03-01,"Eskbank",2.03784,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+WM,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.30915,,"",,"",,3 EH22 1BB,Yes,55.896773,-3.067338,333353,667587,NT333675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",47,28,"","","Thornybank - 01","Other urban area",Scotland,54,,S01011005,,S02002065,"Thornybank",,S00120681,S14000045,1554,1,0,2024-03-01,"Eskbank",1.9307,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+P3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021114,120021115,120021116,120021117,120021118,120021119,120021120,120021121,120021788,120030613,120030614,120030615,120030616,120030617,120030618,120030619,120030620,120030621,120030622,120030623,120033712,120033713,120034075,120034076,120034077,120034078,120034079,120034080,120034081,120034082,120034083,120034084,120034085,120039163,120043525",5.37668,,"",,"",,3 EH22 1BD,Yes,55.896389,-3.068095,333305,667545,NT333675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",20,9,"","","Thornybank - 01","Other urban area",Scotland,54,,S01011005,,S02002065,"Thornybank",,S00120681,S14000045,1554,1,0,2024-03-01,"Eskbank",1.87009,EH,EH22,"Scotland","Scottish Water",9C7RVWWJ+HQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021122,120021123,120021124,120021125,120021126,120021127,120021128,120030624,120030625",5.42095,,"",,"",,3 EH22 1BE,Yes,55.895857,-3.068321,333290,667486,NT332674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",14,10,"","","Dalkeith - 02","Other urban area",Scotland,57,,S01011011,,S02002066,"Dalkeith",,S00120677,S14000045,336,1,0,2024-03-01,"Eskbank",1.81192,EH,EH22,"Scotland","Scottish Water",9C7RVWWJ+8M,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021129,120021130,120021743,120021822,120033262,120034066,120034067,120034069,120034070,120034071,120034072,120034073,120034074,120038778,120042249,120043162,120043446,120047820",5.48058,,"",,"",,1 EH22 1BF,No,55.896247,-3.068971,333250,667530,NT332675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1992-10-01,1992-10-01,"","",,,"","","Dalkeith - 02","Other urban area",Scotland,52,,S01011011,,S02002066,"Dalkeith",,S00120677,S14000045,336,8,0,2024-03-01,"Eskbank",1.82959,EH,EH22,"Scotland","Scottish Water",9C7RVWWJ+FC,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.4391,,"",,"",,1 EH22 1BG,Yes,55.895456,-3.067403,333347,667440,NT333674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",15,8,"","","Dalkeith - 02","Other urban area",Scotland,59,,S01011011,,S02002066,"Dalkeith",,S00120679,S14000045,336,1,0,2024-03-01,"Eskbank",1.80398,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+52,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021131,120021132,120021133,120021134,120021135,120030632,120030633,120030634,120030635,120030636,120030637,120042468,120048292,120048293,120048294,120048295,120048296,120048297",5.52308,,"",,"",,1 EH22 1BH,Yes,55.894994,-3.067385,333347,667389,NT333673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",26,18,"","","Dalkeith - 02","Other urban area",Scotland,59,,S01011011,,S02002066,"Dalkeith",,S00120679,S14000045,336,1,0,2024-03-01,"Eskbank",1.76166,EH,EH22,"Scotland","Scottish Water",9C7RVWVM+X2,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021599,120021600,120021601,120021602,120021603,120021604,120030638,120030639,120030640,120030641,120030642,120030643,120030644,120030645,120030646,120030647,120030648,120030649,120035405",5.57436,,"",,"",,1 EH22 1BJ,Yes,55.894692,-3.066913,333376,667355,NT333673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",33,17,"","","Dalkeith - 02","Other urban area",Scotland,58,,S01011011,,S02002066,"Dalkeith",,S00120684,S14000045,336,1,0,2024-03-01,"Eskbank",1.7506,EH,EH22,"Scotland","Scottish Water",9C7RVWVM+V6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021605,120021606,120021607,120021608,120021609,120021684,120021685,120021686,120021687,120021688,120021689,120021690,120021691,120021692,120021693,120021694,120021695,120021794,120032332,120038728,120038729,120042865",5.60711,,"",,"",,1 EH22 1BL,Yes,55.895194,-3.066112,333427,667410,NT334674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",55,25,"","","Dalkeith - 02","Other urban area",Scotland,58,,S01011011,,S02002066,"Dalkeith",,S00120684,S14000045,336,1,0,2024-03-01,"Eskbank",1.82496,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+3H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021136,120021137,120021138,120021139,120021140,120021141,120021142,120021143,120021144,120021145,120021146,120021147,120021148,120021149,120021150,120021151,120021152,120021153,120021154,120021155,120021156,120021157,120021158,120021159,120021160,120048230,120050373",5.55034,,"",,"",,1 EH22 1BN,Yes,55.895823,-3.066017,333434,667480,NT334674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",10,5,"","","Dalkeith - 02","Other urban area",Scotland,57,,S01011011,,S02002066,"Dalkeith",,S00120684,S14000045,336,1,0,2024-03-01,"Eskbank",1.8857,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+8H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021610,120021611,120021612,120021613,120021614",5.48037,,"",,"",,1 EH22 1BP,Yes,55.896023,-3.066363,333413,667503,NT334675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",22,13,"","","Thornybank - 01","Other urban area",Scotland,58,,S01011005,,S02002065,"Thornybank",,S00120682,S14000045,1554,1,0,2024-03-01,"Eskbank",1.89215,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+CF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021616,120030650,120030651,120030652,120030653,120030654,120030655,120030656,120030657,120030658,120030883,120030884,120030885,120030886,120050270",5.45851,,"",,"",,3 EH22 1BQ,No,55.896543,-3.065941,333440,667560,NT334675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1994-02-01,1995-12-01,"","",,,"","","Thornybank - 01","Other urban area",Scotland,57,,S01011005,,S02002065,"Thornybank",,S00120682,S14000045,1554,8,1,2024-03-01,"Eskbank",1.95488,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+JJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.4003,,"",,"",,3 EH22 1BS,Yes,55.896350,-3.065408,333473,667538,NT334675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",20,16,"","","Thornybank - 01","Other urban area",Scotland,56,,S01011005,,S02002065,"Thornybank",,S00120683,S14000045,1554,1,0,2024-03-01,"Eskbank",1.95546,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+GR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021617,120021618,120021619,120021620,120021621,120021622,120021623,120021624,120021625,120021626,120021627,120021628,120030659,120030660,120030661,120030662",5.42138,,"",,"",,3 EH22 1BT,Yes,55.896597,-3.065894,333443,667566,NT334675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",24,13,"","","Thornybank - 01","Other urban area",Scotland,57,,S01011005,,S02002065,"Thornybank",,S00120682,S14000045,1554,1,0,2024-03-01,"Eskbank",1.96151,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+JJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021629,120021630,120021631,120021632,120021633,120021634,120030663,120030664,120030665,120030666,120030667,120030668,120030669,120030670",5.39426,,"",,"",,3 EH22 1BU,Yes,55.897037,-3.065938,333441,667615,NT334676,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",2,1,"","","Thornybank - 01","Other urban area",Scotland,57,,S01011005,,S02002065,"Thornybank",,S00120682,S14000045,1554,1,0,2024-03-01,"Eskbank",2.00119,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+RJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032380,120034383,120034389,120034436,120034446,120035127",5.34541,,"",,"",,3 EH22 1BW,Yes,55.895658,-3.065341,333476,667461,NT334674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",18,10,"","","Thornybank - 01","Other urban area",Scotland,56,,S01011005,,S02002065,"Thornybank",,S00120683,S14000045,1554,1,0,2024-03-01,"Eskbank",1.89484,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+7V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021161,120021162,120021163,120021164,120021165,120021166,120021167,120021168,120021169,120021170,120021171,120042360",5.49824,,"",,"",,3 EH22 1BX,Yes,55.896644,-3.064680,333519,667570,NT335675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",101,50,"","","Thornybank - 01","Other urban area",Scotland,56,,S01011005,,S02002065,"Thornybank",,S00120683,S14000045,1554,1,0,2024-03-01,"Eskbank",2.00809,EH,EH22,"Scotland","Scottish Water",9C7RVWWP+M4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021172,120021173,120021174,120021175,120021176,120021177,120021178,120021179,120021180,120021181,120021182,120021183,120021184,120021185,120021186,120021187,120021188,120021189,120021190,120021191,120021192,120021193,120021194,120021195,120021196,120021197,120021198,120021199,120021200,120021201,120021202,120021203,120021204,120021205,120021206,120021207,120021208,120021209,120021210,120021211,120021212,120021213,120021214,120021215,120021216,120021217,120021218,120021219,120021220,120021221,120021222,120021223,120021224,120021225,120030671,120034168,120034169,120034170,120044667,120044824,10025429013",5.38855,,"",,"",,3 EH22 1BY,No,55.897286,-3.065241,333485,667642,NT334676,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,2004-02-01,"","",,,"","","Thornybank - 01","Other urban area",Scotland,57,,S01011005,,S02002065,"Thornybank",,S00120682,S14000045,1554,1,0,2024-03-01,"Eskbank",2.04788,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+WW,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.3173,,"",,"",,3 EH22 1BZ,Yes,55.897424,-3.063742,333579,667656,NT335676,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",48,22,"","","Thornybank - 01","Other urban area",Scotland,56,,S01011005,,S02002065,"Thornybank",,S00120682,S14000045,1554,1,0,2024-03-01,"Eskbank",2.11261,EH,EH22,"Scotland","Scottish Water",9C7RVWWP+XG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021227,120021228,120021229,120021230,120021231,120021232,120021233,120021234,120021235,120021236,120021237,120021238,120021239,120021240,120021241,120021242,120021243,120021244,120021245,120021246,120021247,120021248,120034457",5.30222,,"",,"",,3 EH22 1DA,Yes,55.896613,-3.062009,333686,667564,NT336675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",78,44,"","","Thornybank - 01","Other urban area",Scotland,53,,S01011005,,S02002065,"Thornybank",,S00120688,S14000045,1554,1,0,2024-03-01,"Eskbank",2.10483,EH,EH22,"Scotland","Scottish Water",9C7RVWWQ+J5,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021249,120021250,120021251,120021252,120021253,120021254,120021255,120021256,120021257,120021258,120021259,120021260,120021261,120021262,120021263,120021264,120021265,120021266,120021267,120021268,120021269,120021270,120021271,120021272,120021273,120021274,120021275,120021276,120021277,120021278,120021279,120021280,120021281,120021282,120021283,120021284,120021285,120021286,120021287,120021288,120021289,120021290,120021291,120033533,120042809",5.39463,,"",,"",,3 EH22 1DB,Yes,55.896390,-3.061827,333697,667539,NT336675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",10,6,"","","Thornybank - 01","Other urban area",Scotland,52,,S01011005,,S02002065,"Thornybank",,S00120688,S14000045,1554,1,0,2024-03-01,"Eskbank",2.09268,EH,EH22,"Scotland","Scottish Water",9C7RVWWQ+H7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021292,120021293,120021294,120021295,120021296,120021297",5.41977,,"",,"",,3 EH22 1DD,Yes,55.896299,-3.062976,333625,667530,NT336675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",33,16,"","","Thornybank - 01","Other urban area",Scotland,54,,S01011005,,S02002065,"Thornybank",,S00120689,S14000045,1554,1,0,2024-03-01,"Eskbank",2.04014,EH,EH22,"Scotland","Scottish Water",9C7RVWWP+GR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021298,120021299,120021300,120021301,120021302,120021303,120021304,120021305,120021306,120021307,120021308,120021309,120021310,120021311,120021312,120021313,120021314",5.42797,,"",,"",,3 EH22 1DE,No,55.892221,-3.070108,333172,667083,NT331670,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,2000-06-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121039,S14000045,404,1,1,2024-03-01,"Eskbank",1.41149,EH,EH22,"Scotland","Scottish Water",9C7RVWRH+VX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.88959,,"",,"",,1 EH22 1DF,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-12-01,2018-12-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8 EH22 1DG,No,55.894193,-3.067475,333340,667300,NT333672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1992-10-01,1992-10-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,58,,S01011010,,S02002066,"Dalkeith",,S00120680,S14000045,404,8,1,2024-03-01,"Eskbank",1.6851,EH,EH22,"Scotland","Scottish Water",9C7RVWVM+M2,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.6635,,"",,"",,1 EH22 1DH,Yes,55.895104,-3.069131,333238,667403,NT332674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1983-11-01,,"","",8,8,"","","Dalkeith - 02","Other urban area",Scotland,57,,S01011011,,S02002066,"Dalkeith",,S00120677,S14000045,336,1,0,2024-03-01,"Eskbank",1.71421,EH,EH22,"Scotland","Scottish Water",9C7RVWWJ+28,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021316,120021317,120021318,120021319,120021320,120021321,120030902,120033996,120033997,120036578,120045210",5.56645,,"",,"",,1 EH22 1DJ,Yes,55.892221,-3.070108,333172,667083,NT331670,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1984-03-01,,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121039,S14000045,404,1,1,2024-03-01,"Eskbank",1.41149,EH,EH22,"Scotland","Scottish Water",9C7RVWRH+VX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032338,120045422,10025429571",5.88959,,"",,"",,1 EH22 1DL,No,55.893720,-3.069157,333234,667249,NT332672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2002-07-01,2002-07-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00120680,S14000045,404,2,0,2024-03-01,"Eskbank",1.58268,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+F8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.72013,,"",,"",,1 EH22 1DN,Yes,55.892221,-3.070108,333172,667083,NT331670,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1992-07-01,,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121039,S14000045,404,1,1,2024-03-01,"Eskbank",1.41149,EH,EH22,"Scotland","Scottish Water",9C7RVWRH+VX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","10092010707",5.88959,,"",,"",,1 EH22 1DP,No,55.892452,-3.069378,333218,667108,NT332671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1992-01-01,2014-01-01,"","",0,0,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121039,S14000045,404,1,0,2024-03-01,"Eskbank",1.45875,EH,EH22,"Scotland","Scottish Water",9C7RVWRJ+X6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.86154,,"",,"",,1 EH22 1DQ,Yes,55.896156,-3.068041,333308,667519,NT333675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1983-08-01,,"","",44,36,"","","Dalkeith - 02","Other urban area",Scotland,56,,S01011011,,S02002066,"Dalkeith",,S00120677,S14000045,336,1,0,2024-03-01,"Eskbank",1.8494,EH,EH22,"Scotland","Scottish Water",9C7RVWWJ+FQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032340,120032341,120032342,120032343,120032344,120032345,120032346,120032347,120032348,120032349,120032350,120032351,120032352,120032353,120032354,120032355,120032356,120032357,120032358,120032359,120032360,120032361,120032362,120032363,120032364,120032365,120032366,120032367,120032368,120032369,120032370,120032371,120032372,120032373,120032374,120032375,120032376,120035064,120042280,120048190",5.4467,,"",,"",,1 EH22 1DR,Yes,55.892031,-3.068183,333292,667060,NT332670,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",34,15,"","","Dalkeith - 01","Other urban area",Scotland,58,,S01011010,,S02002066,"Dalkeith",,S00121040,S14000045,404,1,0,2024-03-01,"Eskbank",1.46702,EH,EH22,"Scotland","Scottish Water",9C7RVWRJ+RP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021323,120021324,120021325,120021326,120021327,120021328,120021329,120021681,120030672,120030673,120030674,120030872,120030873,120030874,120030875,120030876,120030877,120032386,120032603,120034161,120034361,120034362,120037161,120046742,120051988",5.90508,,"",,"",,1 EH22 1DS,Yes,55.892550,-3.068970,333244,667119,NT332671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",7,5,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00121039,S14000045,404,1,0,2024-03-01,"Eskbank",1.48253,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+2C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021330,120021683,120021837,120030675,120030676,120030677,120030878,120030880,120030881,120033085,120033138,120034163,120034368,120035107,120044853,120046835,120046836,120046837,120046845,120046846,120046847,120046848,120046849,120046850,120046851,120046852,120046853,120046854,120046855,120046856,120046857,120046858,120046859,120046860,120046861,120046862,120046863,120046864,120046866,120046867,120048171,120049798",5.84946,,"",,"",,1 EH22 1DT,No,55.892755,-3.068619,333266,667141,NT332671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,1999-06-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00121039,S14000045,404,1,1,2024-03-01,"Eskbank",1.51385,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+4H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.82575,,"",,"",,1 EH22 1DU,Yes,55.892812,-3.068753,333258,667148,NT332671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",2,1,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00121039,S14000045,404,1,0,2024-03-01,"Eskbank",1.514,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+4F,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021331,120021682,120021835,120021847,120030879,120032339,120033387,120035475,120037711,120037712,120042417,120042567,120045416,120053419,120053654,120053892,120053896,120054051",5.81977,,"",,"",,1 EH22 1DW,No,55.893095,-3.069844,333190,667180,NT331671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1992-07-01,1995-12-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121039,S14000045,404,8,1,2024-03-01,"Eskbank",1.50113,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+63,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.7917,,"",,"",,1 EH22 1DX,Yes,55.892569,-3.067223,333353,667119,NT333671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2011-09-01,,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,56,,S01011010,,S02002066,"Dalkeith",,S00121042,S14000045,404,1,0,2024-03-01,"Eskbank",1.55118,EH,EH22,"Scotland","Scottish Water",9C7RVWVM+24,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032377,120034127,120045450,120045451,120045452,120045453,120045454,120045455,120045456,120045457,120045458,120045459,120045460,120045461,120045462,120045463,120045464,120045465,120045466,120045467",5.84344,,"",,"",,1 EH22 1DY,Yes,55.893049,-3.066820,333379,667172,NT333671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",83,42,"","","Dalkeith - 01","Other urban area",Scotland,57,,S01011010,,S02002066,"Dalkeith",,S00121042,S14000045,404,1,0,2024-03-01,"Eskbank",1.60836,EH,EH22,"Scotland","Scottish Water",9C7RVWVM+67,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021645,120021646,120021647,120021648,120021649,120021650,120021651,120021652,120021653,120021654,120021655,120021656,120021657,120021658,120021659,120021660,120021661,120021696,120021697,120021698,120021699,120021700,120021701,120021702,120021703,120021704,120021705,120021706,120021707,120021708,120021709,120021710,120021711,120021712,120021713,120021783,120021784,120021785,120021786,120031645,120031646,120032379,120034344,120034352,120034353,120034406,120034407,120034437,120035046,120035047,120038557,120038558,120038559,120038560,120038561,120042076,120042077",5.7895,,"",,"",,1 EH22 1DZ,Yes,55.893572,-3.066611,333393,667230,NT333672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,5,"","","Dalkeith - 01","Other urban area",Scotland,58,,S01011010,,S02002066,"Dalkeith",,S00121042,S14000045,404,1,0,2024-03-01,"Eskbank",1.66192,EH,EH22,"Scotland","Scottish Water",9C7RVWVM+C9,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120030678,120030679,120030680,120030681,120030682,120030887",5.73111,,"",,"",,1 EH22 1EA,Yes,55.893704,-3.065879,333439,667244,NT334672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",41,23,"","","Dalkeith - 02","Other urban area",Scotland,57,,S01011011,,S02002066,"Dalkeith",,S00120685,S14000045,336,1,0,2024-03-01,"Eskbank",1.70183,EH,EH22,"Scotland","Scottish Water",9C7RVWVM+FJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120030683,120030684,120030685,120030686,120030687,120030688,120030689,120030690,120030691,120030692,120030693,120030694,120030695,120030696,120030697,120030698,120030699,120030700,120030701,120030702,120030888,120030889,120030890,120030891",5.71569,,"",,"",,1 EH22 1EB,Yes,55.894403,-3.065066,333491,667321,NT334673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",46,41,"","","Dalkeith - 02","Other urban area",Scotland,57,,S01011011,,S02002066,"Dalkeith",,S00120685,S14000045,336,1,0,2024-03-01,"Eskbank",1.79409,EH,EH22,"Scotland","Scottish Water",9C7RVWVM+QX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120030703,120030704,120030705,120030706,120030707,120030708,120030709,120030710,120030711,120030712,120030713,120030714,120030715,120030716,120030717,120030718,120030719,120030720,120030721,120030722,120030723,120030724,120030725,120030726,120030727,120030728,120030729,120030730,120030731,120030732,120030733,120030734,120030735,120030736,120030737,120030738,120030739,120030740,120030741,120030742,120030892,120030897",5.63761,,"",,"",,1 EH22 1ED,Yes,55.894799,-3.063926,333563,667364,NT335673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",33,16,"","","Dalkeith - 02","Other urban area",Scotland,56,,S01011011,,S02002066,"Dalkeith",,S00121043,S14000045,336,1,0,2024-03-01,"Eskbank",1.87306,EH,EH22,"Scotland","Scottish Water",9C7RVWVP+WC,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021332,120021333,120021334,120021335,120021336,120021337,120021338,120021339,120021340,120030743,120030744,120030745,120030746,120030747,120030748,120030749,120030893",5.59378,,"",,"",,1 EH22 1EE,Yes,55.895023,-3.064560,333524,667390,NT335673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",17,8,"","","Dalkeith - 02","Other urban area",Scotland,57,,S01011011,,S02002066,"Dalkeith",,S00121043,S14000045,336,1,0,2024-03-01,"Eskbank",1.86765,EH,EH22,"Scotland","Scottish Water",9C7RVWWP+25,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021341,120021342,120021343,120021344,120030750,120030751,120030752,120030753,120042164",5.56868,,"",,"",,1 EH22 1EF,Yes,55.894641,-3.065537,333462,667348,NT334673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",45,24,"","","Dalkeith - 02","Other urban area",Scotland,58,,S01011011,,S02002066,"Dalkeith",,S00120686,S14000045,336,1,0,2024-03-01,"Eskbank",1.79679,EH,EH22,"Scotland","Scottish Water",9C7RVWVM+VQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021345,120021346,120021347,120021348,120021349,120021350,120021351,120021352,120021353,120021354,120021355,120021356,120021357,120021358,120021359,120021360,120030754,120030755,120030756,120030757,120030758,120030759,120030760,120030761,120030904,120044668,10025429592",5.61135,,"",,"",,1 EH22 1EG,Yes,55.895036,-3.065644,333456,667392,NT334673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",66,26,"","","Dalkeith - 02","Other urban area",Scotland,58,,S01011011,,S02002066,"Dalkeith",,S00120686,S14000045,336,1,0,2024-03-01,"Eskbank",1.82786,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+2P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021361,120021362,120021363,120021364,120021365,120021366,120021367,120021368,120021369,120021370,120021371,120021372,120021373,120021374,120021375,120021376,120021377,120021378,120021379,120021380,120021381,120021382,120030762,120030763,120030764,120030765,120030766,120030767,120030768,120030769,120030770,120030771,120034130",5.56752,,"",,"",,1 EH22 1EH,Yes,55.895378,-3.063494,333591,667428,NT335674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",20,10,"","","Thornybank - 01","Other urban area",Scotland,55,,S01011005,,S02002065,"Thornybank",,S00120689,S14000045,1554,1,0,2024-03-01,"Eskbank",1.9399,EH,EH22,"Scotland","Scottish Water",9C7RVWWP+5J,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021383,120021384,120021385,120021386,120021387,120021388,120021389,120021390,120021391,120021392,120021393",5.52975,,"",,"",,3 EH22 1EJ,Yes,55.895634,-3.063021,333621,667456,NT336674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",41,18,"","","Thornybank - 01","Other urban area",Scotland,55,,S01011005,,S02002065,"Thornybank",,S00120689,S14000045,1554,1,0,2024-03-01,"Eskbank",1.98056,EH,EH22,"Scotland","Scottish Water",9C7RVWWP+7Q,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021394,120021395,120021396,120021397,120021398,120021399,120021400,120021401,120021402,120021403,120021404,120021405,120021406,120021407,120021408,120021409,120030772,120030773",5.50179,,"",,"",,3 EH22 1EL,Yes,55.895931,-3.061894,333692,667488,NT336674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",58,20,"","","Thornybank - 01","Other urban area",Scotland,52,,S01011005,,S02002065,"Thornybank",,S00120947,S14000045,1554,1,0,2024-03-01,"Eskbank",2.05075,EH,EH22,"Scotland","Scottish Water",9C7RVWWQ+96,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021410,120021411,120021412,120021413,120021414,120021415,120021416,120021417,120021418,120021419,120021420,120021421,120021422,120021423,120021424,120030774,120030775,120030776,120030777,120034123,120034124,120041619,120042808",5.47061,,"",,"",,3 EH22 1EN,Yes,55.895055,-3.062446,333656,667391,NT336673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",50,24,"","","Thornybank - 01","Other urban area",Scotland,52,,S01011005,,S02002065,"Thornybank",,S00120947,S14000045,1554,1,0,2024-03-01,"Eskbank",1.95446,EH,EH22,"Scotland","Scottish Water",9C7RVWWQ+22,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021425,120021426,120021427,120021428,120021429,120021430,120021431,120021432,120021433,120021434,120021435,120021436,120021437,120021438,120021439,120021440,120021441,120021442,120021443,120021444,120030778,120030779,120030780,120030781,120030782,120030783,120042162,120042163",5.56692,,"",,"",,3 EH22 1EP,Yes,55.893666,-3.065062,333490,667239,NT334672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",18,8,"","","Dalkeith - 02","Other urban area",Scotland,55,,S01011011,,S02002066,"Dalkeith",,S00120687,S14000045,336,1,0,2024-03-01,"Eskbank",1.73112,EH,EH22,"Scotland","Scottish Water",9C7RVWVM+FX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021445,120021446,120021447,120021448,120021449,120021450,120021451,120021452,120044581,120053256,10015369398,10025429593",5.7195,,"",,"",,1 EH22 1EQ,Yes,55.895548,-3.064063,333556,667447,NT335674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",14,7,"","","Dalkeith - 02","Other urban area",Scotland,55,,S01011011,,S02002066,"Dalkeith",,S00121043,S14000045,336,1,0,2024-03-01,"Eskbank",1.93269,EH,EH22,"Scotland","Scottish Water",9C7RVWWP+69,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021453,120021454,120021455,120021456,120021457,120021458,120021459,120021795,120030784,120030785,120043098,10025429026",5.51048,,"",,"",,1 EH22 1ER,Yes,55.892792,-3.065406,333467,667142,NT334671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",42,26,"","","Dalkeith - 02","Other urban area",Scotland,52,,S01011011,,S02002066,"Dalkeith",,S00120687,S14000045,336,1,0,2024-03-01,"Eskbank",1.64395,EH,EH22,"Scotland","Scottish Water",9C7RVWVM+4R,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021460,120021461,120021462,120021463,120021464,120021465,120021466,120021467,120021468,120021469,120021470,120021471,120021472,120021473,120021474,120021475,120021476,120021477,120021478,120021479,120021480,120021481,120021482,120021483,120021484,120021485,120021486,120042079",5.81674,,"",,"",,1 EH22 1ES,Yes,55.892416,-3.066775,333381,667102,NT333671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",5,2,"","","Dalkeith - 01","Other urban area",Scotland,55,,S01011010,,S02002066,"Dalkeith",,S00121040,S14000045,404,1,0,2024-03-01,"Eskbank",1.55619,EH,EH22,"Scotland","Scottish Water",9C7RVWRM+X7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021487,120021488",5.85976,,"",,"",,1 EH22 1ET,Yes,55.892488,-3.064199,333542,667107,NT335671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",17,7,"","","Dalkeith - 02","Other urban area",Scotland,46,,S01011011,,S02002066,"Dalkeith",,S00120687,S14000045,336,1,0,2024-03-01,"Eskbank",1.67109,EH,EH22,"Scotland","Scottish Water",9C7RVWRP+X8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021489,120021490,120021491,120021492,120021493,120021636,120021727,120021846,120030898,120030905,120032395,120034166,120038099,120048570,120049911,120050421,120050444,120055229,120055230,10024914927",5.85045,,"",,"",,1 EH22 1EU,Yes,55.895871,-3.065714,333453,667485,NT334674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1998-12-01,,"","",19,10,"","","Dalkeith - 02","Other urban area",Scotland,57,,S01011011,,S02002066,"Dalkeith",,S00120684,S14000045,336,1,0,2024-03-01,"Eskbank",1.90079,EH,EH22,"Scotland","Scottish Water",9C7RVWWM+8P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021615,120032883,120032884,120032885,120032886,120032887,120032888,120032889,120032890,120032891,120032892,120032893,120032894,120037383",5.47479,,"",,"",,1 EH22 1EW,Yes,55.894063,-3.063858,333566,667282,NT335672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",101,55,"","","Dalkeith - 02","Other urban area",Scotland,53,,S01011011,,S02002066,"Dalkeith",,S00121044,S14000045,336,1,0,2024-03-01,"Eskbank",1.81357,EH,EH22,"Scotland","Scottish Water",9C7RVWVP+JF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021494,120021495,120021496,120021497,120021498,120021499,120021500,120021501,120021502,120021503,120021504,120021505,120021506,120021507,120030786,120030787,120030788,120030789,120030790,120030791,120030792,120030793,120030794,120030795,120030796,120030797,120030798,120030799,120030800,120030801,120030802,120030803,120030804,120030805,120030806,120030807,120030808,120030809,120030810,120030811,120030812,120030813,120030814,120030815,120030816,120030817,120030818,120030819,120030820,120030821,120030822,120030823,120030824,120030825,120030826,120030827,120030828,120030894,120030895,120042165",5.6756,,"",,"",,1 EH22 1EX,Yes,55.896688,-3.067896,333318,667578,NT333675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2000-12-01,,"","",13,7,"","","Thornybank - 01","Other urban area",Scotland,53,,S01011005,,S02002065,"Thornybank",,S00120681,S14000045,1554,1,0,2024-03-01,"Eskbank",1.90507,EH,EH22,"Scotland","Scottish Water",9C7RVWWJ+MR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120035363,120035364,120035365,120035366,120035367,120035368,120035369,120035370",5.38728,,"",,"",,3 EH22 1EY,Yes,55.894528,-3.067729,333325,667337,NT333673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2018-04-01,,"","",,,"","","Dalkeith - 02","Other urban area",Scotland,53,,S01011011,,S02002066,"Dalkeith",,S00120678,S14000045,336,5,0,2024-03-01,"Eskbank",1.70673,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+RW,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120056860,120056861,120056862,120056863,120056864,120056865",5.62679,,"",,"",,1 EH22 1EZ,Yes,55.892373,-3.067574,333331,667098,NT333670,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2007-10-01,,"","",36,27,"","","Dalkeith - 01","Other urban area",Scotland,57,,S01011010,,S02002066,"Dalkeith",,S00121040,S14000045,404,1,0,2024-03-01,"Eskbank",1.52047,EH,EH22,"Scotland","Scottish Water",9C7RVWRJ+WX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021787,120035129,120038830,120038832,120038833,120038834,120038835,120038836,120038837,120038838,120038839,120038840,120038841,120038842,120038843,120038844,120038845,120038846,120038847,120038848,120038849,120038850,120038851,120038852,120038853,120038854,120038855,120038856,120038857,120038858,120038859,120038860,120038861,120038862,120038863,120038864,120038865,120038866,120039145,120039146,120041225,120041734,120044820,120047110,120047111",5.86583,,"",,"",,1 EH22 1FA,Yes,55.912067,-3.087360,332128,669309,NT321693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2019-04-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,62,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,1,0,2024-03-01,"Shawfair",1.02751,EH,EH22,"Scotland","Scottish Water",9C7RWW67+R3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120038623,120046839,120050919,120052946,120053101,120053102,120053125,120053230,120053271,120053360,120053397,120053793,120054182,120054183,10025429001",3.93572,,"",,"",,6 EH22 1FB,Yes,55.912550,-3.086510,332182,669361,NT321693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2019-09-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,58,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,1,0,2024-03-01,"Shawfair",0.954204,EH,EH22,"Scotland","Scottish Water",9C7RWW77+29,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120050315,120054377,120054378,120054379,120054380,120054381,120054382,120054383,120054384,120054385,120054386,120054387,120054388,120054389,120054706",3.86678,,"",,"",,6 EH22 1FD,Yes,55.907735,-3.100112,331323,668839,NT313688,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2011-03-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,62,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.90158,EH,EH22,"Scotland","Scottish Water",9C7RWV5X+3X,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120033742,120037105,120039277,120039278,120039279,120042039,120043083,120044979,120045638,120045642,120045643,120045644,120045645,120047239,120047463,120052744,120052895,120054026,120055088,120056122,10025429281,10096077924",4.70401,,"",,"",,6 EH22 1FE,Yes,55.908658,-3.097371,331496,668939,NT314689,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2010-02-01,,"","",0,0,"","","Shawfair - 01","Accessible rural area",Scotland,60,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.70951,EH,EH22,"Scotland","Scottish Water",9C7RWW53+F3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120034957,120044980,120056547,120057054,10025429268",4.53462,,"",,"",,6 EH22 1FF,Yes,55.905541,-3.099218,331375,668594,NT313685,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2008-05-01,,"","",0,0,"","","Shawfair - 01","Accessible rural area",Scotland,64,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",2.04735,EH,EH22,"Scotland","Scottish Water",9C7RWW42+68,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120041572,120042814,120046094,120053922,10025370858",4.8961,,"",,"",,6 EH22 1FG,Yes,55.912666,-3.086625,332175,669374,NT321693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2020-12-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,63,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,1,0,2024-03-01,"Shawfair",0.946837,EH,EH22,"Scotland","Scottish Water",9C7RWW77+39,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120054390,120054391,120054392,120054393,120054394,120054395,120054396,120054460,120054461,120054462,120054463,120054464,120054465,120054466,120054467,120054468,120054469,120054470,120054471,120054472,120054473,120054474,120054475,120054476",3.85723,,"",,"",,6 EH22 1FH,Yes,55.912514,-3.085517,332244,669356,NT322693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2020-10-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,51,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,2,0,2024-03-01,"Shawfair",0.927828,EH,EH22,"Scotland","Scottish Water",9C7RWW77+2Q,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120054102,120054103,120054123,120054124,120054125,120054126,120054127,120054128,120054135,120054136,120056814",3.8493,,"",,"",,6 EH22 1FJ,Yes,55.914554,-3.081462,332501,669580,NT325695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2019-05-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,46,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,1,0,2024-03-01,"Shawfair",0.622734,EH,EH22,"Scotland","Scottish Water",9C7RWW79+RC,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120050569,120050570,120050573,120053134,120053135,120053136,120053137,120053138,120053139,120053140,120053141,120053142,120053143,120053144,120053145,120053146,120053147",3.55458,,"",,"",,6 EH22 1FL,Yes,55.912049,-3.084272,332321,669304,NT323693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2017-05-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,64,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,1,0,2024-03-01,"Shawfair",0.942945,EH,EH22,"Scotland","Scottish Water",9C7RWW68+R7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120036093,120042514,120043552,120050314,120050316,120050318,120051609,120051722,120051723,120051724,120051725,120051741,120051746,120051760,120051826,120051827,120051835,120051846,120051898,120051899,120051900,120051932,120051933,120051934,120051951,120051952,120051958,120051979,120051980,120051981,120052012,120052013,120052033,120052034,120052035,120052120,120052121,120052166,120052167,120052178,120052179,120052180,120052188,120052197,120052227,120052228,120052238,120052239,120052397,120052459,120052460,120052470,120052512,120052520,120052550,120052576,120052577,120052591,120052592,120052593,120052594,120052595,120052609,120052610,120052611,120052612,120052613,120052614,120052615,120052658,120052659,120052735,120052825,120052961,120053056,120053544,120054181,120054581,120054734,120054735,120055325,10015400000",3.87295,,"",,"",,6 EH22 1FN,Yes,55.912567,-3.083567,332366,669360,NT323693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2017-10-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,50,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,1,0,2024-03-01,"Shawfair",0.873507,EH,EH22,"Scotland","Scottish Water",9C7RWW78+2H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120047519,120050319,120051719,120051720,120051721,120051737,120051740,120051747,120051758,120051759,120051798,120051833,120051834,120051888,120052032,120052229",3.80458,,"",,"",,6 EH22 1FP,Yes,55.912315,-3.085671,332234,669334,NT322693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2020-11-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,58,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,1,0,2024-03-01,"Shawfair",0.951882,EH,EH22,"Scotland","Scottish Water",9C7RWW67+WP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120050317,120054159,120054160,120054161,120054162,120054163,120054164,120054168,120054169,120054170,120054171,120054172,120054173,120054174",3.87335,,"",,"",,6 EH22 1FQ,Yes,55.910954,-3.099263,331382,669196,NT313691,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2018-05-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,57,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.62336,EH,EH22,"Scotland","Scottish Water",9C7RWW62+97,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120050578,120051838,120051839,120051840,120051841,120051842,120052316,120052317,120052318,120052319,120052320,120052364,120052365,120052366,120052367,120052455,120052456,120052457,120052458,120052505,120052506,120052507,120052525,120052549,120052558,120052587,120052640,120052641,120052642,120052671,120052672,120052686,120052705,120052706,120052707,120052708,120052733,120052747,120052810,120052836,120052837,120053069,120053110,120053149,120053164,120053189,120053201,120053207,120053241,120053242,120053248,120053258,120053259,120053277,120053306,120053392,120053393,120053449,120053495,120053505,120053506,120053557,120053558,120053559,120053560,120053626,120053627,120053646,120053664,120053712,120053713,120053714,120053738,120053794,120053876,120053877,120053878,120053879,120053880,120053881,120053882,120053928,120053929,120054003,120055591,120055991",4.36485,,"",,"",,6 EH22 1FR,Yes,55.911529,-3.103374,331126,669265,NT311692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2021-03-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,65,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.79791,EH,EH22,"Scotland","Scottish Water",9C7RWV6W+JM,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120054493,120054494,120054495,120054496,120054599,120054600,120054601,120054678,120054679,120054680,120054681,120054841,120054842,120054843,120054844,120054845,120054846,120054847,120054848,120054849,120054850,120054851,120054852,120055131,120055132,120055133,120055134,120055135,120055136,120055137,120055138,120055139,120055140,120055441,120055442,120055443,120055444,120055572,120055573,120055574,120055575,120055576,120055577,120055578,120055579",4.4426,,"",,"",,6 EH22 1FS,Yes,55.911026,-3.102368,331188,669208,NT311692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2019-07-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,59,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.77529,EH,EH22,"Scotland","Scottish Water",9C7RWV6X+C3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120053603,120053604,120053605,120053606,120054116,120054141,120054179,120054215,120054235,120054263,120054264,120054283,120054305,120054326,120054327,120054339,120054340,120054435,120054436,120054492,120054582,120054583,120054609,120054610,120055057,120055058,120055059,120055161,120055195,120055196,120055210,120055289,120055310,120055331,120055364,120055407,120055431,120055480,120055524,120055543,120055598,120055619,120055636,120055670,120055685,120055713,120055726,120055756,120055802,120055803,120055832,120055855,120055867,120055978,120055979,120055980,120056009,120056010,120056061,120056072,120056134,120056146,120056149,120056181,120056223,120056242,120056294",4.45644,,"",,"",,6 EH22 1FT,Yes,55.910521,-3.100530,331302,669150,NT313691,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2019-01-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,62,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.7152,EH,EH22,"Scotland","Scottish Water",9C7RWV6X+6Q,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120050577,120052873,120052894,120052907,120052917,120052962,120052963,120053003,120053033,120053034,120053035,120053036,120053741,120053969,120053970,120053976,120053992,120054069,120054638,120054639,120054676,120054710,120054723,120054733,120054764,120054785,120054829,120054905,120054924,120054925,120054926,120054989,120056716,120056717,120056754,120056757,120056759,120056760",4.44582,,"",,"",,6 EH22 1FU,Yes,55.909995,-3.101091,331266,669092,NT312690,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2022-10-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,61,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.77873,EH,EH22,"Scotland","Scottish Water",9C7RWV5X+XH,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120056429,120056450,120056451,120056609,120056610,120056611,120056613",4.51391,,"",,"",,6 EH22 1FW,Yes,55.912655,-3.099967,331341,669386,NT313693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2020-02-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,50,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.55162,EH,EH22,"Scotland","Scottish Water",9C7RWW72+32,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120053888,120053889,120053923,120053924,120053925,120054296,120054367,120054368",4.22397,,"",,"",,6 EH22 1FX,Yes,55.912370,-3.100774,331290,669356,NT312693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2018-07-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,50,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.61101,EH,EH22,"Scotland","Scottish Water",9C7RWV6X+WM,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120052419,120052479,120053679,120053724,120053733,120053742,120053743,120053744,120053800,120053801,120053988,120053989,120053990,120053991,120054046,120054047,120054112,120054113,120054114,120054115,120054187,120054225,120054226,120054490,120054491",4.27722,,"",,"",,6 EH22 1FY,Yes,55.913042,-3.101929,331219,669431,NT312694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2019-04-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,63,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.63647,EH,EH22,"Scotland","Scottish Water",9C7RWV7X+66,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120050575,120053246,120053247,120053251,120053266,120053267,120053278,120053343,120053344,120053345,120053346,120053401,120053428,120053494,120053507,120053561,120053567,120053568,120053593,120053607,120053612,120053722,120053723",4.25255,,"",,"",,6 EH22 1FZ,Yes,55.913320,-3.103057,331149,669464,NT311694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2018-06-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,50,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.68512,EH,EH22,"Scotland","Scottish Water",9C7RWV7W+8Q,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120051925,120051926,120051927,120051928,120051929,120052370,120052371,120052418,120052501,120052523,120052524,120052560,120052636,120052669,120052670,120052683,120052788,120052818,120052861,120052891,120052892,120052893,120053009,120053037,120053070,120053190,120053191,120053200,120053347,120054361",4.26556,,"",,"",,6 EH22 1GA,Yes,55.912916,-3.104021,331088,669420,NT310694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2018-05-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,57,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.7588,EH,EH22,"Scotland","Scottish Water",9C7RWV7W+59,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120052434,120052435,120052439,120052440,120052489,120052500,120052557,120052559,120052588,120052589,120052606,120052607,120052919,120053071,120053072,120053073,120053074,120053075,120053076,120053077,120053078,120053079,120053080,120053081,120053082,120053083,120053084,120053085,120053086,120053087,120053088,120053089,120053090,120053091,120053092,120053093,120054518",4.33642,,"",,"",,6 EH22 1GD,Yes,55.911993,-3.088622,332049,669302,NT320693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2019-09-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,66,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,2,0,2024-03-01,"Shawfair",1.07752,EH,EH22,"Scotland","Scottish Water",9C7RWW66+QH,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",3.97216,,"",,"",,6 EH22 1GE,Yes,55.912769,-3.092291,331821,669392,NT318693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2021-02-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,66,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.16203,EH,EH22,"Scotland","Scottish Water",9C7RWW75+43,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120048839,120050567,120052971,120053546,120054711,120054725,120054769,120054770,120054826,120054956,120054957,120054958,120054959,120054983,120055004,120055005,120055007,120055008,120055104,120055113,120055141,120055166,120055167,120055226,120055244,120055278,120055281,120055400,120055401,120055471,120055479,120055512,120055518,120055701,10025376390",3.98523,,"",,"",,6 EH22 1GF,No,55.892569,-3.069866,333188,667122,NT331671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2023-09-01,2023-12-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,54,,S01011010,,S02002066,"Dalkeith",,S00121039,S14000045,404,2,0,2024-03-01,"Eskbank",1.45186,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+23,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.85014,,"",,"",,1 EH22 1GH,Yes,55.893438,-3.063861,333565,667212,NT335672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2023-09-01,,"","",,,"","","Dalkeith - 02","Other urban area",Scotland,53,,S01011011,,S02002066,"Dalkeith",,S00120687,S14000045,336,1,0,2024-03-01,"Eskbank",1.76189,EH,EH22,"Scotland","Scottish Water",9C7RVWVP+9F,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.74505,,"",,"",,1 EH22 1GJ,Yes,55.893665,-3.062572,333646,667236,NT336672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2023-09-01,,"","",,,"","","Dalkeith - 02","Other urban area",Scotland,54,,S01011011,,S02002066,"Dalkeith",,S00120687,S14000045,336,2,0,2024-03-01,"Eskbank",1.83545,EH,EH22,"Scotland","Scottish Water",9C7RVWVP+FX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.72114,,"",,"",,1 EH22 1GL,Yes,55.913107,-3.091613,331864,669428,NT318694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2022-05-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,54,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,2,0,2024-03-01,"Shawfair",1.10554,EH,EH22,"Scotland","Scottish Water",9C7RWW75+69,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120055767,120055797,120055798,120055825,120055826,120055846,120055871,120055872,120055895,120055923,120055941,120055942,120056017,120056116,120056117,120056121,120056125,120056136,120056167,120056191,120056240,120056241,120056378,120056415,120056495,120056496,120056551,120056552,120056553,120056648,120056674,120056690,120056698,120056713,120056714,120056727,120056731",3.93322,,"",,"",,6 EH22 1GN,Yes,55.927433,-3.087166,332167,671018,NT321710,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2023-09-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,54,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,2,0,2024-03-01,"Newcraighall",0.672629,EH,EH22,"Scotland","Scottish Water",9C7RWWG7+X4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",2.41281,,"",,"",,6 EH22 1HA,Yes,55.892752,-3.071534,333084,667144,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",28,21,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121041,S14000045,404,1,0,2024-03-01,"Eskbank",1.41303,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+49,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021065,120021508,120021509,120021510,120021511,120021512,120021638,120021639,120021728,120021729,120030855,120030856,120030857,120030858,120030859,120030860,120030861,120030862,120030863,120030864,120030865,120030866,120030867,120030868,120030869,120030870,120033142,120033755,120033756,120033757,120033758,120033759,120033760,120034763,120034764,120034765,120035031,120043099,120043593,120044426,120044428,120048647,120049195,120049198,120051435,120053287",5.83646,,"",,"",,1 EH22 1HB,Yes,55.893057,-3.071638,333078,667178,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",0,0,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121041,S14000045,404,1,0,2024-03-01,"Eskbank",1.43908,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+68,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021061,120021513,120021514,120021799,120032394,120034136,120035030,120041769,120042088",5.80314,,"",,"",,1 EH22 1HD,Yes,55.892750,-3.072265,333038,667144,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",6,2,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,0,2024-03-01,"Eskbank",1.3902,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+43,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021515,120021516,120021517,120021518,120021679,120021782,120021802,120021810,120021839,120036581",5.84017,,"",,"",,8 EH22 1HE,No,55.892713,-3.072392,333030,667140,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1973-08-01,1992-07-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,8,1,2024-03-01,"Eskbank",1.38278,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+32,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.84491,,"",,"",,8 EH22 1HF,Yes,55.892920,-3.072833,333003,667163,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",5,0,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,0,2024-03-01,"Eskbank",1.39016,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021059,120045432,10025429577",5.8243,,"",,"",,8 EH22 1HG,Yes,55.892462,-3.072885,332999,667113,NT329671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",1,1,"","","Eskbank - 06","Other urban area",Scotland,61,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,0,2024-03-01,"Eskbank",1.34361,EH,EH22,"Scotland","Scottish Water",9C7RVWRG+XR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018507,120018659,120042620",5.87528,,"",,"",,8 EH22 1HH,No,55.892822,-3.073242,332977,667153,NT329671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,2013-08-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.36889,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+4P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.83741,,"",,"",,8 EH22 1HJ,Yes,55.892103,-3.073254,332975,667073,NT329670,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",7,2,"","","Eskbank - 06","Other urban area",Scotland,61,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,0,2024-03-01,"Eskbank",1.29759,EH,EH22,"Scotland","Scottish Water",9C7RVWRG+RM,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018508,120018509,120018651,120018654,120018661,120021717,120030497,120030499,120030899,120032923,120037998,120042619,120051432",5.91704,,"",,"",,8 EH22 1HL,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2008-08-01,2015-06-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8 EH22 1HQ,Yes,55.892774,-3.073609,332954,667148,NT329671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",0,0,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,0,2024-03-01,"Eskbank",1.35401,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+4H,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018505,120018510,120018511,120018512,120018513,120018514,120018656,120033709,120046642,120047234,120048423,120048568",5.84484,,"",,"",,8 EH22 1HR,Yes,55.893428,-3.071788,333069,667219,NT330672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",7,5,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00120673,S14000045,404,1,0,2024-03-01,"Eskbank",1.47055,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+97,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021519,120021744,120021745,120021746,120021747,120021748,120021749,120021750,120021850,120031917,120032393,120033095,120033710,120034131,120034132,120034133,120034134,120034135,120035589,120038135,120038136,120038137,120038138,120038514,120045475",5.76273,,"",,"",,1 EH22 1HS,No,55.893624,-3.070898,333125,667240,NT331672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1973-08-01,1992-07-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00121041,S14000045,404,8,1,2024-03-01,"Eskbank",1.51668,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+CJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.73703,,"",,"",,1 EH22 1HU,Yes,55.893759,-3.070378,333158,667254,NT331672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",32,18,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00120673,S14000045,404,1,0,2024-03-01,"Eskbank",1.54602,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+GR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021068,120021520,120021521,120021522,120021523,120021524,120021525,120021526,120021527,120021528,120021529,120021530,120021531,120021532,120021533,120021534,120021535,120021536,120021537,120021538,120021539,120021540,120021541,120021542,120021543,120021544,120021545,120021546,120021547,120021800,120021807,120021808,120021809,120021812,120021840,120021842,120021845,120031913,120032334,120033137,120033197,120037116,120042090,120042301,120042651,120048176,120048179,120048180,120053284,120053797,120053798,10025429568,10025429580",5.71998,,"",,"",,1 EH22 1HW,Yes,55.895454,-3.077521,332714,667450,NT327674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2012-09-01,,"","",,,"","","Eskbank - 06","Other urban area",Scotland,46,,S01010999,,S02002063,"Eskbank",,S00120675,S14000045,4984,1,0,2024-03-01,"Eskbank",1.55557,EH,EH22,"Scotland","Scottish Water",9C7RVWWC+5X,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018541,120033284,120046082,120046520,120047394,120048828,120048842,120049025,120049082,120049403,120049404,120049407,120049602,120049775,120049847,120049916,120049917,120049918,120049919",5.57801,,"",,"",,8 EH22 1HX,No,55.893900,-3.070186,333170,667270,NT331672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1992-02-01,1995-12-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00120673,S14000045,404,8,1,2024-03-01,"Eskbank",1.5656,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+HW,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.70362,,"",,"",,1 EH22 1HY,No,55.894053,-3.070142,333173,667287,NT331672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,2007-03-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00120673,S14000045,404,1,1,2024-03-01,"Eskbank",1.58161,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+JW,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.68648,,"",,"",,1 EH22 1HZ,Yes,55.894272,-3.069257,333229,667310,NT332673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",19,12,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00120680,S14000045,404,1,0,2024-03-01,"Eskbank",1.63103,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+P7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021058,120021063,120021548,120021714,120021751,120021752,120021753,120021754,120021755,120021756,120021833,120021849,120030896,120034137,120034138,120034147,120034148,120034149,120034150,120034336,120034337,120034338,120034339,120034393,120044826,120045334,120047233,120047393,120051693",5.65917,,"",,"",,1 EH22 1JA,Yes,55.894492,-3.070330,333162,667336,NT331673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",20,12,"","","Dalkeith - 01","Other urban area",Scotland,57,,S01011010,,S02002066,"Dalkeith",,S00120680,S14000045,404,1,0,2024-03-01,"Eskbank",1.61799,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+QV,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018652,120021549,120021550,120021757,120021758,120021759,120021760,120021761,120021762,120021763,120021764,120021765,120021781,120021817,120021818,120021823,120021824,120021838,120032769,120033764,120034060,120034061,120034062,120034063,120034064,120034065,120035473,120035474,120038351,120038352,120038513,120038515,120038528,120042073,120042853,120043333,120044401,120044402,120045043,120045124,120045415,120048126,120048677,120051611,120053286,10025429581",5.6385,,"",,"",,1 EH22 1JB,Yes,55.893669,-3.071986,333057,667246,NT330672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",29,20,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00120673,S14000045,404,1,0,2024-03-01,"Eskbank",1.48835,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+F6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021067,120021551,120021552,120021553,120021554,120021555,120021766,120021767,120021768,120021769,120021770,120021771,120021772,120021773,120021819,120021820,120021841,120021848,120030829,120030901,120032855,120034046,120034047,120034048,120034049,120034050,120034051,120034052,120034053,120034054,120034055,120034056,120034057,120034058,120034059,120034386,120034387,120034427,120034443,120035066,120035392,120035393,120035394,120037507,120037508,120037947,120038755,120039432,120039433,120043957,120044987,120045154,120045156,10092046788",5.73699,,"",,"",,1 EH22 1JD,Yes,55.893614,-3.073088,332988,667241,NT329672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,5,"","","Eskbank - 06","Other urban area",Scotland,58,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,0,2024-03-01,"Eskbank",1.45221,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+CQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018626,120018655,120018660,120032256,120032273,120033090,120033804,120037946,120042705,120044060,120044061,120044580,120045419,120045420,10025286137,10025429578",5.74889,,"",,"",,8 EH22 1JE,Yes,55.894165,-3.071792,333070,667301,NT330673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,4,"","","Eskbank - 06","Other urban area",Scotland,57,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,0,2024-03-01,"Eskbank",1.54285,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+M7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021556,120021557,120021774,120021775,120021776,120021777,120030907,120033196,120033703,120033761,120034097,120038309,120044579,120046095,10015478693",5.6811,,"",,"",,8 EH22 1JF,Yes,55.898739,-3.073741,332956,667812,NT329678,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2006-04-01,,"","",90,27,"","","Shawfair - 01","Other urban area",Scotland,57,,S01011000,,S02002064,"Shawfair",,S00120390,S14000045,3900,1,0,2024-03-01,"Eskbank",1.96944,EH,EH22,"Scotland","Scottish Water",9C7RVWXG+FG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032275,120038044,120038210,120038211,120038212,120038231,120038234,120038236,120038265,120038288,120038346,120038433,120038434,120038476,120038477,120038478,120038637,120038638,120038668,120038685,120038768,120038769,120038887,120038923,120039028,120039106,120039107,120039237,120052732,120053471",5.18625,,"",,"",,6 EH22 1JG,Yes,55.895237,-3.072493,333028,667421,NT330674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",45,15,"","","Eskbank - 06","Other urban area",Scotland,47,,S01010999,,S02002063,"Eskbank",,S00120676,S14000045,4984,1,0,2024-03-01,"Eskbank",1.63164,EH,EH22,"Scotland","Scottish Water",9C7RVWWH+32,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018515,120018516,120021558,120021559,120021560,120021561,120021562,120021563,120021564,120021565,120021566,120021567,120021568,120021569,120021570,120021571",5.56597,,"",,"",,8 EH22 1JH,Yes,55.895153,-3.073375,332973,667413,NT329674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",2,2,"","","Eskbank - 06","Other urban area",Scotland,47,,S01010999,,S02002063,"Eskbank",,S00120676,S14000045,4984,1,0,2024-03-01,"Eskbank",1.60156,EH,EH22,"Scotland","Scottish Water",9C7RVWWG+3M,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032258,120032259,120034102",5.5803,,"",,"",,8 EH22 1JJ,Yes,55.895210,-3.074603,332896,667420,NT328674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",26,22,"","","Eskbank - 06","Other urban area",Scotland,45,,S01010999,,S02002063,"Eskbank",,S00120676,S14000045,4984,1,0,2024-03-01,"Eskbank",1.58025,EH,EH22,"Scotland","Scottish Water",9C7RVWWG+35,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018517,120018518,120018519,120018520,120018521,120018522,120018523,120018524,120018525,120018526,120018527,120018528,120018529,120018530,120018531,120018532,120018533,120018534,120018535,120018536,120018537,120018538,120018539,120049797",5.58191,,"",,"",,8 EH22 1JL,Yes,55.895553,-3.073913,332940,667458,NT329674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",3,2,"","","Eskbank - 06","Other urban area",Scotland,44,,S01010999,,S02002063,"Eskbank",,S00120676,S14000045,4984,1,0,2024-03-01,"Eskbank",1.63077,EH,EH22,"Scotland","Scottish Water",9C7RVWWG+6C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032257,120032931,120033114,120033569,120034103,120034345,120034877,120034878,120042085",5.53942,,"",,"",,8 EH22 1JN,Yes,55.896245,-3.074312,332916,667535,NT329675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",21,11,"","","Eskbank - 06","Other urban area",Scotland,42,,S01010999,,S02002063,"Eskbank",,S00120676,S14000045,4984,1,0,2024-03-01,"Eskbank",1.69484,EH,EH22,"Scotland","Scottish Water",9C7RVWWG+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018540,120032261,120032262,120032263,120032264,120032265,120032266,120032267,120032268,120032269,120032270,120033295,120034323,120034324,120034325,120034326,120034327,120034328,120034329,120034330,120034331,120034332,120035083,120053433,120056834",5.4656,,"",,"",,8 EH22 1JP,Yes,55.894120,-3.077979,332683,667302,NT326673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",27,11,"","","Eskbank - 06","Other urban area",Scotland,46,,S01010999,,S02002063,"Eskbank",,S00120675,S14000045,4984,1,0,2024-03-01,"Eskbank",1.40471,EH,EH22,"Scotland","Scottish Water",9C7RVWVC+JR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018542,120018543,120018544,120018545,120018546,120018547,120018548,120018549,120018550,120018551,120018552,120018650,120018653,120018657,120031633,120033073,120034086,120034087,120035085,120037060,120046717,120046982,120046992,120047260,120047756,120054332,10092038942",5.7288,,"",,"",,8 EH22 1JQ,Yes,55.894398,-3.074933,332874,667330,NT328673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",126,46,"","","Eskbank - 06","Other urban area",Scotland,52,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,0,2024-03-01,"Eskbank",1.48837,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+Q2,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018553,120018554,120018555,120018556,120018557,120018558,120018559,120018560,120018561,120018562,120018563,120018564,120018565,120018566,120018567,120018568,120018569,120018570,120018571,120018572,120018573,120018574,120018575,120018576,120018577,120018578,120018579,120018580,120018581,120018582,120018583,120018584,120018585,120018586,120018587,120018588,120018589,120018590,120018591,120018592,120018593,120018594,120018595,120018596,120018597,120034092,120034093,120034094,120034095,120034096,120034902,120034903,120042171,120042520",5.67386,,"",,"",,8 EH22 1JR,Yes,55.896284,-3.073018,332997,667538,NT329675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",0,0,"","","Eskbank - 06","Other urban area",Scotland,41,,S01010999,,S02002063,"Eskbank",,S00120676,S14000045,4984,1,0,2024-03-01,"Eskbank",1.72655,EH,EH22,"Scotland","Scottish Water",9C7RVWWG+GQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018658,120030500,120032391,120033465",5.45307,,"",,"",,8 EH22 1JS,Yes,55.895604,-3.072615,333021,667462,NT330674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1991-11-01,,"","",23,15,"","","Eskbank - 06","Other urban area",Scotland,43,,S01010999,,S02002063,"Eskbank",,S00120676,S14000045,4984,1,0,2024-03-01,"Eskbank",1.66603,EH,EH22,"Scotland","Scottish Water",9C7RVWWG+6X,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021664,120021665,120021666,120021667,120021668,120021669,120021670,120021671,120021672,120021673,120021674,120021675,120021676,120021677,120021678,120037053,120041746",5.52601,,"",,"",,8 EH22 1JT,Yes,55.896998,-3.073581,332963,667618,NT329676,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",10,5,"","","Shawfair - 01","Other urban area",Scotland,45,,S01011000,,S02002064,"Shawfair",,S00120390,S14000045,3900,1,0,2024-03-01,"Eskbank",1.7888,EH,EH22,"Scotland","Scottish Water",9C7RVWWG+QH,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018627,120018628,120018629,120018630,120018631,120032255,120033146",5.37758,,"",,"",,6 EH22 1JU,No,55.897233,-3.074371,332914,667645,NT329676,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,2013-11-01,"","",0,0,"","","Shawfair - 01","Other urban area",Scotland,50,,S01011000,,S02002064,"Shawfair",,S00120390,S14000045,3900,1,0,2024-03-01,"Eskbank",1.79801,EH,EH22,"Scotland","Scottish Water",9C7RVWWG+V7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.3569,,"",,"",,6 EH22 1JW,Yes,55.895668,-3.074600,332897,667471,NT328674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",43,28,"","","Eskbank - 06","Other urban area",Scotland,41,,S01010999,,S02002063,"Eskbank",,S00120675,S14000045,4984,1,0,2024-03-01,"Eskbank",1.62837,EH,EH22,"Scotland","Scottish Water",9C7RVWWG+75,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018598,120018599,120018600,120018601,120018602,120018603,120018604,120018605,120018606,120018607,120018608,120018632,120018633,120018634,120018635,120018636,120018637,120018638,120018639,120018640,120018641,120018642,120018643,120018644,120018645,120018646,120018647,120018648,120018649,120035084,120042100,120042106,120042296,120046676,120046677,120054232",5.53131,,"",,"",,8 EH22 1JX,Yes,55.897294,-3.077240,332735,667655,NT327676,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",35,16,"","","Shawfair - 01","Other urban area",Scotland,61,,S01011000,,S02002064,"Shawfair",,S00120390,S14000045,3900,1,0,2024-03-01,"Eskbank",1.75903,EH,EH22,"Scotland","Scottish Water",9C7RVWWF+W4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018504,120018609,120018610,120018611,120018612,120018613,120018614,120018615,120018616,120018617,120018618,120018619,120018620,120018621,120018622,120018623,120018624,120018625,120030498,120032271,120032272,120034422,120036126,120038146,120039201,120041745,120041768,120042427,120042727,120047241,120049217,120049953,120050288,120050439",5.37316,,"",,"",,6 EH22 1JY,Yes,55.895884,-3.071972,333062,667493,NT330674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",2,1,"","","Eskbank - 06","Other urban area",Scotland,44,,S01010999,,S02002063,"Eskbank",,S00120676,S14000045,4984,1,0,2024-03-01,"Eskbank",1.71052,EH,EH22,"Scotland","Scottish Water",9C7RVWWH+96,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021572,120021573,120032274,120036041,120037034,120042199,120042591,120047114,120047120,120049043,120049860,10025429010",5.49159,,"",,"",,8 EH22 1JZ,Yes,55.894911,-3.069638,333206,667382,NT332673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",7,6,"","","Dalkeith - 01","Other urban area",Scotland,57,,S01011010,,S02002066,"Dalkeith",,S00120680,S14000045,404,1,0,2024-03-01,"Eskbank",1.67979,EH,EH22,"Scotland","Scottish Water",9C7RVWVJ+X4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021778,120021779,120021780,120030830,120030831,120030832,120030833,120030834,120030835,120033099,120033203,120035045,120038743,120045892,120045893",5.58951,,"",,"",,1 EH22 1LA,Yes,55.894791,-3.070098,333177,667369,NT331673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",12,4,"","","Dalkeith - 01","Other urban area",Scotland,57,,S01011010,,S02002066,"Dalkeith",,S00120680,S14000045,404,1,0,2024-03-01,"Eskbank",1.65404,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+WX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021574,120021575,120021791,120030566,120030567,120030568,120030906,120032387,120049781,120049782,120049783,120049784,120049785,120049786",5.60446,,"",,"",,1 EH22 1LB,Yes,55.893165,-3.070981,333119,667189,NT331671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",30,21,"","","Dalkeith - 01","Other urban area",Scotland,60,,S01011010,,S02002066,"Dalkeith",,S00121041,S14000045,404,1,0,2024-03-01,"Eskbank",1.47008,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+7J,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021576,120021577,120021578,120021579,120021580,120021581,120021582,120021583,120021584,120021585,120021586,120021587,120021588,120021805,120021825,120021826,120021827,120021828,120021829,120021830,120021831,120021832,120037401,120037710,120038530,120042091,120042345,120048275,10024915708",5.78827,,"",,"",,1 EH22 1LD,No,55.893751,-3.071893,333063,667255,NT330672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,2022-07-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,58,,S01011010,,S02002066,"Dalkeith",,S00120673,S14000045,404,1,1,2024-03-01,"Eskbank",1.49911,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+G6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.72745,,"",,"",,1 EH22 1LE,No,55.894885,-3.076801,332758,667386,NT327673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,2014-05-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,43,,S01010999,,S02002063,"Eskbank",,S00120675,S14000045,4984,1,1,2024-03-01,"Eskbank",1.50501,EH,EH22,"Scotland","Scottish Water",9C7RVWVF+X7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.63444,,"",,"",,8 EH22 1LF,No,55.893347,-3.071770,333070,667210,NT330672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,1996-12-01,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,59,,S01011010,,S02002066,"Dalkeith",,S00120673,S14000045,404,8,1,2024-03-01,"Eskbank",1.46319,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+87,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.77162,,"",,"",,1 EH22 1LG,Yes,55.919572,-3.103267,331147,670160,NT311701,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2000-12-01,,"","",17,8,"","","Shawfair - 01","Accessible rural area",Scotland,66,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,1,0,2024-03-01,"Shawfair",1.52948,EH,EH22,"Scotland","Scottish Water",9C7RWV9W+RM,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120017529,120017530,120017531,120017532,120017533,120017534,120017535,120017536,120017537,120017538,120017539,120017540,120042263,120052189,120055589",3.71845,,"",,"",,6 EH22 1LH,Yes,55.894633,-3.076810,332757,667358,NT327673,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2013-03-01,,"","",,,"","","Eskbank - 06","Other urban area",Scotland,44,,S01010999,,S02002063,"Eskbank",,S00120675,S14000045,4984,1,0,2024-03-01,"Eskbank",1.47784,EH,EH22,"Scotland","Scottish Water",9C7RVWVF+V7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018506,120035087,120044847,120046998,120047052,120047072,120047107,120047227,120047328,120047352,120047543,120047597,120047650,120047675,120047757,120047769,120047770,120048037,10025286136",5.66226,,"",,"",,8 EH22 1LJ,Yes,55.895709,-3.075581,332836,667477,NT328674,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2017-03-01,,"","",,,"","","Eskbank - 06","Other urban area",Scotland,41,,S01010999,,S02002063,"Eskbank",,S00120676,S14000045,4984,1,0,2024-03-01,"Eskbank",1.61394,EH,EH22,"Scotland","Scottish Water",9C7RVWWF+7Q,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032260,120035086,120049168,120051412,120051413,120051414,120051415,120051856,120055315",5.53391,,"",,"",,8 EH22 1LP,Yes,55.913376,-3.113745,330481,669480,NT304694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",25,12,"","","Shawfair - 04","Accessible rural area",Scotland,90,,S01011003,,S02002064,"Shawfair",,S00121077,S14000045,2930,1,0,2024-03-01,"Shawfair",2.30031,EH,EH22,"Scotland","Scottish Water",9C7RWV7P+9G,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014607,120014608,120014609,120014610,120014611,120014612,120014613,120014614,120014615,120014616,120014617,120014618",4.66576,,"",,"",,5 EH22 1LQ,Yes,55.894043,-3.071389,333095,667287,NT330672,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",,,"","","Dalkeith - 01","Other urban area",Scotland,57,,S01011010,,S02002066,"Dalkeith",,S00120673,S14000045,404,1,1,2024-03-01,"Eskbank",1.54249,EH,EH22,"Scotland","Scottish Water",9C7RVWVH+JC,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120021070,120042581",5.69273,,"",,"",,1 EH22 1LR,Yes,55.912447,-3.112135,330580,669375,NT305693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",30,14,"","","Shawfair - 04","Accessible rural area",Scotland,84,,S01011003,,S02002064,"Shawfair",,S00121077,S14000045,2930,1,0,2024-03-01,"Shawfair",2.24175,EH,EH22,"Scotland","Scottish Water",9C7RWV6Q+X4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014619,120014620,120014621,120014622,120014623,120014624,120014625,120014626,120014627,120014628,120014629,120014630,120014631,120014632",4.68051,,"",,"",,5 EH22 1LS,Yes,55.911667,-3.110945,330653,669287,NT306692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",8,4,"","","Shawfair - 04","Accessible rural area",Scotland,80,,S01011003,,S02002064,"Shawfair",,S00120895,S14000045,2930,1,0,2024-03-01,"Shawfair",2.20781,EH,EH22,"Scotland","Scottish Water",9C7RWV6Q+MJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014633,120014634,120014635,120014636",4.70241,,"",,"",,5 EH22 1LT,Yes,55.911108,-3.110241,330696,669225,NT306692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",1,1,"","","Shawfair - 02","Accessible rural area",Scotland,78,,S01011001,,S02002064,"Shawfair",,S00120894,S14000045,2721,1,0,2024-03-01,"Shawfair",2.19511,EH,EH22,"Scotland","Scottish Water",9C7RWV6Q+CW,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120030419,120030420,120042838,10025284133",4.7253,,"",,"",,4 EH22 1LU,Yes,55.911909,-3.108088,330832,669312,NT308693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",77,28,"","","Shawfair - 03","Accessible rural area",Scotland,76,,S01011002,,S02002064,"Shawfair",,S00120896,S14000045,2386,1,0,2024-03-01,"Shawfair",2.03547,EH,EH22,"Scotland","Scottish Water",9C7RWV6R+QQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014637,120014638,120014639,120014640,120014641,120014642,120014643,120014644,120014645,120014646,120014647,120014648,120014649,120014650,120014651,120014652,120014653,120014654,120014655,120014656,120014657,120014658,120014659,120014660,120014661,120014662,120014663,120014664,120014665,120041821,120042140",4.57399,,"",,"",,4 EH22 1LW,No,55.912910,-3.105170,331016,669420,NT310694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1993-02-01,2000-06-01,"","",,,"","","Shawfair - 03","Accessible rural area",Scotland,70,,S01011002,,S02002064,"Shawfair",,S00120905,S14000045,2386,1,0,2024-03-01,"Shawfair",1.82347,EH,EH22,"Scotland","Scottish Water",9C7RWV7V+5W,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",4.37772,,"",,"",,4 EH22 1LX,Yes,55.912761,-3.106782,330915,669405,NT309694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",23,9,"","","Shawfair - 03","Accessible rural area",Scotland,73,,S01011002,,S02002064,"Shawfair",,S00120905,S14000045,2386,1,0,2024-03-01,"Shawfair",1.92147,EH,EH22,"Scotland","Scottish Water",9C7RWV7V+47,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014666,120014667,120014668,120014669,120014670,120014671,120014672,120014673,120014674,120014675,120014676,120014677,120014678,120014679,120015186,120017528,120032167,120054912,120055429,120055592,10015394055",4.44957,,"",,"",,4 EH22 1LY,Yes,55.911899,-3.109112,330768,669311,NT307693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",48,26,"","","Shawfair - 03","Accessible rural area",Scotland,79,,S01011002,,S02002064,"Shawfair",,S00120896,S14000045,2386,1,0,2024-03-01,"Shawfair",2.09343,EH,EH22,"Scotland","Scottish Water",9C7RWV6R+Q9,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014680,120014681,120014682,120014683,120014684,120014685,120014686,120014687,120014688,120014689,120014690,120014691,120014692,120014693,120014694,120014695,120014696,120014697,120014698,120014699,120014700,120014701,120014702,120014703,120014704,120015031,120030430,120037963,10024914865,10025428848",4.61279,,"",,"",,4 EH22 1LZ,Yes,55.912529,-3.110058,330710,669383,NT307693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",80,35,"","","Shawfair - 04","Accessible rural area",Scotland,80,,S01011003,,S02002064,"Shawfair",,S00120895,S14000045,2930,1,0,2024-03-01,"Shawfair",2.11865,EH,EH22,"Scotland","Scottish Water",9C7RWV7Q+2X,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014128,120014129,120014130,120014131,120014132,120014133,120014134,120014135,120014136,120014137,120014138,120014139,120014140,120014141,120014142,120014143,120014144,120014145,120014146,120014147,120014148,120014149,120014150,120014151,120014152,120014153,120014154,120014155,120014156,120014157,120014158,120014159,120014160,120014161,120014162,120014163",4.59287,,"",,"",,5 EH22 1NA,Yes,55.912827,-3.107842,330849,669413,NT308694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",23,8,"","","Shawfair - 03","Accessible rural area",Scotland,76,,S01011002,,S02002064,"Shawfair",,S00120905,S14000045,2386,1,0,2024-03-01,"Shawfair",1.97877,EH,EH22,"Scotland","Scottish Water",9C7RWV7R+4V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014164,120014165,120014166,120014167,120014168,120014169,120014170,120014171,120041975",4.48284,,"",,"",,4 EH22 1NB,Yes,55.913539,-3.108647,330800,669494,NT307694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",51,24,"","","Shawfair - 03","Accessible rural area",Scotland,78,,S01011002,,S02002064,"Shawfair",,S00120897,S14000045,2386,1,0,2024-03-01,"Shawfair",1.99524,EH,EH22,"Scotland","Scottish Water",9C7RWV7R+CG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014172,120014173,120014174,120014175,120014176,120014177,120014178,120014179,120014180,120014181,120014182,120014183,120014184,120014185,120014186,120014187,120014188,120014189,120014190,120014191,120014192,120014193,120014194,120014195,120041640",4.45033,,"",,"",,4 EH22 1ND,Yes,55.914110,-3.110087,330711,669558,NT307695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",20,8,"","","Shawfair - 03","Accessible rural area",Scotland,81,,S01011002,,S02002064,"Shawfair",,S00120897,S14000045,2386,1,0,2024-03-01,"Shawfair",2.0584,EH,EH22,"Scotland","Scottish Water",9C7RWV7Q+JX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014196,120014197,120014198,120014199,120014200,120014201,120014202,120014203",4.45669,,"",,"",,4 EH22 1NE,Yes,55.914194,-3.108745,330795,669566,NT307695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",30,15,"","","Shawfair - 03","Accessible rural area",Scotland,80,,S01011002,,S02002064,"Shawfair",,S00120897,S14000045,2386,1,0,2024-03-01,"Shawfair",1.97622,EH,EH22,"Scotland","Scottish Water",9C7RWV7R+MG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014705,120014706,120014707,120014708,120014709,120014710,120014711,120014712,120014713,120014714,120014715,120014716,120014717,120014718,120014719,120014720,120042949",4.39692,,"",,"",,4 EH22 1NF,Yes,55.913545,-3.110007,330715,669496,NT307694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",39,12,"","","Shawfair - 04","Accessible rural area",Scotland,81,,S01011003,,S02002064,"Shawfair",,S00120898,S14000045,2930,1,0,2024-03-01,"Shawfair",2.07435,EH,EH22,"Scotland","Scottish Water",9C7RWV7Q+CX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014815,120014816,120014817,120014818,120014819,120014820,120014821,120014822,120014823,120014824,120014825,120014826,120014827,120014828,120041639",4.50233,,"",,"",,5 EH22 1NG,Yes,55.913112,-3.111130,330644,669448,NT306694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",133,43,"","","Shawfair - 04","Accessible rural area",Scotland,83,,S01011003,,S02002064,"Shawfair",,S00121078,S14000045,2930,1,0,2024-03-01,"Shawfair",2.15665,EH,EH22,"Scotland","Scottish Water",9C7RWV7Q+6G,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014829,120014830,120014831,120014832,120014833,120014834,120014835,120014836,120014837,120014838,120014839,120014840,120014841,120014842,120014843,120014844,120014845,120014846,120014847,120014848,120014849,120014850,120014851,120014852,120014853,120014854,120014855,120014856,120014857,120014858,120014859,120014860,120014861,120014862,120014863,120014864,120014865,120014866,120014867,120014868,120014869,120014870,120014871,120014872,120050601",4.58369,,"",,"",,5 EH22 1NH,Yes,55.915331,-3.112663,330552,669697,NT305696,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",23,10,"","","Shawfair - 05","Accessible rural area",Scotland,88,,S01011004,,S02002064,"Shawfair",,S00120900,S14000045,4898,1,0,2024-03-01,"Shawfair",2.1753,EH,EH22,"Scotland","Scottish Water",9C7RWV8P+4W,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014204,120014205,120014206,120014207,120014208,120014209,120014210,120014211,120014212,120014213,120042060",4.45826,,"",,"",,8 EH22 1NJ,Yes,55.915342,-3.111527,330623,669697,NT306696,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",19,7,"","","Shawfair - 04","Accessible rural area",Scotland,86,,S01011003,,S02002064,"Shawfair",,S00120901,S14000045,2930,1,0,2024-03-01,"Shawfair",2.10632,EH,EH22,"Scotland","Scottish Water",9C7RWV8Q+49,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014214,120014215,120014216,120014217,120014218,120014219,120014220,120046363,10025425946",4.41032,,"",,"",,5 EH22 1NL,Yes,55.914994,-3.110720,330673,669658,NT306696,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",10,4,"","","Shawfair - 04","Accessible rural area",Scotland,84,,S01011003,,S02002064,"Shawfair",,S00120898,S14000045,2930,1,0,2024-03-01,"Shawfair",2.06756,EH,EH22,"Scotland","Scottish Water",9C7RWV7Q+XP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014221,120014222,120014223,120014224,120042941,10025425947",4.40662,,"",,"",,5 EH22 1NN,Yes,55.914902,-3.108990,330781,669646,NT307696,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",35,14,"","","Shawfair - 03","Accessible rural area",Scotland,80,,S01011002,,S02002064,"Shawfair",,S00120903,S14000045,2386,1,0,2024-03-01,"Shawfair",1.96681,EH,EH22,"Scotland","Scottish Water",9C7RWV7R+XC,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014225,120014226,120014227,120014228,120014229,120014230,120014231,120014232,120014233,120014234,120014235,120014236,120014237,120014238",4.34532,,"",,"",,4 EH22 1NP,Yes,55.914168,-3.110584,330680,669565,NT306695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",29,12,"","","Shawfair - 04","Accessible rural area",Scotland,82,,S01011003,,S02002064,"Shawfair",,S00120898,S14000045,2930,1,0,2024-03-01,"Shawfair",2.0858,EH,EH22,"Scotland","Scottish Water",9C7RWV7Q+MQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014721,120014722,120014723,120014724,120014725,120014726,120014727,120014728,120014729,120014730,120014731,120014732",4.47139,,"",,"",,5 EH22 1NQ,Yes,55.914298,-3.113148,330520,669582,NT305695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",124,58,"","","Shawfair - 04","Accessible rural area",Scotland,90,,S01011003,,S02002064,"Shawfair",,S00120899,S14000045,2930,1,0,2024-03-01,"Shawfair",2.23416,EH,EH22,"Scotland","Scottish Water",9C7RWV7P+PP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014873,120014874,120014875,120014876,120014877,120014878,120014879,120014880,120014881,120014882,120014883,120014884,120014885,120014886,120014887,120014888,120014889,120014890,120014891,120014892,120014893,120014894,120014895,120014896,120014897,120014898,120014899,120014900,120014901,120014902,120014903,120014904,120014905,120014906,120014907,120014908,120014909,120014910,120014911,120014912,120014913,120014914,120014915,120014916,120014917,120014918,120014919,120014920,120014921,120014922,120014923,120014924,120014925,120014926,120014927,120014928,120014929,120014930",4.5641,,"",,"",,5 EH22 1NR,Yes,55.914658,-3.111094,330649,669620,NT306696,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",32,14,"","","Shawfair - 04","Accessible rural area",Scotland,84,,S01011003,,S02002064,"Shawfair",,S00120898,S14000045,2930,1,0,2024-03-01,"Shawfair",2.10016,EH,EH22,"Scotland","Scottish Water",9C7RWV7Q+VH,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014733,120014734,120014735,120014736,120014737,120014738,120014739,120014740,120014741,120014742,120014743,120014744,120014745,120014746,120014747,120014748,120041998",4.45014,,"",,"",,5 EH22 1NS,Yes,55.914447,-3.112624,330553,669599,NT305695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",61,27,"","","Shawfair - 04","Accessible rural area",Scotland,88,,S01011003,,S02002064,"Shawfair",,S00120901,S14000045,2930,1,0,2024-03-01,"Shawfair",2.1982,EH,EH22,"Scotland","Scottish Water",9C7RWV7P+QX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014931,120014932,120014933,120014934,120014935,120014936,120014937,120014938,120014939,120014940,120014941,120014942,120014943,120014944,120014945,120014946,120014947,120014948,120014949,120014950,120014951,120014952,120014953,120014954,120014955,120014956,120014957,120014958",4.53014,,"",,"",,5 EH22 1NT,Yes,55.913480,-3.111189,330641,669489,NT306694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",40,13,"","","Shawfair - 04","Accessible rural area",Scotland,84,,S01011003,,S02002064,"Shawfair",,S00120898,S14000045,2930,1,0,2024-03-01,"Shawfair",2.14606,EH,EH22,"Scotland","Scottish Water",9C7RWV7Q+9G,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014959,120014960,120014961,120014962,120014963,120014964,120014965,120014966,120014967,120014968,120014969,120014970,120014971,120014972",4.55434,,"",,"",,5 EH22 1NU,Yes,55.914181,-3.111670,330612,669568,NT306695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",18,8,"","","Shawfair - 04","Accessible rural area",Scotland,85,,S01011003,,S02002064,"Shawfair",,S00120898,S14000045,2930,1,0,2024-03-01,"Shawfair",2.14982,EH,EH22,"Scotland","Scottish Water",9C7RWV7Q+M8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014973,120014974,120014975,120014976,120014977,120014978,120014979,120014980,120052065",4.51376,,"",,"",,5 EH22 1NW,Yes,55.914740,-3.110438,330690,669629,NT306696,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",19,10,"","","Shawfair - 03","Accessible rural area",Scotland,83,,S01011002,,S02002064,"Shawfair",,S00120903,S14000045,2386,1,0,2024-03-01,"Shawfair",2.05839,EH,EH22,"Scotland","Scottish Water",9C7RWV7Q+VR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014749,120014750,120014751,120014752,120014753,120014754,120014755,120014756,120014757,120014758",4.41679,,"",,"",,4 EH22 1NX,Yes,55.913676,-3.112346,330569,669512,NT305695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",12,6,"","","Shawfair - 04","Accessible rural area",Scotland,85,,S01011003,,S02002064,"Shawfair",,S00120901,S14000045,2930,1,0,2024-03-01,"Shawfair",2.20711,EH,EH22,"Scotland","Scottish Water",9C7RWV7Q+F3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014981,120014982,120014983,120014984,120014985,120014986,120014987,120014988",4.58378,,"",,"",,5 EH22 1NY,Yes,55.913166,-3.113083,330522,669456,NT305694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",19,7,"","","Shawfair - 04","Accessible rural area",Scotland,87,,S01011003,,S02002064,"Shawfair",,S00121077,S14000045,2930,1,0,2024-03-01,"Shawfair",2.26889,EH,EH22,"Scotland","Scottish Water",9C7RWV7P+7Q,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014989,120014990,120014991,120014992,120014993,120014994,120014995,120014996",4.65669,,"",,"",,5 EH22 1NZ,No,55.912806,-3.107775,330853,669411,NT308694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1993-05-01,1997-06-01,"","",,,"","","Shawfair - 03","Accessible rural area",Scotland,76,,S01011002,,S02002064,"Shawfair",,S00120905,S14000045,2386,8,1,2024-03-01,"Shawfair",1.97588,EH,EH22,"Scotland","Scottish Water",9C7RWV7R+4V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",4.48222,,"",,"",,4 EH22 1PA,Yes,55.918999,-3.113011,330537,670106,NT305701,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2022-02-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,77,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,1,0,2024-03-01,"Newcraighall",2.09005,EH,EH22,"Scotland","Scottish Water",9C7RWV9P+HQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120055649,120055671,120055801,120056855,120056896,120056907,120057009,120057010,120057043,120057044",4.17986,,"",,"",,6 EH22 1PB,Yes,55.918231,-3.113485,330506,670021,NT305700,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2022-04-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,77,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,2,0,2024-03-01,"Shawfair",2.17353,EH,EH22,"Scotland","Scottish Water",9C7RWV9P+7J,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120055738,120055739,120055740,120055800,120056685,120056686,120056710,120056748,120056763,120056815",4.26059,,"",,"",,6 EH22 1PD,Yes,55.918999,-3.113011,330537,670106,NT305701,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2023-10-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,87,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,5,0,2024-03-01,"Newcraighall",2.09005,EH,EH22,"Scotland","Scottish Water",9C7RWV9P+HQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",4.17986,,"",,"",,6 EH22 1PE,No,55.911168,-3.109459,330745,669230,NT307692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2022-07-01,2023-01-01,"","",,,"","","Shawfair - 02","Accessible rural area",Scotland,76,,S01011001,,S02002064,"Shawfair",,S00120894,S14000045,2721,5,0,2024-03-01,"Shawfair",2.14863,EH,EH22,"Scotland","Scottish Water",9C7RWV6R+F6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",4.69089,,"",,"",,4 EH22 1PG,Yes,55.917771,-3.112591,330561,669968,NT305699,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2022-05-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,76,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,2,0,2024-03-01,"Shawfair",2.12329,EH,EH22,"Scotland","Scottish Water",9C7RWV9P+4X,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120055812,120055847,120055848,120055880,120056002,120056011,120056032,120056059,120056132,120056195,120056199,120056218,120056300,120056301,120056357,120056447,120056516,120056524,120056608,120056616,120056672,906305766,906305767",4.2575,,"",,"",,6 EH22 1PH,Yes,55.911168,-3.109459,330745,669230,NT307692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,4,"","","Shawfair - 02","Accessible rural area",Scotland,78,,S01011001,,S02002064,"Shawfair",,S00120894,S14000045,2721,1,0,2024-03-01,"Shawfair",2.14863,EH,EH22,"Scotland","Scottish Water",9C7RWV6R+F6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014239,120014240,120014241,120014242,120034089,120043659",4.69089,,"",,"",,4 EH22 1PJ,Yes,55.910433,-3.109358,330750,669149,NT307691,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",42,14,"","","Shawfair - 02","Accessible rural area",Scotland,77,,S01011001,,S02002064,"Shawfair",,S00120894,S14000045,2721,1,0,2024-03-01,"Shawfair",2.18141,EH,EH22,"Scotland","Scottish Water",9C7RWV6R+57,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014243,120014244,120014245,120014246,120014247,120014248,120014249,120014250,120014251,120014252,120014253,120014254,120015188,120032169,120033422,120034091,120034426,120042459,120051591,10025429000",4.7532,,"",,"",,4 EH22 1PL,Yes,55.909898,-3.107839,330844,669087,NT308690,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",4,1,"","","Shawfair - 02","Accessible rural area",Scotland,75,,S01011001,,S02002064,"Shawfair",,S00120891,S14000045,2721,1,0,2024-03-01,"Shawfair",2.12971,EH,EH22,"Scotland","Scottish Water",9C7RWV5R+XV,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014126,120032164,120032166,120032950,906464392,906464393,906464394,906464395",4.74747,,"",,"",,4 EH22 1PN,Yes,55.910296,-3.107514,330865,669131,NT308691,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",54,26,"","","Shawfair - 02","Accessible rural area",Scotland,75,,S01011001,,S02002064,"Shawfair",,S00120967,S14000045,2721,1,0,2024-03-01,"Shawfair",2.08947,EH,EH22,"Scotland","Scottish Water",9C7RWV6R+4X,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014255,120014256,120014257,120014258,120014259,120014260,120014261,120014262,120014263,120014264,120014265,120014266,120014267,120014268,120014269,120014270,120014271,120014272,120014273,120014274,120014275,120014276,120014277,120014278,120014279,120014280,120041822,120041824,120042313,120056198",4.69955,,"",,"",,4 EH22 1PP,Yes,55.910438,-3.105775,330974,669146,NT309691,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",51,20,"","","Shawfair - 02","Accessible rural area",Scotland,72,,S01011001,,S02002064,"Shawfair",,S00120967,S14000045,2721,1,0,2024-03-01,"Shawfair",1.98885,EH,EH22,"Scotland","Scottish Water",9C7RWV6V+5M,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014281,120014282,120014283,120014284,120014285,120014286,120014287,120014288,120014289,120014290,120014291,120014292,120014293,120014294,120017372,120017373,120017374,120017375,120017376,120017377",4.62587,,"",,"",,4 EH22 1PR,Yes,55.910930,-3.105498,330992,669200,NT309691,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",35,14,"","","Shawfair - 02","Accessible rural area",Scotland,71,,S01011001,,S02002064,"Shawfair",,S00120892,S14000045,2721,1,0,2024-03-01,"Shawfair",1.94555,EH,EH22,"Scotland","Scottish Water",9C7RWV6V+9R,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014295,120014296,120014297,120014298,120014299,120014300,120014301,120014302,120014303,120014304,120014305,120014306,120017378,120017379,120017380",4.5708,,"",,"",,4 EH22 1PS,Yes,55.910970,-3.105067,331019,669204,NT310692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",23,8,"","","Shawfair - 02","Accessible rural area",Scotland,70,,S01011001,,S02002064,"Shawfair",,S00120892,S14000045,2721,1,0,2024-03-01,"Shawfair",1.92028,EH,EH22,"Scotland","Scottish Water",9C7RWV6V+9X,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120017381,120017382,120017383,120017384,120017385,120017386,120017387,120017388",4.55224,,"",,"",,4 EH22 1PT,Yes,55.910959,-3.104299,331067,669202,NT310692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",25,10,"","","Shawfair - 02","Accessible rural area",Scotland,69,,S01011001,,S02002064,"Shawfair",,S00120892,S14000045,2721,1,0,2024-03-01,"Shawfair",1.88022,EH,EH22,"Scotland","Scottish Water",9C7RWV6W+97,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120017389,120017390,120017391,120017392,120017393,120017394,120017395,120017396,120017397,120017398",4.52706,,"",,"",,4 EH22 1PU,Yes,55.911346,-3.104729,331041,669246,NT310692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,5,"","","Shawfair - 02","Accessible rural area",Scotland,69,,S01011001,,S02002064,"Shawfair",,S00120893,S14000045,2721,1,0,2024-03-01,"Shawfair",1.88075,EH,EH22,"Scotland","Scottish Water",9C7RWV6W+G4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120017399,120017400,120017401,120017402,120017403",4.50578,,"",,"",,4 EH22 1PW,Yes,55.910644,-3.106788,330911,669169,NT309691,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",33,10,"","","Shawfair - 02","Accessible rural area",Scotland,73,,S01011001,,S02002064,"Shawfair",,S00120892,S14000045,2721,1,0,2024-03-01,"Shawfair",2.03084,EH,EH22,"Scotland","Scottish Water",9C7RWV6V+77,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014307,120014308,120014309,120014310,120014311,120014312,120014313,120014314,120014315,120014316",4.64209,,"",,"",,4 EH22 1PX,Yes,55.911501,-3.105405,330999,669263,NT309692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",67,27,"","","Shawfair - 02","Accessible rural area",Scotland,71,,S01011001,,S02002064,"Shawfair",,S00120893,S14000045,2721,1,0,2024-03-01,"Shawfair",1.90861,EH,EH22,"Scotland","Scottish Water",9C7RWV6V+JR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014317,120014318,120014319,120014320,120014321,120014322,120014323,120014324,120014325,120014326,120014327,120014328,120014329,120014330,120014331,120014332,120017404,120017405,120017406,120017407,120017408,120017409,120017410,120017411,120017412,120017413,120017414,120017415,120041825",4.51491,,"",,"",,4 EH22 1PY,Yes,55.910951,-3.106637,330921,669203,NT309692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",15,10,"","","Shawfair - 02","Accessible rural area",Scotland,73,,S01011001,,S02002064,"Shawfair",,S00120893,S14000045,2721,1,0,2024-03-01,"Shawfair",2.00553,EH,EH22,"Scotland","Scottish Water",9C7RWV6V+98,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014333,120014334,120014335,120014336,120014337,120014338,120014339,120014340,120014341,120014342,120041827",4.60863,,"",,"",,4 EH22 1PZ,Yes,55.911006,-3.107503,330867,669210,NT308692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",31,10,"","","Shawfair - 02","Accessible rural area",Scotland,75,,S01011001,,S02002064,"Shawfair",,S00120894,S14000045,2721,1,0,2024-03-01,"Shawfair",2.0495,EH,EH22,"Scotland","Scottish Water",9C7RWV6R+CX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014343,120014344,120014345,120014346,120014347,120014348,120014349,120014350,120014351,120014352",4.63436,,"",,"",,4 EH22 1QA,Yes,55.910662,-3.108820,330784,669173,NT307691,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",20,8,"","","Shawfair - 02","Accessible rural area",Scotland,77,,S01011001,,S02002064,"Shawfair",,S00120894,S14000045,2721,1,0,2024-03-01,"Shawfair",2.13978,EH,EH22,"Scotland","Scottish Water",9C7RWV6R+7F,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014759,120014760,120014761,120014762,120014763,120014764,120014765,120014766,120041820",4.71298,,"",,"",,4 EH22 1QB,Yes,55.911451,-3.108059,330833,669261,NT308692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",71,31,"","","Shawfair - 02","Accessible rural area",Scotland,76,,S01011001,,S02002064,"Shawfair",,S00120894,S14000045,2721,1,0,2024-03-01,"Shawfair",2.0567,EH,EH22,"Scotland","Scottish Water",9C7RWV6R+HQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014767,120014768,120014769,120014770,120014771,120014772,120014773,120014774,120014775,120014776,120014777,120014778,120014779,120014780,120014781,120014782,120014783,120014784,120014785,120014786,120014787,120014788,120014789,120014790,120014791,120014792,120014793,120014794,120014795,120014796,120014797,120014798,120036064,120044166",4.61413,,"",,"",,4 EH22 1QD,Yes,55.912050,-3.106348,330941,669325,NT309693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",55,25,"","","Shawfair - 02","Accessible rural area",Scotland,72,,S01011001,,S02002064,"Shawfair",,S00120893,S14000045,2721,1,0,2024-03-01,"Shawfair",1.9315,EH,EH22,"Scotland","Scottish Water",9C7RWV6V+RF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014799,120014800,120014801,120014802,120014803,120014804,120014805,120014806,120014807,120014808,120014809,120014810,120014811,120014812,120014813,120014814,120017449,120030421,120030422,120030423,120030424,120030425,120030426,120030427,120030468,120032618,120036551,120041823,10024915686",4.49809,,"",,"",,4 EH22 1QE,Yes,55.913355,-3.105679,330985,669470,NT309694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",0,0,"","","Shawfair - 03","Accessible rural area",Scotland,71,,S01011002,,S02002064,"Shawfair",,S00120970,S14000045,2386,1,0,2024-03-01,"Shawfair",1.83184,EH,EH22,"Scotland","Scottish Water",9C7RWV7V+8P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032168",4.35582,,"",,"",,4 EH22 1QF,Yes,55.914127,-3.106168,330956,669556,NT309695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",88,40,"","","Shawfair - 03","Accessible rural area",Scotland,73,,S01011002,,S02002064,"Shawfair",,S00120970,S14000045,2386,1,0,2024-03-01,"Shawfair",1.82772,EH,EH22,"Scotland","Scottish Water",9C7RWV7V+MG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014353,120014354,120014355,120014356,120014357,120014358,120014359,120014360,120014361,120014362,120014363,120014364,120014365,120014366,120014367,120014368,120014369,120014370,120014371,120014372,120014373,120014374,120014375,120014376,120014377,120014378,120014379,120014380,120014381,120014382,120014383,120014384,120014385,120014386,120014387,120014388,120017416,120017417,120017418,120017419,120041632",4.30472,,"",,"",,4 EH22 1QG,Yes,55.913306,-3.106624,330926,669466,NT309694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",34,13,"","","Shawfair - 03","Accessible rural area",Scotland,73,,S01011002,,S02002064,"Shawfair",,S00120905,S14000045,2386,1,0,2024-03-01,"Shawfair",1.88805,EH,EH22,"Scotland","Scottish Water",9C7RWV7V+89,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014389,120014390,120014391,120014392,120014393,120014394,120014395,120014396,120014397,120014398,120014399,120014400,120014401,120034041,120042897",4.3949,,"",,"",,4 EH22 1QH,Yes,55.914460,-3.107185,330893,669595,NT308695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",84,35,"","","Shawfair - 03","Accessible rural area",Scotland,76,,S01011002,,S02002064,"Shawfair",,S00120902,S14000045,2386,1,0,2024-03-01,"Shawfair",1.87473,EH,EH22,"Scotland","Scottish Water",9C7RWV7V+Q4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014402,120014403,120014404,120014405,120014406,120014407,120014408,120014409,120014410,120014411,120014412,120014413,120014414,120014415,120014416,120014417,120014418,120014419,120014420,120014421,120014422,120014423,120014424,120014425,120014426,120014427,120014428,120014429,120014430,120014431,120014432,120014433,120014434,120014435,120014436,120014437,120042062,120043155",4.31366,,"",,"",,4 EH22 1QJ,Yes,55.915279,-3.108008,330843,669687,NT308696,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",18,8,"","","Shawfair - 03","Accessible rural area",Scotland,78,,S01011002,,S02002064,"Shawfair",,S00120902,S14000045,2386,1,0,2024-03-01,"Shawfair",1.89639,EH,EH22,"Scotland","Scottish Water",9C7RWV8R+4Q,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014438,120014439,120014440,120014441,120014442,120014443,120014444,120014445",4.2742,,"",,"",,4 EH22 1QL,Yes,55.915774,-3.110372,330696,669744,NT306697,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",0,0,"","","Shawfair - 03","Accessible rural area",Scotland,83,,S01011002,,S02002064,"Shawfair",,S00120903,S14000045,2386,1,0,2024-03-01,"Shawfair",2.0251,EH,EH22,"Scotland","Scottish Water",9C7RWV8Q+8V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120015185",4.32683,,"",,"",,4 EH22 1QN,Yes,55.915445,-3.107485,330876,669704,NT308697,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",96,44,"","","Shawfair - 03","Accessible rural area",Scotland,78,,S01011002,,S02002064,"Shawfair",,S00120904,S14000045,2386,1,0,2024-03-01,"Shawfair",1.86004,EH,EH22,"Scotland","Scottish Water",9C7RWV8V+52,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014446,120014447,120014448,120014449,120014450,120014451,120014452,120014453,120014454,120014455,120014456,120014457,120014458,120014459,120014460,120014461,120014462,120014463,120014464,120014465,120014466,120014467,120014468,120014469,120014470,120014471,120014472,120014473,120014474,120014475,120014476,120014477,120014478,120014479,120014480,120014481,120014482,120014483,120014484,120014485,120014486,120014487,120014488,120014489,120042064,120047479",4.23938,,"",,"",,4 EH22 1QP,Yes,55.916512,-3.111289,330640,669827,NT306698,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",7,4,"","","Shawfair - 05","Accessible rural area",Scotland,85,,S01011004,,S02002064,"Shawfair",,S00121081,S14000045,4898,1,0,2024-03-01,"Shawfair",2.064,EH,EH22,"Scotland","Scottish Water",9C7RWV8Q+JF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014490,120014491,120014492,120014493,120041976",4.30355,,"",,"",,8 EH22 1QQ,Yes,55.913727,-3.107708,330859,669513,NT308695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",39,19,"","","Shawfair - 03","Accessible rural area",Scotland,76,,S01011002,,S02002064,"Shawfair",,S00120905,S14000045,2386,1,0,2024-03-01,"Shawfair",1.93316,EH,EH22,"Scotland","Scottish Water",9C7RWV7R+FW,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014494,120014495,120014496,120014497,120014498,120014499,120014500,120014501,120014502,120014503,120014504,120014505,120014506,120014507,120014508,120014509,120014510,120014511,120014512",4.39806,,"",,"",,4 EH22 1QR,Yes,55.915854,-3.111478,330627,669754,NT306697,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",71,29,"","","Shawfair - 05","Accessible rural area",Scotland,86,,S01011004,,S02002064,"Shawfair",,S00121081,S14000045,4898,1,0,2024-03-01,"Shawfair",2.09025,EH,EH22,"Scotland","Scottish Water",9C7RWV8Q+8C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014513,120014514,120014515,120014516,120014517,120014518,120014519,120014520,120014521,120014522,120014523,120014524,120014525,120014526,120014527,120014528,120014529,120014530,120014531,120014532,120014533,120014534,120014535,120014536,120014537,120014538,120014539,120014540,120014541,120014542,120015187,120046364,120052310",4.36572,,"",,"",,8 EH22 1QS,Yes,55.916087,-3.112589,330558,669781,NT305697,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",61,34,"","","Shawfair - 05","Accessible rural area",Scotland,89,,S01011004,,S02002064,"Shawfair",,S00120900,S14000045,4898,1,0,2024-03-01,"Shawfair",2.15252,EH,EH22,"Scotland","Scottish Water",9C7RWV8P+CX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014997,120014998,120014999,120015000,120015001,120015002,120015003,120015004,120015005,120015006,120015007,120015008,120015009,120015010,120015011,120015012,120015013,120015014,120015015,120015016,120015017,120015018,120015019,120015020,120015021,120015022,120015023,120015024,120015025,120015026,120015027,120015028,120015029,120015030",4.39307,,"",,"",,8 EH22 1QT,Yes,55.916808,-3.112321,330576,669861,NT305698,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",10,5,"","","Shawfair - 05","Accessible rural area",Scotland,88,,S01011004,,S02002064,"Shawfair",,S00121081,S14000045,4898,1,0,2024-03-01,"Shawfair",2.12154,EH,EH22,"Scotland","Scottish Water",9C7RWV8Q+P3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014543,120014544,120014545,120014546,120014547,120014548,120043154,10015473501",4.32307,,"",,"",,8 EH22 1QU,Yes,55.917509,-3.111832,330608,669939,NT306699,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",10,3,"","","Shawfair - 01","Accessible rural area",Scotland,85,,S01011000,,S02002064,"Shawfair",,S00120391,S14000045,3900,1,0,2024-03-01,"Shawfair",2.07994,EH,EH22,"Scotland","Scottish Water",9C7RWV9Q+27,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014549,120014550,120015033,120030428,120030429,120033346,120033560,120034429,120045310,120045976,120048039,120050574,120051351,120055379",4.24558,,"",,"",,6 EH22 1QW,Yes,55.916027,-3.108750,330798,669770,NT307697,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",14,6,"","","Shawfair - 03","Accessible rural area",Scotland,79,,S01011002,,S02002064,"Shawfair",,S00120903,S14000045,2386,1,0,2024-03-01,"Shawfair",1.92034,EH,EH22,"Scotland","Scottish Water",9C7RWV8R+CG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014551,120014552,120014553,120014554,120014555,120014556",4.2397,,"",,"",,4 EH22 1QX,Yes,55.917485,-3.114455,330444,669938,NT304699,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",38,20,"","","Shawfair - 01","Accessible rural area",Scotland,91,,S01011000,,S02002064,"Shawfair",,S00120391,S14000045,3900,1,0,2024-03-01,"Shawfair",2.24231,EH,EH22,"Scotland","Scottish Water",9C7RWV8P+X6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014557,120014558,120014559,120014560,120014561,120014562,120014563,120014564,120014565,120014566,120014567,120014568,120014569,120014570,120014571,120014572,120014573,120014574,120014575,120014576,120014577,120015032,120015183,120032719,120037853,120037854,120052020",4.36184,,"",,"",,6 EH22 1QY,Yes,55.916569,-3.114413,330445,669837,NT304698,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",84,25,"","","Shawfair - 05","Accessible rural area",Scotland,93,,S01011004,,S02002064,"Shawfair",,S00121081,S14000045,4898,1,0,2024-03-01,"Shawfair",2.25441,EH,EH22,"Scotland","Scottish Water",9C7RWV8P+J6,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120015189,120015190,120015191,120015192,120015193,120015194,120015195,120015196,120015197,120015198,120015199,120015200,120015201,120015202,120015203,120015204,120015205,120015206,120015207,120015208,120015209,120015210,120015211,120015212,120015213,120015214,120032165,120038378,120042888",4.43233,,"",,"",,8 EH22 1QZ,Yes,55.909947,-3.105409,330996,669091,NT309690,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",102,48,"","","Shawfair - 02","Accessible rural area",Scotland,71,,S01011001,,S02002064,"Shawfair",,S00120891,S14000045,2721,1,0,2024-03-01,"Shawfair",1.99937,EH,EH22,"Scotland","Scottish Water",9C7RWV5V+XR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014578,120014579,120014580,120014581,120014582,120014583,120014584,120014585,120014586,120014587,120014588,120014589,120014590,120014591,120014592,120014593,120014594,120014595,120014596,120014597,120014598,120014599,120014600,120014601,120014602,120014603,120014604,120014605,120014606,120017420,120017421,120017422,120017423,120017424,120017425,120017426,120017427,120017428,120017429,120017430,120017431,120017432,120017433,120017434,120017435,120017436,120017437,120017438,120017439,120017440,120017441,120033110,120038802,120044355,120044356,120044357,120044358,120044364,120044365,120044366,120044367,120044368,120050716,120053687,120055693,120055985",4.65903,,"",,"",,4 EH22 1RA,Yes,55.915766,-3.114758,330422,669747,NT304697,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1994-02-01,,"","",133,56,"","","Shawfair - 05","Accessible rural area",Scotland,95,,S01011004,,S02002064,"Shawfair",,S00121080,S14000045,4898,1,0,2024-03-01,"Shawfair",2.29201,EH,EH22,"Scotland","Scottish Water",9C7RWV8P+83,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120015034,120015035,120015036,120015037,120015038,120015039,120015040,120015041,120015042,120015043,120015044,120015045,120015046,120015047,120015048,120015049,120015050,120015051,120015052,120015053,120015054,120015055,120015056,120015057,120015058,120015059,120015060,120015061,120015062,120015063,120015064,120015065,120015066,120015067,120015068,120015069,120015070,120015071,120015072,120015073,120015074,120015075,120015076,120015077,120015078,120015079,120015080,120015081,120015082,120015083,120015084,120015085,120015086,120015087,120015088,120015089,120015090,120015091,120015092,120015093,120042715,120042856,906473018,10096080766,10096080767,10096080768,10096080769,10096080770,10096080771,10096080772,10096080773,10096080774,10096080775,10096080776,10096080777,10096080778,10096080779,10096080780,10096080781,10096080782,10096080783,10096080784,10096080785,10096080786,10096080787,10096080788,10096080789,10096080790,10096080791,10096080792,10096080793,10096080794,10096080795,10096080796,10096080797,1009608079",4.51149,,"",,"",,8 EH22 1RB,Yes,55.914409,-3.114815,330416,669597,NT304695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1994-02-01,,"","",143,51,"","","Shawfair - 05","Accessible rural area",Scotland,94,,S01011004,,S02002064,"Shawfair",,S00121079,S14000045,4898,1,0,2024-03-01,"Shawfair",2.33069,EH,EH22,"Scotland","Scottish Water",9C7RWV7P+Q3,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120015094,120015095,120015096,120015097,120015098,120015099,120015100,120015101,120015102,120015103,120015104,120015105,120015106,120015107,120015108,120015109,120015110,120015111,120015112,120015113,120015114,120015115,120015116,120015117,120015118,120015119,120015120,120015121,120015122,120015123,120015124,120015125,120015126,120015127,120015128,120015129,120015130,120015131,120015132,120015133,120015134,120015135,120015136,120015137,120015138,120015139,120015140,120015141,120015142,120015143,120015144,120041666",4.62417,,"",,"",,8 EH22 1RD,Yes,55.913308,-3.104846,331037,669464,NT310694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1985-07-01,,"","",8,7,"","","Shawfair - 03","Accessible rural area",Scotland,69,,S01011002,,S02002064,"Shawfair",,S00120970,S14000045,2386,1,0,2024-03-01,"Shawfair",1.78656,EH,EH22,"Scotland","Scottish Water",9C7RWV7W+83,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120017442,120017443,120017444,120017445,120017446,120017447,120017448",4.32994,,"",,"",,4 EH22 1RE,Yes,55.914095,-3.116275,330324,669563,NT303695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1994-02-01,,"","",92,35,"","","Shawfair - 05","Accessible rural area",Scotland,95,,S01011004,,S02002064,"Shawfair",,S00121082,S14000045,4898,1,0,2024-03-01,"Shawfair",2.42761,EH,EH22,"Scotland","Scottish Water",9C7RWV7M+JF,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120015145,120015146,120015147,120015148,120015149,120015150,120015151,120015152,120015153,120015154,120015155,120015156,120015157,120015158,120015159,120015160,120015161,120015162,120015163,120015164,120015165,120015166,120015167,120015168,120015169,120015170,120015171,120015172,120015173,120015174,120015175,120015176,120015177,120015178,120015179,120015180,120042958,10015452045,10024914867,10025426088,10096517583,10096517588,10096517590,10096517596,10096517597",4.71144,,"",,"",,8 EH22 1RN,No,55.896233,-3.060175,333800,667520,NT338675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,1995-12-01,"","",,,"","","Thornybank - 01","Other urban area",Scotland,45,,S01011005,,S02002065,"Thornybank",,S00120688,S14000045,1554,8,0,2024-03-01,"Eskbank",2.14622,EH,EH22,"Scotland","Scottish Water",9C7RVWWQ+FW,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.44158,,"",,"",,3 EH22 1RR,Yes,55.907167,-3.105295,330998,668781,NT309687,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,70,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",2.18077,EH,EH22,"Scotland","Scottish Water",9C7RWV4V+VV,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120014122,120014123,120014124,120014125,120017370,120030418,120032597,120033091,120035132,120038208,120041602,120054714,120055410,906305768,906464396,906464397,906464398,906464399,906464400,906464401,906464402,906464403,906464404,906464405,906464406,906464407,906464408,906464409,906464410,906464411,906464412,906464413,906464414,906465086,906490133,10094326747",4.91757,,"",,"",,6 EH22 1RS,Yes,55.902983,-3.096414,331546,668307,NT315683,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",15,4,"","","Shawfair - 01","Accessible rural area",Scotland,67,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",2.18329,EH,EH22,"Scotland","Scottish Water",9C7RWW33+5C,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120035968,120035969,120035970,120035971,120036803,120036836,120037237,120037238,120047155,120047457,120047458,120047459,120048523,120048545,120056297,10015329287,10092036525",5.08279,,"",,"",,6 EH22 1RT,Yes,55.900999,-3.095175,331620,668084,NT316680,"","City of Edinburgh","Liberton/Gilmerton",S12000036,S13002934,Scotland,S99999999,"Edinburgh South",1980-01-01,,"","",7,2,"","","Gilmerton South and the Murrays - 03","Accessible rural area",Scotland,64,,S01008549,,S02001600,"Gilmerton South and the Murrays",,S00106690,S14000024,4517,1,0,2024-03-01,"Eskbank",2.26214,EH,EH22,"Scotland","Scottish Water",9C7RWW23+9W,,"","Edinburgh","Eastern Scotland","City of Edinburgh","120017371,120056548,906305770,906305771,906305772,906305773,906305774,906305775,906305776,906305777,906478181,906479983",5.25837,,"",,"",,7 EH22 1RU,Yes,55.899673,-3.089201,331991,667931,NT319679,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",4,2,"","","Shawfair - 01","Accessible rural area",Scotland,62,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Eskbank",2.02179,EH,EH22,"Scotland","Scottish Water",9C7RVWX6+V8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120033388,120041217,120041604,120041948,120042589,120043251,120043252,120043253,120046840,120046968,120048233,120048234,120048235,120052716",5.27688,,"",,"",,6 EH22 1RX,Yes,55.907394,-3.085834,332215,668787,NT322687,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",9,5,"","","Shawfair - 01","Accessible rural area",Scotland,57,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,1,0,2024-03-01,"Shawfair",1.46319,EH,EH22,"Scotland","Scottish Water",9C7RWW47+XM,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120034104,120034105,120034106,120034107,120034108,120042815,120043661,120050278,120051338,120051339,120055588,10015312655,10015319429,10015359251,10015385865,10015448890,10025370714",4.39515,,"",,"",,6 EH22 1RY,Yes,55.911821,-3.086665,332171,669280,NT321692,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",12,5,"","","Shawfair - 01","Accessible rural area",Scotland,54,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,1,0,2024-03-01,"Shawfair",1.02938,EH,EH22,"Scotland","Scottish Water",9C7RWW67+P8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120036629,120036630,120037775,120037776,120037777,120037778,120050313,120053565,120053577,120054523,120054566,120055001",3.94607,,"",,"",,6 EH22 1RZ,Yes,55.913688,-3.082846,332413,669485,NT324694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",93,42,"","","Shawfair - 01","Accessible rural area",Scotland,48,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,1,0,2024-03-01,"Shawfair",0.741101,EH,EH22,"Scotland","Scottish Water",9C7RWW78+FV,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120035482,120035555,120035660,120035687,120035761,120035762,120035763,120035764,120035765,120035766,120035767,120035769,120035770,120035771,120035772,120036235,120036236,120036732,120037115,120037455,120037779,120037780,120037781,120037782,120037783,120037784,120037785,120037786,120037787,120037788,120037789,120037792,120037793,120037794,120037795,120037796,120037797,120037798,120037799,120037800,120037801,120037802,120037803,120037804,120037805,120037806,120037807,120037931,120037932,120038979,120039239,120042588,120043081,120043963,120049096,120049133,120050498,120050499,120052190,120052817,120053127,120053128,120053129,120053426,120055587,10015299400,10015302680,10015323535,10015326080,10015379218,10015392429,10015445542,10025369470,10025426080",3.67224,,"",,"",,6 EH22 1SA,Yes,55.918386,-3.073181,333025,669998,NT330699,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",22,12,"","","Shawfair - 01","Accessible rural area",Scotland,41,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,1,0,2024-03-01,"Shawfair",0.385404,EH,EH22,"Scotland","Scottish Water",9C7RWW9G+9P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032975,120035620,120036134,120037005,120037006,120037007,120037008,120037009,120037010,120037353,120037354,120037355,120038323,120041599,120042570,120043073,120043994,120043995,120043996,120043997,120043998,120043999,120044137,120047158,120048629,120051551,120051552,120051569,120056709,138066793,10015279666,10015312718,10015365751,10015412367,10015438759,10015438915,10015442241,10015448801,10025376237",3.01886,,"",,"",,6 EH22 1SB,Yes,55.915350,-3.088424,332067,669675,NT320696,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",24,9,"","","Shawfair - 01","Accessible rural area",Scotland,49,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,1,0,2024-03-01,"Shawfair",0.79126,EH,EH22,"Scotland","Scottish Water",9C7RWW86+4J,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120018662,120018663,120018664,120018665,120031634,120032279,120032280,120032717,120032977,120034044,120034045,120034761,120034850,120034852,120035008,120035025,120037456,120041512,120043970,120046903,120047003,120047705,120048415,120049301,120049302,120049906,120050561,120050563,120050564,120050565,120050566,120050568,120055586",3.62391,,"",,"",,6 EH22 1SD,Yes,55.915518,-3.098400,331444,669704,NT314697,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",4,1,"","","Shawfair - 01","Accessible rural area",Scotland,59,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.32083,EH,EH22,"Scotland","Scottish Water",9C7RWW82+6J,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120037016,120042063,120044143,120055590",3.90227,,"",,"",,6 EH22 1SE,No,55.919523,-3.091037,331911,670142,NT319701,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1997-12-01,2015-05-01,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,47,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,1,1,2024-03-01,"Shawfair",0.768816,EH,EH22,"Scotland","Scottish Water",9C7RWW95+RH,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",3.28394,,"",,"",,6 EH22 1SF,Yes,55.917133,-3.099178,331398,669884,NT313698,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",11,4,"","","Shawfair - 01","Accessible rural area",Scotland,67,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,1,0,2024-03-01,"Shawfair",1.31203,EH,EH22,"Scotland","Scottish Water",9C7RWW82+V8,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032207,120032208,120032209,120032210,120032211,120042527,120050553,120050558,120050559",3.7794,,"",,"",,6 EH22 1SG,Yes,55.921439,-3.100472,331325,670365,NT313703,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",29,11,"","","Shawfair - 01","Accessible rural area",Scotland,61,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,1,0,2024-03-01,"Shawfair",1.36503,EH,EH22,"Scotland","Scottish Water",9C7RWVCX+HR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120033561,120035417,120035886,120035887,120035888,120035889,120035890,120036804,120037486,120038980,120041491,120041492,120044854,120045333,120046302,120046902,120047906,120049245,120050123,120050367,120050554,120050556,120050560,120050562",3.44766,,"",,"",,6 EH22 1SH,Yes,55.926140,-3.109724,330755,670897,NT307708,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2002-12-01,,"","",8,3,"","","Shawfair - 01","Accessible rural area",Scotland,60,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,1,0,2024-03-01,"Newcraighall",1.40845,EH,EH22,"Scotland","Scottish Water",9C7RWVGR+F4,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120015215,120015216,120015217,120015218,120015219,120032170,120032914,120033015,120033998,120035174,120035472,120036370,120036371,120036372,120036373,120038622,120039112,120044634,120050364,120050365,120052509,120052510,10015339133,10015435357",3.5074,,"",,"",,6 EH22 1SJ,No,55.926209,-3.111054,330672,670906,NT306709,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,2000-07-01,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,58,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,1,1,2024-03-01,"Newcraighall",1.47423,EH,EH22,"Scotland","Scottish Water",9C7RWVGQ+FH,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",3.56933,,"",,"",,6 EH22 1SL,Yes,55.921526,-3.106216,330966,670380,NT309703,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",2,1,"","","Shawfair - 01","Accessible rural area",Scotland,71,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,1,0,2024-03-01,"Newcraighall",1.60529,EH,EH22,"Scotland","Scottish Water",9C7RWVCV+JG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032220",3.68166,,"",,"",,6 EH22 1SN,Yes,55.913612,-3.093483,331748,669487,NT317694,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",110,48,"","","Shawfair - 01","Accessible rural area",Scotland,51,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.15792,EH,EH22,"Scotland","Scottish Water",9C7RWW74+CJ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120017450,120017451,120017452,120017453,120017454,120017455,120017456,120017457,120017458,120017459,120017460,120017461,120017462,120017463,120017464,120017465,120017466,120017467,120017468,120017469,120017470,120017471,120017472,120017473,120017474,120017475,120017476,120017477,120017478,120017479,120017480,120017481,120017482,120017483,120017484,120017485,120032206,120032212,120032804,120032805,120032806,120032807,120032808,120032809,120032810,120032811,120032812,120032813,120032814,120032815,120033084,120033410,120042525,120042572,120052045,120052191,120052970,10024914903,10025426379",3.9341,,"",,"",,6 EH22 1SP,Yes,55.913814,-3.090429,331939,669506,NT319695,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1989-10-01,,"","",0,0,"","","Shawfair - 01","Accessible rural area",Scotland,50,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",0.998011,EH,EH22,"Scotland","Scottish Water",9C7RWW75+GR,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120033020,120047587,120047588,120050606",3.8309,,"",,"",,6 EH22 1SQ,Yes,55.930415,-3.101955,331248,671365,NT312713,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",0,0,"","","Shawfair - 01","Accessible rural area",Scotland,42,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,1,0,2024-03-01,"Newcraighall",0.754335,EH,EH22,"Scotland","Scottish Water",9C7RWVJX+56,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120037501,120042990,120050579,120053054",2.8366,,"",,"",,6 EH22 1SR,Yes,55.911935,-3.098091,331457,669304,NT314693,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",6,2,"","","Shawfair - 01","Accessible rural area",Scotland,58,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Shawfair",1.4993,EH,EH22,"Scotland","Scottish Water",9C7RWW62+QQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120043600,120043601,120043602,120043660,120051717,120054138,120054139",4.23405,,"",,"",,6 EH22 1SS,Yes,55.910722,-3.110150,330701,669182,NT307691,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",1,1,"","","Shawfair - 02","Accessible rural area",Scotland,78,,S01011001,,S02002064,"Shawfair",,S00120894,S14000045,2721,1,0,2024-03-01,"Shawfair",2.20961,EH,EH22,"Scotland","Scottish Water",9C7RWV6Q+7W,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120034088,120034090,10025284135",4.75633,,"",,"",,4 EH22 1ST,Yes,55.897592,-3.085704,332206,667696,NT322676,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",5,1,"","","Shawfair - 01","Accessible rural area",Scotland,66,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,1,0,2024-03-01,"Eskbank",1.76181,EH,EH22,"Scotland","Scottish Water",9C7RVWX7+2P,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120037487,120038235,120045730,120046488,120049210,120051715",5.44234,,"",,"",,6 EH22 1SU,No,55.894299,-3.086188,332170,667330,NT321673,"","Midlothian","Midlothian East",S12000019,S13003022,Scotland,S99999999,"Midlothian",1992-07-01,1994-12-01,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,72,,S01011000,,S02002064,"Shawfair",,S00120392,S14000045,3900,8,1,2024-03-01,"Eskbank",1.40175,EH,EH22,"Scotland","Scottish Water",9C7RVWV7+PG,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.80511,,"",,"",,6 EH22 1SW,Yes,55.914986,-3.093038,331778,669639,NT317696,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1980-01-01,,"","",141,56,"","","Shawfair - 01","Accessible rural area",Scotland,51,,S01011000,,S02002064,"Shawfair",,S00120937,S14000045,3900,1,0,2024-03-01,"Shawfair",1.04836,EH,EH22,"Scotland","Scottish Water",9C7RWW74+XQ,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120017486,120017487,120017488,120017489,120017490,120017491,120017492,120017493,120017494,120017495,120017496,120017497,120017498,120017499,120017500,120017501,120017502,120017503,120017504,120017505,120017506,120017507,120017508,120017509,120017510,120017511,120017512,120017513,120017514,120017515,120017516,120017517,120017518,120017519,120017520,120017521,120017522,120017523,120017524,120017525,120017526,120017527,120032816,120032817,120032818,120032819,120032820,120032821,120032822,120032823,120032824,120032825,120032826,120032827,120032828,120032829,120046140,120047004,120055585",3.7858,,"",,"",,6 EH22 1SX,Yes,55.924180,-3.085251,332281,670655,NT322706,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2016-04-01,,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,42,,S01011000,,S02002064,"Shawfair",,S00120939,S14000045,3900,1,0,2024-03-01,"Shawfair",0.622484,EH,EH22,"Scotland","Scottish Water",9C7RWWF7+MV,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120037389,120043696,120049233,120049234,120050557,120053790,120055063,120056003,120056053,10015279683,10015281571,10015289686,10015307925,10015312575,10015324579,10015325943,10015337944,10015339459,10015361111,10015409169,10015422328,10015437463,10015446359,10015461946,10015466228,10015470657",2.6563,,"",,"",,6 EH22 1SY,Yes,55.917124,-3.115661,330368,669900,NT303698,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1994-06-01,,"","",13,3,"","","Shawfair - 01","Accessible rural area",Scotland,94,,S01011000,,S02002064,"Shawfair",,S00120391,S14000045,3900,1,0,2024-03-01,"Shawfair",2.32194,EH,EH22,"Scotland","Scottish Water",9C7RWV8M+RP,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120015181,120015182,120015184,120042970,120054694",4.44345,,"",,"",,6 EH22 1UU,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2000-06-01,2020-02-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8 EH22 1UZ,Yes,55.896369,-3.060067,333807,667535,NT338675,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2000-06-01,,"","",10,4,"","","Thornybank - 01","Other urban area",Scotland,45,,S01011005,,S02002065,"Thornybank",,S00120688,S14000045,1554,1,0,2024-03-01,"Eskbank",2.16199,EH,EH22,"Scotland","Scottish Water",9C7RVWWQ+GX,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","120032381,120032382,120032383,120032384,120032385,120034824,120034825,120034826,120034827,120034828,120035128,120038118,120042084,120050246",5.42685,,"",,"",,3 EH22 1WA,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2001-06-01,2003-06-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8 EH22 1WU,No,55.906291,-3.087675,332098,668666,NT320686,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2005-04-01,2005-09-01,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,57,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,6,1,2024-03-01,"Shawfair",1.61635,EH,EH22,"Scotland","Scottish Water",9C7RWW46+GW,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",4.54697,,"",,"",,6 EH22 1WW,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2005-01-01,2018-12-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8 EH22 1WX,Yes,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2004-07-01,,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","10092759873",5.81605,,"",,"",,8 EH22 1YB,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2007-01-01,2007-01-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8 EH22 1YD,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1997-06-01,2003-05-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8 EH22 1YE,No,55.907376,-3.086873,332150,668786,NT321687,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1999-12-01,2000-06-01,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,57,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,6,1,2024-03-01,"Shawfair",1.48596,EH,EH22,"Scotland","Scottish Water",9C7RWW47+X7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",4.41682,,"",,"",,6 EH22 1YF,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",1999-12-01,2018-12-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8 EH22 1YJ,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2000-12-01,2005-09-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8 EH22 1YR,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2001-06-01,2005-09-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8 EH22 1YS,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2006-06-01,2006-07-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8 EH22 1YT,No,55.906291,-3.087675,332098,668666,NT320686,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2003-06-01,2004-06-01,"","",,,"","","Shawfair - 01","Accessible rural area",Scotland,57,,S01011000,,S02002064,"Shawfair",,S00120393,S14000045,3900,6,1,2024-03-01,"Shawfair",1.61635,EH,EH22,"Scotland","Scottish Water",9C7RWW46+GW,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",4.54697,,"",,"",,6 EH22 1YU,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2003-10-01,2018-12-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8 EH22 1YW,No,55.892996,-3.072863,333001,667172,NT330671,"","Midlothian","Dalkeith",S12000019,S13003020,Scotland,S99999999,"Midlothian",2004-02-01,2006-04-01,"","",,,"","","Eskbank - 06","Other urban area",Scotland,60,,S01010999,,S02002063,"Eskbank",,S00120674,S14000045,4984,1,1,2024-03-01,"Eskbank",1.39681,EH,EH22,"Scotland","Scottish Water",9C7RVWVG+5V,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",5.81605,,"",,"",,8