We are providing COVID-19 case data in machine-readable form (CSV) as OGD resources (Open Government Data), that has been published online by official sources (Cantons and FL).
We seek to cover all Cantons, and to update the data automatically (by scraping or pipeline). Join our challenge to contribute to this goal: https://db.schoolofdata.ch/project/73
(Status: 2020-03-21 01:00)
| OGD resource | updated by | latest update | Official source(s) |
|---|---|---|---|
| FL | manually | 2020-03-20 | see 'source' OGD resource |
| AG | scraping | 2020-03-20 | see 'source' OGD resource |
| AI | manually | 2020-03-14 | see 'source' OGD resource |
| AR | manually | 2020-03-18 | see 'source' OGD resource |
| BE | scraping | 2020-03-20 | see 'source' OGD resource |
| BL | manually | 2020-03-20 | see 'source' OGD resource |
| BS | manually | 2020-03-20 | see 'source' OGD resource |
| FR | https://www.fr.ch/de/covid19/gesundheit/covid-19/coronavirus-entwicklungen-der-situation | ||
| GE | 2020-03-20 | https://www.ge.ch/document/point-coronavirus-maladie-covid-19 | |
| GL | |||
| GR | manually | 2020-03-19 | see 'source' OGD resource |
| JU | manually | 2020-03-20 | see 'source' OGD resource |
| LU | manually | 2020-03-20 | see 'source' OGD resource |
| NE | 2020-03-20 | https://www.ne.ch/autorites/DFS/SCSP/medecin-cantonal/maladies-vaccinations/Pages/Coronavirus.aspx | |
| NW | manually | 2020-03-20 | see 'source' OGD resource |
| OW | |||
| SG | scraping | 2020-03-20 | see 'source' OGD resource |
| SH | scraping | 2020-03-20 | see 'source' OGD resource |
COVID19 cases Canton of Zürich (ZH) - case numbers include persons tested in the Canton of Zürich. The data is updated once a day (times of collection and update may vary).
Official source: https://gd.zh.ch/internet/gesundheitsdirektion/de/themen/coronavirus.html#title-content-internet-gesundheitsdirektion-de-themen-coronavirus-jcr-content-contentPar-textimage_7) & https://twitter.com/gd_zuerich
Important: Since 09.03.2020, only persons who meet certain test criteria are tested (see "Testkriterien" at www.gd.zh.ch/coronavirus).
Official source: Please report official government sources to us: https://twitter.com/OpenDataZH - we will check and give you feedback. Thanks!
Official source: Please report official government sources to us: https://twitter.com/OpenDataZH - we will check and give you feedback. Thanks!
COVID19 cases Canton of Thurgau (TG) - case numbers include persons tested in the Canton of Thurgau. The data is updated once a day (times of collection and update may vary).
Official source: https://twitter.com/Kanton_Thurgau & https://www.tg.ch/news/fachdossier-coronavirus.html/10552
Official source: https://www4.ti.ch/area-media/comunicati/?parole=&periodo=&FONTE=23690&NEWS_TYPE=
Official source: https://www.ur.ch/mmdirektionen
Official source: Please report official government sources to us: https://twitter.com/OpenDataZH - we will check and give you feedback. Thanks!
Official source: Please report official government sources to us: https://twitter.com/OpenDataZH - we will check and give you feedback. Thanks!
Official source: https://twitter.com/gesundZG
Metadata (in German): https://opendata.swiss/en/dataset/covid_19-fallzahlen-kanton-zuerich
Metadata (in English): https://opendata.swiss/de/dataset/covid_19-cases-per-canton-of-switzerland-and-principality-of-liechtenstein
Important: Data is being updated after the next official data publication incl. Cantonal level issued by the Federal Office of Public Health FOPH: https://www.bag.admin.ch/bag/en/home/krankheiten/ausbrueche-epidemien-pandemien/aktuelle-ausbrueche-epidemien/novel-cov/situation-schweiz-und-international.html#-1199962081
Quick beta Visualization: https://observablehq.com/@mmznrstat/covid19-cases-in-switzerland
The data of the cantonal case numbers is structured in such a way, it can be easily expanded both horizontally (Cantons) and vertically (Confederation).
| Field Name | Description | Format |
|---|---|---|
| date | Date of notification | YYYY-MM-DD |
| time | Time of notification | HH:MM |
| abbreviation_canton | Abbreciation of the reporting canton | Text |
| ncumul_tested | Tests performed (cumulative) | Number |
| ncumul_conf | Number of confirmed cases | Number |
| ncumul_hosp | Number of hospitalised patients | Number |
| ncumul_ICU | Number of hospitalised patients in ICUs | Number |
| ncumul_vent | Number of patients requiring ventilation | Number |
| ncumul_released | Number of patients released from hospitals | Number |
| ncumul_deceased | Number of deceased | Number |
| source | Source of the information | href |
The aim is to create a common official OGD dataset of the Swiss Authorities.
We are available to advise and support interested authorities. You can reach us: https://twitter.com/OpenDataZH (follow us, we send you a private Direct Message, thanks!)
-
https://rsalzer.github.io/COVID_19_KT_ZH/
Robert Salzer on Twitter: https://twitter.com/rob_salzer -
https://github.com/daenuprobst/covid19-cases-switzerland
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
Many thanks for the great work!