`charttime` seem to be wrong by over 1 year in `chartevents` in MIMIC IV
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 3.4k
- Forks
- 1.7k
- PR merge metrics
- No merged PRs in 30d
Description
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
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the ICU/chartevents data and compare the listed stay_id, itemid, and charttime values against neighboring observations and the online documentation. Done means determining whether the roughly one-year timestamp discrepancies are expected or confirmed data errors, then documenting the finding or an agreed correction path.
Written by the indexing model from the issue text.
Assessment
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100