This file contains names and codes for the parishes and communities in England and Wales as at 31 December 2017. (File Size - 1 MB)

Field Names - PAR17CD, PAR17NM, PAR17NMW, LAD17CD, LAD17NM

Field Types - Text, Text, Text, Text, Text

Field Lengths - 9, 66, 42, 9, 36

@ukgov.parishes_december_2017_names_and_codes_in_ew.table_1

CREATE TABLE table_1 (
  "fid" BIGINT,
  "par17cd" VARCHAR,
  "par17nm" VARCHAR,
  "par17nmw" VARCHAR,
  "lad17cd" VARCHAR,
  "lad17nm" VARCHAR
);