Borough Council Election Results 2018

Greater London Authority

@ukgov.borough_council_election_results_2018

Table List

2 tables(183.55 KB)

Votes By Candidate

@ukgov.borough_council_election_results_2018.votes_by_candidate

149.45 KB
6554 rows
10 columns

ward_code Ward Code	ward_name Ward Name	borough_code Borough Code	borough_name Borough Name	candidate_name Candidate Name	party Party	party_long Party Long	number_votes Number Votes	elected_flag Elected Flag	number_of_councillors_in_ward Number Of Councillors In Ward
E05000026	Abbey	E09000002	Barking and Dagenham	Butt, Laila *	LAB	Labour Party	2169	Yes	3
E05000026	Abbey	E09000002	Barking and Dagenham	Rodwell, Darren J.	LAB	Labour Party	2086	Yes	3
E05000026	Abbey	E09000002	Barking and Dagenham	Miah, Giasuddin M. *	LAB	Labour Party	2043	Yes	3
E05000026	Abbey	E09000002	Barking and Dagenham	Manish Wankhade, Archanna	CON	Conservative Party	382		3
E05000026	Abbey	E09000002	Barking and Dagenham	Naqvi, Syed N.R.	CON	Conservative Party	362		3
E05000026	Abbey	E09000002	Barking and Dagenham	Panchardcharam, Kresan	CON	Conservative Party	353		3
E05000027	Alibon	E09000002	Barking and Dagenham	Dulwich, John S.	LAB	Labour Party	1350	Yes	3
E05000027	Alibon	E09000002	Barking and Dagenham	Robinson, Paul D.	LAB	Labour Party	1306	Yes	3
E05000027	Alibon	E09000002	Barking and Dagenham	Alasia, Sanchia A. *	LAB	Labour Party	1281	Yes	3
E05000027	Alibon	E09000002	Barking and Dagenham	Syers, Keith T.	CON	Conservative Party	480		3


CREATE TABLE votes_by_candidate (
  "ward_code" VARCHAR,
  "ward_name" VARCHAR,
  "borough_code" VARCHAR,
  "borough_name" VARCHAR,
  "candidate_name" VARCHAR,
  "party" VARCHAR,
  "party_long" VARCHAR,
  "number_votes" VARCHAR,
  "elected_flag" VARCHAR,
  "number_of_councillors_in_ward" BIGINT
);