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

Office for National Statistics

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__7265994e

Table List

1 table(276.39 KB)

Table 1

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__7265994e.table_1

276.39 KB
9578 rows
9 columns

wd17cd WD17CD	wd17nm WD17NM	pcon17cd PCON17CD	pcon17nm PCON17NM	lad17cd LAD17CD	lad17nm LAD17NM	utla17cd UTLA17CD	utla17nm UTLA17NM	fid FID
E05001621	Bastwell	E14000570	Blackburn	E06000008	Blackburn with Darwen	E06000008	Blackburn with Darwen	1
E05001518	Ormesby	E14000891	Redcar	E06000003	Redcar and Cleveland	E06000003	Redcar and Cleveland	2
E05008942	Burn Valley	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	3
E05001622	Beardwood with Lammack	E14000570	Blackburn	E06000008	Blackburn with Darwen	E06000008	Blackburn with Darwen	4
E05008943	De Bruce	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	5
E05001519	St Germain's	E14000891	Redcar	E06000003	Redcar and Cleveland	E06000003	Redcar and Cleveland	6
E05001623	Corporation Park	E14000570	Blackburn	E06000008	Blackburn with Darwen	E06000008	Blackburn with Darwen	7
E05008944	Fens and Rossmere	E14000733	Hartlepool	E06000001	Hartlepool	E06000001	Hartlepool	8
E05001522	South Bank	E14000891	Redcar	E06000003	Redcar and Cleveland	E06000003	Redcar and Cleveland	9
E05001626	Ewood	E14000570	Blackburn	E06000008	Blackburn with Darwen	E06000008	Blackburn with Darwen	10


CREATE TABLE table_1 (
  "wd17cd" VARCHAR,
  "wd17nm" VARCHAR,
  "pcon17cd" VARCHAR,
  "pcon17nm" VARCHAR,
  "lad17cd" VARCHAR,
  "lad17nm" VARCHAR,
  "utla17cd" VARCHAR,
  "utla17nm" VARCHAR,
  "fid" BIGINT
);