Dataset: Uk 2024 General Election Data

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.24 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

216.65 KB
4515 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

45.47 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
);