CREATE TABLE vaccination (
  "date" TIMESTAMP,
  "dose1_perlis" BIGINT,
  "dose2_perlis" BIGINT,
  "dose1_kedah" BIGINT,
  "dose2_kedah" BIGINT,
  "dose1_penang" BIGINT,
  "dose2_penang" BIGINT,
  "dose1_perak" BIGINT,
  "dose2_perak" BIGINT,
  "dose1_selangor" BIGINT,
  "dose2_selangor" BIGINT,
  "dose1_kl" BIGINT,
  "dose2_kl" BIGINT,
  "dose1_putrajaya" BIGINT,
  "dose2_putrajaya" BIGINT,
  "dose1_ns" BIGINT,
  "dose2_ns" BIGINT,
  "dose1_melaka" BIGINT,
  "dose2_melaka" BIGINT,
  "dose1_kelantan" BIGINT,
  "dose2_kelantan" BIGINT,
  "dose1_terengganu" BIGINT,
  "dose2_terengganu" BIGINT,
  "dose1_pahang" BIGINT,
  "dose2_pahang" BIGINT,
  "dose1_johor" BIGINT,
  "dose2_johor" BIGINT,
  "dose1_sabah" BIGINT,
  "dose2_sabah" BIGINT,
  "dose1_labuan" BIGINT,
  "dose2_labuan" BIGINT,
  "dose1_sarawak" BIGINT,
  "dose2_sarawak" BIGINT
);

CREATE TABLE registered (
  "date" TIMESTAMP,
  "perlis" BIGINT,
  "kedah" BIGINT,
  "penang" BIGINT,
  "perak" BIGINT,
  "selangor" BIGINT,
  "kl" BIGINT,
  "putrajaya" BIGINT,
  "ns" BIGINT,
  "melaka" BIGINT,
  "kelantan" BIGINT,
  "terengganu" BIGINT,
  "pahang" BIGINT,
  "johor" BIGINT,
  "sabah" BIGINT,
  "labuan" BIGINT,
  "sarawak" BIGINT
);

CREATE TABLE malaysia_population_18yo (
  "state" VARCHAR,
  "population" BIGINT
);