Baselight

Malaysia General Election Datasets

Malaysia General Election Results (GE12-GE15)

@kaggle.jjean95_malaysia_general_election_datasets

Loading...
Loading...

About this Dataset

Malaysia General Election Datasets

Data from Thevesh's Github

The dataset contains election results from

  • GE 12 (2008)
  • GE 13 (2013)
  • GE 14 (2018)
  • GE 15 (2022)

candidates_ge12.csv to candidates_ge15.csv contains candidates details

results_parlimen_ge12.csv to results_parlimen_ge12.csv contains voting information

Tables

Candidates Ge12

@kaggle.jjean95_malaysia_general_election_datasets.candidates_ge12
  • 22.25 KB
  • 480 rows
  • 11 columns
Loading...

CREATE TABLE candidates_ge12 (
  "state" VARCHAR,
  "parlimen" VARCHAR,
  "ballot_order" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "sex" VARCHAR,
  "ethnicity" VARCHAR,
  "party" VARCHAR,
  "votes" BIGINT,
  "result" BIGINT,
  "result_desc" VARCHAR
);

Candidates Ge13

@kaggle.jjean95_malaysia_general_election_datasets.candidates_ge13
  • 25.13 KB
  • 579 rows
  • 11 columns
Loading...

CREATE TABLE candidates_ge13 (
  "state" VARCHAR,
  "parlimen" VARCHAR,
  "ballot_order" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "sex" VARCHAR,
  "ethnicity" VARCHAR,
  "party" VARCHAR,
  "votes" BIGINT,
  "result" BIGINT,
  "result_desc" VARCHAR
);

Candidates Ge14

@kaggle.jjean95_malaysia_general_election_datasets.candidates_ge14
  • 27.92 KB
  • 687 rows
  • 11 columns
Loading...

CREATE TABLE candidates_ge14 (
  "state" VARCHAR,
  "parlimen" VARCHAR,
  "ballot_order" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "sex" VARCHAR,
  "ethnicity" VARCHAR,
  "party" VARCHAR,
  "votes" BIGINT,
  "result" BIGINT,
  "result_desc" VARCHAR
);

Candidates Ge15

@kaggle.jjean95_malaysia_general_election_datasets.candidates_ge15
  • 51.65 KB
  • 945 rows
  • 13 columns
Loading...

CREATE TABLE candidates_ge15 (
  "state" VARCHAR,
  "parlimen" VARCHAR,
  "ballot_order" BIGINT,
  "name" VARCHAR,
  "name_display" VARCHAR,
  "age" DOUBLE,
  "sex" VARCHAR,
  "ethnicity" VARCHAR,
  "party" VARCHAR,
  "votes" BIGINT,
  "result" BIGINT,
  "result_desc" VARCHAR,
  "new_mp" BIGINT
);

Census Dun

@kaggle.jjean95_malaysia_general_election_datasets.census_dun
  • 139.07 KB
  • 600 rows
  • 55 columns
Loading...

CREATE TABLE census_dun (
  "state" VARCHAR,
  "parlimen" VARCHAR,
  "dun" VARCHAR,
  "code_state" BIGINT,
  "code_parlimen" VARCHAR,
  "code_dun" VARCHAR,
  "code_state_dun" VARCHAR,
  "year" BIGINT,
  "area_km2" BIGINT,
  "population_total" BIGINT,
  "nationality_citizen" BIGINT,
  "nationality_non_citizen" BIGINT,
  "sex_male" BIGINT,
  "sex_female" BIGINT,
  "ethnicity_proportion_bumi" DOUBLE,
  "ethnicity_proportion_chinese" DOUBLE,
  "ethnicity_proportion_indian" DOUBLE,
  "ethnicity_proportion_other" DOUBLE,
  "age_proportion_0_14" DOUBLE,
  "age_proportion_15_64" DOUBLE,
  "age_proportion_65_above" DOUBLE,
  "age_proportion_18_above" DOUBLE,
  "housing_total" BIGINT,
  "household_total" BIGINT,
  "household_size_avg" DOUBLE,
  "live_births" BIGINT,
  "live_births_male" BIGINT,
  "live_births_female" BIGINT,
  "deaths" BIGINT,
  "deaths_male" BIGINT,
  "deaths_female" BIGINT,
  "labour_participation_rate" DOUBLE,
  "labour_unemployment_rate" DOUBLE,
  "income_median" BIGINT,
  "income_avg" BIGINT,
  "expenditure_avg" BIGINT,
  "gini" DOUBLE,
  "poverty_incidence" DOUBLE,
  "sme_small" DOUBLE,
  "sme_micro" BIGINT,
  "sme_medium" DOUBLE,
  "businesses_agriculture" BIGINT,
  "businesses_crops" BIGINT,
  "businesses_livestock" BIGINT,
  "businesses_fisheries" BIGINT,
  "businesses_forestry" BIGINT,
  "businesses_mining" BIGINT,
  "businesses_manufacturing" BIGINT,
  "businesses_construction" BIGINT,
  "businesses_services" BIGINT,
  "utilities_pipedwater_home" DOUBLE,
  "utilities_pipedwater_public" DOUBLE,
  "utilities_pipedwater_other" DOUBLE,
  "utilities_electricity_home" DOUBLE,
  "utilities_electricity_none" DOUBLE
);

Census Parlimen

@kaggle.jjean95_malaysia_general_election_datasets.census_parlimen
  • 86.26 KB
  • 222 rows
  • 52 columns
Loading...

CREATE TABLE census_parlimen (
  "state" VARCHAR,
  "parlimen" VARCHAR,
  "code_state" BIGINT,
  "code_parlimen" VARCHAR,
  "year" BIGINT,
  "area_km2" BIGINT,
  "population_total" BIGINT,
  "nationality_citizen" BIGINT,
  "nationality_non_citizen" BIGINT,
  "sex_male" BIGINT,
  "sex_female" BIGINT,
  "ethnicity_proportion_bumi" DOUBLE,
  "ethnicity_proportion_chinese" DOUBLE,
  "ethnicity_proportion_indian" DOUBLE,
  "ethnicity_proportion_other" DOUBLE,
  "age_proportion_0_14" DOUBLE,
  "age_proportion_15_64" DOUBLE,
  "age_proportion_65_above" DOUBLE,
  "age_proportion_18_above" DOUBLE,
  "housing_total" BIGINT,
  "household_total" BIGINT,
  "household_size_avg" DOUBLE,
  "live_births" BIGINT,
  "live_births_male" BIGINT,
  "live_births_female" BIGINT,
  "deaths" BIGINT,
  "deaths_male" BIGINT,
  "deaths_female" BIGINT,
  "labour_participation_rate" DOUBLE,
  "labour_unemployment_rate" DOUBLE,
  "income_median" BIGINT,
  "income_avg" BIGINT,
  "expenditure_avg" BIGINT,
  "gini" DOUBLE,
  "poverty_incidence" DOUBLE,
  "sme_small" DOUBLE,
  "sme_micro" BIGINT,
  "sme_medium" BIGINT,
  "businesses_agriculture" BIGINT,
  "businesses_crops" BIGINT,
  "businesses_livestock" BIGINT,
  "businesses_fisheries" BIGINT,
  "businesses_forestry" BIGINT,
  "businesses_mining" BIGINT,
  "businesses_manufacturing" BIGINT,
  "businesses_construction" BIGINT,
  "businesses_services" BIGINT,
  "utilities_pipedwater_home" DOUBLE,
  "utilities_pipedwater_public" DOUBLE,
  "utilities_pipedwater_other" DOUBLE,
  "utilities_electricity_home" DOUBLE,
  "utilities_electricity_none" DOUBLE
);

Results Parlimen Ge12

@kaggle.jjean95_malaysia_general_election_datasets.results_parlimen_ge12
  • 29.93 KB
  • 222 rows
  • 14 columns
Loading...

CREATE TABLE results_parlimen_ge12 (
  "state" VARCHAR,
  "parlimen" VARCHAR,
  "undi_keluar_peti" DOUBLE,
  "undi_dalam_peti" DOUBLE,
  "undi_tak_kembali" DOUBLE,
  "undi_tolak" DOUBLE,
  "majoriti" DOUBLE,
  "peratus_keluar" DOUBLE,
  "undi_rosak" DOUBLE,
  "pengundi_jumlah" DOUBLE,
  "pengundi_tidak_hadir" DOUBLE,
  "rosak_vs_keseluruhan" DOUBLE,
  "rosak_vs_majoriti" DOUBLE,
  "tidakhadir_vs_majoriti" DOUBLE
);

Results Parlimen Ge13

@kaggle.jjean95_malaysia_general_election_datasets.results_parlimen_ge13
  • 29.24 KB
  • 222 rows
  • 14 columns
Loading...

CREATE TABLE results_parlimen_ge13 (
  "state" VARCHAR,
  "parlimen" VARCHAR,
  "undi_keluar_peti" BIGINT,
  "undi_dalam_peti" BIGINT,
  "undi_tak_kembali" BIGINT,
  "undi_tolak" BIGINT,
  "majoriti" BIGINT,
  "peratus_keluar" DOUBLE,
  "undi_rosak" BIGINT,
  "pengundi_jumlah" BIGINT,
  "pengundi_tidak_hadir" BIGINT,
  "rosak_vs_keseluruhan" DOUBLE,
  "rosak_vs_majoriti" DOUBLE,
  "tidakhadir_vs_majoriti" DOUBLE
);

Results Parlimen Ge14

@kaggle.jjean95_malaysia_general_election_datasets.results_parlimen_ge14
  • 29.51 KB
  • 222 rows
  • 14 columns
Loading...

CREATE TABLE results_parlimen_ge14 (
  "state" VARCHAR,
  "parlimen" VARCHAR,
  "undi_keluar_peti" BIGINT,
  "undi_dalam_peti" BIGINT,
  "undi_tak_kembali" BIGINT,
  "undi_tolak" BIGINT,
  "majoriti" BIGINT,
  "peratus_keluar" DOUBLE,
  "undi_rosak" BIGINT,
  "pengundi_jumlah" BIGINT,
  "pengundi_tidak_hadir" BIGINT,
  "rosak_vs_keseluruhan" DOUBLE,
  "rosak_vs_majoriti" DOUBLE,
  "tidakhadir_vs_majoriti" DOUBLE
);

Results Parlimen Ge15

@kaggle.jjean95_malaysia_general_election_datasets.results_parlimen_ge15
  • 31.17 KB
  • 222 rows
  • 14 columns
Loading...

CREATE TABLE results_parlimen_ge15 (
  "state" VARCHAR,
  "parlimen" VARCHAR,
  "undi_keluar_peti" DOUBLE,
  "undi_dalam_peti" DOUBLE,
  "undi_tak_kembali" DOUBLE,
  "undi_tolak" DOUBLE,
  "majoriti" DOUBLE,
  "peratus_keluar" DOUBLE,
  "undi_rosak" DOUBLE,
  "pengundi_jumlah" BIGINT,
  "pengundi_tidak_hadir" DOUBLE,
  "rosak_vs_keseluruhan" DOUBLE,
  "rosak_vs_majoriti" DOUBLE,
  "tidakhadir_vs_majoriti" DOUBLE
);

Voters Ge15

@kaggle.jjean95_malaysia_general_election_datasets.voters_ge15
  • 91.6 KB
  • 613 rows
  • 27 columns
Loading...

CREATE TABLE voters_ge15 (
  "state" VARCHAR,
  "parlimen" VARCHAR,
  "dun" VARCHAR,
  "total" BIGINT,
  "male_18_20" BIGINT,
  "female_18_20" BIGINT,
  "male_21_29" BIGINT,
  "female_21_29" BIGINT,
  "male_30_39" BIGINT,
  "female_30_39" BIGINT,
  "male_40_49" BIGINT,
  "female_40_49" BIGINT,
  "male_50_59" BIGINT,
  "female_50_59" BIGINT,
  "male_60_69" BIGINT,
  "female_60_69" BIGINT,
  "male_70_79" BIGINT,
  "female_70_79" BIGINT,
  "male_80_89" BIGINT,
  "female_80_89" BIGINT,
  "male_90" BIGINT,
  "female_90" BIGINT,
  "votertype_regular" BIGINT,
  "votertype_early_army" BIGINT,
  "votertype_early_police" BIGINT,
  "votertype_postal_overseas" BIGINT,
  "total_ge14" DOUBLE
);

Share link

Anyone who has the link will be able to view this.