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

E07000112 - Shepway renamed Folkestone and Hythe on 1st April 2018

Field Names - LAD18CD, LAD18NM, RGN18CD, RGN18NM

Field Types - Text, Text, Text, Text

Field Lengths - 9, 28, 9, 24

@ukgov.local_authority_district_to_region_april_2018_lookup_in_en.table_1


CREATE TABLE table_1 (
  "lad18cd" VARCHAR,
  "lad18nm" VARCHAR,
  "rgn18cd" VARCHAR,
  "rgn18nm" VARCHAR,
  "fid" BIGINT
);