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

289.85 kB
9,344 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
);