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

Field Names - LAD22CD, LAD22NM, RGN22CD, RGN22NM

Field Types - Text, Text, Text, Text

Field Lengths - 9, 35, 9, 24
Publisher name: Office for National Statistics
Last updated: 2024-12-10T04:32:15Z

@ukgov.local_authority_district_to_region_december_2022_lookup_in_en.table_1

CREATE TABLE table_1 (
  "lad22cd" VARCHAR,
  "lad22nm" VARCHAR,
  "rgn22cd" VARCHAR,
  "rgn22nm" VARCHAR,
  "objectid" BIGINT
);