Skip to content

Instantly share code, notes, and snippets.

@tnwei
Last active July 11, 2022 13:46
Show Gist options
  • Save tnwei/6b1e974ff0fa5463933c94964a831dd0 to your computer and use it in GitHub Desktop.
Save tnwei/6b1e974ff0fa5463933c94964a831dd0 to your computer and use it in GitHub Desktop.
Changes in data schema for Malaysia COVID19 vaccination statistics (https://github.com/CITF-Malaysia/citf-public)
Data schema changes in CITF repo
================================
Format is <+ or -><filename>: <columnname>.
'+' means added column, '-' means removed column.
Data source: https://github.com/CITF-Malaysia/citf-public
Generated with: https://github.com/tnwei/msia-covid-api/blob/master/generate-data-schema-changelog.py
Changes in commit 9739fc on (2021-07-01 10:17:21+08:00)
-------------------------------------------------------
+vax_malaysia.csv: date
+vax_malaysia.csv: dose1_cumul
+vax_malaysia.csv: dose1_daily
+vax_malaysia.csv: dose2_cumul
+vax_malaysia.csv: dose2_daily
+vax_malaysia.csv: total_cumul
+vax_malaysia.csv: total_daily
+vax_state.csv: date
+vax_state.csv: dose1_cumul
+vax_state.csv: dose1_daily
+vax_state.csv: dose2_cumul
+vax_state.csv: dose2_daily
+vax_state.csv: state
+vax_state.csv: total_cumul
+vax_state.csv: total_daily
Changes in commit 7bf7e4 on (2021-07-04 03:52:15+08:00)
-------------------------------------------------------
+vaxreg_malaysia.csv: call
+vaxreg_malaysia.csv: children
+vaxreg_malaysia.csv: comorb
+vaxreg_malaysia.csv: date
+vaxreg_malaysia.csv: elderly
+vaxreg_malaysia.csv: mysj
+vaxreg_malaysia.csv: oku
+vaxreg_malaysia.csv: phase2
+vaxreg_malaysia.csv: state
+vaxreg_malaysia.csv: total
+vaxreg_malaysia.csv: web
+vaxreg_state.csv: call
+vaxreg_state.csv: children
+vaxreg_state.csv: comorb
+vaxreg_state.csv: date
+vaxreg_state.csv: elderly
+vaxreg_state.csv: mysj
+vaxreg_state.csv: oku
+vaxreg_state.csv: phase2
+vaxreg_state.csv: state
+vaxreg_state.csv: total
+vaxreg_state.csv: web
Changes in commit a6ccca on (2021-08-18 00:45:43+08:00)
-------------------------------------------------------
+vax_malaysia.csv: astra1
+vax_malaysia.csv: astra2
+vax_malaysia.csv: cansino
+vax_malaysia.csv: cumul
+vax_malaysia.csv: cumul_full
+vax_malaysia.csv: cumul_partial
+vax_malaysia.csv: daily
+vax_malaysia.csv: daily_full
+vax_malaysia.csv: daily_partial
+vax_malaysia.csv: pending1
+vax_malaysia.csv: pending2
+vax_malaysia.csv: pfizer1
+vax_malaysia.csv: pfizer2
+vax_malaysia.csv: sinovac1
+vax_malaysia.csv: sinovac2
+vax_state.csv: astra1
+vax_state.csv: astra2
+vax_state.csv: cansino
+vax_state.csv: cumul
+vax_state.csv: cumul_full
+vax_state.csv: cumul_partial
+vax_state.csv: daily
+vax_state.csv: daily_full
+vax_state.csv: daily_partial
+vax_state.csv: pending1
+vax_state.csv: pending2
+vax_state.csv: pfizer1
+vax_state.csv: pfizer2
+vax_state.csv: sinovac1
+vax_state.csv: sinovac2
-vax_malaysia.csv: dose1_cumul
-vax_malaysia.csv: dose1_daily
-vax_malaysia.csv: dose2_cumul
-vax_malaysia.csv: dose2_daily
-vax_malaysia.csv: total_cumul
-vax_malaysia.csv: total_daily
-vax_state.csv: dose1_cumul
-vax_state.csv: dose1_daily
-vax_state.csv: dose2_cumul
-vax_state.csv: dose2_daily
-vax_state.csv: total_cumul
-vax_state.csv: total_daily
Changes in commit b222fd on (2021-08-18 01:07:06+08:00)
-------------------------------------------------------
+vax_malaysia.csv: pending
+vax_state.csv: pending
-vax_malaysia.csv: cansino
-vax_malaysia.csv: pending1
-vax_malaysia.csv: pending2
-vax_state.csv: cansino
-vax_state.csv: pending1
-vax_state.csv: pending2
Changes in commit 536c89 on (2021-08-28 04:35:57+08:00)
-------------------------------------------------------
+vax_malaysia.csv: cansino
+vax_state.csv: cansino
Changes in commit 8e7649 on (2021-09-15 22:01:55+08:00)
-------------------------------------------------------
+vax_malaysia.csv: cumul_full_child
+vax_malaysia.csv: cumul_partial_child
+vax_state.csv: cumul_full_child
+vax_state.csv: cumul_partial_child
Changes in commit c27416 on (2021-09-22 06:38:53+08:00)
-------------------------------------------------------
+vax_malaysia.csv: daily_full_child
+vax_malaysia.csv: daily_partial_child
+vax_state.csv: daily_full_child
+vax_state.csv: daily_partial_child
Changes in commit 5a215f on (2021-10-14 09:25:38+08:00)
-------------------------------------------------------
+vax_malaysia.csv: cumul_booster
+vax_malaysia.csv: daily_booster
+vax_state.csv: cumul_booster
+vax_state.csv: daily_booster
Changes in commit e65e5b on (2021-11-08 07:55:20+08:00)
-------------------------------------------------------
+vax_malaysia.csv: astra3
+vax_malaysia.csv: cansino3
+vax_malaysia.csv: pfizer3
+vax_malaysia.csv: sinopharm1
+vax_malaysia.csv: sinopharm2
+vax_malaysia.csv: sinopharm3
+vax_malaysia.csv: sinovac3
+vax_state.csv: astra3
+vax_state.csv: cansino3
+vax_state.csv: pfizer3
+vax_state.csv: sinopharm1
+vax_state.csv: sinopharm2
+vax_state.csv: sinopharm3
+vax_state.csv: sinovac3
Changes in commit bf65c8 on (2021-11-09 05:40:42+08:00)
-------------------------------------------------------
+vax_malaysia.csv: pending1
+vax_malaysia.csv: pending2
+vax_malaysia.csv: pending3
+vax_state.csv: pending1
+vax_state.csv: pending2
+vax_state.csv: pending3
-vax_malaysia.csv: pending
-vax_state.csv: pending
Changes in commit b026e8 on (2021-11-16 08:30:40+08:00)
-------------------------------------------------------
+vax_malaysia.csv: pending
+vax_state.csv: pending
-vax_malaysia.csv: astra3
-vax_malaysia.csv: cansino3
-vax_malaysia.csv: pending1
-vax_malaysia.csv: pending2
-vax_malaysia.csv: pending3
-vax_malaysia.csv: pfizer3
-vax_malaysia.csv: sinopharm1
-vax_malaysia.csv: sinopharm2
-vax_malaysia.csv: sinopharm3
-vax_malaysia.csv: sinovac3
-vax_state.csv: astra3
-vax_state.csv: cansino3
-vax_state.csv: pending1
-vax_state.csv: pending2
-vax_state.csv: pending3
-vax_state.csv: pfizer3
-vax_state.csv: sinopharm1
-vax_state.csv: sinopharm2
-vax_state.csv: sinopharm3
-vax_state.csv: sinovac3
Changes in commit c92a9b on (2021-11-16 08:30:43+08:00)
-------------------------------------------------------
+vax_malaysia.csv: astra3
+vax_malaysia.csv: cansino3
+vax_malaysia.csv: pending1
+vax_malaysia.csv: pending2
+vax_malaysia.csv: pending3
+vax_malaysia.csv: pfizer3
+vax_malaysia.csv: sinopharm1
+vax_malaysia.csv: sinopharm2
+vax_malaysia.csv: sinopharm3
+vax_malaysia.csv: sinovac3
+vax_state.csv: astra3
+vax_state.csv: cansino3
+vax_state.csv: pending1
+vax_state.csv: pending2
+vax_state.csv: pending3
+vax_state.csv: pfizer3
+vax_state.csv: sinopharm1
+vax_state.csv: sinopharm2
+vax_state.csv: sinopharm3
+vax_state.csv: sinovac3
-vax_malaysia.csv: pending
-vax_state.csv: pending
Changes in commit 8e52e0 on (2022-01-28 17:17:14+08:00)
-------------------------------------------------------
+vaxreg_malaysia.csv: adolescents
+vaxreg_malaysia.csv: children_solo
+vaxreg_state.csv: adolescents
+vaxreg_state.csv: children_solo
Changes in commit 567125 on (2022-01-29 08:46:02+08:00)
-------------------------------------------------------
-vaxreg_malaysia.csv: adolescents
-vaxreg_malaysia.csv: children_solo
-vaxreg_state.csv: adolescents
-vaxreg_state.csv: children_solo
Changes in commit f738df on (2022-01-29 08:46:04+08:00)
-------------------------------------------------------
+vaxreg_malaysia.csv: adolescents
+vaxreg_malaysia.csv: children_solo
+vaxreg_state.csv: adolescents
+vaxreg_state.csv: children_solo
Changes in commit e46216 on (2022-01-30 08:11:53+08:00)
-------------------------------------------------------
+vax_malaysia.csv: cumul_full_adol
+vax_malaysia.csv: cumul_partial_adol
+vax_malaysia.csv: daily_full_adol
+vax_malaysia.csv: daily_partial_adol
+vax_state.csv: cumul_full_adol
+vax_state.csv: cumul_partial_adol
+vax_state.csv: daily_full_adol
+vax_state.csv: daily_partial_adol
Changes in commit 551202 on (2022-02-01 06:38:28+08:00)
-------------------------------------------------------
-vax_malaysia.csv: cumul_full_adol
-vax_malaysia.csv: cumul_partial_adol
-vax_malaysia.csv: daily_full_adol
-vax_malaysia.csv: daily_partial_adol
-vax_state.csv: cumul_full_adol
-vax_state.csv: cumul_partial_adol
-vax_state.csv: daily_full_adol
-vax_state.csv: daily_partial_adol
Changes in commit efa42f on (2022-02-01 06:38:32+08:00)
-------------------------------------------------------
+vax_malaysia.csv: cumul_full_adol
+vax_malaysia.csv: cumul_partial_adol
+vax_malaysia.csv: daily_full_adol
+vax_malaysia.csv: daily_partial_adol
+vax_state.csv: cumul_full_adol
+vax_state.csv: cumul_partial_adol
+vax_state.csv: daily_full_adol
+vax_state.csv: daily_partial_adol
Changes in commit 6c402f on (2022-07-09 07:44:39+08:00)
-------------------------------------------------------
+vax_malaysia.csv: astra4
+vax_malaysia.csv: cansino4
+vax_malaysia.csv: cumul_booster2
+vax_malaysia.csv: cumul_booster2_adol
+vax_malaysia.csv: cumul_booster2_child
+vax_malaysia.csv: cumul_booster_adol
+vax_malaysia.csv: cumul_booster_child
+vax_malaysia.csv: daily_booster2
+vax_malaysia.csv: daily_booster2_adol
+vax_malaysia.csv: daily_booster2_child
+vax_malaysia.csv: daily_booster_adol
+vax_malaysia.csv: daily_booster_child
+vax_malaysia.csv: pending4
+vax_malaysia.csv: pfizer4
+vax_malaysia.csv: sinopharm4
+vax_malaysia.csv: sinovac4
+vax_state.csv: astra4
+vax_state.csv: cansino4
+vax_state.csv: cumul_booster2
+vax_state.csv: cumul_booster2_adol
+vax_state.csv: cumul_booster2_child
+vax_state.csv: cumul_booster_adol
+vax_state.csv: cumul_booster_child
+vax_state.csv: daily_booster2
+vax_state.csv: daily_booster2_adol
+vax_state.csv: daily_booster2_child
+vax_state.csv: daily_booster_adol
+vax_state.csv: daily_booster_child
+vax_state.csv: pending4
+vax_state.csv: pfizer4
+vax_state.csv: sinopharm4
+vax_state.csv: sinovac4
Changes in commit c4a1ae on (2022-07-10 13:48:39+08:00)
-------------------------------------------------------
+vax_booster_combos.csv: aaa
+vax_booster_combos.csv: aac
+vax_booster_combos.csv: aah
+vax_booster_combos.csv: aap
+vax_booster_combos.csv: aas
+vax_booster_combos.csv: ca
+vax_booster_combos.csv: cc
+vax_booster_combos.csv: ch
+vax_booster_combos.csv: cp
+vax_booster_combos.csv: cs
+vax_booster_combos.csv: date
+vax_booster_combos.csv: district
+vax_booster_combos.csv: hha
+vax_booster_combos.csv: hhc
+vax_booster_combos.csv: hhh
+vax_booster_combos.csv: hhp
+vax_booster_combos.csv: hhs
+vax_booster_combos.csv: other
+vax_booster_combos.csv: ppa
+vax_booster_combos.csv: ppc
+vax_booster_combos.csv: pph
+vax_booster_combos.csv: ppp
+vax_booster_combos.csv: pps
+vax_booster_combos.csv: ssa
+vax_booster_combos.csv: ssc
+vax_booster_combos.csv: ssh
+vax_booster_combos.csv: ssp
+vax_booster_combos.csv: sss
+vax_booster_combos.csv: state
+vax_demog_age.csv: booster2_12_17
+vax_demog_age.csv: booster2_18_29
+vax_demog_age.csv: booster2_30_39
+vax_demog_age.csv: booster2_40_49
+vax_demog_age.csv: booster2_50_59
+vax_demog_age.csv: booster2_5_11
+vax_demog_age.csv: booster2_60_69
+vax_demog_age.csv: booster2_70_79
+vax_demog_age.csv: booster2_80
+vax_demog_age.csv: booster2_missing
+vax_demog_age.csv: booster_12_17
+vax_demog_age.csv: booster_18_29
+vax_demog_age.csv: booster_30_39
+vax_demog_age.csv: booster_40_49
+vax_demog_age.csv: booster_50_59
+vax_demog_age.csv: booster_5_11
+vax_demog_age.csv: booster_60_69
+vax_demog_age.csv: booster_70_79
+vax_demog_age.csv: booster_80
+vax_demog_age.csv: booster_missing
+vax_demog_age.csv: date
+vax_demog_age.csv: district
+vax_demog_age.csv: full_12_17
+vax_demog_age.csv: full_18_29
+vax_demog_age.csv: full_30_39
+vax_demog_age.csv: full_40_49
+vax_demog_age.csv: full_50_59
+vax_demog_age.csv: full_5_11
+vax_demog_age.csv: full_60_69
+vax_demog_age.csv: full_70_79
+vax_demog_age.csv: full_80
+vax_demog_age.csv: full_missing
+vax_demog_age.csv: partial_12_17
+vax_demog_age.csv: partial_18_29
+vax_demog_age.csv: partial_30_39
+vax_demog_age.csv: partial_40_49
+vax_demog_age.csv: partial_50_59
+vax_demog_age.csv: partial_5_11
+vax_demog_age.csv: partial_60_69
+vax_demog_age.csv: partial_70_79
+vax_demog_age.csv: partial_80
+vax_demog_age.csv: partial_missing
+vax_demog_age.csv: state
+vax_demog_age_children.csv: date
+vax_demog_age_children.csv: district
+vax_demog_age_children.csv: full_10
+vax_demog_age_children.csv: full_11
+vax_demog_age_children.csv: full_12
+vax_demog_age_children.csv: full_13
+vax_demog_age_children.csv: full_14
+vax_demog_age_children.csv: full_15
+vax_demog_age_children.csv: full_16
+vax_demog_age_children.csv: full_17
+vax_demog_age_children.csv: full_5
+vax_demog_age_children.csv: full_6
+vax_demog_age_children.csv: full_7
+vax_demog_age_children.csv: full_8
+vax_demog_age_children.csv: full_9
+vax_demog_age_children.csv: partial_10
+vax_demog_age_children.csv: partial_11
+vax_demog_age_children.csv: partial_12
+vax_demog_age_children.csv: partial_13
+vax_demog_age_children.csv: partial_14
+vax_demog_age_children.csv: partial_15
+vax_demog_age_children.csv: partial_16
+vax_demog_age_children.csv: partial_17
+vax_demog_age_children.csv: partial_5
+vax_demog_age_children.csv: partial_6
+vax_demog_age_children.csv: partial_7
+vax_demog_age_children.csv: partial_8
+vax_demog_age_children.csv: partial_9
+vax_demog_age_children.csv: state
+vax_demog_ethnicity.csv: booster2_chinese
+vax_demog_ethnicity.csv: booster2_indian
+vax_demog_ethnicity.csv: booster2_malay
+vax_demog_ethnicity.csv: booster2_missing
+vax_demog_ethnicity.csv: booster2_native
+vax_demog_ethnicity.csv: booster2_other
+vax_demog_ethnicity.csv: booster_chinese
+vax_demog_ethnicity.csv: booster_indian
+vax_demog_ethnicity.csv: booster_malay
+vax_demog_ethnicity.csv: booster_missing
+vax_demog_ethnicity.csv: booster_native
+vax_demog_ethnicity.csv: booster_other
+vax_demog_ethnicity.csv: date
+vax_demog_ethnicity.csv: district
+vax_demog_ethnicity.csv: full_chinese
+vax_demog_ethnicity.csv: full_indian
+vax_demog_ethnicity.csv: full_malay
+vax_demog_ethnicity.csv: full_missing
+vax_demog_ethnicity.csv: full_native
+vax_demog_ethnicity.csv: full_other
+vax_demog_ethnicity.csv: partial_chinese
+vax_demog_ethnicity.csv: partial_indian
+vax_demog_ethnicity.csv: partial_malay
+vax_demog_ethnicity.csv: partial_missing
+vax_demog_ethnicity.csv: partial_native
+vax_demog_ethnicity.csv: partial_other
+vax_demog_ethnicity.csv: state
+vax_demog_highrisk.csv: booster2_comorbid
+vax_demog_highrisk.csv: booster2_hcw
+vax_demog_highrisk.csv: booster2_oku
+vax_demog_highrisk.csv: booster_comorbid
+vax_demog_highrisk.csv: booster_hcw
+vax_demog_highrisk.csv: booster_oku
+vax_demog_highrisk.csv: date
+vax_demog_highrisk.csv: district
+vax_demog_highrisk.csv: full_comorbid
+vax_demog_highrisk.csv: full_hcw
+vax_demog_highrisk.csv: full_oku
+vax_demog_highrisk.csv: partial_comorbid
+vax_demog_highrisk.csv: partial_hcw
+vax_demog_highrisk.csv: partial_oku
+vax_demog_highrisk.csv: state
+vax_demog_nationality.csv: booster2_bangladesh
+vax_demog_nationality.csv: booster2_china
+vax_demog_nationality.csv: booster2_india
+vax_demog_nationality.csv: booster2_indonesia
+vax_demog_nationality.csv: booster2_malaysia
+vax_demog_nationality.csv: booster2_missing
+vax_demog_nationality.csv: booster2_myanmar
+vax_demog_nationality.csv: booster2_nepal
+vax_demog_nationality.csv: booster2_other
+vax_demog_nationality.csv: booster2_pakistan
+vax_demog_nationality.csv: booster2_philippines
+vax_demog_nationality.csv: booster2_thailand
+vax_demog_nationality.csv: booster2_vietnam
+vax_demog_nationality.csv: booster_bangladesh
+vax_demog_nationality.csv: booster_china
+vax_demog_nationality.csv: booster_india
+vax_demog_nationality.csv: booster_indonesia
+vax_demog_nationality.csv: booster_malaysia
+vax_demog_nationality.csv: booster_missing
+vax_demog_nationality.csv: booster_myanmar
+vax_demog_nationality.csv: booster_nepal
+vax_demog_nationality.csv: booster_other
+vax_demog_nationality.csv: booster_pakistan
+vax_demog_nationality.csv: booster_philippines
+vax_demog_nationality.csv: booster_thailand
+vax_demog_nationality.csv: booster_vietnam
+vax_demog_nationality.csv: date
+vax_demog_nationality.csv: district
+vax_demog_nationality.csv: full_bangladesh
+vax_demog_nationality.csv: full_china
+vax_demog_nationality.csv: full_india
+vax_demog_nationality.csv: full_indonesia
+vax_demog_nationality.csv: full_malaysia
+vax_demog_nationality.csv: full_missing
+vax_demog_nationality.csv: full_myanmar
+vax_demog_nationality.csv: full_nepal
+vax_demog_nationality.csv: full_other
+vax_demog_nationality.csv: full_pakistan
+vax_demog_nationality.csv: full_philippines
+vax_demog_nationality.csv: full_thailand
+vax_demog_nationality.csv: full_vietnam
+vax_demog_nationality.csv: partial_bangladesh
+vax_demog_nationality.csv: partial_china
+vax_demog_nationality.csv: partial_india
+vax_demog_nationality.csv: partial_indonesia
+vax_demog_nationality.csv: partial_malaysia
+vax_demog_nationality.csv: partial_missing
+vax_demog_nationality.csv: partial_myanmar
+vax_demog_nationality.csv: partial_nepal
+vax_demog_nationality.csv: partial_other
+vax_demog_nationality.csv: partial_pakistan
+vax_demog_nationality.csv: partial_philippines
+vax_demog_nationality.csv: partial_thailand
+vax_demog_nationality.csv: partial_vietnam
+vax_demog_nationality.csv: state
+vax_demog_sex.csv: booster2_female
+vax_demog_sex.csv: booster2_male
+vax_demog_sex.csv: booster2_missing
+vax_demog_sex.csv: booster_female
+vax_demog_sex.csv: booster_male
+vax_demog_sex.csv: booster_missing
+vax_demog_sex.csv: date
+vax_demog_sex.csv: district
+vax_demog_sex.csv: full_female
+vax_demog_sex.csv: full_male
+vax_demog_sex.csv: full_missing
+vax_demog_sex.csv: partial_female
+vax_demog_sex.csv: partial_male
+vax_demog_sex.csv: partial_missing
+vax_demog_sex.csv: state
+vax_district.csv: astra1
+vax_district.csv: astra2
+vax_district.csv: astra3
+vax_district.csv: astra4
+vax_district.csv: cansino
+vax_district.csv: cansino3
+vax_district.csv: cansino4
+vax_district.csv: cumul
+vax_district.csv: cumul_booster
+vax_district.csv: cumul_booster2
+vax_district.csv: cumul_booster2_adol
+vax_district.csv: cumul_booster2_child
+vax_district.csv: cumul_booster_adol
+vax_district.csv: cumul_booster_child
+vax_district.csv: cumul_full
+vax_district.csv: cumul_full_adol
+vax_district.csv: cumul_full_child
+vax_district.csv: cumul_partial
+vax_district.csv: cumul_partial_adol
+vax_district.csv: cumul_partial_child
+vax_district.csv: daily
+vax_district.csv: daily_booster
+vax_district.csv: daily_booster2
+vax_district.csv: daily_booster2_adol
+vax_district.csv: daily_booster2_child
+vax_district.csv: daily_booster_adol
+vax_district.csv: daily_booster_child
+vax_district.csv: daily_full
+vax_district.csv: daily_full_adol
+vax_district.csv: daily_full_child
+vax_district.csv: daily_partial
+vax_district.csv: daily_partial_adol
+vax_district.csv: daily_partial_child
+vax_district.csv: date
+vax_district.csv: district
+vax_district.csv: pending1
+vax_district.csv: pending2
+vax_district.csv: pending3
+vax_district.csv: pending4
+vax_district.csv: pfizer1
+vax_district.csv: pfizer2
+vax_district.csv: pfizer3
+vax_district.csv: pfizer4
+vax_district.csv: sinopharm1
+vax_district.csv: sinopharm2
+vax_district.csv: sinopharm3
+vax_district.csv: sinopharm4
+vax_district.csv: sinovac1
+vax_district.csv: sinovac2
+vax_district.csv: sinovac3
+vax_district.csv: sinovac4
+vax_district.csv: state
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment