I wonder whether APACHE scores are available somewhere in MIMIC-III.
There doesn't seem to be any widely used APACHE ITEMIDs in the table CHARTEVENTS
:
SELECT LABEL, COUNT(*) cnt
FROM mimiciii.CHARTEVENTS,
mimiciii.d_items
WHERE LOWER(d_items.LABEL) LIKE '%apache%'
and CHARTEVENTS.itemid = d_items.itemid
GROUP BY d_items.LABEL
ORDER BY cnt DESC ;