Baselight
Sign In

Covid-19 Case In Malaysia

Dataset retrieved from Malaysia's Ministry of Health

@kaggle.viviansam_covid_19_case_in_malaysia

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

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

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

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

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

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

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

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