CHF, ESRD and Sepsis

[Gh-pishgahi]

Hi,
I want to evaluate admitted patients with ESRD, CHF, and Sepsis. I don't know if I consider the following values for CHF and ESRD, I have all of them or not? Could you please help me with how I can consider all ESRD and CHF patients? Considering the 'value' is a good approach to extract patients?
I have found different numbers of septic patients. Could you please tell me how many patients with sepsis exist? 3136 admission is correct?!

Values of CHF: 'Non-operatief Cardiovasculair - Congestief hart falen', 'Non-operative cardiovascular - CHF, congestive heart failure', 'Congestief hart falen', 'CHF, congestive heart failure'.

Values of ESRD: 'Dialyselijn Subclavia', 'DMC_Interne Geneeskunde_Renaal', 'Non-operatief Renaal', 'Dialyselijn', 'Apache II Operatief Renaal', 'Graft for dialysis, insertion of', 'D_Interne Geneeskunde_Renaal', 'Apache II Non-Operatief Renaal','Renaal', 'Post-operative cardiovascular - Graft for dialysis, insertion of'.

Thanks for your kind consideration,

[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.