This is a lookup file between wards and National Assembly for Wales constituencies in Wales as at 31st December 2017. (File size - 160KB).

Field Names - WD17CD, WD17NM, WD17NMW, NAWC17CD, NAWC17NM

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

Field Lengths - 9, 48, 45, 9, 39

@ukgov.ward_to_national_assembly_for_wales_constituency_decem_00175e1b.table_1

CREATE TABLE table_1 (
  "wd17cd" VARCHAR,
  "wd17nm" VARCHAR,
  "wd17nmw" VARCHAR,
  "nawc17cd" VARCHAR,
  "nawc17nm" VARCHAR,
  "fid" BIGINT
);