djay / covidthailand

Thailand Covid testing and case data gathered and combined from various sources for others to download or view
126 stars 15 forks source link

show estimated CFR per region/province (should show vaccine influence) #189

Closed djay closed 2 years ago

djay commented 2 years ago

deaths falling faster than cases seems to be a good indicator that vaccine is working. image

It would be see this for each region and each province.

cases / deaths.shift(avg_days_death) is a rough estimate of daily CFR but a real one would have to track individual cases. But if detection rate doesn't change then it should show the effect of vaccines by lowering the CFR.

Per province some death rate is so low it might be noisy so might need 21 day average.

We could also do the same for different ages per provice as we could collect that from the dashboard.

djay commented 2 years ago

I added in this plot but didn't show things as clearly as I thought.

image

in theory the CFR should drop as vaccines kick in since less people die for the same number of cases. but it seems to effected too much by the detection rate cases maybe?

it also looks very different from OWID one. because I think they calculate it based on total deaths / total cases on each date. Whereas I'm calculating 14 avg deaths shifted 11 days) / 14 day avg cases to try and get a rough daily figure. So I probably need to call it somthing else.

image

djay commented 2 years ago

I think using the OWID way is perhaps better even if it going to show less and less variation over time. This is without any time to death shift correction cfr_region_3

Doing an 11 day shift

cfr_region_3

Another option is something inbetween. if we have a 90 day window instead of all previous values then it includes more recent variance.

cfr_region_3

or 60 days

cfr_region_3

djay commented 2 years ago

Settled on last 90 days window

cfr_region_3