Identify patients who went through CABG in eicu database

[yugangjia]

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, redo","CABG with double valve repair/replacement", "CABG with aortic valve replacement","CABG with other operation","CABG with mitral valve repair","CABG redo with other operation","CABG with pulmonic or tricuspid valve repair or replacement ONLY.","CABG, minimally invasive; mid-CABG")

[jraffa]

Possible to pickup some more in the diagnosis table.

[yugangjia]

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 cardiovascular|cardiac surgery|s/p CABG < 7 days|with CPB cardiovascular|chest pain / ASHD|coronary artery disease|s/p CABG cardiovascular|cardiac surgery|s/p CABG >= 7 days cardiovascular|chest pain / ASHD|coronary artery disease|no previous CABG cardiovascular|cardiac surgery|s/p CABG < 7 days|minimally invasive