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
EH19 9AA,No,55.873723,-3.104280,331002,665058,NT310650,"","Midlothian","Bonnyrigg",S12000019,S13003019,Scotland,S99999999,"Midlothian",2008-11-01,2010-12-01,"","",,,"","","Bonnyrigg North - 03","Other urban area",Scotland,102,,S01010980,,S02002061,"Bonnyrigg North",,S00120659,S14000045,1970,1,1,2024-03-01,"Eskbank",1.59814,EH,EH19,"Scotland","Scottish Water",9C7RVVFW+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.30922,,"",,"",,3
EH19 9AB,No,0,0,,,,"","","",,,Scotland,,"",2008-10-01,2009-11-01,"","",,,"","","","",Scotland,,,,,,"",,,,0,9,1,2024-03-01,"",,EH,EH19,"","Scottish Water",,,"","","","","",,,"",,"",,0
EH19 9AD,No,0,0,,,,"","","",,,Scotland,,"",2009-03-01,2009-09-01,"","",,,"","","","",Scotland,,,,,,"",,,,0,9,1,2024-03-01,"",,EH,EH19,"","Scottish Water",,,"","","","","",,,"",,"",,0
EH19 9AE,No,55.873723,-3.104280,331002,665058,NT310650,"","Midlothian","Bonnyrigg",S12000019,S13003019,Scotland,S99999999,"Midlothian",2009-09-01,2012-10-01,"","",,,"","","Bonnyrigg North - 03","Other urban area",Scotland,102,,S01010980,,S02002061,"Bonnyrigg North",,S00120659,S14000045,1970,1,1,2024-03-01,"Eskbank",1.59814,EH,EH19,"Scotland","Scottish Water",9C7RVVFW+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.30922,,"",,"",,3
EH19 9AF,No,55.873723,-3.104280,331002,665058,NT310650,"","Midlothian","Bonnyrigg",S12000019,S13003019,Scotland,S99999999,"Midlothian",2010-01-01,2011-02-01,"","",,,"","","Bonnyrigg North - 03","Other urban area",Scotland,102,,S01010980,,S02002061,"Bonnyrigg North",,S00120659,S14000045,1970,1,1,2024-03-01,"Eskbank",1.59814,EH,EH19,"Scotland","Scottish Water",9C7RVVFW+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.30922,,"",,"",,3
EH19 9AG,No,55.873723,-3.104280,331002,665058,NT310650,"","Midlothian","Bonnyrigg",S12000019,S13003019,Scotland,S99999999,"Midlothian",2010-05-01,2012-06-01,"","",,,"","","Bonnyrigg North - 03","Other urban area",Scotland,102,,S01010980,,S02002061,"Bonnyrigg North",,S00120659,S14000045,1970,1,1,2024-03-01,"Eskbank",1.59814,EH,EH19,"Scotland","Scottish Water",9C7RVVFW+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.30922,,"",,"",,3
EH19 9AH,No,55.873723,-3.104280,331002,665058,NT310650,"","Midlothian","Bonnyrigg",S12000019,S13003019,Scotland,S99999999,"Midlothian",2010-05-01,2012-06-01,"","",,,"","","Bonnyrigg North - 03","Other urban area",Scotland,102,,S01010980,,S02002061,"Bonnyrigg North",,S00120659,S14000045,1970,1,1,2024-03-01,"Eskbank",1.59814,EH,EH19,"Scotland","Scottish Water",9C7RVVFW+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.30922,,"",,"",,3
EH19 9AJ,No,55.873723,-3.104280,331002,665058,NT310650,"","Midlothian","Bonnyrigg",S12000019,S13003019,Scotland,S99999999,"Midlothian",2010-11-01,2012-10-01,"","",,,"","","Bonnyrigg North - 03","Other urban area",Scotland,102,,S01010980,,S02002061,"Bonnyrigg North",,S00120659,S14000045,1970,1,1,2024-03-01,"Eskbank",1.59814,EH,EH19,"Scotland","Scottish Water",9C7RVVFW+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.30922,,"",,"",,3
EH19 9AL,No,55.873723,-3.104280,331002,665058,NT310650,"","Midlothian","Bonnyrigg",S12000019,S13003019,Scotland,S99999999,"Midlothian",2012-09-01,2013-04-01,"","",,,"","","Bonnyrigg North - 03","Other urban area",Scotland,102,,S01010980,,S02002061,"Bonnyrigg North",,S00120659,S14000045,1970,1,1,2024-03-01,"Eskbank",1.59814,EH,EH19,"Scotland","Scottish Water",9C7RVVFW+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.30922,,"",,"",,3
EH19 9AN,Yes,55.873719,-3.104283,331002,665058,NT310650,"","Midlothian","Bonnyrigg",S12000019,S13003019,Scotland,S99999999,"Midlothian",2019-04-01,,"","",,,"","","Bonnyrigg North - 03","Other urban area",Scotland,101,,S01010980,,S02002061,"Bonnyrigg North",,S00120659,S14000045,1970,1,1,2024-03-01,"Eskbank",1.59854,EH,EH19,"Scotland","Scottish Water",9C7RVVFW+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","10092813004",8.3097,,"",,"",,3
EH19 9AP,No,55.873719,-3.104283,331002,665058,NT310650,"","Midlothian","Bonnyrigg",S12000019,S13003019,Scotland,S99999999,"Midlothian",2020-02-01,2020-09-01,"","",,,"","","Bonnyrigg North - 03","Other urban area",Scotland,101,,S01010980,,S02002061,"Bonnyrigg North",,S00120659,S14000045,1970,1,1,2024-03-01,"Eskbank",1.59854,EH,EH19,"Scotland","Scottish Water",9C7RVVFW+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.3097,,"",,"",,3
EH19 9AQ,No,55.873719,-3.104283,331002,665058,NT310650,"","Midlothian","Bonnyrigg",S12000019,S13003019,Scotland,S99999999,"Midlothian",2020-07-01,2020-11-01,"","",,,"","","Bonnyrigg North - 03","Other urban area",Scotland,101,,S01010980,,S02002061,"Bonnyrigg North",,S00120659,S14000045,1970,1,1,2024-03-01,"Eskbank",1.59854,EH,EH19,"Scotland","Scottish Water",9C7RVVFW+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.3097,,"",,"",,3
EH19 9AR,No,55.873719,-3.104283,331002,665058,NT310650,"","Midlothian","Bonnyrigg",S12000019,S13003019,Scotland,S99999999,"Midlothian",2023-04-01,2023-07-01,"","",,,"","","Bonnyrigg North - 03","Other urban area",Scotland,101,,S01010980,,S02002061,"Bonnyrigg North",,S00120659,S14000045,1970,1,1,2024-03-01,"Eskbank",1.59854,EH,EH19,"Scotland","Scottish Water",9C7RVVFW+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.3097,,"",,"",,3
EH19 9AS,No,55.873719,-3.104283,331002,665058,NT310650,"","Midlothian","Bonnyrigg",S12000019,S13003019,Scotland,S99999999,"Midlothian",2023-08-01,2024-01-01,"","",,,"","","Bonnyrigg North - 03","Other urban area",Scotland,101,,S01010980,,S02002061,"Bonnyrigg North",,S00120659,S14000045,1970,1,1,2024-03-01,"Eskbank",1.59854,EH,EH19,"Scotland","Scottish Water",9C7RVVFW+F7,,"","Edinburgh","Eastern Scotland","East Lothian and Midlothian","",8.3097,,"",,"",,3