search

CITF-Malaysia / citf-public

Official data on Malaysia's National Covid-​19 Immunisation Programme (PICK). Powered by MySejahtera.
Other
498 stars 186 forks source link

Totals do not add up #164

Open mgdatas opened 2 years ago

mgdatas commented 2 years ago

Hello and thank you to all those working on providing this valuable data to the public.

I notice that the 'cumul' figures are not equal to ('cumulative_partial' + cumulative_full') nor ('cumulative_partial' + cumulative_full' + 'cumulative_booster'). May I know how I can obtain the relationships between the different data?

Thank you.

KennethThePro commented 2 years ago

daily_partial is consist of the 1st doses (for double-dose vaccines) only cumul_partial is the sum of both daily_partial and cansino

daily_full consist of 2nd doses (for double-dose vaccines) and 1-dose vaccines (e.g. Cansino) cumul_full is the sum of daily_full

daily_booster consist of all booster shots cumul_booster is the sum of daily_booster

To obtain the total cumulative doses administered, it may see like a straight forward answer which is cumul_partial + cumul_full + cumul_booster

However, single-dose vaccine like Cansino is defined in both cumul_partial and cumul_full which means that there is a duplicate count. Therefore the final formula to obtain the cumul is as follow cumul = cumul_partial + cumul_full + cumul_booster - cumulative of cansino

mgdatas commented 2 years ago

Thank you for the clarification, KennethThePro. Appreciate it. I will check and get back to you if necessary.

May I communicate with you directly via this email address?

Just one more clarification pertaining to your response above. Should this statement: daily_full consist of 2nd doses (for single-dose vaccines) and 1-dose vaccines (e.g. Cansino) actually read as: daily_full consist of 2nd doses (for double-dose vaccines) and 1-dose vaccines (e.g. Cansino)?

Thank you again and regards.

Mohan G

On Mon, Nov 22, 2021 at 8:52 PM KennethThePro @.***> wrote:

daily_partial is consist of the 1st doses (for double-dose vaccines) only cumul_partial is the sum of both daily_partial and cansino

daily_full consist of 2nd doses (for single-dose vaccines) and 1-dose vaccines (e.g. Cansino) cumul_full is the sum of daily_full

daily_booster consist of all booster shots cumul_booster is the sum of daily_booster

To obtain the total cumulative doses administered, it may see like a straight forward answer which is cumul_partial + cumul_full + cumul_booster

However, single-dose vaccine like Cansino is defined in both cumul_partial and cumul_full which means that there is a duplicate count. Therefore the final formula to obtain the cumul is as follow cumul = cumul_partial + cumul_full + cumul_booster - cumulative of cansino

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/CITF-Malaysia/citf-public/issues/164#issuecomment-975491461, or unsubscribe https://github.com/notifications/unsubscribe-auth/AWSXX765K6OMY2DNG2ZCT5LUNI4KBANCNFSM5INRIDCQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

KennethThePro commented 2 years ago

Yes, my mistake should had been double dose vaccines, will edit the comment