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

Office for National Statistics

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__2f828b3f

Table List

1 table(257.76 KB)

Table 1

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__2f828b3f.table_1

257.76 KB
9272 rows
9 columns

wd22cd WD22CD	wd22nm WD22NM	pcon22cd PCON22CD	pcon22nm PCON22NM	lad22cd LAD22CD	lad22nm LAD22NM	utla22cd UTLA22CD	utla22nm UTLA22NM	objectid ObjectId
E05011545	West Carr	E14000771	Kingston upon Hull East	E06000010	Kingston upon Hull, City of	E06000010	Kingston upon Hull, City of	1
E05011525	Avenue	E14000772	Kingston upon Hull North	E06000010	Kingston upon Hull, City of	E06000010	Kingston upon Hull, City of	2
E05011526	Beverley & Newland	E14000772	Kingston upon Hull North	E06000010	Kingston upon Hull, City of	E06000010	Kingston upon Hull, City of	3
E05011528	Bricknell	E14000772	Kingston upon Hull North	E06000010	Kingston upon Hull, City of	E06000010	Kingston upon Hull, City of	4
E05011529	Central	E14000772	Kingston upon Hull North	E06000010	Kingston upon Hull, City of	E06000010	Kingston upon Hull, City of	5
E05011534	Kingswood	E14000772	Kingston upon Hull North	E06000010	Kingston upon Hull, City of	E06000010	Kingston upon Hull, City of	6
E05011538	North Carr	E14000772	Kingston upon Hull North	E06000010	Kingston upon Hull, City of	E06000010	Kingston upon Hull, City of	7
E05011539	Orchard Park	E14000772	Kingston upon Hull North	E06000010	Kingston upon Hull, City of	E06000010	Kingston upon Hull, City of	8
E05011543	Sutton	E14000772	Kingston upon Hull North	E06000010	Kingston upon Hull, City of	E06000010	Kingston upon Hull, City of	9
E05011544	University	E14000772	Kingston upon Hull North	E06000010	Kingston upon Hull, City of	E06000010	Kingston upon Hull, City of	10


CREATE TABLE table_1 (
  "wd22cd" VARCHAR,
  "wd22nm" VARCHAR,
  "pcon22cd" VARCHAR,
  "pcon22nm" VARCHAR,
  "lad22cd" VARCHAR,
  "lad22nm" VARCHAR,
  "utla22cd" VARCHAR,
  "utla22nm" VARCHAR,
  "objectid" BIGINT
);