March 11, 2020

687 words 4 mins read

openZH/covid_19

openZH/covid_19

COVID19 case numbers Cantons of Switzerland and Principality of Liechtenstein (FL) - case numbers include persons tested in the respective area. The data is updated at best once a day (times of collection and update may vary). Start with the README! Help closing the gaps:

repo name openZH/covid_19
repo link https://github.com/openZH/covid_19
homepage https://db.schoolofdata.ch/project/73
language Jupyter Notebook
size (curr.) 762 kB
stars (curr.) 98
created 2020-03-09
license Creative Commons Attribution 4.0 International

GitHub commit Binder

SARS-CoV-2 Cases communicated by Swiss Cantons and Principality of Liechtenstein (FL)

We are providing a common official OGD dataset of SARS-CoV-2 case numbers, which are communicated by official Swiss canton’s (26 cantons, abbreviations see below) and Principality of Liechtenstein’s (abbreviation: FL) sources.

The infection rates refer to the infection with SARS-CoV-2, whereas the disease caused by the virus is called Covid-19.

We are providing SARS-CoV-2 case numbers in machine-readable form (CSV) as OGD resources (Open Government Data), that have been published by official sources (Cantons and FL) online. Sources are specified with the respective URL(s).

Case numbers include persons tested and treated in the respective Canton resp. Principality of Liechtenstein. Important: Since 09.03.2020, only persons who meet certain test criteria are tested (see e.g. with the Canton of Zurich “Testkriterien” at www.gd.zh.ch/coronavirus).

The data is updated regularly - if available daily. Times of collection and update of the data may vary. We are specifying the date of the last reporting, and - if available - a time-stamp, too.

The data is both automatically and manually updated, and regularly checked. We are performing three times a day complete manual updates and verifications; these “roundtrips” are starting at 8am, 2pm and 8pm. They are usally completed within 60 minutes.

There is a merged file of all Cantons and FL that is automatically updated for use in data analysis.

You can get started exploring the data with visualise.ipynb (run it in your browser).

We are available to advise and support interested authorities, how to easily complete both historized data, and missing columns. You can reach us:

Data Updates

–> Check our status dashboard with the latest data updates

Cantonal / FL data ressources

Canton / FL updated by data historized
FL manually yes
AG scraping yes
AI scraping yes
AR scraping yes
BE scraping yes
BL scraping yes
BS scraping yes
FR scraping yes
GE manually no
GL scraping no
GR scraping no
JU scraping no
LU scraping no
NE scraping no
NW scraping no
OW scraping no
SG scraping yes
SH scraping no
SO scraping yes
SZ scraping no
TG scraping no
TI manually yes
UR scraping yes
VD scraping yes
VS scraping yes
ZG scraping no
ZH manually yes

Data structure

The data of the Cantonal case numbers is structured as follows:

example-file

Field Name Description Format
date Date of notification YYYY-MM-DD
time Time of notification HH:MM
abbreviation_canton_and_fl Abbreviation of the reporting canton Text
ncumul_tested Reported number of tests performed as of date Number
ncumul_conf Reported number of confirmed cases as of date Number
ncumul_hosp * Reported number of hospitalised patients on date Number
ncumul_ICU * Reported number of hospitalised patients in ICUs on date Number
ncumul_vent * Reported number of patients requiring ventilation on date Number
ncumul_released Reported number of patients released from hospitals or reported recovered as of date Number
ncumul_deceased Reported number of deceased as of date Number
source Source of the information href

*These variables reflect current, not cumulative numbers, even if the prefix in the column-name might suggest otherwise. Column names will not be changed to grant stability.

The Data for Genevé and Ticino contains an additional column reporting the number of currently intubated patients. | Field Name | Description | Format | |———————|——————————————–|————| | ninstant_ICU_intub |Reported number of patients requiring intubation on date| Number |

Community Contributions

Visualization of Swiss and Cantonal Case Numbers over Time

Operations Dashboard

corona-data.ch

REST-API

Many thanks for the great work!

comments powered by Disqus