Malaysia General Election Datasets
Malaysia General Election Results (GE12-GE15)
@kaggle.jjean95_malaysia_general_election_datasets
Malaysia General Election Results (GE12-GE15)
@kaggle.jjean95_malaysia_general_election_datasets
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
Anyone who has the link will be able to view this.