`charttime` seem to be wrong by over 1 year in `chartevents` in MIMIC IV
Opened this issue · 0 comments
mpierrau commented
Prerequisites
- Put an X between the brackets on this line if you have done all of the following:
- Checked the online documentation: https://mimic.mit.edu/
- Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=
Description
While processing the ICU/chartevents
file I discovered a number of seemingly incorrect timestamps for (at least) 35 stay id's on a total of 106 rows. The error is characterized by one (or multiple related) parameter(s) having a single observation that is around 365 days earlier/later than the next/previous observation.
The table below indicates which stay_id, itemid and charttime values are impacted. I'm mainly posting this here for information as the number of impacted is low enough that this simply comes down to data entry errors.
Let me know if you would like some more information about this issue.
stay_id | itemid | charttime |
---|---|---|
35018903 | 224690,224689 | 2127-08-05 20:42:00 |
30966322 | 225668,220274,226063 | 2113-05-26 12:32:00 |
33483753 | 223835 | 2120-12-23 22:00:00 |
30586760 | 223761,220045,220277 | 2175-06-11 20:00:00 |
34773087 | 220045,220180,220181,220210,220277,223761,220179 | 2180-01-03 23:35:00 |
38231972 | 223835 | 2179-11-21 00:00:00 |
36223916 | 223901,223900,220739 | 2152-09-30 00:00:00 |
39531674 | 223901,223900,220739 | 2114-01-28 20:27:00 |
38145046 | 223901,223900,220739 | 2117-03-19 00:00:00 |
37234590 | 223901,223900,220739 | 2151-03-02 |
33045087 | 223901,223900,220739 | 2187-11-02 23:00:00 |
31206864 | 223901,223900,220739 | 2150-10-09 00:00:00 |
38003809 | 223901,223900,220739 | 2153-03-09 00:00:00 |
37788644 | 223901,223900,220739 | 2120-04-17 04:00:00 |
36570472 | 223901,223900,220739 | 2172-10-24 04:00:00 |
36412149 | 223901,223900,220739 | 2150-05-01 20:00:00 |
35786353 | 223901,223900,220739 | 2158-08-18 20:00:00 |
32889695 | 223901,223900,220739 | 2116-07-12 00:00:00 |
38202389 | 223901,223900,220739 | 2165-07-07 23:01:00 |
37849566 | 223901,223900,220739 | 2137-10-06 21:00:00 |
32266080 | 223901,223900,220739 | 2112-04-29 00:15:00 |
32568586 | 223901,223900,220739 | 2177-05-11 00:00:00 |
32715168 | 223901,223900,220739 | 2194-09-21 00:00:00 |
36052524 | 223901,223900,220739 | 2131-09-06 00:00:00 |
37179437 | 223901,223900,220739 | 2189-06-08 00:00:00 |
30433797 | 223901,223900,220739 | 2148-01-02 00:00:00 |
38427713 | 223901,223900,220739 | 2157-06-05 00:00:00 |
31945426 | 223901,223900,220739 | 2182-03-24 00:00:00 |
36751420 | 223901,223900,220739 | 2185-05-07 00:00:00 |
32482285 | 223901,223900,220739 | 2150-12-11 00:00:00 |
31911210 | 223901,223900,220739 | 2165-01-13 00:00:00 |
32662398 | 223901,223900,220739 | 2150-08-19 20:00:00 |
36712541 | 223901,223900,220739 | 2164-03-11 00:00:00 |
31229999 | 223901,223900,220739 | 2135-08-18 00:00:00 |
34337346 | 223830 | 2192-04-04 15:20:00 |
Edit: typos