Local Authority District To County And Unitary Authority (April 2019) Lookup In EW
Office for National Statistics
@ukgov.local_authority_district_to_county_and_unitary_authori_247f9315
Office for National Statistics
@ukgov.local_authority_district_to_county_and_unitary_authori_247f9315
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 2019. (File Size = 56KB)
Field Names - LAD19CD, LAD19NM, CTYAUA19CD, CTYUA19NM, FID
Field Types - Text, Text, Text, Text, Numeric
Field Lengths - 9, 35, 9, 35
FID = The FID, or Feature ID is created by the publication process when the names and codes / lookup products are published to the Open Geography portal.
File includes the following LAD changes
E06000058 - Bournemouth, Christchurch and Poole - new unitary authority
E06000059 - Dorset - new unitary authority - (Dorset county abolished)
E07000244 - East Suffolk - new local authority district (Suffolk Coastal and Waveney districts abolished)
E07000245 - West Suffolk - new local authority district (Forest Heath and St Edmundsbury districts abolished)
E07000246 - Somerset West and Taunton - new local authority district (Taunton Deane and West Somerset districts abolished)
REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LTLA19_UTLA19_EW_LU_e18698202ee449c28c8e54b38018e962/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2025-05-27T04:01:18Z
CREATE TABLE table_1 (
"lad19cd" VARCHAR,
"lad19nm" VARCHAR,
"ctyua19cd" VARCHAR,
"ctyua19nm" VARCHAR,
"fid" BIGINT
);Anyone who has the link will be able to view this.