Local Authority District To County (April 2019) Lookup In EN
Office for National Statistics
@ukgov.local_authority_district_to_county_april_2019_lookup_in_en
Office for National Statistics
@ukgov.local_authority_district_to_county_april_2019_lookup_in_en
This is a lookup file between local authority districts and counties, metropolitan counties and Greater London in England as at 1st April 2019. (File Size - 48KB)
E10000009 - 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)
Field Names - LAD19CD, LAD19NM, CTY19CD, CTY19NM, FID
Field Types - Text, Text, Text, Text, Numeric
Field Lengths - 9, 28, 9, 18
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.
REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LAD19_CTY19_EN_LU_a9328f0e5c4a4d7cb0f9900a2e51281b/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T01:34:33Z
CREATE TABLE table_1 (
"lad19cd" VARCHAR,
"lad19nm" VARCHAR,
"cty19cd" VARCHAR,
"cty19nm" VARCHAR,
"fid" BIGINT
);Anyone who has the link will be able to view this.