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

Office for National Statistics

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__e9c1dd6d

Table List

1 table(269.41 KB)

Table 1

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__e9c1dd6d.table_1

269.41 KB
9511 rows
9 columns

wd19cd WD19CD	wd19nm WD19NM	pcon19cd PCON19CD	pcon19nm PCON19NM	lad19cd LAD19CD	lad19nm LAD19NM	utla19cd UTLA19CD	utla19nm UTLA19NM	fid FID
E05001714	East Marsh	E14000716	Great Grimsby	E06000012	North East Lincolnshire	E06000012	North East Lincolnshire	1
E05001715	Freshney	E14000716	Great Grimsby	E06000012	North East Lincolnshire	E06000012	North East Lincolnshire	2
E05001717	Heneage	E14000716	Great Grimsby	E06000012	North East Lincolnshire	E06000012	North East Lincolnshire	3
E05001720	Park	E14000716	Great Grimsby	E06000012	North East Lincolnshire	E06000012	North East Lincolnshire	4
E05001721	Scartho	E14000716	Great Grimsby	E06000012	North East Lincolnshire	E06000012	North East Lincolnshire	5
E05001723	South	E14000716	Great Grimsby	E06000012	North East Lincolnshire	E06000012	North East Lincolnshire	6
E05001725	West Marsh	E14000716	Great Grimsby	E06000012	North East Lincolnshire	E06000012	North East Lincolnshire	7
E05001727	Yarborough	E14000716	Great Grimsby	E06000012	North East Lincolnshire	E06000012	North East Lincolnshire	8
E05001729	Axholme Central	E14000596	Brigg and Goole	E06000013	North Lincolnshire	E06000013	North Lincolnshire	9
E05001730	Axholme North	E14000596	Brigg and Goole	E06000013	North Lincolnshire	E06000013	North Lincolnshire	10


CREATE TABLE table_1 (
  "wd19cd" VARCHAR,
  "wd19nm" VARCHAR,
  "pcon19cd" VARCHAR,
  "pcon19nm" VARCHAR,
  "lad19cd" VARCHAR,
  "lad19nm" VARCHAR,
  "utla19cd" VARCHAR,
  "utla19nm" VARCHAR,
  "fid" BIGINT
);