yugangjia

### Prerequisites * [X ] Put an X between the brackets on this line if you have done all of the following: * Checked the online documentation: https://mimic.mit.edu/ * Checked...

Identify people who was electively admitted

1

Should I look at admitdxpath only? Any other data source for this info?

Identify patients with Cirrhosis

4

Hi, I am trying to identify patients with Cirrhosis before their icu admission. I searched the "pasthistorypath" in the physionet-data.eicu_crd.pasthistory table and find out the following values are relevant with...

Identify patients who went through CABG in eicu database

2

Here is my code, any comments? select distinct patientunitstayid from `physionet-data.eicu_crd.patient` where apacheadmissiondx in ("CABG alone, coronary artery bypass grafting","CABG redo with valve repair/replacement", "CABG with mitral valve replacement","CABG alone,...