Ward To Westminster Parliamentary Constituencies To LAD (Dec 2020) Lookup In The UK (V2)

Office for National Statistics

@ukgov.ward_to_westminster_parliamentary_constituencies_to_la_6a9bf7c4

Table List

1 table(269.87 KB)

Table 1

@ukgov.ward_to_westminster_parliamentary_constituencies_to_la_6a9bf7c4.table_1

269.87 KB
9512 rows
7 columns

wd20cd WD20CD	wd20nm WD20NM	pcon20cd PCON20CD	pcon20nm PCON20NM	lad20cd LAD20CD	lad20nm LAD20NM	fid FID
E05009288	Aldersgate	E14000639	Cities of London and Westminster	E09000001	City of London	1
E05009289	Aldgate	E14000639	Cities of London and Westminster	E09000001	City of London	2
E05009290	Bassishaw	E14000639	Cities of London and Westminster	E09000001	City of London	3
E05009291	Billingsgate	E14000639	Cities of London and Westminster	E09000001	City of London	4
E05009292	Bishopsgate	E14000639	Cities of London and Westminster	E09000001	City of London	5
E05009293	Bread Street	E14000639	Cities of London and Westminster	E09000001	City of London	6
E05009294	Bridge	E14000639	Cities of London and Westminster	E09000001	City of London	7
E05009295	Broad Street	E14000639	Cities of London and Westminster	E09000001	City of London	8
E05009296	Candlewick	E14000639	Cities of London and Westminster	E09000001	City of London	9
E05009297	Castle Baynard	E14000639	Cities of London and Westminster	E09000001	City of London	10


CREATE TABLE table_1 (
  "wd20cd" VARCHAR,
  "wd20nm" VARCHAR,
  "pcon20cd" VARCHAR,
  "pcon20nm" VARCHAR,
  "lad20cd" VARCHAR,
  "lad20nm" VARCHAR,
  "fid" BIGINT
);