Name: Elections - Parish And Town Councils
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Elections - Parish And Town Councils

This dataset lists all results concerning parish and town councils.
Publisher name: Leeds City Council
Last updated: 2022-07-01T04:03:00Z

Tables

2015

@ukgov.elections_parish_and_town_councils.n_2015

15.8 KB
168 rows
14 columns


CREATE TABLE n_2015 (
  "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
);

2019

@ukgov.elections_parish_and_town_councils.n_2019

11.93 KB
154 rows
10 columns


CREATE TABLE n_2019 (
  "title" VARCHAR,
  "wardname" VARCHAR,
  "partyname" VARCHAR,
  "surname" VARCHAR,
  "forename" VARCHAR,
  "votes" BIGINT,
  "elected" BOOLEAN,
  "electorate" BIGINT,
  "electionyear" BIGINT,
  "spoiltpapers" BIGINT
);

24/01/2013 - 22/05/2014

@ukgov.elections_parish_and_town_councils.n_24_01_2013_22_05_2014

13.61 KB
17 rows
18 columns


CREATE TABLE n_24_01_2013_22_05_2014 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "date" TIMESTAMP,
  "type" VARCHAR,
  "area" VARCHAR,
  "surname" VARCHAR,
  "forename" VARCHAR,
  "partyname" VARCHAR,
  "votes" VARCHAR,
  "spoiltpaper_a" VARCHAR,
  "spoiltpaper_b" DOUBLE,
  "spoiltpaper_c" VARCHAR,
  "spoiltpaper_d" DOUBLE,
  "elected" VARCHAR,
  "electorate" BIGINT
);