Ward To Westminster Parliamentary Constituency To LAD To UTLA (Dec 2020) Lookup In UK (V2)

Office for National Statistics

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__61babf61

Table List

1 table(283.16 KB)

Table 1

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__61babf61.table_1

283.16 KB
9512 rows
9 columns

wd20cd WD20CD	wd20nm WD20NM	pcon20cd PCON20CD	pcon20nm PCON20NM	lad20cd LAD20CD	lad20nm LAD20NM	utla20cd UTLA20CD	utla20nm UTLA20NM	fid FID
E05000171	Cleveland	E14000675	Ealing North	E09000009	Ealing	E13000002	Outer London	1
E05000172	Dormers Wells	E14000676	Ealing, Southall	E09000009	Ealing	E13000002	Outer London	2
E05000173	Ealing Broadway	E14000674	Ealing Central and Acton	E09000009	Ealing	E13000002	Outer London	3
E05000174	Ealing Common	E14000674	Ealing Central and Acton	E09000009	Ealing	E13000002	Outer London	4
E05000175	East Acton	E14000674	Ealing Central and Acton	E09000009	Ealing	E13000002	Outer London	5
E05000176	Elthorne	E14000676	Ealing, Southall	E09000009	Ealing	E13000002	Outer London	6
E05000177	Greenford Broadway	E14000675	Ealing North	E09000009	Ealing	E13000002	Outer London	7
E05000178	Greenford Green	E14000675	Ealing North	E09000009	Ealing	E13000002	Outer London	8
E05000179	Hanger Hill	E14000674	Ealing Central and Acton	E09000009	Ealing	E13000002	Outer London	9
E05000180	Hobbayne	E14000675	Ealing North	E09000009	Ealing	E13000002	Outer London	10


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