Comments (2)
I don't think there is a specific table or variable. Context will be important, as there are like post-labour patients in here that you may or may not want.
I found some in the diagnosis
table:
select diagnosisstring, count(diagnosisstring) as count from diagnosis where diagnosisstring ilike '%preg%' group by diagnosisstring ORDER by c DESC;
diagnosisstring | count |
---|---|
surgery|obstetrics|pregnancy | 243 |
surgery|obstetrics|pre-eclampsia/ eclampsia|pregnancy induced hypertension | 42 |
surgery|obstetrics|vaginal hemorrhage|not pregnancy related | 32 |
surgery|obstetrics|ectopic pregnancy|with rupture | 24 |
gastrointestinal|hepatic disease|hepatic dysfunction|pregnancy related | 17 |
cardiovascular|ventricular disorders|cardiomyopathy|peri-partum|during pregnancy | 14 |
hematology|bleeding and red blood cell disorders|anemia|relative anemia, including anemia of pregnancy | 10 |
....and more
I would also look in the pasthistory
table.
from eicu-code.
Thanks this might work!
Initially, I was thinking of using the icd9code in the diagnosis table to identify pregnant women but could not get the pregnancy codes associated with pregnancy such as Z33, O009-09A in the demo database.
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
- Finding start and end time for infused drugs from the eICU infusionDrug table HOT 5
- 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.