Switzerland COVID-19 data

In the switzerland schema, we have data related to this country. So far, the tables available are related to the COVID-19 and stratified by canton¹. They were provided by the FOPH². In the table below, we have a brief description of the content of each table. For each of them, we have another table named {table_name}_meta that contains an explanation of the columns in the table.

For example, in the switzerland schema, we have a table called foph_cases_d that represents the daily records timelines for cases in each canton of Switzerland. The meaning of the columns of this table are explained in the foph_cases_d_meta table.

The georegion column is a two-letter code representing the cantons of Switzerland.

Table name	Keys	Content	Source
foph_cases_d	date, georegion	Daily record timelines by georegion for cases.	FOPH2
foph_casesvaccpersons_d	date, georegion	Daily record timelines for cases of fully vaccinated persons by vaccine. Data only available for georegion CHFL. This file has been deprecated and will no longer be updated after 11.11.2021.	FOPH2
foph_covidcertificates_d	date, georegion	Daily record timelines for cases of fully vaccinated persons by vaccine. Data only available for georegion CHFL. This file has been deprecated and will no longer be updated after 11.11.2021.	FOPH2
foph_death_d	date, georegion	Daily record timelines by georegion for deaths.	FOPH2
foph_deathvaccpersons_d	date, georegion	Daily record timelines for deaths of fully vaccinated persons by vaccine. Data only available for georegion CHFL.	FOPH2
foph_hosp_d	date, georegion	Daily record timelines by georegion for hospitalisations.	FOPH2
foph_hospcapacity_d	date, georegion	Daily hospital capacity data timelines by georegion.	FOPH2
foph_hospcapacitycertstatus_d	date, georegion	Daily hospital capacity data timelines of certified/ad-hoc status of operational ICU beds by georegion.	FOPH2
foph_hospvaccpersons_d	date, georegion	Daily record timelines for hospitalisations of fully vaccinated persons by vaccine. Data only available for georegion CHFL.	FOPH2
foph_intcases_d	date, georegion	International daily data (cases). This file has been deprecated and will no longer be updated after 05.04.2022.	FOPH2
foph_re_d	date, georegion	Reproductive number for the cantons in Switzerland	FOPH2
foph_test_d	date, georegion	Daily record timelines by georegion for tests (all test types combined).	FOPH2
foph_testpcrantigen_d	datum, georegion	Daily record timelines by georegion and test type (pcr/antigen) for tests.	FOPH2

canton¹ - refers to a political division of Switzerland.

FOPH² - Federal Office of Public Health