Get the data

[pearsonca]

• Prefer direct from Kenyan MoH
• if not conveniently formatted / downloadable automatically, fall back to JHU? Our World In Data? Other?

Task: determine what's available from where.

[aarcury-quandt]

Quick check - MOH data are available as .png (ETA overwritten every day). Time series data are available on WHO (https://www.who.int/countries/ken/), but I can't immediately find a downloadable version. HOWEVER. My group is scraping data daily, so we may have a JSON version of it (or CSV if we're lucky/I'm not looking hard enough). It's a holiday today, but I will e-mail tomorrow morning.

That said, if @ThumbiMwangi knows of an easier way, then let's go for it.

[aarcury-quandt]

Slight exploration - WHO time series is equivalent to JHU, so hoping Thumbi has better insight in navigating the MOH website. If we can only get JHU or similar will potentially need to consider data lag.

[aarcury-quandt]

Too many comments, but to summarize the data I can find/get:

• Image of cumulative totals at national level and new cases at county level available from MOH: https://www.health.go.ke. Images are replaced daily.
• JHU has the cumulative total of cases and deaths for each day in CSV on their GitHub. The time series of cases and deaths are in different files, and the data are in a wide format (i.e., 1 column per day). Only cumulative counts are included, so new cases/deaths per day would need to be calculated.
• WHO has the cumulative total of cases and deaths for each day in CSV from their website. The file also has the newly reported cases/deaths (i.e., cum total today - cum total yesterday). Data are in a long format, and deaths and cases are in the same file. Downloadable from here: https://covid19.who.int/info/
• Africa CDC has the same cumulative data. I can get a JSON file, but why bother?
• OWID - same as WHO with added columns for smoothed new cases/deaths, case/death rates, and reproduction rate. Available: https://ourworldindata.org/coronavirus/country/kenya

We - my group at Pitt - may have, and I'm quoting here, "some admin1 level data in JSON at some point for a short amount of time" for Kenya. But our programmer or curator would have to check.