Polling Station Locations
Leeds City Council
@ukgov.polling_station_locations
Leeds City Council
@ukgov.polling_station_locations
CREATE TABLE april_2015 (
"station_name" VARCHAR,
"station_add1" VARCHAR,
"station_add2" VARCHAR,
"station_add3" VARCHAR,
"station_add4" VARCHAR,
"station_add5" VARCHAR,
"station_pcode" VARCHAR,
"station_number" BIGINT,
"station_letters" VARCHAR,
"station_text" VARCHAR,
"main_election_level" VARCHAR,
"main_election_area" VARCHAR
);
CREATE TABLE april_2018 (
"reference" BIGINT,
"polling_place" VARCHAR,
"district_s" VARCHAR,
"elector_count" BIGINT,
"header_polling_place" VARCHAR,
"electiondescription" VARCHAR,
"electiondate" VARCHAR
);
CREATE TABLE february_2014 (
"premise_name" VARCHAR,
"premise_add1" VARCHAR,
"premise_add2" VARCHAR,
"premise_add3" VARCHAR,
"premise_add4" VARCHAR,
"premise_add5" VARCHAR,
"premise_postcode" VARCHAR,
"premise_code" VARCHAR,
"premise_code_desc" VARCHAR,
"access_difficulty" VARCHAR,
"station_number" BIGINT,
"station_text" VARCHAR,
"station_type" VARCHAR,
"station_type_desc" VARCHAR
);
CREATE TABLE february_2016 (
"station_name" VARCHAR,
"station_add1" VARCHAR,
"station_add2" VARCHAR,
"station_add3" VARCHAR,
"station_add4" VARCHAR,
"station_add5" VARCHAR,
"station_pcode" VARCHAR,
"station_number" BIGINT,
"station_letters" VARCHAR,
"station_text" VARCHAR,
"main_election_level" VARCHAR,
"main_election_area" VARCHAR
);
Anyone who has the link will be able to view this.