Chapter 18 (trend analysis), how to retrieve year? about critical-data-book HOT 16 CLOSED

If you're extracting this from MIMIC II or III, the dates have been shifted, and the years should be nonsensical as the shifting is necessary to protect PHI. It is possible to apply for access to get the actual years, and I would e-mail [email protected] to ask how.

I am not certain, but the authors likely applied for this additional access themselves, and this was how they were able to write their chapter.

Since this isn't a question related to the code, I will close the issue, but if I have misunderstood, feel free to let me know.

from critical-data-book.

@jinjinzhou as Jesse mentions, the dates are shifted by several hundred years for de-identification purposes. Are you looking at the raw text or using an application like Excel? Excel mashes up the shifted dates, which might explain why you are seeing a nonsensical value.

from critical-data-book.

from critical-data-book.

@jinjinzhou There is no need to email us. We prefer to discuss these issues on the public repository (as noted at: https://mimic.physionet.org/help/).

You can typically treat the dates in MIMIC as standard dates. It should not be necessary to translate them. What software are you using the view the data?

from critical-data-book.

from critical-data-book.

The date that you've listed above (CHARTTIME, is 5/12/34 12:00) does not occur in MIMIC-III as far as I am aware. If this date appears in your database, please provide us with a query to find this value (e.g. select charttime from chartevents where row_id = X). Please also read https://www.nature.com/articles/sdata201635 and https://mimic.physionet.org/mimicdata/time/ if you have not already done so.

from critical-data-book.

How are you viewing it in R? Are you using RPostgreSQL?

from critical-data-book.

from critical-data-book.

It is difficult to diagnosis this if we can't replicate it on our end. Are you are able to find what @tompollard has asked for? (row_id)

from critical-data-book.

from critical-data-book.

Jin, can you post the image on github.com, it's not showing up here.
#14

from critical-data-book.

from critical-data-book.

from critical-data-book.

Jin, can you post the image on github.com, it's not showing up here.
#14

The data set description about chartevents.csv is available from the website https://mimic.physionet.org/mimictables/chartevents/
The dates are all shifted based on the website https://mimic.physionet.org/mimicdata/time/
It seems that only year had been shifted. Month and day are from original record.
I am just wondering is there anyway to find original year for each observation.

from critical-data-book.

To echo above comment, we don't need to have exact year - just a number in the same order as the calendar year order. Thanks,

from critical-data-book.

The year (or sequence by year) is not available in MIMIC-III unfortunately. We understand that this is a limitation and are considering alternative options for handling de-identification for the next release of MIMIC.

from critical-data-book.