Skip to content

Machine readable records about the COVID-19 pandemic in Czech Republic. Currently automatically parsing from wikipedia and MZČR (ÚZIS).

License

Notifications You must be signed in to change notification settings

kukosek/czech-covid-db

Repository files navigation

czech-covid-db

I started this project on 19.3. 2020. I wanted to make a COVID-19 visualisation website of czech data, but there wasn't a open dataset for CZ. I didn't want to manually write the numbers into a spreadsheet everyday, so I came with a solution: make a script that will check the wikipedia page in a regular time period. If it detects a change, it saves it as a record by appending a row to the CSV tables.

On 28.3., an official open dataset was released

But it doesn't have everything as i would need. So I made a new script that parses data from wikipedia (into the repo root dir) and also from the official page into new CSV tables in the uzis dir.

  • Problem: They don't have a spreadsheet about recovered cases and deaths, only current numbers on the page.
    • Solution: Copy my records_deaths and records_recovered files that were updated by wikipedia's numbers into the uzis dir. Now check the website's current numbers, and if they change, append a record to the CSV files (records_recovered_uzis.csv, records_deaths_uzis.csv)
  • Problem: They have a JSON about every infected person, but I would need a records spreadsheet with numbers for individual regions, individual import states and age groups
    • Solution: Parse the persons.json files and create new CSV files from it.
records_tests_uzis.csv is the only file that is nearly the same as the original tests file from opendata.

Used by

  • koronagrafy - a page with chart visualisations and prediction of the pandemic

If you use this repository, feel free to create a issue mentioning your project. I will add your project here.

About

Machine readable records about the COVID-19 pandemic in Czech Republic. Currently automatically parsing from wikipedia and MZČR (ÚZIS).

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published