Awesome
<img src="https://github.com/openZH/covid_19/blob/master/statistisches_amt_kt_zh.png" alt="OpenZH-logo" width="180"/> <img src="https://github.com/openZH/covid_19/blob/master/gd.png" alt="GD-logo" width="200"/>
SARS-CoV-2 open government data reported by the Swiss Cantons and the Principality of Liechtenstein
Important note
Find and use high quality data published by our data colleagues of the FOPH for all Cantons and FL:
- visualized (Dashboard): https://www.covid19.admin.ch/en/overview
- published as 'open government data': https://opendata.swiss/en/dataset/covid-19-schweiz
- data documentation: https://www.covid19.admin.ch/api/data/documentation
- release notes: https://www.covid19.admin.ch/api/data/documentation#releases
- Data Context API: https://www.covid19.admin.ch/api/data/documentation#data-context-api
Aim of this repository
The aim of this repository is to provide open government datasets for SARS-CoV-2 related data reported by the Swiss Cantons and the Principality of Liechtenstein. Since Jun 8, 2020 most cantons report case numbers at least once or twice a week. Updates of cantonal case numbers during weekends are infrequent.
If you have any questions, please don't hestitate to contact us: <br>
- https://twitter.com/OpenDataZH (follow us, we send you a private Direct Message, thanks!) <br>
- info@open.zh.ch <br>
List of open government datasets published in this repository
Swiss Cantons and Principality of Liechtenstein <br>
- Unified dataset <br>
- More detailed dataset <br>
Canton Zurich <br>
- Unified dataset <br>
- More detailed dataset<br>
- Postal codes (Postleitzahl)<br>
- Districts (Bezirke)<br>
- Travel self quarantine<br>
- Intensive care occupancy<br>
- Variants of Concern (VOC) - Note: ZH data is deprecated (2021-02-12); since 2021-02-19 FOPH publishes data for all Cantons ("virusVariants", https://www.covid19.admin.ch/api/data/context)<br>
- Vaccination campaign<br>
Don't forget to take a look at the community contributions.
Swiss Cantons and Principality of Liechtenstein: Unified dataset
General description <br> This data is generated and validated daily using manual and automated procedures. Note that we only publish data that are reported by the Swiss Cantons and the Principality of Liechtenstein. Thus, gaps result if Swiss Cantons or the Principality of Liechtenstein do not report data for the specific date.
Data <br>
https://github.com/openZH/covid_19/tree/master/fallzahlen_kanton_total_csv_v2 <br> Description: Case numbers for each spatial unit separately <br> Spatial unit: Swiss cantons and Principality of Liechtenstein <br> Format: csv <br> Additional remark: Link to deprecated dataset (data structure has changed)
https://github.com/openZH/covid_19/blob/master/COVID19_Fallzahlen_CH_total_v2.csv <br> Description: Case numbers for all spatial units in one single file. <br> Spatial unit: Swiss cantons and Principality of Liechtenstein <br> Format: csv <br> Additional remark: Link to deprecated dataset (data structure has changed)
Metadata
| Field Name | Description | Format | Note |
|---|---|---|---|
| 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 | Irrespective of canton of residence |
| ncumul_conf | Reported number of confirmed cases as of date | Number | Only cases that reside in the current canton |
| new_hosp | new hospitalisations since last date | Number | Irrespective of canton of residence |
| current_hosp | Reported number of hospitalised patients on date | Number | Irrespective of canton of residence |
| current_icu | Reported number of hospitalised patients in ICUs on date | Number | Irrespective of canton of residence |
| current_vent | Reported number of patients requiring invasive ventilation on date | Number | Irrespective of canton of residence |
| ncumul_released | Reported number of patients released from hospitals or reported recovered as of date | Number | Irrespective of canton of residence |
| ncumul_deceased | Reported number of deceased as of date | Number | Only cases that reside in the current canton |
| source | Source of the information | href | |
| current_isolated | Reported number of isolated persons on date | Number | Infected persons, who are not hospitalised |
| current_quarantined | Reported number of quarantined persons on date | Number | Persons, who were in 'close contact' with an infected person, while that person was infectious, and are not hospitalised themselves |
| current_quarantined_riskareatravel | Reported number of quarantined persons on date | Number | People arriving in Switzerland from certain countries and areas, who are required to go into quarantine. |
Empty values vs. 0
| Value | Meaning |
|---|---|
| 0 | Zero cases are reported. |
| empty | No value is reported. |
Latest updates
The latest updates are visualized here.
| Canton / FL | Last update (of any variable) | Important notes |
|---|---|---|
| FL |  | |
| AG |  | Since 2022-03-04 AG is not publishing updated case numbers on its website anymore, but referencing to FOPH. You find respective data via FOPH's API: https://www.covid19.admin.ch/api/data/context |
| AI |  | Since 2022-03-31 AI is not publishing updated case numbers on its website anymore, but referencing to FOPH. You find respective data via FOPH's API: https://www.covid19.admin.ch/api/data/context |
| AR |  | Since 2021-01-22 AR is not publishing updated case numbers on its website anymore, but referencing to FOPH. You find respective data via FOPH's API: https://www.covid19.admin.ch/api/data/context |
| BE | | Since 2022-03-31 BE is not publishing updated case numbers on its website anymore, but referencing to FOPH. You find respective data via FOPH's API: https://www.covid19.admin.ch/api/data/context |
| BL |  | |
| BS |  | |
| FR |  | |
| GE |  | |
| GL |  | Since 2022-02-09 GL is not publishing updated case numbers on its website anymore, but referencing to FOPH. You find respective data via FOPH's API: https://www.covid19.admin.ch/api/data/context |
| GR | | Since 2022-03-31 GR is not publishing updated case numbers on its website anymore, but referencing to FOPH. You find respective data via FOPH's API: https://www.covid19.admin.ch/api/data/context |
| JU |  | |
| LU |  | |
| NE |  | |
| NW |  | |
| OW | | |
| SG |  | |
| SH |  | |
| SO | | |
| SZ |  | Since 2022-03-07 SZ is not publishing updated case numbers on its website anymore, but referencing to FOPH. You find respective data via FOPH's API: https://www.covid19.admin.ch/api/data/context |
| TG |  | Since 2022-05-16 TG is updating data only once per week (on Mondays). |
| TI |  | |
| UR | | Since 2022-03-31 UR is not publishing updated case numbers on its website anymore, but referencing to FOPH. You find respective data via FOPH's API: https://www.covid19.admin.ch/api/data/context |
| VD | | |
| VS |  | Since 2022-05-31 VS is not publishing updated case numbers on its website anymore, but referencing to FOPH. You find respective data via FOPH's API: https://www.covid19.admin.ch/api/data/context |
| ZG |  | |
| ZH |  | Since 2022-03-14 ZH is updating data only once per week (on Tuesdays). Since 2023-01-03 ZH is not publishing updated case numbers. |
Swiss Cantons and Principality of Liechtenstein: More detailed dataset
Data <br>
https://github.com/openZH/covid_19/tree/master/fallzahlen_kanton_alter_geschlecht_csv <br> Description: Selected cantons publish more detailed datasets. <br> Spatial unit: Swiss cantons and Principality of Liechtenstein <br> Format: csv <br> Additional remark: Not all datasets are maintained.
Maintained datasets <br>
Unmaintained datasets <br>
-
COVID19_Fallzahlen_Kanton_BS_alter_geschlecht.csv (Basel-Stadt data in this format continues to be maintained here: https://data.bs.ch/explore/dataset/100076)
Metadata for unmaintained datasets <br>
| Field Name | Description | Format | Reporting Cantons |
|---|---|---|---|
| Date | ZH = Date of test result (NewConfCases) / Date of death (NewDeaths) </br> BL = Date of death </br> BS = Date of notification | YYYY-MM-DD | |
| Area | Abbreviation of the reporting canton | ||
| AgeYear | Number | ZH,BS,BL | |
| Gender | Text | ZH,BS,BL | |
| NewConfCases | Number of Confirmed Cases | Number | ZH |
| NewDeaths | Number of Deceased | Number | ZH,BS,BL |
| PreExistingCond | Pre-Existing Conditions | Text | BL,BS |
Canton Zürich: Unified dataset
Data <br>
https://github.com/openZH/covid_19#swiss-cantons-and-principality-of-liechtenstein-unified-dataset <br> Description: open data swiss: COVID_19 Fallzahlen Kanton Zürich Total
Canton Zürich: More detailed dataset
Data <br>
https://github.com/openZH/covid_19/blob/master/fallzahlen_kanton_alter_geschlecht_csv/COVID19_Fallzahlen_Kanton_ZH_altersklassen_geschlecht.csv <br> Description: open data swiss: COVID_19 Verteilung der Fälle im Kanton Zürich nach Altersklasse, Geschlecht und Kalenderwoche <br> Spatial unit: Canton Zürich <br> Format: csv <br> Additional remark: Comparable data for the canton of Thurgau is published at opendata.swiss.
Metadata
| Spaltenname / Fieldname | Beschreibung (DE) | Description (EN) | Format |
|---|---|---|---|
| Week | Kalenderwoche des Befundes (NewConfCases) / Todesdatums (NewDeaths) | Calendar week of test result (NewConfCases) / Date of death (NewDeaths) | Zahl |
| Year | Jahr des Befundes (NewConfCases) / Todesdatums (NewDeaths) | Year of test result (NewConfCases) / Date of death (NewDeaths) | Zahl |
| Area | Kanton | Abbreviation of the reporting canton | Text |
| AgeYearCat | 10-Jahres Altersklassen | Age groups (10 year steps) | Text |
| Gender | Geschlecht | Gender | Text |
| NewConfCases | Neue bestätigte Fälle | Newly confirmed number of cases | Zahl |
| NewDeaths | Neue Todesfälle | Newly confirmed number of deaths | Zahl |
Data <br>
https://github.com/openZH/covid_19/blob/master/fallzahlen_kanton_alter_geschlecht_csv/COVID19_Einwohner_Kanton_ZH_altersklassen_geschlecht.csv <br> Description: Inhabitants per age category and gender. <br> Spatial unit: Canton Zürich <br> Format: csv <br>
Metadata
| Spaltenname / Fieldname | Beschreibung (DE) | Description (EN) | Format |
|---|---|---|---|
| Year | Stichtag ist jeweils der 31.12 des angegebenen Jahres | The reporting date is the 31.12 of the indicated year | Zahl |
| Area | Kanton | Abbreviation of the reporting canton | Text |
| AgeYearCat | 10-Jahres Altersklassen | Age groups (10 year steps) | Text |
| Gender | Geschlecht | Gender | Text |
| Inhabitants | Anzahl Einwohner | Number of inhabitants | Zahl |
Data <br>
https://raw.githubusercontent.com/openZH/covid_19/master/fallzahlen_kanton_zh/COVID19_Anteil_positiver_Test_pro_KW.csv <br> Description: opendata.swiss: COVID_19 Anteil der positiven SARS-CoV-2 Tests im Kanton Zürich nach Kalenderwoche <br> Spatial unit: Canton Zürich <br> Format: csv <br> Additional remark: <br>
Metadata
| Spaltenname / Fieldname | Beschreibung (DE) | Description (EN) | Format |
|---|---|---|---|
| Woche_von | Beginn der Kalenderwoche (Datum) | Start of the calendar week (Date) | YYYY-MM-DD |
| Woche_bis | Ende der Kalenderwoche (Datum) | End of the calendar week (Date) | YYYY-MM-DD |
| Kalenderwoche | Kalenderwoche | Abbreviation of the reporting canton | Zahl |
| Anzahl_positiv | Anzahl positiver Tests | Number of positive tests | Text |
| Anzahl_negativ | Anzahl negativer Tests | Number of negative tests | Text |
| Anteil_positiv | Anteil der positiven Tests an allen Tests | Share of positive tests | Zahl |
Canton Zürich: Postal codes (Postleitzahl)
Data <br>
https://github.com/openZH/covid_19/blob/master/fallzahlen_plz/fallzahlen_kanton_ZH_plz.csv <br> Description: opendata.swiss: COVID_19 Fallzahlen Kanton Zürich nach Bezirk und Kalenderwoche <br> Spatial unit: Canton Zürich <br> Format: csv <br> Additional remark: <br>
Metadata
| Fieldname | Beschreibung (DE) | Description (EN) | Format |
|---|---|---|---|
| PLZ | Postleitzahl* | Postalcode* | Zahl |
| Date | Datum des Befundes | Date of test result (NewConfCases) | Zahl |
| Population | Einwohner mit Hauptwohnsitz | Inhabitants with main residency | Zahl |
| NewConfCases_7days | Neue bestätigte Fälle in den letzten sieben Tagen (Kategorien) | Newly confirmed cases (Categories) | Text |
Geodata <br>
https://github.com/openZH/covid_19/blob/master/fallzahlen_plz/PLZ_gen_epsg4326_F_KTZH_2020.json <br>
https://github.com/openZH/covid_19/blob/master/fallzahlen_plz/PLZ_gen_epsg2056_F_KTZH_2020.json
Canton Zurich: Districts (Bezirk)
Data <br>
https://github.com/openZH/covid_19/blob/master/fallzahlen_bezirke/fallzahlen_kanton_ZH_bezirk.csv <br> Description: opendata.swiss: COVID_19 Verteilung der Fälle im Kanton Zürich nach Postleitzahl <br> Spatial unit: Canton Zürich <br> Format: csv <br>
Metadata
| Fieldname | Beschreibung (DE) | Description (EN) | Format |
|---|---|---|---|
| DistrictId | Bezirks-ID (BFS-Nummer)* | District (BFS-Id)* | Zahl |
| District | Bezirksname* | District name* | Text |
| Population | Wohnbevölkerung | Population | Zahl |
| Week | Kalenderwoche des Befundes (NewConfCases) / Todesdatums (NewDeaths) | Calendar week of test result (NewConfCases) / Date of death (NewDeaths) | Zahl |
| Year | Jahr des Befundes (NewConfCases) / Todesdatums (NewDeaths) | Year of test result (NewConfCases) / Date of death (NewDeaths) | Zahl |
| NewConfCases | Neue bestätigte Fälle | Newly confirmed number of cases | Zahl |
| NewDeaths | Neue Todesfälle | Newly confirmed number of deaths | Zahl |
| TotalConfCases | Total der bestätigten Fälle (kumuliert) | Total of confirmed cases (cumulated) | Zahl |
| TotalDeaths | Total der Todesfälle (kumuliert) | Total of confirmed deaths (cumulated) | Zahl |
Geodata
Canton Zurich: Travel self quarantine
Data <br>
https://github.com/openZH/covid_19/blob/master/fallzahlen_kanton_zh/COVID19_Einreisequarantaene_pro_KW.csv <br> Description: opendata.swiss: COVID_19 Einreisequarantäne im Kanton Zürich <br> Spatial unit: Canton Zürich <br> Format: csv <br>
Metadata
| Fieldname | Beschreibung (DE) | Description (EN) | Format |
|---|---|---|---|
| Kalenderwoche | Kalenderwoche | Calendar week | Zahl |
| Einreiseland | Aufenthaltsland vor der Einreise (Risikogebiete gemäss BAG-Liste) | Country of stay before entry (risk areas) | Text |
| Anzahl_Einreisende | Anzahl Einreisende aus Risikogebiet | Number of people returning from risk area | Zahl |
Canton Zurich: Intensive care occupancy
Data <br>
https://github.com/openZH/covid_19/blob/master/fallzahlen_kanton_zh/COVID19_Belegung_Intensivpflege.csv <br> Description: opendata.swiss: COVID_19 Belegung Intensivpflege Kanton Zürich <br> Spatial unit: Canton Zürich <br> Format: csv <br>
Metadata
| Fieldname | Description (EN) | Format |
|---|---|---|
| date | Date of notification | YYYY-MM-DD |
| time | Time of notification | HH:MM |
| abbreviation_canton_and_fl | Abbreviation of the reporting canton | Text |
| hospital_name | Full name of the hospital | Text |
| current_icu_service_certified | Reported number of certified 'Intensive Care Unit' (ICU) beds on date and time | Number |
| current_icu_target_covid | Target number of Covid19 patients in whose treatment a hospital would currently have to participate. (Target values are defined by the Health Department Canton Zurich together with the hospitals.) | Number |
| current_hosp_covid | Reported number of hospitalised Covid19 patients on date. (These data are communicated by the Health Department Canton Zurich on weekdays, and available here: https://github.com/openZH/covid_19/tree/master#swiss-cantons-and-principality-of-liechtenstein-unified-dataset) | Number |
| current_icu_covid | Reported number of hospitalised Covid19 patients in ICU on date. | Number |
| current_vent_covid | Reported number of hospitalised Covid19 patients requiring invasive ventilation on date. (These data are communicated by the Health Department Canton Zurich on weekdays, and available here: https://github.com/openZH/covid_19/tree/master#swiss-cantons-and-principality-of-liechtenstein-unified-dataset) | Number |
| current_icu_not_covid | Reported number of hospitalised non-Covid19 patients in ICU on date. | Number |
| current_icu_service_certified_operated | Reported number of currently operated certified 'Intensive Care Unit' (ICU) beds on date and time | Number |
| source | Source URL of the data reported. | String |
Canton Zurich: Variants of Concern
Note: ZH data is deprecated (2021-02-12) - this resource will not be updated further from 2021-02-12 as the week of 2021-02-15 will be used to analyse the completeness of the collection of available data and adjust the approach to which VOCs are tested. <br> Since 2021-02-19 FOPH publishes data for all Cantons ("virusVariants", https://www.covid19.admin.ch/api/data/context). <br> Variants of concern ('VOC') can not be detected by 'rapid' tests, but can be detected by PCR tests. Virus mutations are classified as being of concern because, among other things, they are more infectious than the wild type of the virus.
Data <br>
https://github.com/openZH/covid_19/blob/master/fallzahlen_kanton_zh/COVID19_VOC_Kanton_ZH.csv <br> Description: Ressource: "COVID_19 PCR-Tests und besorgniserregende Virusmutationen im Kanton Zürich" <br> Spatial unit: Canton Zürich <br> Format: csv <br>
Metadata
| Fieldname | Beschreibung (EN) | Format |
|---|---|---|
| date | Date of notification | YYYY-MM-DD |
| new_pcr_pos | Number of newly positive PCR tests | Number |
| new_voc | Number of newly detected variants of concern ('VOC') | Number |
Community Contributions
Visualization of Swiss and Cantonal Case Numbers over Time
- https://rsalzer.github.io/COVID_19_CH/
- https://rsalzer.github.io/COVID_19_KT_ZH/ <br>Robert Salzer on Twitter: https://twitter.com/rob_salzer
ArcGIS Dashboard
- https://covid19.ddrobotec.com/ github-repo <br>Zeno Davatz on Twitter: https://twitter.com/zdavatz
corona-data.ch
- https://www.corona-data.ch/ github-repo <br>Daniel Probst on Twitter: https://twitter.com/skepteis?lang=de
Interactive Small Multiples of Case Numbers by Canton
shellyBits Interactive Dashboard
REST-API
- https://covid19-rest.herokuapp.com
- github-repo <br>Andreas Pfeuti
Estimated reproduction number by Canton
- https://amkuhn.shinyapps.io/restimate/ <br>Alexandre Kuhn
Data for Basel-Stadt
- https://data.bs.ch/pages/covid-19-dashboard/<br>Open Government Data Basel-Stadt on Twitter: https://twitter.com/OpenDataBS
COVID-19 Data Hub
Visualization of Covid-19 cases in Switzerland
- https://www.covid19-data.ch/ github-repo <br>Marc Doerflinger on Twitter: https://twitter.com/doerfli
Many thanks for the great work!