Data Dictionary

Patients

	Column Name	Data Type	Required?	Description
🔑	Id	UUID	true	Primary Key. Unique Identifier of the patient.
	BirthDate	Date (YYYY-MM-DD)	true	The date the patient was born.
	DeathDate	Date (YYYY-MM-DD)	false	The date the patient died.
	Age	Integer	true	Patients Age
	Gender	String	true	Gender. M is male, F is female.
	County	String	false	Patient's address county.
	Lat	Numeric	false	Latitude of Patient's address.
	Lon	Numeric	false	Longitude of Patient's address.

County

	Column Name	Data Type	Required?	Description
🔑	County	String	true	County the patient lives in.
	Population	integer	true	Population of the county.
	Density	integer	true	Population density in the county in people/mi².
	Seaside	Bool	true	Information if the county has a seaside.

Covid

	Column Name	Data Type	Required?	Description
🔑	Start	Date (YYYY-MM-DD)	true	The date the patient was infected with Covid.
	Stop	Date (YYYY-MM-DD)	false	The date the Covid infection was cured.
	duration	days	true	The duration the patient was infected.

SEVID Score

	Column Name	Data Type	Required?	Description
🔑	Ventilation	bool	true	The information if the usage of a ventilator was needed.
	Medications	bool	true	The information if the patient got Medications
	Disorder	string	true	The symptoms a patient had.
	death	bool	true	The information if the patient died.
	inpatient	bool	true	The information if the patient was hospitalized.

Aus diesen Daten wurde das Factsheet mithilfe des Sternschemas generiert.