README.md

COVID-19 Cases communicated by Swiss Cantons and Principality of Liechtenstein (FL)

Our aim is to create a common official OGD dataset of COVID-19 cases of the Swiss Authorities.

We are providing COVID-19 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

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!)

(Last roundtrip to check for updates: 2020-03-22 07:30-08:55)

OGD resource updated by latest update data historized Official source(s) FL manually 2020-03-21 yes see 'source' OGD resource AG manually 2020-03-20 yes see 'source' OGD resource
for list of all sources see here AI file by email 2020-03-19 yes see 'source' OGD resource AR manually 2020-03-21 (partially) yes see 'source' OGD resource BE scraping 2020-03-21 yes see 'source' OGD resource BL manually 2020-03-21 14:00 yes see 'source' OGD resource BS manually 2020-03-21 10:00 yes see 'source' OGD resource FR manually 2020-03-18 (partially) no see 'source' OGD resource GE manually 2020-03-21 no see 'source' OGD resource GL manually 2020-03-19 no see 'source' (not official!) OGD resource GR manually 2020-03-20 no see 'source' OGD resource JU scraping 2020-03-21 no see 'source' OGD resource LU manually 2020-03-21 11:00 no see 'source' OGD resource NE manually 2020-03-21 15:30 no see 'source' OGD resource NW manually 2020-03-21 18:15 no see 'source' OGD resource OW manually 2020-03-13 no see 'source' OGD resource SG scraping 2020-03-20 yes see 'source' OGD resource SH manually 2020-03-20 no see 'source' OGD resource SO

SZ manually 2020-03-15 no see 'source' (one record not official) OGD resource TG manually 2020-03-21 no see 'source' OGD resource TI manually 2020-03-21 08:00 yes see 'source' OGD resource UR manually 2020-03-21 08:00 yes see 'source' OGD resource VD manually 2020-03-20 yes see 'source' OGD resource VS manually 2020-03-21 yes see 'source' OGD resource ZG manually 2020-03-20 no see 'source' OGD resource ZH manually 2020-03-20 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 abbreviation_canton_and_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

• 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://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!