About this Dataset

Local Authority District To County (April 2020) 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 2020. (File Size - 104KB)

E10000002 - Buckinghamshire county abolished. E06000060 - Buckinghamshire unitary authority created.

(E07000004 - Aylesbury Vale, E07000005 - Chiltern, E07000006 - South Bucks and E07000007 - Wycombe districts abolished)

Field Names - LAD20CD, LAD20NM, CTY20CD, CTY20NM, FID

Field Types - Text, Text, Text, Text,

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/LAD20_CTY20_EN_LU_598927d71aca422f893bab3ee1283f87/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T01:35:14Z

Tables

Table 1

@ukgov.local_authority_district_to_county_april_2020_lookup_in_en.table_1

10.4 KB
257 rows
5 columns


CREATE TABLE table_1 (
  "lad20cd" VARCHAR,
  "lad20nm" VARCHAR,
  "cty20cd" VARCHAR,
  "cty20nm" VARCHAR,
  "fid" BIGINT
);