Local Authority District To County And Unitary Authority (April 2023) Lookup In EW
Office for National Statistics
@ukgov.local_authority_district_to_county_and_unitary_authori_1919150c
Office for National Statistics
@ukgov.local_authority_district_to_county_and_unitary_authori_1919150c
A lookup file of the local authority districts (local authority districts, unitary authorities, metropolitan districts, London boroughs) to the county and unitary authorities (counties, metropolitan counties, inner and outer London, unitary authorities) in England and Wales as at 1st April 2023. (File Size = 56KB)
Field Names - LAD23CD, LAD23NM, LAD23NMW, CTYUA23CD, CTYUA23NM, CTYUA23NMW
Field Types - Text, Text, Text, Text, Text, Text,
Field Lengths - 9, 35, 24, 9, 35, 24
The local authority districts that changed -
| E06000063 | Cumberland | 331/2022 | The Cumbria (Structural Changes) Order 2022 | 01/04/2023 | |
|---|---|---|---|---|---|
| E06000064 | Westmorland and Furness | 331/2022 | The Cumbria (Structural Changes) Order 2022 | 01/04/2023 | |
| E06000065 | North Yorkshire | 328/2022 | The North Yorkshire (Structural Changes) Order 2022 | 01/04/2023 | |
| E06000066 | Somerset | 329/2022 | The Somerset (Structural Changes) Order 2022 | 01/04/2023 | |
| Publisher name: Office for National Statistics | |||||
| Last updated: 2025-05-27T04:01:18Z |
CREATE TABLE table_1 (
"ltla23cd" VARCHAR,
"ltla23nm" VARCHAR,
"ltla23nmw" VARCHAR,
"utla23cd" VARCHAR,
"utla23nm" VARCHAR,
"utla23nmw" VARCHAR,
"objectid" BIGINT
);Anyone who has the link will be able to view this.