Composition of total parenteral nutrition
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 3.4k
- Forks
- 1.7k
- PR merge metrics
- No merged PRs in 30d
Description
Prerequisites
- [ X] Put an X between the brackets on this line if you have done all of the following:
- Checked the online documentation: https://mimic.physionet.org/about/mimic/
- Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=
Description
Is it possible to work out the composition (dextrose, amino acids, lipids) for every case of a patient receiving total parenteral nutrition?
For example, if I look at ICUSTAY_ID = 200087 there are four TPN administration events. For two of these I can see the dextrose, amino acid and lipids breakdown using (225969, 225948, 225947) but not for the other two. I guess that makes me wonder if there is a standard formulation used and the reason we have a breakdown in two cases is a change to the standard TPN formulation?
select * from mimic.mimiciii.inputevents_mv
where icustay_id = 200087 and
itemid in(225916,225969,225948,225947,227090,225801) and
statusdescription is distinct from 'Rewritten'
order by starttime, row_id
| row_id | subject_id | hadm_id | icustay_id | starttime | endtime | itemid | amount | amountuom | rate | rateuom | storetime | cgid | orderid | linkorderid | ordercategoryname | secondaryordercategoryname | ordercomponenttypedescription | ordercategorydescription | patientweight | totalamount | totalamountuom | isopenbag | continueinnextdept | cancelreason | statusdescription | comments_editedby | comments_canceledby | comments_date | originalamount | originalrate |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2729461 | 61871 | 124231 | 200087 | 2196-08-30 12:03:00 | 2196-08-30 18:30:00 | 225916 | 483.75 | ml | 75 | mL/hour | 2196-08-30 12:04:00 | 17525 | 9709399 | 9709399 | 12-Parenteral Nutrition | Additives (PN) | Main order parameter | Continuous IV | 95.1 | 1800 | ml | 0 | 0 | 0 | Paused | 1800 | 75 | |||
| 2729448 | 61871 | 124231 | 200087 | 2196-09-01 00:00:00 | 2196-09-01 18:59:00 | 225916 | 1537.7000021 | ml | 81.002634 | mL/hour | 2196-09-02 02:25:00 | 16934 | 9272247 | 9272247 | 12-Parenteral Nutrition | Additives (PN) | Main order parameter | Continuous IV | 95.1 | 1950 | ml | 0 | 0 | 0 | FinishedRunning | 1537.7 | 81.002632 | |||
| 2729449 | 61871 | 124231 | 200087 | 2196-09-01 00:00:00 | 2196-09-01 18:59:00 | 225969 | 43.371023101 | grams | 2196-09-02 02:25:00 | 16934 | 9272247 | 9272247 | 12-Parenteral Nutrition | Additives (PN) | Additives Ampoule | Continuous IV | 95.1 | 1950 | ml | 0 | 0 | 0 | FinishedRunning | 43.371025 | 0 | |||||
| 2729451 | 61871 | 124231 | 200087 | 2196-09-01 00:00:00 | 2196-09-01 18:59:00 | 225948 | 78.856404085 | grams | 2196-09-02 02:25:00 | 16934 | 9272247 | 9272247 | 12-Parenteral Nutrition | Additives (PN) | Additives Ampoule | Continuous IV | 95.1 | 1950 | ml | 0 | 0 | 0 | FinishedRunning | 78.856407 | 0 | |||||
| 2729452 | 61871 | 124231 | 200087 | 2196-09-01 00:00:00 | 2196-09-01 18:59:00 | 225947 | 291.76871163 | grams | 2196-09-02 02:25:00 | 16934 | 9272247 | 9272247 | 12-Parenteral Nutrition | Additives (PN) | Additives Ampoule | Continuous IV | 95.1 | 1950 | ml | 0 | 0 | 0 | FinishedRunning | 291.76871 | 0 | |||||
| 2729317 | 61871 | 124231 | 200087 | 2196-09-01 18:59:00 | 2196-09-02 18:11:00 | 225916 | 1879.778376 | ml | 81.02493 | mL/hour | 2196-09-02 02:25:00 | 16934 | 3544368 | 3544368 | 12-Parenteral Nutrition | Additives (PN) | Main order parameter | Continuous IV | 95.1 | 1950 | ml | 0 | 0 | 0 | Stopped | 1950 | 81 | |||
| 2729318 | 61871 | 124231 | 200087 | 2196-09-01 18:59:00 | 2196-09-02 18:11:00 | 225969 | 53.019389664 | grams | 2196-09-02 02:25:00 | 16934 | 3544368 | 3544368 | 12-Parenteral Nutrition | Additives (PN) | Additives Ampoule | Continuous IV | 95.1 | 1950 | ml | 0 | 0 | 0 | Stopped | 55 | 0.038088642 | |||||
| 2729319 | 61871 | 124231 | 200087 | 2196-09-01 18:59:00 | 2196-09-02 18:11:00 | 225947 | 356.67589056 | grams | 2196-09-02 02:25:00 | 16934 | 3544368 | 3544368 | 12-Parenteral Nutrition | Additives (PN) | Additives Ampoule | Continuous IV | 95.1 | 1950 | ml | 0 | 0 | 0 | Stopped | 370 | 0.25623268 | |||||
| 2729321 | 61871 | 124231 | 200087 | 2196-09-01 18:59:00 | 2196-09-02 18:11:00 | 225948 | 96.398896752 | grams | 2196-09-02 02:25:00 | 16934 | 3544368 | 3544368 | 12-Parenteral Nutrition | Additives (PN) | Additives Ampoule | Continuous IV | 95.1 | 1950 | ml | 0 | 0 | 0 | Stopped | 100 | 0.069252081 | |||||
| 2729464 | 61871 | 124231 | 200087 | 2196-09-02 18:18:00 | 2196-09-03 17:39:00 | 225916 | 1891.9321155 | ml | 81.02493 | mL/hour | 2196-09-02 18:19:00 | 15225 | 9738791 | 9738791 | 12-Parenteral Nutrition | Additives (PN) | Main order parameter | Continuous IV | 95.1 | 1950 | ml | 0 | 0 | 0 | Stopped | 1950 | 81 |
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the MIMIC documentation and the mimic.mimiciii.inputevents_mv table. Reproduce the query for ICUSTAY_ID 200087, focusing on itemids 225916, 225969, 225948, 225947, 227090, and 225801 and the order and status fields shown. Done means establishing whether the available events support a complete, documented composition for each TPN administration.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- data, databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100