How to solve the failure to obtain ejection fraction and NTproBNP in mimiciii

[yidouwunv]

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

Description of the issue, including:

• what you have tried
• references to similar issues
• queries demonstrating your question (if applicable)

[SichengH]

Could you please describe the issue that you are having in detail?

[yidouwunv]

I am very happy to receive your reply. When I use the code select * from mimiciii.d_labitems where label like'%TproBNP%' and select * from mimiciii.d_items where label like'%jection%' in the database, the data obtained is special Less or sometimes missing

At 2021-09-30 03:12:05, "Sicheng Hao" @.***> wrote:

Could you please describe the issue that you are having in detail?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android.

[khalid-hussain]

I am also looking for ejection fraction data.

To get the code for ejection fraction, I used:

SELECT *
FROM d_items
WHERE label LIKE '%jection%'

I found out that the itemid for Ejection Fraction is 227008.

Using this itemid with the following code:

SELECT *
FROM chartevents
WHERE itemid=227008

...returns only two (2) records.