CHF, ESRD and Sepsis about amsterdamumcdb

[patrickthoral]

The current database only contains the primary (and sometimes secondary) admission diagnoses (https://github.com/AmsterdamUMC/AmsterdamUMCdb/blob/master/concepts/diagnosis/reason_for_admission.ipynb).

Since ESRD (end stage renal disease) is never an ICU admission diagnosis you cannot directly select these patients. However, most patients will have data before the ICU admission (e.g. eGFR/Creatinine), so you might conclude this indirectly. In addition, patients with a shunt are bound to have ESRD (but as you can see, not many patients [142] have them):

index	itemid	item	item_en	abbreviation	categoryid	category	category_en	ordercategoryid	ordercategory	islabresult	valueid	value	unitid	unit	low_normal_value	high_normal_value	table	count	count_validated
7622	18736	Shunt	NaN	Shunt	422	PROC. Lijnen/Catheter/Drains	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	processitems	142	Na

Sepsis AND congestive hart failure are admission diagnoses, but since you can only have ONE primary diagnosis, you may need to decide whether you want to start with a cohort a patients with CHF as admission diagnosis, and then select those which fulfill the criteria for sepsis.