Dataset: Ward To Westminster Parliamentary Constituency To LAD To UTLA (Dec 2023) Lookup In The UK

About this Dataset

Ward To Westminster Parliamentary Constituency To LAD To UTLA (Dec 2023) Lookup In The UK

This file is a lookup between electoral wards/divisions, Westminster parliamentary constituencies, local authority districts and upper tier local authorities in the United Kingdom as at 31 December 2023. (File Size - 2.8 MB)

Field Names - WD23CD, WD23NM, WD23NMW, PCON23CD, PCON23NM, PCON23NMW, LAD23CD, LAD23NM, LAD23NMW, UTLA23CD, UTLA23NM, UTLA23NMW

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

Field Lengths - 9, 53, 45, 9, 41, 32, 9, 36, 24, 9, 36, 24
Publisher name: Office for National Statistics
Last updated: 2024-12-10T02:19:36Z

Tables

Table 1

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__d51d685f.table_1

283.06 KB
9344 rows
13 columns


CREATE TABLE table_1 (
  "wd23cd" VARCHAR,
  "wd23nm" VARCHAR,
  "wd23nmw" VARCHAR,
  "pcon23cd" VARCHAR,
  "pcon23nm" VARCHAR,
  "pcon23nmw" VARCHAR,
  "lad23cd" VARCHAR,
  "lad23nm" VARCHAR,
  "lad23nmw" VARCHAR,
  "utla23cd" VARCHAR,
  "utla23nm" VARCHAR,
  "utla23nmw" VARCHAR,
  "objectid" BIGINT
);