Comments (5)
We don't have one at the moment but if you highlight which columns have codes you are interested in we can ask the right people and add it to the documentation.
from eicu-code.
Thanks for your reply. Here are some of the columns I have questions on:
- In the ApachePredVar Table: the columns admitsource, dischargelocation, and amilocation
- In the Hospital Table: the column teachingstatus
I also have a question regarding how identification numbers are used. I understand how they are used for the column patientUnitStayid but in other columns it isn't as clear. For instance, for the column “diagnosisid” is one ID number given for a specific diagnosis so that if you were looking for patients with “x” diagnosis you could search the database for that specific diagnosisid?
from eicu-code.
The table "id" columns are just used to ensure uniqueness of rows. They have no meaning. You'll find diagnosisid is unique to every row. I'll get back to you on the others.
from eicu-code.
You can generate the mapping for admitsource
values by linking the apachepredvar
table to the patient
table:
select distinct a.admitsource, p.unitadmitsource
from `physionet-data.eicu_crd_demo.apachepredvar` a
left join `physionet-data.eicu_crd_demo.patient` p
on a.patientunitstayid = p.patientunitstayid
order by admitsource;
Row admitsource unitadmitsource
1 -1
2 1 Operating Room
3 2 Recovery Room
4 4 Floor
5 4 Step-Down Unit (SDU)
6 4 ICU to SDU
7 5 Other ICU
8 6 Other Hospital
9 7 Direct Admit
10 8 Emergency Department
from eicu-code.
I also have the same question on what are the numbers contained in "admitsource" under ApachePredVar represents. These are so important that can change the model completely.
Thanks in advance.
And it seems to me that the number of patients in each group mapped to the patient table does not make much sense, esp. there is no.3 in admitsource that is not correlated to any group. in unitadmitsource.
from eicu-code.
Related Issues (20)
- Identify patients with Cirrhosis HOT 4
- Identify patients who went through CABG in eicu database HOT 2
- Finding Pregnant Women in the dataset HOT 2
- Identify people who was electively admitted HOT 1
- What is the difference between eicu_derived and the original tables? HOT 1
- C-Reactive Protein value distribution is abnormal
- could not find LVEF(left ventricular ejection fraction) in eICU HOT 2
- FINDING ARTERIAL BLOOD GAS MEASUREMENT IN THE eICU Database HOT 1
- How to find patients who enter ICU due to specific diseases? HOT 5
- Derived tables with no queries in repo HOT 2
- What is the meaning of 'activetx' in the apache predvar table? HOT 1
- missing ventilation_events table in the pivoted-oasis.sql. HOT 12
- onsite and remote physicians data
- Critical Data MIT
- Meaning of negative offset in lab table. HOT 1
- Determining SAPS-II Admission Type from eICU data for patientunitstayids HOT 1
- Constraints are not loaded in Makefile and multiple primary keys are missing
- 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
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.