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.57 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.23 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

27.74 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

18.79 KB
379 rows
12 columns


CREATE TABLE n_2017_turnout (
  "polling_station_box_no" VARCHAR,
  "polling_district_s" VARCHAR,
  "ward" VARCHAR,
  "constituency" VARCHAR,
  "electorate" BIGINT,
  "votes_cast" BIGINT,
  "n__turnout" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR
);