To obtain the start and stop times for non-invasive mechanical ventilation for each ICU stay event in MIMIC, I tried to use:
SELECT ICUSTAY_ID, MIN(CHARTTIME) start_mv, MAX(CHARTTIME) stop_mv FROM mimiciii.CHARTEVENTS WHERE ITEMID IN (225794) GROUP BY ICUSTAY_ID;
SELECT itemid, label, linksto FROM mimiciii.d_items WHERE LOWER(label) LIKE '%vent%' ORDER BY itemid ASC;`
SELECT COUNT(*) FROM mimiciii.IOEVENTS WHERE ITEMID = 225794;
0 so it doesn't work.
ITEMIDs should I look at to obtain the start and stop times for non-invasive mechanical ventilation in MIMIC?
E.g. for invasive mechanical ventilation, the
ITEMIDs to look for are
('720', '722', '224685', '682', '683', '224686', '684', '224684', '721').