Questions tagged [mimic-iii]
The [MIMIC-III (Medical Information Mart for Intensive Care) database](https://mimic.physionet.org/about/mimic/) contains physiologic signals, vital signs time series, and comprehensive clinical data obtained from hospital medical information systems for over 40,000 intensive care unit (ICU) admissions at the Beth Israel Deaconess Medical Center.
130 questions
7
votes
2
answers
1k
views
MIMIC-III severity score
Is there any severity score in the MIMIC-III beyond SOFA? I've found many itemdid with APACHE IV label but I did not retrieve any information in the chartevents. Best
- 367
7
votes
1
answer
876
views
Are there any (openly) available data sets for medical coding examples?
Are there any data sets of medical coding examples available online?
Eg. Doctor's notes and resulting (correct/accepted) procedure and diagnosis codes for individual encounters or samples of ...
6
votes
1
answer
207
views
MIMIC-III Citation
Is there a new citation for MIMIC-III? If so, what is that citation?
If not, should we continue to use the citation for MIMIC-II?
@article{MIMICII,
Author = {Saeed, Mohammed and Villarroel, ...
- 116
6
votes
1
answer
668
views
MIMIC-III Elixhauser comorbidity table
How can I obtain a table containing the 30 Elixhauser comorbidities for patients in the MIMIC-III database? Did anybody already run the code in the MIMIC-III forum?
- 367
5
votes
2
answers
2k
views
Is the patient's height available?
Is the patient's height available in MIMIC-III? In my use case, I would be interested in having it in order to compute the patient's ideal body weight.
On Oracle DB:
SELECT *
FROM all_tab_columns
...
- 7,815
5
votes
2
answers
1k
views
MIMIC III : Date and Time when Diagnosis Code was determined for the patient, say Septic Shock
I am working on a project to predict Septic Shock on the MIMIC III data set.
I am using the following ICD9-CODes to detect Sepsis but not sure how to get the date + time stamp when the patient was ...
- 51
5
votes
1
answer
532
views
Why are lab tests splitted into 2 tables: chartevents and labevents?
For example, blood sodium has itemid 837, 220645 etc... in chartevents and 50983 in labevents. Most patients have recordings in both tables, of which some are duplicates and some are unique.
I'm using ...
- 88
5
votes
1
answer
460
views
MIMIC-III. Select only the first ICU admission
How can I select data only for the first ICU stay of each patient? In the MIMIC-II, there was a column with the sequence of ICU stay (first, second) and another column with the icustay_id. In the ...
- 367
4
votes
2
answers
146
views
MIMIC-III: Negative cultures and microbiologyevents
In MIMIC-III, where do negative cultures appear? Is this different between CareVue patients and Metavision patients?
Despite the documentation's assertion (here) that "If the specimen is null, then ...
4
votes
1
answer
139
views
Time of death in-hospital?
How do you determine the exact time of death for in-hospital deaths? I see DOD (day of death) but not a time stamp.
- 41
4
votes
1
answer
106
views
MIMIC-III: When exactly was MIMIC-III v1.3 released?
What is the release history for MIMIC-III?
I was using some version and now I see there is version 1.3.
When was 1.3 officially released?
When was 1.2 officially released?
Are there other versions?
...
- 730
4
votes
1
answer
202
views
MIMIC-III - days of the week?
Although dates in MIMIC-III are shifted for patient confidentiality purposes, is there any way to extract days of the week? This would be useful for e.g. calculating severity of admissions on Saturday/...
- 63
4
votes
1
answer
126
views
Estimation of intubation time
If I would need the estimated time of intubation for our project, what would be a good proxy. I have found several ventilation-related codes in the MIMIC-III GitHub repo (https://github.com/MIT-LCP/...
- 41
4
votes
1
answer
202
views
Patient admitted to ICU after cardiac arrest (post cardiac arrest) in MIMIC-III
How to select patients in the MIMIC-III database admitted to ICU immediately after a cardiac arrest? Although ICD-9-CM 427.5 is related to cardiac arrest, it is unclear to select the patients admitted ...
- 322
4
votes
0
answers
201
views
Priority sequence column in diagnosis_icd
The order in the sequence column is related to the patient and based on priority. Priority of patients in critical care medicine are related to triage which is a scoring system including:
the ...
- 322
3
votes
2
answers
1k
views
MIMIC-III inputevents MV or CV
An intravenous drug that is not continuous appears to be in the inputevents_mv table but not in the inputevents_cv table. Is it right? How can I work with the full dosage of medication?
- 367
3
votes
1
answer
183
views
Photoplethysmogram sampling frequency problem
I'm doing some calculations on the photoplethysmogram signal it seems that the metrics I'm using suffer from a cyclic artifact each 94-96[s].
The waveform seem ok at the "breakpoints".
Is it ...
- 181
3
votes
1
answer
224
views
Where did the attribute ICU_EXPIRE_FLAG go from MIMIC-II to MIMIC-III?
MIMIC is an openly available dataset developed by the MIT Lab for Computational Physiology, comprising deidentified health data associated with >40,000 critical care patients. It includes demographics,...
- 322
3
votes
1
answer
98
views
Looking for equivalence of MIMIC-II v2.6 dataset in MIMIC-III v1.3
There is a table in the MIMIC-II v2.6 database named "mimic2v26.d_codeditems" which includes a category named "type". One of the specified types is "procedure". I am looking for the equivalent data in ...
- 149
3
votes
1
answer
423
views
Meaning of SEQ_NUM in DIAGNOSES_ICD table and missing values in ICD9_CODE field
I am just starting to analyze v1.3 of MIMIC-III data. I have two questions about the DIAGNOSES_ICD table.
According to the documentation [1] : "ICD diagnoses are ordered by priority - and the order ...
- 63
3
votes
1
answer
199
views
MIMIC-III prescription problem
How can I sum the full dose of a medication in the dose_val_rx column in the prescription table? I had tried to sum(dose_val_rx) nbut it does not work.
- 367
3
votes
1
answer
237
views
ADMISSIONS Table, recent Mimic-III Postgres Updates
Just updated my mimic-code directory after some changes were made yesterday to the postgres configuration files. Reimporting the data and getting the following error for the admissions table:
...
- 33
3
votes
1
answer
151
views
Admitted to the ICU before admission to the hospital
It would be expected that the time of admission to the intensive care unit would occur after the time of admission to the hospital. Sometimes, however, admission to the intensive care unit occurs ...
- 322
3
votes
2
answers
242
views
MIMIC III - C-Reactive protein
I'm trying to find CRP values in the MIMIC-III database.
I've tried different search strategies but I've only found two items (227444, 220612) in the d_items table, which are both empty variables.
Are ...
- 33
3
votes
1
answer
316
views
Mimic iii - Are the months of the year accurate to the actual months?
According to the Mimic III documentation:
All dates in the database have been shifted to protect patient
confidentiality. Dates will be internally consistent for the same
patient, but randomly ...
- 151
3
votes
1
answer
64
views
Where can I get previous versions of MIMIC-III?
The current version of MIMIC-III is 1.3, and can be obtain here. Where can I get previous versions of MIMIC-III? Namely, versions 1.1 and 1.2?
- 7,815
3
votes
1
answer
77
views
Relation of MIMIC-II v2.6 and MIMIC-III v1.3 patients records
Are all patients' admissions and ICU stays from MIMIC-II included in MIMIC-III?
- 149
3
votes
1
answer
91
views
Arterial line location and PPG sensor location
1) From which artery the ABP signal was collected?
2) Where was the PPG device located? Fingertip? What wavelength was used?
- 181
3
votes
1
answer
90
views
(mimic-iii) Why D_LABITEMS doesn't have reference range while D_ITEMs has?
Often Lab test should come with a reference range, which is likely to be included in D_LABITEMS.
On the other hand, although D_ITEMS has columns lownormalvalue and highnormalvalue, there is no record ...
- 31
3
votes
1
answer
40
views
In which cases is a waveform recording split into two recordings in MIMIC WDB 2v3?
http://physionet.org/physiobank/database/mimic2wdb/ lists two cases where one waveform recording is split into two recordings:
a patient was admitted more than once to any of the study ICUs during ...
- 7,815
3
votes
1
answer
799
views
Are the APACHE scores available somewhere?
I wonder whether APACHE scores are available somewhere in MIMIC-III.
There doesn't seem to be any widely used APACHE ITEMIDs in the table CHARTEVENTS:
SELECT LABEL, COUNT(*) cnt
FROM mimiciii....
- 7,815
3
votes
1
answer
55
views
Why are some transfers.ICUSTAY_ID null?
Why is the ICUSTAY_ID null for some rows in the transfers table?
-- returns 174176 rows
SELECT * FROM mimiciii.transfers
WHERE ICUSTAY_ID IS NULL
ORDER BY ICUSTAY_ID ASC ;
- 7,815
3
votes
1
answer
74
views
MIMIC-III Inputevents_mv 'Rewritten' value
Can anyone clarify how the 'Rewritten' value in the statusdescription column impacts the data? It appears impossible to ascertain the final "approved" sequence of events in a particular fluid delivery....
- 33
3
votes
1
answer
173
views
Does MIMIC-III have patients with atrial fibrillation & knee osteoarthritis?
Do you know if the MIMIC-III database includes patients (in parcticular their free-text notes, medications & demography) - that have either atrial fibrillation, knee osteoarthritis or closely ...
- 176
3
votes
1
answer
275
views
Where to find the most recent mapping between Clinical and Waveform Records?
I saw a few mappings between Clinical and Waveform Records:
http://www.physionet.org/physiobank/tutorials/using-mimic2/#linking (MIMIC Waveform database 2V2)
http://physionet.org/physiobank/database/...
- 7,815
3
votes
1
answer
102
views
How to get the list of ICUSTAY_IDs that happened in a given HADM_ID?
In the MIMIC-III database, I wonder whether there is an easy way to obtain the list of ICUSTAY_IDs that happened in a given HADM_ID.
- 7,815
3
votes
0
answers
125
views
Physionet.org - Sepsis Data Files?
I am searching for "Pre" and "Post" Physiological Data Files from Patients that have Sepsis. They can be in just about any format such as Excel, CSV, etc. but contain a Time Stamp, Heart Rate, BP(s), ...
- 31
3
votes
0
answers
23
views
Problem with base+gain of signals
There seems to be a problem with the gain/base when correcting the base/gain of several subjects. For example the gain/base of subject a44012am (mimic2db) should 512 /255 respectively (according to ...
- 181
3
votes
0
answers
154
views
Detecting use of vasopressor in a patient in MIMIC
To detect whether vasopressor was used for a patient in MIMIC, is looking at the presence of itemids whose labels are dobutamine, dopamine, epinephrine, epinephrine-k, levophed, levophed-k, ...
- 7,815
2
votes
3
answers
788
views
How to map MIMIC-II's SUBJECT_ID and HADM_ID with MIMIC-III's SUBJECT_ID and HADM_ID?
I wonder how to map SUBJECT_ID and HADM_ID of MIMIC-II with SUBJECT_ID and HADM_ID of MIMIC-III.
- 7,815
2
votes
1
answer
281
views
What is the ISERROR column in MIMIC-III's noteevents table?
I see that MIMIC-III's noteevents table contains a column ISERROR, which is a CHAR(1), but no explanation. What does ISERROR represent (i.e. what error are we talking about)?
- 7,815
2
votes
1
answer
260
views
Looking for admitting SAPS score for first hospitalization of patients in MIMICIII [duplicate]
There is a table in MIMICII named "MIMIC2V26.ICUSTAY_DETAIL" and there is a field named "SAPSI_FIRST" inside the table. It seems that this field contains SAPS score for the first hospitalization of ...
- 149
2
votes
1
answer
123
views
MIMIC-II Introduction document: errors in example code?
I am new to SQL and am trying to explore the MIMIC-II dataset using the query builder so the logical step seemed to be follow the tutorials within the introduction document [1]. Unfortunately I ...
- 23
2
votes
2
answers
634
views
Memory consumption MIMIC-III
How much memory is needed to join (psql) the patient and labevent table using:
SELECT
patients.subject_id,
patients.gender,
patients.dob,
patients.dod,
patients.dod_hosp,
patients....
- 322
2
votes
2
answers
123
views
MIMIC-III: Why is the time stamp of prescription only "per day"?
How can I tell the exact time of prescription, or the start of medications?
- 23
2
votes
1
answer
355
views
Gold annotations for diabetic patients in MIMIC-III
I am looking for a list of patients in MIMIC-II or MIMIC-III who have been annotated as diabetic by experts. I.e. a gold standard, physician-validated, data set for diabetic patients in MIMIC-II/III.
- 7,815
2
votes
1
answer
59
views
The unit for blood cell number is different in labevent. How could I unify them?
I just want to unify the unit for lab measurement data in labevent table for mimiciii. But I found there are two types of units for counting numbers of blood cell: #/uL and %. I could not find the ...
- 21
2
votes
1
answer
404
views
Want to understand MIMIC III warning in table Chartevents
In table Chartevents, there is a attribute named warning. What does it represent? for example if there is a data entry with ITEMID 220046 which represents Heart rate Alarm - High, what does warning ...
- 21
2
votes
1
answer
304
views
loading MIMIC III into SQL Server [closed]
I'd like to load the MIMIC III data into SQL Server because that's what I know best. The problem with the csv files is that some fields contain commas as part of the data. It would be far easier to ...
2
votes
1
answer
129
views
Pulse transit time values (PTT)
It seems that PTT based on the ABP & ECG signals is ~300 ms, but when based on the PPG signal then PTT is ~550 ms (consistent for multiple subjects). As I understand both ABP and PPG were measured ...
- 181