UK Postcodes and UPRNs

UPRN and Postcode data from UK Organisation of National Statistics.

The postcode table has a record for every single Postcode in the UK, with history going back to August 2009.

The UPRN table has a record for every Unique Property Reference Number in the UK, with history back to October 2020

The postcode table contains following fields:

- Postcode_8_chars
- Postcode_single_space_e_Gif
- Date_of_Introduction
- Date_of_Termination
- Grid_Ref_Easting
- Grid_Ref_Northing
- County
- Local_Authority_Organisation
- Local_Authority_District_Unitary_Authority
- Electoral_Ward_or_Division
- Postcode_Usertype
- Grid_Ref_Positional_Quality_Indicator
- Country
- Strategic_Health_Authority
- GOR_Code
- Health_Authority_Old_Style
- Commissioning_Region
- Primary_Care_Organisation
- yr1991_Census_ED_OGSS_Code
- yr1991_Census_ED_Census_Code
- ED_Positional_Quality_Indicator
- yr1998_Ward_Code
- yr2001_Census_Output_Area
- Area_Team
- PAN_SHA_Country
- LSOA
- yr2001_Census_Urban_Rural_Indicator
- MSOA
- Cancer_Network
- Strategic_Clinical_Network
- Pre_July_2006_SHA
- Old_PCT
- Old_IT_Cluster_Country
- Parliamentary_Constituency
- Cancer_Registry
- Second_Wave
- Grid_Ref_Easting_1m
- Grid_Ref_Northing_1m
- yr2011_OA
- yr2011_LSOA
- yr2011_MSOA
- Cancer_Alliance_Nat_Cancer_Vanguard
- Sustainability_And_Transformation_Partnership
- SMHPC_Adult_Eating_Disorder_Services
- SMHPC_Adult_Low_And_Medium_Secure_Services
- SMHPC_Children_And_Young_People_Mental_Health_Services
- yr2021_OA
- yr2021_LSOA
- yr2021_MSOA
- PO_Box_NonGeographic_Indicator
- yr2001_Census_Output_Area_Ind
- Scottish_Datazone
- Urban_Rural_Indicator_EandW
- Urban_Rural_Indicator_Scot
- Latitude_1m
- Longitude_1m
- In_Source_Data
- Import_Date
- Created_Date
- Is_Latest
- Effective_From
- Effective_To
- Char_8_ASCII_Index

The UPRN table contains fields

- UPRN
- Grid_Ref_Easting
- Grid_Ref_Northing
- Postcode_single_space_e_Gif
- Census_Output_Area
- County
- County_Electoral_Division
- Local_Authority_District
- Electoral_Ward_Division
- Strategic_Health_Authority
- Country
- Region
- Parliamentary_Constituency
- European_Electoral_Region
- Travel_To_Work_Area
- LAU2_Or_ITL_Area
- National_Park
- LSOA
- MSOA
- Workplace_Zone
- CCG
- Built_Up_Area
- Built_Up_Area_Sub_Division
- Rural_Urban_Classification
- Output_Area_Classification
- Local_Enterprise_Partnership_1st_Instance
- Local_Enterprise_Partnership_2nd_Instance
- Police_Force_Area
- Index_Of_Multiple_Deprivation_Rank
- Postcode_Char_8_ASCII_Index
- In_Source_Data
- Effective_Snapshot_Date
- Is_Latest
- Effective_From
- Effective_To