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

plot mobility/social-distance vs cases #198

Open djay opened 2 years ago

djay commented 2 years ago

http://www.healthdata.org/covid/data-downloads (based on google mobility data but combined to one index) is probably one of the ones.

or use the OWID google mobility data or the raw google data. There is also apple mobility data available but it seems to be based on trip planning and not sure how accurate that is for thailand.

There are perhaps others measures too - https://www.economist.com/the-world-ahead/2021/11/08/will-pre-pandemic-behaviour-ever-return

I think it could even be incorporated the main summary plot as % change from peak. it would have to be inverted so not sure how to label that.

% of social distancing peak? % of peak non-mobility?

image

Screen Shot 2021-11-22 at 1 56 43 pm

May be better to just use time spent at home % peak since thats already positive measure?

Screen Shot 2021-11-22 at 2 00 45 pm

djay commented 2 years ago

@chrisadas I think it would be cool to add this in too. Screen Shot 2021-11-28 at 5 29 31 pm

So we can see the gov laws vs individual choices

chrisadas commented 2 years ago

@djay I can download the data manually, and it has daily index that can be used.

But it doesn't seem to have static URL to get the download in a repeatable manner. I have zero scraping skill. If someone can do that part, I'll be happy to incorporate.

djay commented 2 years ago

@chrisadas yes I can get that done

djay commented 2 years ago

@chrisadas isn't it just this url? https://covid.ourworldindata.org/data/owid-covid-data.csv. https://github.com/owid/covid-19-data/tree/master/public/data/

So you can do exactly the same as what you did the other one.

I may need to optimise it later so it only downloads its once per day but that can be done seperatly.

djay commented 2 years ago

@chrisadas want to have a go?