Name: Covid-19 Case In Malaysia
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Covid-19 Case In Malaysia

Retrieved from Official Github account of Malaysia's Ministry of Health on 04-Aug-2023.

Imported database :

cases_state.csv: Daily recorded COVID-19 cases at state level.
deaths_state.csv: Daily deaths due to COVID-19 at state level.
hospital.csv: Flow of patients to/out of hospitals, with capacity and utilisation.
icu.csv: Capacity and utilisation of intensive care unit (ICU) beds.
vax_state.csv: Vaccinations (daily and cumulative, by dose type and brand) at state level.
vax_malaysia.csv: Vaccinations (daily and cumulative, by dose type and brand) at country level.
population.csv Malaysia's population by state (last updated from DOSM 2020 census, as published in 2022).

Database mainly focused on state-level analysis only.

Full available datasets from MOH (including country-level data) please refer to link above.

Tables

Cases State

@kaggle.viviansam_covid_19_case_in_malaysia.cases_state

530.62 KB
20512 rows
25 columns


CREATE TABLE cases_state (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "cases_new" BIGINT,
  "cases_import" BIGINT,
  "cases_recovered" BIGINT,
  "cases_active" BIGINT,
  "cases_cluster" BIGINT,
  "cases_unvax" BIGINT,
  "cases_pvax" BIGINT,
  "cases_fvax" BIGINT,
  "cases_boost" BIGINT,
  "cases_child" BIGINT,
  "cases_adolescent" BIGINT,
  "cases_adult" BIGINT,
  "cases_elderly" BIGINT,
  "cases_0_4" BIGINT,
  "cases_5_11" BIGINT,
  "cases_12_17" BIGINT,
  "cases_18_29" BIGINT,
  "cases_30_39" BIGINT,
  "cases_40_49" BIGINT,
  "cases_50_59" BIGINT,
  "cases_60_69" BIGINT,
  "cases_70_79" BIGINT,
  "cases_80" BIGINT
);

Deaths State

@kaggle.viviansam_covid_19_case_in_malaysia.deaths_state

71.76 KB
19680 rows
11 columns


CREATE TABLE deaths_state (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "deaths_new" BIGINT,
  "deaths_bid" BIGINT,
  "deaths_new_dod" BIGINT,
  "deaths_bid_dod" BIGINT,
  "deaths_unvax" BIGINT,
  "deaths_pvax" BIGINT,
  "deaths_fvax" BIGINT,
  "deaths_boost" BIGINT,
  "deaths_tat" BIGINT
);

Hospital

@kaggle.viviansam_covid_19_case_in_malaysia.hospital

274.96 KB
19155 rows
14 columns


CREATE TABLE hospital (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "beds" BIGINT,
  "beds_covid" BIGINT,
  "beds_noncrit" BIGINT,
  "admitted_pui" BIGINT,
  "admitted_covid" BIGINT,
  "admitted_total" BIGINT,
  "discharged_pui" BIGINT,
  "discharged_covid" BIGINT,
  "discharged_total" BIGINT,
  "hosp_covid" BIGINT,
  "hosp_pui" BIGINT,
  "hosp_noncovid" BIGINT
);

Icu

@kaggle.viviansam_covid_19_case_in_malaysia.icu

147.25 KB
19175 rows
16 columns


CREATE TABLE icu (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "beds_icu" BIGINT,
  "beds_icu_rep" BIGINT,
  "beds_icu_total" BIGINT,
  "beds_icu_covid" BIGINT,
  "vent" BIGINT,
  "vent_port" BIGINT,
  "icu_covid" BIGINT,
  "icu_pui" BIGINT,
  "icu_noncovid" BIGINT,
  "vent_covid" BIGINT,
  "vent_pui" BIGINT,
  "vent_noncovid" BIGINT,
  "vent_used" BIGINT,
  "vent_port_used" BIGINT
);

Population

@kaggle.viviansam_covid_19_case_in_malaysia.population

5.99 KB
18 rows
7 columns


CREATE TABLE population (
  "state" VARCHAR,
  "idxs" BIGINT,
  "pop" BIGINT,
  "pop_18" BIGINT,
  "pop_60" BIGINT,
  "pop_12" BIGINT,
  "pop_5" BIGINT
);

Vax Malaysia

@kaggle.viviansam_covid_19_case_in_malaysia.vax_malaysia

160.08 KB
891 rows
50 columns


CREATE TABLE vax_malaysia (
  "date" TIMESTAMP,
  "daily_partial" BIGINT,
  "daily_full" BIGINT,
  "daily_booster" BIGINT,
  "daily_booster2" BIGINT,
  "daily" BIGINT,
  "daily_partial_adol" BIGINT,
  "daily_full_adol" BIGINT,
  "daily_booster_adol" BIGINT,
  "daily_booster2_adol" BIGINT,
  "daily_partial_child" BIGINT,
  "daily_full_child" BIGINT,
  "daily_booster_child" BIGINT,
  "daily_booster2_child" BIGINT,
  "cumul_partial" BIGINT,
  "cumul_full" BIGINT,
  "cumul_booster" BIGINT,
  "cumul_booster2" BIGINT,
  "cumul" BIGINT,
  "cumul_partial_adol" BIGINT,
  "cumul_full_adol" BIGINT,
  "cumul_booster_adol" BIGINT,
  "cumul_booster2_adol" BIGINT,
  "cumul_partial_child" BIGINT,
  "cumul_full_child" BIGINT,
  "cumul_booster_child" BIGINT,
  "cumul_booster2_child" BIGINT,
  "pfizer1" BIGINT,
  "pfizer2" BIGINT,
  "pfizer3" BIGINT,
  "pfizer4" BIGINT,
  "sinovac1" BIGINT,
  "sinovac2" BIGINT,
  "sinovac3" BIGINT,
  "sinovac4" BIGINT,
  "astra1" BIGINT,
  "astra2" BIGINT,
  "astra3" BIGINT,
  "astra4" BIGINT,
  "sinopharm1" BIGINT,
  "sinopharm2" BIGINT,
  "sinopharm3" BIGINT,
  "sinopharm4" BIGINT,
  "cansino" BIGINT,
  "cansino3" BIGINT,
  "cansino4" BIGINT,
  "pending1" BIGINT,
  "pending2" BIGINT,
  "pending3" BIGINT,
  "pending4" BIGINT
);

Vax State

@kaggle.viviansam_covid_19_case_in_malaysia.vax_state

1.02 MB
14256 rows
51 columns


CREATE TABLE vax_state (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "daily_partial" BIGINT,
  "daily_full" BIGINT,
  "daily_booster" BIGINT,
  "daily_booster2" BIGINT,
  "daily" BIGINT,
  "daily_partial_adol" BIGINT,
  "daily_full_adol" BIGINT,
  "daily_booster_adol" BIGINT,
  "daily_booster2_adol" BIGINT,
  "daily_partial_child" BIGINT,
  "daily_full_child" BIGINT,
  "daily_booster_child" BIGINT,
  "daily_booster2_child" BIGINT,
  "cumul_partial" BIGINT,
  "cumul_full" BIGINT,
  "cumul_booster" BIGINT,
  "cumul_booster2" BIGINT,
  "cumul" BIGINT,
  "cumul_partial_adol" BIGINT,
  "cumul_full_adol" BIGINT,
  "cumul_booster_adol" BIGINT,
  "cumul_booster2_adol" BIGINT,
  "cumul_partial_child" BIGINT,
  "cumul_full_child" BIGINT,
  "cumul_booster_child" BIGINT,
  "cumul_booster2_child" BIGINT,
  "pfizer1" BIGINT,
  "pfizer2" BIGINT,
  "pfizer3" BIGINT,
  "pfizer4" BIGINT,
  "sinovac1" BIGINT,
  "sinovac2" BIGINT,
  "sinovac3" BIGINT,
  "sinovac4" BIGINT,
  "astra1" BIGINT,
  "astra2" BIGINT,
  "astra3" BIGINT,
  "astra4" BIGINT,
  "sinopharm1" BIGINT,
  "sinopharm2" BIGINT,
  "sinopharm3" BIGINT,
  "sinopharm4" BIGINT,
  "cansino" BIGINT,
  "cansino3" BIGINT,
  "cansino4" BIGINT,
  "pending1" BIGINT,
  "pending2" BIGINT,
  "pending3" BIGINT,
  "pending4" BIGINT
);