About this Dataset

Election Results - Local

This dataset provides information on local elections in Leeds. You can find details of candidates, the parties they represent, and the number of votes they received. Please note ----------- * There were no local elections held in Leeds in 2009, 2013 and 2020
Publisher name: Leeds City Council
Last updated: 2024-09-14T10:06:45Z

Tables

2006

@ukgov.election_results_local.n_2006

12.63 KB
161 rows
10 columns


CREATE TABLE n_2006 (
  "year" BIGINT,
  "type" VARCHAR,
  "area" VARCHAR,
  "surname" VARCHAR,
  "forename" VARCHAR,
  "partyname" VARCHAR,
  "votes" BIGINT,
  "spoiltpapers" BIGINT,
  "elected" VARCHAR,
  "electorate" BIGINT
);

2007

@ukgov.election_results_local.n_2007

13 KB
182 rows
10 columns


CREATE TABLE n_2007 (
  "year" BIGINT,
  "type" VARCHAR,
  "area" VARCHAR,
  "surname" VARCHAR,
  "forename" VARCHAR,
  "partyname" VARCHAR,
  "votes" BIGINT,
  "spoiltpapers" BIGINT,
  "elected" VARCHAR,
  "electorate" BIGINT
);

2010

@ukgov.election_results_local.n_2010

12.1 KB
169 rows
10 columns


CREATE TABLE n_2010 (
  "year" BIGINT,
  "type" VARCHAR,
  "area" VARCHAR,
  "surname" VARCHAR,
  "forename" VARCHAR,
  "partyname" VARCHAR,
  "votes" BIGINT,
  "spoiltpapers" VARCHAR,
  "elected" VARCHAR,
  "electorate" VARCHAR
);

2011

@ukgov.election_results_local.n_2011

11.48 KB
142 rows
10 columns


CREATE TABLE n_2011 (
  "year" BIGINT,
  "type" VARCHAR,
  "area" VARCHAR,
  "surname" VARCHAR,
  "forename" VARCHAR,
  "partyname" VARCHAR,
  "votes" BIGINT,
  "spoiltpapers" VARCHAR,
  "elected" VARCHAR,
  "electorate" BIGINT
);

2014

@ukgov.election_results_local.n_2014

12.53 KB
177 rows
10 columns


CREATE TABLE n_2014 (
  "year" BIGINT,
  "type" VARCHAR,
  "area" VARCHAR,
  "surname" VARCHAR,
  "forename" VARCHAR,
  "party_name" VARCHAR,
  "votes" BIGINT,
  "spoiltpapers" VARCHAR,
  "elected" VARCHAR,
  "electorate" BIGINT
);

2016

@ukgov.election_results_local.n_2016

24.65 KB
185 rows
23 columns


CREATE TABLE n_2016 (
  "publicationdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "electiondate" TIMESTAMP,
  "typeofelection" VARCHAR,
  "electedbodyuri" VARCHAR,
  "electedbodylabel" VARCHAR,
  "constituencyurl" VARCHAR,
  "constituencylabel" VARCHAR,
  "candidatename" VARCHAR,
  "politicalpartyuri" VARCHAR,
  "politicalpartylabel" VARCHAR,
  "voteswon" BIGINT,
  "elected" VARCHAR,
  "votescast" BIGINT,
  "sizeofelectorate" BIGINT,
  "rejected_invalid_votes" BIGINT,
  "electoralservices" VARCHAR,
  "reportemail" VARCHAR,
  "reporttel" VARCHAR,
  "notes" VARCHAR
);

2018

@ukgov.election_results_local.n_2018

17.96 KB
337 rows
12 columns


CREATE TABLE n_2018 (
  "title" VARCHAR,
  "wardname" VARCHAR,
  "partyname" VARCHAR,
  "surname" VARCHAR,
  "forename" VARCHAR,
  "votes" DOUBLE,
  "elected" VARCHAR,
  "electorate" DOUBLE,
  "turnout" DOUBLE,
  "electiontype" VARCHAR,
  "electionyear" DOUBLE,
  "spoiltpapers" DOUBLE
);

2021

@ukgov.election_results_local.n_2021

11.75 KB
184 rows
7 columns


CREATE TABLE n_2021 (
  "areaname" VARCHAR,
  "candidatesurname" VARCHAR,
  "candidateforename" VARCHAR,
  "knownas" VARCHAR,
  "candidatedescription" VARCHAR,
  "votes" BIGINT,
  "elected" BIGINT
);