Name: Election Results - General
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Election Results - General

This dataset provides information on general elections in Leeds. You can find details of candidates, the parties they represent, and the number of votes they received.
Publisher name: Leeds City Council
Last updated: 2022-07-01T04:02:59Z

Tables

2010 - Results

@ukgov.election_results_general.n_2010_results

8.78 kB
47 rows
10 columns

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

2015 - Results

@ukgov.election_results_general.n_2015_results

12.52 kB
48 rows
14 columns

CREATE TABLE n_2015_results (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "election_year" BIGINT,
  "election_type" VARCHAR,
  "ward_name" VARCHAR,
  "surname" VARCHAR,
  "forename" VARCHAR,
  "description" VARCHAR,
  "votes" BIGINT,
  "elected" VARCHAR,
  "electorate" BIGINT
);

2017 - Results

@ukgov.election_results_general.n_2017_results

28.4 kB
43 rows
33 columns

CREATE TABLE n_2017_results (
  "publicationdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "electiondate" TIMESTAMP,
  "typeofelection" VARCHAR,
  "electedbodyuri" VARCHAR,
  "electedbodylabel" VARCHAR,
  "electoralareauri" VARCHAR,
  "electoralarealabel" VARCHAR,
  "candidatesurname" VARCHAR,
  "candidateforenames" VARCHAR,
  "commonlyusedsurname" VARCHAR,
  "commonlyusedforenames" VARCHAR,
  "politicalpartyuri" VARCHAR,
  "politicalpartylabel" VARCHAR,
  "candidatesdescription" VARCHAR,
  "voteswon" BIGINT,
  "elected" VARCHAR,
  "votescast" BIGINT,
  "eligibleelectorate" BIGINT,
  "ballotsrejectedofficialmark" BIGINT,
  "ballotsrejectedmultiplevote" BIGINT,
  "ballotsrejectedidentification" BIGINT,
  "ballotsrejectedinpart" BIGINT,
  "ballotsrejectedunmarked" BIGINT,
  "percentageturnout" DOUBLE,
  "infourl" VARCHAR,
  "returningofficer" VARCHAR,
  "electoraldept" VARCHAR,
  "contactemail" VARCHAR,
  "contacttel" VARCHAR
);

2017 - Turnout

@ukgov.election_results_general.n_2017_turnout

19.24 kB
379 rows
12 columns

CREATE TABLE n_2017_turnout (
  "polling_station_box_no" VARCHAR  -- Polling Station Box No.,
  "polling_district_s" VARCHAR  -- Polling District(s),
  "ward" VARCHAR,
  "constituency" VARCHAR,
  "electorate" BIGINT,
  "votes_cast" BIGINT,
  "n__turnout" VARCHAR  -- % Turnout,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);