Ventilator duration inconsistent with charted data

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.physionet.org/about/mimic/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=

Description

Hello,

I was looking at the chartevents table for patients who were on ventilation. I was able to see that their ventilation duration was for example 100 hours but the PEEP and Fi02 readings are captured only for 2 days/48 hours.

For example subject_id = 1354 was in icu from 18th - 22nd but his/her PEEP/Fio2 readings were captured only till 19th in chartevents table.

Similarly subject_id = 78996

I see similar scenario for several other subjects. data is missing for several other subjects like this.

Is this expected or am I making any mistake? Please find the query that I tried. I understand it has lot of itemids but these were used for PEEP and Fi02. few may not be directly related. I was expecting to see the readings till 22nd. I mean for his full duration.

select min(charttime), max(charttime) from `physionet-data.mimiciii_clinical`.chartevents where subject_id = 1354 and icustay_id = 224934 and itemid in (1096, 505, 506, 60, 437, 3555, 8053,1227,686,5964,8345,8357,6349,6350,6985,7534,7802,7803,6489,6601, 6859,6889,6924, 6943,224699,224700,220339,1040,1206,185, 186,189,190,191,727,3420,3421,3422,1863, 5955,2518,2981,7018,7041,7570,8517,226754,227009,227010,160,727,3420,223835)

Start with the supplied chartevents query for subject_id 1354 and icustay_id 224934, then compare the listed PEEP/FiO2 itemids with the ICU stay dates; repeat for subject_id 78996. Done means documenting whether the shorter charted range is expected or identifying a reproducible data problem.