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:
- https://twitter.com/OpenDataZH (follow us, we send you a private Direct Message, thanks!)
- mailto:info@open.zh.ch
| OGD resource | updated by | latest update | data historized | Official source(s) |
|---|---|---|---|---|
| FL | manually | 2020-03-26 | yes | see 'source' OGD resource |
| AG | scraping | 2020-03-26 15:00 | yes | see 'source' OGD resource for list of all sources see here |
| AI | manually | 2020-03-26 18:00 | yes | see 'source' OGD resource |
| AR | scraping | 2020-03-26 16:00 | yes | see 'source' OGD resource |
| BE | scraping | 2020-03-26 | yes | see 'source' OGD resource |
| BL | scraping | 2020-03-26 | yes | see 'source' OGD resource |
| BS | manually | 2020-03-27 10:00 | yes | see 'source' OGD resource |
| FR | manually | 2020-03-26 | yes | see 'source' OGD resource |
| GE | manually | 2020-03-26 12:00 | no | see 'source' OGD resource |
| GL | manually | 2020-03-26 13:30 | no | see 'source' (data before 2020-03-22 not official) OGD resource |
| GR | scraping | 2020-03-26 | no | see 'source' (identical case no. for 2020-03-22; we're verifying) OGD resource |
| JU | scraping | 2020-03-26 16:00 | no | see 'source' OGD resource |
| LU | scraping | 2020-03-26 11:00 | no | see 'source' OGD resource |
| NE | scraping | 2020-03-26 14:30 | no | see 'source' OGD resource |
| NW | scraping | 2020-03-26 16:00 | no | see 'source' OGD resource |
| OW | manually | 2020-03-26 | no | see 'source' OGD resource |
| SG | scraping | 2020-03-26 | yes | see 'source' OGD resource |
| SH | scraping | 2020-03-26 07:00 | no | see 'source' OGD resource |
| SO | scraping | 2020-03-26 00:00 | yes | see 'source' (data before 2020-03-20 not official) OGD resource |
| SZ | manually | 2020-03-26 | no | see 'source' (one record not official) OGD resource |
| TG | scraping | 2020-03-26 | no | see 'source' OGD resource |
| TI | manually | 2020-03-26 08:00 | yes | see 'source' OGD resource |
| UR | scraping | 2020-03-26 | yes | see 'source' OGD resource |
| VD | manually | 2020-03-25 | yes | see 'source' OGD resource |
| VS | scraping | 2020-03-26 15:00 | yes | see 'source' OGD resource |
| ZG | scraping | 2020-03-26 08:00 | no | see 'source' OGD resource |
| ZH | manually | 2020-03-27 09:30 | yes | see 'source' OGD resource |
The data of the Cantonal case numbers is structured as follows:
| 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é contains an additional column reporting the number of currently intubated patients. This column will be integrated into all files shortly.
| Field Name | Description | Format |
|---|---|---|
| ninstant_ICU_intub | Reported number of patients requiring intubation on date | Number |
- https://rsalzer.github.io/COVID_19_CH/
- https://rsalzer.github.io/COVID_19_KT_ZH/
Robert Salzer on Twitter: https://twitter.com/rob_salzer
- https://covid19.ddrobotec.com/
github-repo
Zeno Davatz on Twitter: https://twitter.com/zdavatz
-
https://www.corona-data.ch/ github-repo
Daniel Probst on Twitter: https://twitter.com/skepteis?lang=de -
https://github.com/opendatabs/covid_19
Open Government Data Basel-Stadt on Twitter: https://twitter.com/OpenDataBS
- https://covid19-rest.herokuapp.com
- github-repo
Andreas Pfeuti
Many thanks for the great work!