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

Field Names - LAD17CD, LAD17NM, CTRY17CD, CTRY17NM

Field Types - Text, Text, Text, Text

Field Lengths - 9, 36, 9, 17

@ukgov.local_authority_district_to_country_december_2017_look_96c671f4.table_1

CREATE TABLE table_1 (
  "lad17cd" VARCHAR,
  "lad17nm" VARCHAR,
  "ctry17cd" VARCHAR,
  "ctry17nm" VARCHAR,
  "fid" BIGINT
);