We have added ref_spine_2025 table this is a comprehensive geographic reference dataset that serves as the backbone for linking postcodes to various administrative, statistical, and healthcare geographies across the UK.
This is especially important with the recent OA (Output Area) renaming in Northern Ireland and the ongoing merging of various local authorities. This dataset will be refreshed quarterly to reflect changes in Local Authority control at a postcode level.
Core Data Structure
Postcode Information
- Postcode: Full postcode (e.g., S74 9SF, S74 9SJ)
- Introduction Date: When the postcode was first introduced
- Termination Date: When the postcode was discontinued (if applicable)
- User Type: Classification of postcode usage
Geographic Classifications
- Output Areas (OA): 2001 and 2011 census output area codes with classifications
- LSOA/MSOA: Lower and Middle Layer Super Output Areas for both 2001 and 2011
- Rural/Urban Classification: Detailed urban/rural categorizations (e.g., "Urban: Nearer to a major town or city")
Administrative Boundaries
The table links each postcode to multiple administrative layers:
- Local Authority Districts (e.g., Barnsley)
- Regions (e.g., Yorkshire and The Humber)
- Counties (e.g., South Yorkshire)
- Wards (e.g., Rockingham, Hoyland Milton)
- Parliamentary Constituencies (e.g., Barnsley South)
- National Parks (where applicable)
This table is essential for any analysis requiring precise geographic attribution of data to official UK administrative boundaries and statistical areas.