About this Dataset

Local Authority District To Region (April 2019) Lookup In EN

This is a lookup file between local authority districts and regions in England as at 1st April 2019. (File Size - 56 KB)

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)

Field Names - LAD19CD, LAD19NM, RGN19CD, RGN19NM, FID

Field Types - Text, Text, Text, Text, Numeric

Field Lengths - 9, 35, 9, 24

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_RGN19_EN_LU_948748b0eaa54fe888a604b126f5e672/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T04:36:13Z

Tables

Table 1

@ukgov.local_authority_district_to_region_april_2019_lookup_in_en.table_1

11.27 KB
317 rows
5 columns


CREATE TABLE table_1 (
  "lad19cd" VARCHAR,
  "lad19nm" VARCHAR,
  "rgn19cd" VARCHAR,
  "rgn19nm" VARCHAR,
  "fid" BIGINT
);