About this Dataset

Election Results

This dataset shows results of elections for County Councillors in Lincolnshire County Council elections. The details shown include voting results and turnout for each Electoral Division. Please note electoral divisions and their boundaries may be subject to changes over time. This dataset contains data for electoral divisions as they exist at the time of a county election. This data is provided by the Lincolnshire County Council Democratic Services team. This dataset is updated after each County Election. For any enquiries about this dataset please contact DemocraticServices@lincolnshire.gov.uk
Publisher name: Lincolnshire County Council
Last updated: 2024-09-14T09:18:10Z

Tables

Election Results

@ukgov.election_results1.election_results

59.13 KB
1980 rows
23 columns


CREATE TABLE election_results (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "latestdata" VARCHAR,
  "reportingperiodtype" VARCHAR,
  "reportingperiod" VARCHAR,
  "geo_entity_name" VARCHAR,
  "geo_code" VARCHAR,
  "geo_name" VARCHAR,
  "geo_uri" VARCHAR,
  "datacategory" VARCHAR,
  "elected" VARCHAR,
  "candidatename" VARCHAR,
  "partyname" VARCHAR,
  "votescount" VARCHAR,
  "votesharepercent" DOUBLE,
  "majorityvotescount" VARCHAR,
  "allvotestotal" DOUBLE,
  "electoratepersons" DOUBLE,
  "turnoutpercent" DOUBLE,
  "unnamed_22" VARCHAR
);

Table 1

@ukgov.election_results1.table_1

12.29 KB
22 rows
12 columns


CREATE TABLE table_1 (
  "dataset_id_dsid" BIGINT,
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR,
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);