6 votes

MIMIC III : Date and Time when Diagnosis Code was determined for the patient, say Septic Shock

It is important to be aware that the ICD-9 codes are assigned to hospital stays primarily for billing purposes. The codes are recorded by a coding team upon patient discharge, following a review of ...
tomp's user avatar
  • 1,446
6 votes
Accepted

Why are lab tests splitted into 2 tables: chartevents and labevents?

LABEVENTS data is from the actual hospital wide laboratory data management system. CHARTEVENTS data is from the ICU database that is used as an electronic chart for the patient at the bedside. Since ...
alistairewj's user avatar
5 votes
Accepted

MIMIC-III: Negative cultures and microbiologyevents

Negative cultures were added to the microbiologyevents table in version 1.4 of MIMIC-III: http://mimic.physionet.org/about/releasenotes/ #188 - Negative microbiology cultures are now recorded in ...
alistairewj's user avatar
4 votes
Accepted

Looking for admitting SAPS score for first hospitalization of patients in MIMICIII

Code for severity scores and other related clinical concepts can be found in the mimic-code repository: https://github.com/MIT-LCP/mimic-code
alistairewj's user avatar
4 votes
Accepted

Looking for equivalence of MIMIC-II v2.6 dataset in MIMIC-III v1.3

You're correct - the category type "PROCEDURE" in the mimic2v26.d_codeditems table refers to ICD-9 procedure codes. These have been more explicitly delineated in MIMIC-III: the equivalent definitions ...
alistairewj's user avatar
4 votes

Time of death in-hospital?

On MIMIC-III v1.1 and v1.3: SELECT DEATHTIME FROM mimiciii.admissions WHERE DEATHTIME IS NOT NULL ORDER BY DEATHTIME ASC LIMIT 500 ; Maybe you use MIMIC-II.
Franck Dernoncourt's user avatar
4 votes
Accepted

How much did MIMIC have to pay hospitals to get access to their data?

While hospitals charging for data access is a disappointing trend, I don't think MIMIC paid for access in the sense implied by the question. The research and development of MIMIC is the product of ...
Tristan's user avatar
  • 116
3 votes

Want to understand MIMIC III warning in table Chartevents

The chartevents table of MIMIC-III is populated with data that has been archived by Metavision ICU, a clinical information system that integrates charted data from various sources, for example heart ...
tomp's user avatar
  • 1,446
3 votes

The unit for blood cell number is different in labevent. How could I unify them?

You've actually found a bug in MIMIC-III v1.3. Some of the CD counts were muddled - actual counts (#/uL) were merged with percentages, and vice versa. If you look at the LOINC code for percent CD8 (...
alistairewj's user avatar
3 votes

loading MIMIC III into SQL Server

The data files conform to the RFC 4180 specification, which is as close as CSVs get to a formal standard. Loading a RFC 4180 formatted CSV is trivial for many database systems. For example, the load ...
tomp's user avatar
  • 1,446
3 votes

Pulse transit time values (PTT)

I will assume you are using the MIMIC-II v3 Waveform database. If you look at section 5.4 of the MIMIC-II user guide (warning, 2.3 MB PDF), you will see the following: Inter-waveform alignment ...
alistairewj's user avatar
2 votes

How to map WFDB_Annotation().getTime() to actual timestamps?

I believe (based on work in June 2015 using MIMIC II v2.6) that the waveforms and the EMR were time-shifted separately, meaning that while some of the patient IDs have been matched, you cannot match ...
user10452's user avatar
2 votes
Accepted

Where can I get previous versions of MIMIC-III?

Only the most up-to-date version is made available to the research community via PhysioNet, but past versions are archived and may be shared upon request. Contact information is available on the MIMIC ...
tomp's user avatar
  • 1,446
2 votes

How to retrieve discharge summaries?

Try Discharge summary: select category, count(*) from mimiciii.noteevents group by category order by category asc;
Franck Dernoncourt's user avatar
2 votes
Accepted

Relation of MIMIC-II v2.6 and MIMIC-III v1.3 patients records

The vast majority of patients who appear in MIMIC-II v2.6 also appear in MIMIC-III v1.3. These patients retain the same subject_id and can be selected across versions of the database using the ...
tomp's user avatar
  • 1,446
2 votes
Accepted

Inquiry about number of adults in MIMIC-III v1.3

The following query confirms that there are 46,520 distinct patients in MIMIC-III v1.3: SELECT count(distinct subject_id) FROM admissions; -- returns 46520. The following query confirms that the ...
tomp's user avatar
  • 1,446
2 votes

Start and stop times for non-invasive mechanical ventilation in MIMIC

I'm also new to MIMIC and not an expert, but I recently discovered that it is possible to find start and stop times for mechanical ventilation in the procedureevents_mv table.
zss's user avatar
  • 121
2 votes
Accepted

Past medical/medication history in MIMIC-III

This data was unavailable in v1.3 but has now been added and is available in v1.4 (released Sept 2nd 2016).
alistairewj's user avatar
2 votes

mimic-iii - Age adjustment for >89 year olds

I think the answer depends on what you are looking to achieve in your analysis and how you would like to treat this set of patients. Your suggested approach should be fine if you intend to group ...
tomp's user avatar
  • 1,446
2 votes

MIMIC dataset : How to find time since first admission

I will reinterpret your question as "For patients who are still alive, what censor time is appropriate?". The minimum amount of time a patient must survive in order to not have a date of death in the ...
alistairewj's user avatar
2 votes

Experience in transforming MIMIC-III dataset to follow EHR standards?

https://github.com/MIT-LCP/mimic-code/tree/master/buildmimic lists several different distributions of MIMIC: apache-drill, docker, hana, monetdb, mysql, oracle, postgres, vagrant. Sven Van Poucke ...
Franck Dernoncourt's user avatar
2 votes
Accepted

MIMIC-III - days of the week?

Days of the week and approximate seasonality are preserved in the date shift - see section 1.4.4 of the MIMIC II user guide for more details: http://mimic.physionet.org/archive/mimic-ii-guide.pdf (the ...
alistairewj's user avatar
2 votes

How to associate the MIMIC II Waveform Matched database to the MIMIC III Clinical database?

That missingness is perfectly valid. Some patient records were removed from the MIMIC database after they were added, potentially due to privacy concerns or corrupted data. You have to work with only ...
Tanachat's user avatar
  • 153
2 votes

Where is the "MIMIC-III Waveform Database"?

As far as I know the MIMIC-III Waveform Database is not publicly available yet.
Franck Dernoncourt's user avatar
2 votes

Are doses in inputevents_mv correct?

This was an issue in MIMIC-III v1.3 which has been corrected in v1.4. All doses should now be in the correct unit (before they were all in grams, erroneously).
alistairewj's user avatar
2 votes
Accepted

MIMIC-III: How the patients take their prescriptions exactly?

Active prescription orders: Drug (A): 08-01 to 08-02 Drug (A, B): 08-03 to 08-04 Drug (A, B, C): 08-05 to 08-08 Drug (B, C): 08-09 Keep in mind that the prescriptions table is a record of ...
ChristinaC's user avatar
2 votes

Vasopressor and antibiotics in MIMIC3

It looks like the administration record of antibiotics/vasopressor are found in the PRESCRIPTION table. The prescriptions table is a record of medications that were ordered. It does not indicate ...
tomp's user avatar
  • 1,446
2 votes

Medication order in Prescription table

Look in either the inputevents_cv or the inputevents_mv table for detailed information about infusions. This will require identifying the one or more itemid associated with hydromorphone in the ...
alistairewj's user avatar
2 votes

Sequential Compression Device (SCD) records in MIMIC

In CareVue, sequential compression devices are documented in the chartevents table: itemid = 49, label = "Anti-Embolism [Device]", value = (Ace Wrap, Elastic Stocking, None/Remarks, Compress Sleeves) ...
ChristinaC's user avatar
2 votes
Accepted

MIMIC III: timestamps are shifted by several years... is that normal?

The following paper provides important background information on the MIMIC-III dataset: http://www.nature.com/articles/sdata201635. The point below addresses your question: "dates were shifted into ...
tomp's user avatar
  • 1,446

Only top scored, non community-wiki answers of a minimum length are eligible