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

Field Names - LAD24CD, LAD24NM, RGN24CD, RGN24NM

Field Types - Text, Text, Text, Text

Field Lengths - 9, 35, 9, 24
Publisher name: Office for National Statistics
Last updated: 2025-01-13T04:01:10Z

@ukgov.local_authority_district_to_region_december_2024_lookup_in_en.table_1

CREATE TABLE table_1 (
  "lad24cd" VARCHAR,
  "lad24nm" VARCHAR,
  "rgn24cd" VARCHAR,
  "rgn24nm" VARCHAR,
  "objectid" BIGINT
);