SARS-CoV-2 open government datasets

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 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!)
mailto:[email protected]

List of open government datasets published in this repository

Swiss Cantons and Principality of Liechtenstein

• Unified dataset
  
• More detailed dataset
  

Conton Zürich

• Unified dataset
  
• More detailed dataset
  
• Postal codes (Postleitzahl)
  
• Districts (Bezirk)
  

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 at 6pm 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: In contrast to https://github.com/openZH/covid_19/blob/master/fallzahlen_kanton_total_csv/

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: In contrast to https://github.com/openZH/covid_19/blob/master/COVID19_Fallzahlen_CH_total.csv ...

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

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/kalakaru/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/kalakaru/covid_19/blob/master/README.md#conton-z%C3%BCrich-more-detailed-dataset

Unmaintained datasets

• COVID19_Fallzahlen_Kanton_AG_alter_geschlecht.csv

• COVID19_Fallzahlen_Kanton_AI_alter_geschlecht.csv

• COVID19_Fallzahlen_Kanton_AR_alter_geschlecht.csv

• COVID19_Fallzahlen_Kanton_BS_alter_geschlecht.csv

• COVID19_Fallzahlen_Kanton_ZH_alter_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

Conton Zürich: Unified dataset

See:

• https://github.com/kalakaru/covid_19/blob/master/README.md#swiss-cantons-and-principality-of-liechtenstein-unified-dataset
• open data swiss: COVID_19 Fallzahlen Kanton Zürich Total

Conton 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: Conton 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: Conton 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

Conton Zürich: Postal codes (Postleitzahl)

Data

https://github.com/kalakaru/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: Conton 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/kalakaru/covid_19/blob/master/fallzahlen_plz/PLZ_gen_epsg4326_F_KTZH_2020.json

https://github.com/kalakaru/covid_19/blob/master/fallzahlen_plz/PLZ_gen_epsg2056_F_KTZH_2020.json

Conton Zürich: Districts (Bezirk)

Data

https://github.com/kalakaru/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: Conton 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

https://github.com/kalakaru/covid_19/blob/master/fallzahlen_bezirke/BezirkeAlleSee_gen_epsg4326_F_KTZH_2020.json

https://github.com/kalakaru/covid_19/blob/master/fallzahlen_bezirke/BezirkeAlleSee_gen_epsg2056_F_KTZH_2020.json

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

• https://sars-cov-2-switzerland.netlify.com/

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

• https://covid19datahub.io
• https://github.com/covid19datahub/COVID19/

Many thanks for the great work!