This is a lookup file between local authority districts and countries in the UK as at 31st December 2022. (File Size - 64 KB)

Field Names - LAD22CD, LAD22NM, CTRY22CD, CTRY22NM

Field Types - Text, Text, Text, Text

Field Lengths - 9, 36, 9, 16
Publisher name: Office for National Statistics
Last updated: 2024-12-10T02:29:41Z

@ukgov.local_authority_district_to_country_december_2022_look_39274545.table_1

CREATE TABLE table_1 (
  "lad22cd" VARCHAR,
  "lad22nm" VARCHAR,
  "ctry22cd" VARCHAR,
  "ctry22nm" VARCHAR,
  "objectid" BIGINT
);