i want to know hosp.labelevenets include icu label or not?

[ggsimidaa168]

i want to know hosp.labelevenets include icu label or not?
i'll be grateful for any helpful answer ！

[heisenbug-1]

Hi!
As far as I know, there's no icu stay_id in the hosp.labevents table, but you can join hosp.labevents with icu.icustays on subject_id and hadm_id, and then filter by time(measurement should be within icu intime and outtime), since hadm_id can be mapped to multiple icu stay_id.

You can also use icu.chartevents. It contains less data than hosp.labevents, but it has icu labels.

[ggsimidaa168]

thanks for your help！