Kantonale COVID-19-Fallzahlen
Offiziellen COVID-19-Fallzahlen aus alle Kantone der Schweiz verfügbar machen
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.
SARS-CoV-2 open government data reported by the Swiss Cantons and the Principality of Liechtenstein
Aim
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!)
- info@open.zh.ch
List of open government datasets published in this repository
Swiss Cantons and Principality of Liechtenstein
- Unified dataset
- More detailed dataset
Canton Zurich
- Unified dataset
- More detailed dataset
- Postal codes (Postleitzahl)
- Districts (Bezirke)
- Travel self quarantine
Don't forget to take a look at the community contributions.
Swiss Cantons and Principality of Liechtenstein: Unified dataset
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 | |
| abbreviationcantonand_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 |
Empty values vs. 0
| Value | Meaning |
|---|---|
| 0 | Zero cases are reported. |
| empty | No value is reported. |
Data collection
This list provides an overview of how the data is collected:
| Canton / FL | updated by | data historized |
|---|---|---|
| FL | scraping | yes |
| AG | scraping | yes |
| AI | scraping | yes |
| AR | scraping | yes |
| BE | scraping | yes |
| BL | scraping | yes |
| BS | manually | yes |
| FR | scraping | yes |
| GE | scraping | yes |
| GL | scraping | yes |
| GR | scraping | yes |
| JU | scraping | yes |
| LU | scraping | yes |
| NE | scraping | yes |
| NW | scraping | yes |
| OW | scraping | yes |
| SG | scraping | yes |
| SH | scraping | yes |
| SO | scraping | yes |
| SZ | scraping | yes |
| TG | scraping | yes |
| TI | scraping | yes |
| UR | scraping | yes |
| VD | scraping | yes |
| VS | scraping | yes |
| ZG | scraping | yes |
| ZH | scraping | yes |
Latest updates
The latest updates are visualized here. Note that this images is updated every 20 minutes.
Swiss Cantons and Principality of Liechtenstein: More detailed dataset
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
- See: https://github.com/openZH/covid_19/tree/master#canton-zurich-more-detailed-dataset
Unmaintained datasets
- COVID19FallzahlenKantonAGalter_geschlecht.csv
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 |
Canton Zürich: Unified dataset
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
Canton Zürich: More detailed dataset
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 |
Canton Zürich: Postal codes (Postleitzahl)
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
Canton Zurich: Districts (Bezirk)
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
Canton Zurich: Travel self quarantine
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 |
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/
Robert Salzer on Twitter: https://twitter.com/rob_salzer
ArcGIS Dashboard
- https://covid19.ddrobotec.com/
github-repo
Zeno Davatz on Twitter: https://twitter.com/zdavatz
corona-data.ch
- https://www.corona-data.ch/
github-repo
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
Andreas Pfeuti
Estimated reproduction number by Canton
- https://amkuhn.shinyapps.io/restimate/
Alexandre Kuhn
Data for Basel-Stadt
- https://data.bs.ch/pages/covid-19-dashboard/
Open Government Data Basel-Stadt on Twitter: https://twitter.com/OpenDataBS
COVID-19 Data Hub
Many thanks for the great work!
Synchronized
Readme fetched from source
Team forming
loleg has joined!
Worked on documentation
Team forming
muriel has joined!
Hackathon finished
Team forming
findMarcel has joined!
Team forming
Prabitha has joined!
Team forming
stromvirvel has joined!
Team forming
Taremeh has joined!
Team forming
mmznr has joined!
Team forming
matjung has joined!
Team forming
simonmettler has joined!
Worked on documentation
Team forming
rsalzer has joined!
Team forming
wadoli has joined!
Worked on documentation
Team forming
jbouman has joined!
Worked on documentation
Team forming
Somebody has joined!
Worked on documentation
Team forming
odi has joined!
Worked on documentation
Team forming
AndreasAmslerZH has joined!
Project started
Initialized by AndreasAmslerZH 🎉
Hackathon started
Connect to the community on Chat | Forum | Twitter
The contents of this website, unless otherwise stated, are licensed under a Creative Commons Attribution 4.0 International License.