Datenstruktur

PATIENTS_ID	Herkunft
Id	patients_INFO_Id
BIRTHDATE	patients_INFO_BIRTHDATE
DEATHDATE	patients_INFO_DEATHDATE
GENDER	patients_INFO_GENDER
COUNTY	patients_INFO_COUNTY
LAT	patients_INFO_LAT
LON	patients_INFO_LON

COUNTY_ID	Herkunft
DENSITY_per_sqm	county_info_DENSITY_per_sqm
SEASIDE	county_info_SEASIDE

CONDITIONS_ID	Herkunft
stdt_covid	conditions_INFO_START (Filter: 'COVID19')
endt_covid	conditions_INFO_STOP (Filter: 'COVID19')
AGE_Covid	Neu: Berechnet aus BIRTHDATE und stdt_covid

SEVID_ID	Herkunft	Filter
Ventilation	procedures_INFO_DESCRIPTION	Filter nach 'Mechanical ventilator (physical object)'; Gruppiert nach 'Patient'
Medications	medications_info_REASONDESCRIPTION	Filter nach 'COVID-19'; Gruppiert nach 'Patient'
inpatient	encounters_info_ENCOUNTERCLASS	Filter nach 'inpatient'; Gruppiert nach 'Patient'
Disorder	conditions_INFO_DESCRIPTION	Filter nach 'Disorder'; Gruppiert nach 'Patient'
Death	Neu: Grundlage DEATHDATE