yugangjia

Thanks. I do find more patients with diagnosis table. My updated query is like this: select distinct * from ( select distinct patientunitstayid from physionet-data.eicu_crd.pasthistory where pasthistorypath in ( "notes/Progress...

select distinct * from ( select distinct patientunitstayid from `physionet-data.eicu_crd.pasthistory` where pasthistorypath in ( "notes/Progress Notes/Past History/Organ Systems/Gastrointestinal (R)/Cirrhosis/jaundice", "notes/Progress Notes/Past History/Organ Systems/Gastrointestinal (R)/Cirrhosis/UGI bleeding", "notes/Progress Notes/Past History/Organ Systems/Gastrointestinal (R)/Cirrhosis/encephalopathy",...

I searched cabg in diagnosis table and got the following items. It seems to be CABG patients before this admission. cardiovascular|cardiac surgery|s/p CABG < 7 days cardiovascular|cardiac surgery|CABG < 7days...