This is a lookup file between local authority districts and regions in England as at 31 December 2017. (File Size - 56 KB)

Field Names - LAD17CD, LAD17NM, RGN17CD, RGN17NM

Field Types - Text, Text, Text, Text

Field Lengths - 9, 28, 9, 24

@ukgov.local_authority_district_to_region_december_2017_lookup_in_en.table_1

CREATE TABLE table_1 (
  "lad17cd" VARCHAR,
  "lad17nm" VARCHAR,
  "rgn17cd" VARCHAR,
  "rgn17nm" VARCHAR,
  "fid" BIGINT
);