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

Office for National Statistics

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__d51d685f

Table List

1 table(283.06 KB)

Table 1

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__d51d685f.table_1

283.06 KB
9344 rows
13 columns

wd23cd WD23CD	wd23nm WD23NM	pcon23cd PCON23CD	pcon23nm PCON23NM	lad23cd LAD23CD	lad23nm LAD23NM	utla23cd UTLA23CD	utla23nm UTLA23NM	objectid ObjectId
E05013038	Burn Valley	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	1
E05013039	De Bruce	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	2
E05013040	Fens & Greatham	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	3
E05013041	Foggy Furze	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	4
E05013042	Hart	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	5
E05013043	Headland & Harbour	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	6
E05013044	Manor House	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	7
E05013045	Rossmere	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	8
E05013046	Rural West	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	9
E05013047	Seaton	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	10


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
);