How to extract data from mimic-iv database (version2.0)

[xuesekunlun]

Delirium could be identified by CAM-ICU in the mimic-iii database. But how to find out whether a patient suffered delirium in mimic-iv database? Thank you for talking about this topic below.

[Nicholas2074]

I am also looking for the delirium score. In the eICU database, there are scores, but in MIMIC-IV, there are only results. Itemid 228332 and 228688 are related to delirium, but only 228332 has results.

[alistairewj]

Delirium measurements are stored under "CAM-ICU", which is the instrument used to measure them.

select itemid, label, linksto, category
from `physionet-data.mimiciv_icu.d_items`
where lower(label) like '%cam-icu%'

Gives:

itemid	label	linksto	category
228300	CAM-ICU MS change	chartevents	Pain/Sedation
228301	CAM-ICU Inattention	chartevents	Pain/Sedation
228302	CAM-ICU RASS LOC	chartevents	Pain/Sedation
228303	CAM-ICU Disorganized thinking	chartevents	Pain/Sedation
228334	CAM-ICU Altered LOC	chartevents	Pain/Sedation
228335	CAM-ICU Disorganized thinking	chartevents	Pain/Sedation
228336	CAM-ICU Inattention	chartevents	Pain/Sedation
228337	CAM-ICU MS Change	chartevents	Pain/Sedation
229324	CAM-ICU Disorganized thinking	chartevents	Pain/Sedation
229325	CAM-ICU Inattention	chartevents	Pain/Sedation
229326	CAM-ICU MS Change	chartevents	Pain/Sedation

As you can see there are multiple itemid for the same data. Reformatting it makes it clear:

First set	Second Set	Third set
228300 - CAM-ICU MS change	228337 - CAM-ICU MS Change	229326 - CAM-ICU MS Change
228301 - CAM-ICU Inattention	228336 - CAM-ICU Inattention	229325 - CAM-ICU Inattention
228302 - CAM-ICU RASS LOC	228334 - CAM-ICU Altered LOC	-
228303 - CAM-ICU Disorganized thinking	228335 - CAM-ICU Disorganized thinking	229324 - CAM-ICU Disorganized thinking

You will need to include all these parameters in order to get delirium data for all patients.