Ward To Westminster Parliamentary Constituency To LAD To UTLA (July 2024) Lookup In UK

Office for National Statistics

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__34c26b17

Table List

1 table(288.23 KB)

Table 1

@ukgov.ward_to_westminster_parliamentary_constituency_to_lad__34c26b17.table_1

288.23 KB
8798 rows
14 columns

wd24cd WD24CD	wd24nm WD24NM	pcon24cd PCON24CD	pcon24nm PCON24NM	lad24cd LAD24CD	lad24nm LAD24NM	utla24cd UTLA24CD	utla24nm UTLA24NM	objectid ObjectId
E05009352	Blackwater and Hawley	E14001063	Aldershot	E07000089	Hart	E10000014	Hampshire	1
E05009361	Yateley East	E14001063	Aldershot	E07000089	Hart	E10000014	Hampshire	2
E05008989	Aldershot Park	E14001063	Aldershot	E07000092	Rushmoor	E10000014	Hampshire	3
E05008990	Cherrywood	E14001063	Aldershot	E07000092	Rushmoor	E10000014	Hampshire	4
E05008991	Cove and Southwood	E14001063	Aldershot	E07000092	Rushmoor	E10000014	Hampshire	5
E05008992	Empress	E14001063	Aldershot	E07000092	Rushmoor	E10000014	Hampshire	6
E05008993	Fernhill	E14001063	Aldershot	E07000092	Rushmoor	E10000014	Hampshire	7
E05008994	Knellwood	E14001063	Aldershot	E07000092	Rushmoor	E10000014	Hampshire	8
E05008995	Manor Park	E14001063	Aldershot	E07000092	Rushmoor	E10000014	Hampshire	9
E05008996	North Town	E14001063	Aldershot	E07000092	Rushmoor	E10000014	Hampshire	10


CREATE TABLE table_1 (
  "wd24cd" VARCHAR,
  "wd24nm" VARCHAR,
  "wd24nmw" VARCHAR,
  "pcon24cd" VARCHAR,
  "pcon24nm" VARCHAR,
  "pcon24nmw" VARCHAR,
  "lad24cd" VARCHAR,
  "lad24nm" VARCHAR,
  "lad24nmw" VARCHAR,
  "utla24cd" VARCHAR,
  "utla24nm" VARCHAR,
  "utla24nmw" VARCHAR,
  "split_ward" VARCHAR,
  "objectid" BIGINT
);