Name: Uk 2024 General Election Data
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Uk 2024 General Election Data

Data Scraped from Sky News Election Website and Winning members Data Provided by the House of Commons Library

One constituency (Inverness, Skye, and West Ross-shire) was yet to be called when this data was created, and therefore is missing from the data.

The data includes the names, political affiliations, and constituency names ,Vote margins, percentage, turnout.

Tables

Defeated Mps Friday 1720

@kaggle.kartik70_uk_2024_general_election_preliminary_data.defeated_mps_friday_1720

23.79 kB
217 rows
17 columns

CREATE TABLE defeated_mps_friday_1720 (
  "ons_id" VARCHAR,
  "constituency_name" VARCHAR,
  "region_name" VARCHAR,
  "country_name" VARCHAR,
  "constituency_type" VARCHAR,
  "time_recorded" VARCHAR,
  "result" VARCHAR,
  "party_abbreviation" VARCHAR,
  "party_name" VARCHAR,
  "title" VARCHAR,
  "firstname" VARCHAR,
  "surname" VARCHAR,
  "middlenames" VARCHAR,
  "mnis_id" BIGINT,
  "gender" VARCHAR,
  "defeated_mp" VARCHAR,
  "former_mp" VARCHAR
);

Uk 2024 General Election Data

@kaggle.kartik70_uk_2024_general_election_preliminary_data.uk_2024_general_election_data

221.85 kB
4,515 rows
18 columns

CREATE TABLE uk_2024_general_election_data (
  "ons_id" VARCHAR,
  "constituency" VARCHAR,
  "region_name" VARCHAR,
  "country_name" VARCHAR,
  "constituency_type" VARCHAR,
  "candidate_firstname" VARCHAR,
  "candidate_surname" VARCHAR,
  "party_abbreviation" VARCHAR,
  "party_name" VARCHAR,
  "party_displayname" VARCHAR,
  "votecount" BIGINT,
  "votepercentage" DOUBLE,
  "votepercentagechange" DOUBLE,
  "electorate_size" BIGINT,
  "turnout_perc" DOUBLE,
  "new_party" VARCHAR,
  "old_party" VARCHAR,
  "result" VARCHAR
);

Winning Members Friday 1720

@kaggle.kartik70_uk_2024_general_election_preliminary_data.winning_members_friday_1720

46.56 kB
649 rows
17 columns

CREATE TABLE winning_members_friday_1720 (
  "ons_id" VARCHAR,
  "constituency_name" VARCHAR,
  "region_name" VARCHAR,
  "country_name" VARCHAR,
  "constituency_type" VARCHAR,
  "time_recorded" VARCHAR,
  "result" VARCHAR,
  "party_abbreviation" VARCHAR,
  "party_name" VARCHAR,
  "title" VARCHAR,
  "firstname" VARCHAR,
  "surname" VARCHAR,
  "middlenames" VARCHAR,
  "mnis_id" DOUBLE,
  "gender" VARCHAR,
  "candidate_type" VARCHAR,
  "old_constituency" VARCHAR
);