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:
- https://twitter.com/OpenDataZH (follow us, we send you a private Direct Message, thanks!)
- [email protected]
Swiss Cantons and Principality of Liechtenstein
Canton Zurich
- Unified dataset
- More detailed dataset
- Postal codes (Postleitzahl)
- Districts (Bezirke)
- Travel self quarantine
- Intensive care occupancy
- 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)
- Vaccination campaign
Don't forget to take a look at the community contributions.
General description
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
https://github.com/openZH/covid_19/tree/master/fallzahlen_kanton_total_csv_v2
Description: Case numbers for each spatial unit separately
Spatial unit: Swiss cantons and Principality of Liechtenstein
Format: csv
Additional remark: Link to deprecated dataset (data structure has changed)
https://github.com/openZH/covid_19/blob/master/COVID19_Fallzahlen_CH_total_v2.csv
Description: Case numbers for all spatial units in one single file.
Spatial unit: Swiss cantons and Principality of Liechtenstein
Format: csv
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. |
The latest updates are visualized here.
Canton / FL | Last update (of any variable) | Important notes |
---|---|---|
FL | ||
AG | ||
AI | ||
AR | Since 2020-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 | ||
BL | ||
BS | ||
FR | ||
GE | ||
GL | ||
GR | ||
JU | ||
LU | ||
NE | ||
NW | ||
OW | ||
SG | ||
SH | ||
SO | ||
SZ | ||
TG | ||
TI | ||
UR | ||
VD | ||
VS | ||
ZG | ||
ZH |
Data
https://github.com/openZH/covid_19/tree/master/fallzahlen_kanton_alter_geschlecht_csv
Description: Selected cantons publish more detailed datasets.
Spatial unit: Swiss cantons and Principality of Liechtenstein
Format: csv
Additional remark: Not all datasets are maintained.
Maintained datasets
Unmaintained datasets
-
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
Field Name | Description | Format | Reporting Cantons |
---|---|---|---|
Date | ZH = Date of test result (NewConfCases) / Date of death (NewDeaths) BL = Date of death 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 |
Data
https://github.com/openZH/covid_19#swiss-cantons-and-principality-of-liechtenstein-unified-dataset
Description: open data swiss: COVID_19 Fallzahlen Kanton Zürich Total
Data
https://github.com/openZH/covid_19/blob/master/fallzahlen_kanton_alter_geschlecht_csv/COVID19_Fallzahlen_Kanton_ZH_altersklassen_geschlecht.csv
Description: open data swiss: COVID_19 Verteilung der Fälle im Kanton Zürich nach Altersklasse, Geschlecht und Kalenderwoche
Spatial unit: Canton Zürich
Format: csv
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
https://github.com/openZH/covid_19/blob/master/fallzahlen_kanton_alter_geschlecht_csv/COVID19_Einwohner_Kanton_ZH_altersklassen_geschlecht.csv
Description: Inhabitants per age category and gender.
Spatial unit: Canton Zürich
Format: csv
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
https://raw.githubusercontent.com/openZH/covid_19/master/fallzahlen_kanton_zh/COVID19_Anteil_positiver_Test_pro_KW.csv
Description: opendata.swiss: COVID_19 Anteil der positiven SARS-CoV-2 Tests im Kanton Zürich nach Kalenderwoche
Spatial unit: Canton Zürich
Format: csv
Additional remark:
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 |
Data
https://github.com/openZH/covid_19/blob/master/fallzahlen_plz/fallzahlen_kanton_ZH_plz.csv
Description: opendata.swiss: COVID_19 Fallzahlen Kanton Zürich nach Bezirk und Kalenderwoche
Spatial unit: Canton Zürich
Format: csv
Additional remark:
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
https://github.com/openZH/covid_19/blob/master/fallzahlen_plz/PLZ_gen_epsg4326_F_KTZH_2020.json
https://github.com/openZH/covid_19/blob/master/fallzahlen_plz/PLZ_gen_epsg2056_F_KTZH_2020.json
Data
https://github.com/openZH/covid_19/blob/master/fallzahlen_bezirke/fallzahlen_kanton_ZH_bezirk.csv
Description: opendata.swiss: COVID_19 Verteilung der Fälle im Kanton Zürich nach Postleitzahl
Spatial unit: Canton Zürich
Format: csv
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
Data
https://github.com/openZH/covid_19/blob/master/fallzahlen_kanton_zh/COVID19_Einreisequarantaene_pro_KW.csv
Description: opendata.swiss: COVID_19 Einreisequarantäne im Kanton Zürich
Spatial unit: Canton Zürich
Format: csv
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 |
Data
https://github.com/openZH/covid_19/blob/master/fallzahlen_kanton_zh/COVID19_Belegung_Intensivpflege.csv
Description: opendata.swiss: COVID_19 Belegung Intensivpflege Kanton Zürich
Spatial unit: Canton Zürich
Format: csv
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 |
source | Source URL of the data reported. | String |
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.
Since 2021-02-19 FOPH publishes data for all Cantons ("virusVariants", https://www.covid19.admin.ch/api/data/context).
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
https://github.com/openZH/covid_19/blob/master/fallzahlen_kanton_zh/COVID19_VOC_Kanton_ZH.csv
Description: Ressource: "COVID_19 PCR-Tests und besorgniserregende Virusmutationen im Kanton Zürich"
Spatial unit: Canton Zürich
Format: csv
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 |
Status (2021-02-12): Metadata description (s. below) is currently under review (Fieldnames tbc. are not definitive); Data structure is under preparation; Data publication is forthcoming (expected to start mid-February).
Please share your feedback/questions regarding variables/descriptions with us here: openZH#1663.
Data
https://...
Description: (expected) Dataset: "COVID_19 Impfkampagne im Kanton Zürich"
Spatial unit: Canton Zurich
Format: csv
Metadata
Variable type | Fieldname | Beschreibung (DE) | Description (EN) | Format |
---|---|---|---|---|
Personal data | gender | Geschlecht | Gender | Text |
Personal data | age | Alter (automatisch berechnet aus Geburtsdatum) | Age (automatically calculated from date of birth) | Number |
Personal data | canton_or_country_of_residence tbc. | Wohnkanton ('AG', 'AI', 'AR' ... 'ZG', 'ZH') oder -sitz (Land: 'LI', 'AT', 'DE', 'F', 'I', 'UNK') | Canton ('AG', 'AI', 'AR' ... 'ZG', 'ZH') or country of residence ('LI', 'AT', 'DE', 'F', 'I', 'UNK') | Text |
Vaccination indication according to strategy | age_group tbc. | ja/nein (Liste gemäss Impfempfehlung EKIF) tbc. | yes/no (list according to vaccination recommendation EKIF) tbc. | tbc. |
Vaccination indication according to strategy | people_with_chronic_diseases tbc. | ja/nein (Chronische Krankheit(en), Bluthochdruck etc.) | yes/no (Chronic disease(s), high blood pressure etc.) | Text |
Vaccination indication according to strategy | health_care_personnel tbc. | ja/nein (Gesundheits- und Betreuungspersonal, das durch Pflege, Behandlung und Betreuung direkte Kontakte mit Patientinnen und Patienten sowie besonders gefährdeten Personen hat) | yes/no (health and care personnel who have direct contact with patients and particularly vulnerable persons through nursing, treatment and care) | Text |
Vaccination indication according to strategy | close_contact_persons tbc. | ja/nein (Personen ab 16 Jahren, die mit besonders gefährdeten Personen im selben Haushalt leben (z.B. Partner/in, Familienmitglieder, Mitbewohner/innen, Haushälter/in, Au-pairs) oder pflegende Angehörige) | yes/no (persons aged 16 and over who live in the same household with particularly vulnerable persons (e.g. partner, family members, flatmates, housekeepers, au-pairs) or caring relatives) | Text |
Vaccination indication according to strategy | people_in_community_facilities tbc. | ja/nein (Heime und Einrichtungen für Menschen mit Behinderungen, psychosomatische und psychiatrische Kliniken, Bundesasylzentren und kantonale Kollektivunterkünfte für Asylsuchende, Obdachlosenunterkünfte und Anstalten des Freiheitsentzugs) | yes/no (homes and facilities for people with disabilities, psychosomatic and psychiatric clinics, federal asylum centres and cantonal collective accommodation for asylum seekers, accommodation for the homeless and institutions for deprivation of liberty) | Text |
Vaccination indication according to strategy | further_indications tbc. | ja/nein | yes/no | Text |
Details 1st vaccination | place_canton_vaccination_1 tbc. | Ort (Kanton) der 1. Impfung (automatisch berechnet aus PLZ) | Place (Canton) of 1st vaccination (automatically calculated from POSTCODE) | Text |
Details 1st vaccination | place_type_vaccination_1 tbc. | Ort (Typ) der 1. Impfung ('1'=Impfzentrum, '2'=Alters- und Pflegeheim, '3'=Arztpraxis, '4'=Apotheke, '5'=andere (legacy), '6'=Spital, '99'=andere) | Place (type) of 1st vaccination ('1'=vaccination centre, '2'=home for the elderly and nursing home, '3'=doctor's surgery, '4'=pharmacy, '5'=other (legacy), '6'=hospital, '99'=other) | Number (Controlled vocabulary) |
Details 1st vaccination | id_reporting_system_vaccination_1 tbc. | Eindeutige ID des Meldesystems (tbc.) | Unique ID of the reporting system (tbc.) | Number (Controlled vocabulary) |
Details 1st vaccination | id_vaccination_unit_vaccination_1 tbc. | Eindeutige ID der Impf-Einheit innerhalb des Meldesystems, z.B. Impfzentrum A oder Spital B, die beide das Meldesystem X nutzen (tbc.) | Unique ID of the vaccination unit within the reporting system, e.g. vaccination centre A or hospital B, both of which use reporting system X (tbc.) | Number (tbc.) |
Details 1st vaccination | id_vaccination_action_vaccination_1 tbc. | Eindeutige ID der Impf-Aktion; wird von der Impf-Einheit erzeugt | Unique ID of the vaccination action; generated by the vaccination unit | Number |
Details 1st vaccination | id_anonymous_person_vaccination_1 tbc. | Eindeutige anonyme ID der Person; wird von der Impf-Einheit erzeugt | Unique anonymous ID of the person; generated by the vaccination unit | Number |
Details 1st vaccination | date_vaccination_1 | Datum der 1. Impfung | Date of 1st vaccination | YYYY-MM-DD |
Details 1st vaccination | vaccine_code_vaccination_1 | Impfstoff Code (Global Trade Item Number, GTIN) der 1. Impfung | Vaccine code (Global Trade Item Number, GTIN) of 1st vaccination | Number (Controlled vocabulary) |
Details 1st vaccination | batch_number_vaccination_1 tbc. | Losnummer der 1. Impfung tbc. | Batch number of 1st vaccination tbc. | Number |
Details 2nd vaccination | place_canton_vaccination_2 tbc. | Ort (Kanton) der 2. Impfung (automatisch berechnet aus PLZ) | Place (Canton) of 2nd vaccination (automatically calculated from POSTCODE) | Text |
Details 2nd vaccination | place_type_vaccination_2 tbc. | Ort (Typ) der 2. Impfung ('1'=Impfzentrum, '2'=Alters- und Pflegeheim, '3'=Arztpraxis, '4'=Apotheke, '5'=andere (legacy), '6'=Spital, '99'=andere) | Place (type) of 2nd vaccination ('1'=vaccination centre, '2'=home for the elderly and nursing home, '3'=doctor's surgery, '4'=pharmacy, '5'=other (legacy), '6'=hospital, '99'=other) | Number (Controlled vocabulary) |
Details 2nd vaccination | id_reporting_system_vaccination_2 tbc. | Eindeutige ID des Meldesystems (tbc.) | Unique ID of the reporting system (tbc.) | Number (Controlled vocabulary) |
Details 2nd vaccination | id_vaccination_unit_vaccination_2 tbc. | Eindeutige ID der Impf-Einheit innerhalb des Meldesystems, z.B. Impfzentrum A oder Spital B, die beide das Meldesystem X nutzen (tbc.) | Unique ID of the vaccination unit within the reporting system, e.g. vaccination centre A or hospital B, both of which use reporting system X (tbc.) | Number (tbc.) |
Details 2nd vaccination | id_vaccination_action_vaccination_2 tbc. | Eindeutige ID der Impf-Aktion; wird von der Impf-Einheit erzeugt | Unique ID of the vaccination action; generated by the vaccination unit | Number |
Details 2nd vaccination | id_anonymous_person_vaccination_2 tbc. | Eindeutige anonyme ID der Person; wird von der Impf-Einheit erzeugt | Unique anonymous ID of the person; generated by the vaccination unit | Number |
Details 2nd vaccination | date_vaccination_2 | Datum der 2. Impfung | Date of 2nd vaccination | YYYY-MM-DD |
Details 2nd vaccination | vaccine_code_vaccination_2 | Impfstoff Code (Global Trade Item Number, GTIN) der 2. Impfung | Vaccine code (Global Trade Item Number, GTIN) of 2nd vaccination | Number (Controlled vocabulary) |
Details 2nd vaccination | batch_number_vaccination_2 tbc. | Losnummer der 2. Impfung tbc. | Batch number of 2nd vaccination tbc. | 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://covid19-rest.herokuapp.com
- github-repo
Andreas Pfeuti
- https://amkuhn.shinyapps.io/restimate/
Alexandre Kuhn
- https://data.bs.ch/pages/covid-19-dashboard/
Open Government Data Basel-Stadt on Twitter: https://twitter.com/OpenDataBS
- https://www.covid19-data.ch/
github-repo
Marc Doerflinger on Twitter: https://twitter.com/doerfli
Many thanks for the great work!