Alistair Johnson
Alistair Johnson
Totally agree that we should improve them. But why not correct the current LOINC code where it is wrong, rather than having 2 columns? If it's unclear, we could NULL...
Sure! If you make the mapping CSV I'm happy to look it over.
> Sorry for the delayed response. I like the idea of separating the mapping of itemid values to LOINC from the main database--I think this will make the mapping more...
Thanks for the note. Due to the changing underlying lab data, we have to do some tricks to make sure `itemid` are deterministically generated. It might be we did a...
Yes, it is correct that multiple versions of ICD were in use at the BIDMC. Unfortunately, for MIMIC-III, we cannot tell you the version as it correlates with the admission...
Sorry for the late reply. The kdigo-uo query is making the assumption that data measured at `charttime = 03:00` corresponds to urine output during the last hour, i.e. hours `02:00-03:00`....
Really glad you're digging in to this as it's pretty hard to infer AKI from atypically documented UO. I looked at this and I think the real issue is I...
See above and also https://github.com/MIT-LCP/mimic-code/commit/cbfdd96c50dcdc01a450f34ee455ddac531a1a7a That certainly made a difference: ```sql with t1 as ( SELECT ic.icustay_id , ic.gender , ic.admission_age AS age , w.weight , h.height , los_icu ,...
Yes I agree the issue is only partly solved - ideally we'd have each UO measurement and a duration of measurement associated with it but implementing "what time period does...