Comments (5)
Hi @lasiadhi,
I think we need to do some more work understanding this. @obadawi may be able to provide insight here.
For most of the studies we have conducted thus far we have focused on presence/absence of drugs, but knowing dosage/duration is of course important too. Working through your example, I would read it this way (keep in mind, I could be wrong!):
- Heparin appears to be started at 59min and ends 22 hours later. There are 10 hours @ 1000 units/hr, 4h @ 1100, 8h @ 1300. After which it goes to zero. The total amount given almost equals the initial
drugamount
(24800 vs 25000). Theinfusionrates
are all some multiple of the drug rates, and the weighted sum of the infusion rates is pretty close to the totalvolumeoffluid
. - Nitroglycerin starts and stops at the same times (plus a 946 entry) as heparin. The first six hours have 3 hours @ 10mcg/min and 3h @ 20mcg/min, going to zero after that for a period of time. The
drug amount
is probably in mg (50mg), and these rates over the six hours equates with 54mg. So the infusion has 'run out of drug' and it's not surprising that it is zero. It appears to be restarted at a lower rate, which I presume means a new vial, and stops a while later without running out (it still has 28mg left, if I had to guess). Thedrugrates
andinfusionrates
are proportional, but it's unclear to me how it corresponds to thevolumeoffluid
(perhaps NS is documented in another table?).
The precision of the measurements and offsets is largely going to depend on the way the data is collected. If this is charted data, then it's not surprising that everything is done at hourly intervals, and the numbers only roughly work out. If the data is automatically collected, then the durations are probably much more accurate. AFAIK there is no way to determine which is the case, other than exploring the data and drawing your own inferences.
Indeed, the data is difficult to work with. I would recommend focusing on a single hospital and a single drug first, and then trying to generalize to other hospitals and other drugs.
Jesse
from eicu-code.
from eicu-code.
Thank you very much @jraffa for the explanation and for taking the time to do all the calculations! I really appreciate it.
In the Nitroglycerin example, as you mentioned, the patient got 3 hours @ 10mcg/min and 3h @ 20mcg/min. That means the total drug amount given was 5400 mcg within 6 hours. If I am correct, that is equal to 5.4mg (?) (not 54mg). Then I am not sure how to relate that to the 50mg drug amount.
Anyway, I will go through more examples as you recommended. This is very helpful. Thank you, Jesse!
-- Lasith
from eicu-code.
Hi @jraffa, @alistairewj , @obadawi and all,
If we revisit the Heparin example above, the infusion starts at 59min and ends at 1379min according to the infusionDrug table. However, if we look at the same patient stay in the medication table (see below), the Heparin drug was started at 19min and ended at 1425min.
Which offset time should be considered more reliable for determining the start and end of this drug? Are there any other concerns related to time offsets in the medication table for infused drugs? Thank you!
from eicu-code.
Thanks, Omar (@obadawi) for the explanation! This is very helpful to understand the big picture here and how these tables are linked to each other. I believe the last Heparin 5000 UNIT/ML order [not cancelled] is not in the infusionDrug table because it was not continuously administered (?). Thanks again! -- Lasith
from eicu-code.
Related Issues (20)
- Differing Lab Results for rows with same patientunitstayid, labresultoffset, and labname HOT 1
- Find all antibiotic applications HOT 1
- Database data on the use of high-flow nasal cannula (HFNC) were not available HOT 1
- Mechanical ventilation start and end times
- how to convert this observationOffset into daily time intervals
- pivoted-oasis.sql doesn't work in postgresql
- Question about the 'treatment' table
- Information on Troponin essay?
- Sepsis-3 Criteria from eICU data HOT 3
- Issue with Misclassification of diagnosisstrings? HOT 7
- No data on glycosylated hemoglobin (Hba1c) were available in the database. HOT 1
- Difference between pastHistory and diagnosis HOT 2
- Ventilator setting in eICU as already done in MIMIC-IV HOT 1
- Find continuous infusion of drug when drug amount is missing HOT 1
- Interpreting intakeOutputOffset HOT 2
- diagnosis offset for acute conditions
- queries on lab table of eICU-CRD database
- `lab` table - understanding the difference between 'labmeasurenameinterface' and 'labmeasurenamesystem'
- Corrupted data in lab table
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from eicu-code.