Promoting
121

Kantonale COVID-19-Fallzahlen

Offiziellen COVID-19-Fallzahlen aus alle Kantone der Schweiz verfügbar machen


⛶ Full screen

Cantonal COVID-19 case numbers

Challenge: make all official Cantonal COVID-19 case numbers available

⚙ Repository ✍️ Notebook ►Presentation


20 Cantons of Switzerland and the Principality of Liechtenstein (FL) were missing at the start of the hackathon. Over 25 people have participated in getting numbers from the entire country collected through manual data entry or automated scrapers. The README of the repository in GitHub gives you an overview of what's missing, and what the status of the collect data is. Visit github/openZH/covid_19 and check the Issue Tracker for ongoing work.

OpenZH-logo GD-logo

GitHub commit Binder

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

Our aim is to create a common official OGD dataset of SARS-CoV-2 cases of the Swiss Authorities.

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 specifed 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 seeking 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

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. You can reach us: https://twitter.com/OpenDataZH (follow us, we send you a private Direct Message, thanks!)

(Latest full roundtrip to check for updates: completed at 2020-03-25 18:20 - next full roundtrip starting at at 2020-03-25 20:00) | OGD resource | updated by | latest update | data historized | Official source(s) | |--------------|------------|---------------|-----------------|--------------------| |FL|manually|2020-03-25 20:00|yes|see 'source' OGD resource| |AG|scraping|2020-03-25 15:00|yes|see 'source' OGD resource
for list of all sources see here| |AI|manually|2020-03-24 17:00|yes|see 'source' OGD resource| |AR|scraping|2020-03-25 08:00|yes|see 'source' OGD resource| |BE|scraping|2020-03-25|yes|see 'source' OGD resource| |BL|scraping|2020-03-25 14:00|yes|see 'source' OGD resource| |BS|manually|2020-03-25 10:00|yes|see 'source' OGD resource| |FR|manually|2020-03-18 (partially)|no|see 'source' OGD resource| |GE|manually|2020-03-25 12:00|no|see 'source' OGD resource| |GL|manually|2020-03-25 13:30|no|see 'source' (data before 2020-03-22 not official) OGD resource| |GR|scraping|2020-03-25 |no|see 'source' (identical case no. for 2020-03-22; we're verifying) OGD resource| |JU|scraping|2020-03-24 17:00|no|see 'source' OGD resource| |LU|scraping|2020-03-25 11:00|no|see 'source' OGD resource| |NE|scraping|2020-03-25 14:00|no|see 'source' OGD resource| |NW|scraping|2020-03-25 15:30|no|see 'source' OGD resource| |OW|manually|2020-03-25|no|see 'source' OGD resource| |SG|scraping|2020-03-23|yes|see 'source' OGD resource| |SH|scraping|2020-03-25 08:00|no|see 'source' OGD resource| |SO|scraping|2020-03-25 00:00|yes|see 'source' (data before 2020-03-20 not official) OGD resource| |SZ|manually|2020-03-25|no|see 'source' (one record not official) OGD resource| |TG|scraping|2020-03-25|no|see 'source' OGD resource| |TI|manually|2020-03-25 08:00|yes|see 'source' OGD resource| |UR|scraping|2020-03-24 12:00|yes|see 'source' OGD resource| |VD|manually|2020-03-24|yes|see 'source' OGD resource| |VS|scraping|2020-03-25 15:00|yes|see 'source' OGD resource| |ZG|scraping|2020-03-25 08:00|no|see 'source' OGD resource| |ZH|manually|2020-03-25 09:30|yes|see 'source' OGD resource|

Data structure

The data of the Cantonal case numbers is structured in such a way, it can be easily expanded vertically (Confederation).

example-file

Field Name Description Format
date Date of notification YYYY-MM-DD
time Time of notification HH:MM
abbreviationcantonand_fl Abbreviation 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

Metadata and explanations

Cases Canton ZH

Metadata (in German): https://opendata.swiss/en/dataset/covid_19-fallzahlen-kanton-zuerich

Cases all Cantons CH

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

Community Contributions

Visualization of Swiss and Cantonal Case Numbers over Time

Operations Dashboard

corona-data.ch

Many thanks for the great work!

Launched at Monitoring COVID-19 effects by

AndreasAmslerZH odi Somebody jbouman wadoli rsalzer simonmettler matjung mmznr Taremeh stromvirvel Prabitha findMarcel muriel

Maintainer AndreasAmslerZH

Updated 28.03.2020 16:04

  • oleg / update / 28.03.2020 16:04
  • oleg / update / 25.03.2020 21:27
  • oleg / update / 25.03.2020 21:27
  • oleg / update / 25.03.2020 21:27
  • oleg / update / 25.03.2020 21:26

Connect to the community on Chat | Forum | Twitter

All attendees, sponsors, partners, volunteers and staff at our hackathon are required to agree with the Hack Code of Conduct. Organisers will enforce this code throughout the event. We expect cooperation from all participants to ensure a safe environment for everybody. For more details on how the event is run, see the Remote Guidelines.

Creative Commons LicenceThe contents of this website, unless otherwise stated, are licensed under a Creative Commons Attribution 4.0 International License.