search

MIT-LCP / mimic-code

MIMIC Code Repository: Code shared by the research community for the MIMIC family of databases
https://mimic.mit.edu
MIT License
2.51k stars 1.5k forks source link

Implementing "fluid_balance_staging" query #922

Open arielhasidim opened 3 years ago

arielhasidim commented 3 years ago

Hello, In MIMIC-III there is "fluid_balance_staging" table that I would like to implement on MIMIC-IV. I learned that this table is still work-on-progress from the repo's issue, and the table hasn't been updated since. I would like to help implementing this on MIMIC-IV.

Is there any code to fork, adjust/test/fix and PR back?

This is very important to my thesis, and I plan to invest my time as much as it take.

alistairewj commented 3 years ago

I've created a branch for doing this https://github.com/MIT-LCP/mimic-code/tree/fluid-balance/mimic-iv/concepts/fluid-balance

It wasn't complete historically because we didn't map the CareVue fluids, but that isn't a problem in MIMIC-IV, so hopefully the code is not far off being usable. I merged the fluid_balance_staging into the fluid_balance query since they are mostly the same. Feel free to base your branch off that and PR whatever you think is appropriate!

arielhasidim commented 3 years ago

I already wrote a new query for mimic-iv (Metavision only). It is based on the fluid_balance_staging table as I saw it. I haven't use any fluid map for inputs but I explain and rationalise every step in the notes and appended references.

You can see it in this fork. I will be happy to PR this if you approve.