白鲸鱼🐳
发布于

eICU-CRD数据库

概况

eICU是一项具有变革性的危重症远程健康计划,向护理人员提供关键信息,使他们能够更好地照顾患者。它是床边团队的一种补充,而不是替代品,由远程护理人员使用的数据被存档供研究之用。
通过这项工作,我们生成了一个庞大的数据库,具有促进关于患者结果、趋势以及目前大多数医疗机构使用的其他最佳实践协议的额外研究计划的潜力。维护数据的飞利浦eICU研究所(eRI)慷慨地贡献了此处描述的eICU协同研究数据库。

覆盖范围

eICU协同研究数据库汇集了来自美国本土许多危重症监护单位的数据。合作数据库中的数据涵盖了2014年和2015年被送往危重症监护单位的患者。

 

衍生表格

apache_groups

patientunitstayid
apachedxgroup
apacheadmissiondx
 
 
basic_demo
patientunitstayid
age
apacheadmissiondx
gender
hosp_mortality
icu_los_hours

 

icustay_detail

uniquepid
patienthealthsystemstayid
patientunitstayid
unitvisitnumber
hospitalid
region
unittype
hospitaladmitoffset
hospitaldischargeoffset
unitadmitoffset
unitdischargeoffset
apache_iv
hospitaldischargeyear
age
hosp_mort
gender
ethnicity
admissionheight
admissionweight
dischargeweight
icu_los_hours
 
 
labsfirstday
uniquepid
patienthealthsystemstayid
patientunitstayid
aniongap_min
aniongap_max
albumin_min
albumin_max
bands_min
bands_max
bicarbonate_min
bicarbonate_max
hco3_min
hco3_max
bilirubin_min
bilirubin_max
creatinine_min
creatinine_max
chloride_min
chloride_max
glucose_min
glucose_max
hematocrit_min
hematocrit_max
hemoglobin_min
hemoglobin_max
lactate_min
lactate_max
platelet_min
platelet_max
potassium_min
potassium_max
ptt_min
ptt_max
inr_min
inr_max
pt_min
pt_max
sodium_min
sodium_max
bun_min
bun_max
wbc_min
wbc_max
 
pivoted_bg
patientunitstayid
chartoffset
fio2
pao2
paco2
ph
aniongap
basedeficit
baseexcess
peeppivoted_infusion
patientunitstayid
chartoffset
dopamine
dobutamine
norepinephrine
phenylephrine
epinephrine
vasopressin
milrinone
heparin

 

pivoted_lab

patientunitstayid
chartoffset
albumin
bilirubin
bun
calcium
chloride
creatinine
glucose
bicarbonate
totalco2
hematocrit
hemoglobin
inr
lactate
platelets
potassium
ptt
sodium
wbc
bands
alt
ast
alp
 
 
pivoted_med
patientunitstayid
drugorderoffset
chartoffset
drugstopoffset
norepinephrine
epinephrine
dopamine
dobutamine
phenylephrine
vasopressin
milrinone
heparin
warfarin
 
 
pivoted_o2
patientunitstayid
chartoffset
entryoffset
o2_flow
o2_device
etco2
 
 
pivoted_score
patientunitstayid
chartoffset
entryoffset
gcs
gcs_motor
gcs_verbal
gcs_eyes
gcs_unable
gcs_intub
fall_risk
delirium_scale
delirium_score
sedation_scale
sedation_score
sedation_goal
pain_score
pain_goal
 
pivoted_treatment_vasopressor
patientunitstayid
chartoffset
vasopressor
 
pivoted_uo
patientunitstayid
chartoffset
outputtotal
urineoutput

 

pivoted_vital

patientunitstayid
chartoffset
entryoffset
heartrate
respiratoryrate
spo2
nibp_systolic
nibp_diastolic
nibp_mean
temperature
temperaturelocation
ibp_systolic
ibp_diastolic
ibp_mean
 
 
pivoted_vital_other
patientunitstayid
chartoffset
entryoffset
pasystolic
padiastolic
pamean
sv
co
svr
icp
ci
svri
cpp
svo2
paop
pvr
pvri
iap

 

原生病人表格

admissiondrug

admissiondrugid
patientunitstayid
drugoffset
drugenteredoffset
drugnotetype
specialtytype
usertype
rxincluded
writtenineicu
drugname
drugdosage
drugunit
drugadmitfrequency
drughiclseqno
 
admissiondx
admissiondxid
patientunitstayid
admitdxenteredoffset
admitdxpath
admitdxname
admitdxtext
 
 
allergy
allergyid
patientunitstayid
allergyoffset
allergyenteredoffset
allergynotetype
specialtytype
usertype
rxincluded
writtenineicu
drugname
allergytype
allergyname
drughiclseqno
 
apacheapsvar
apacheapsvarid
patientunitstayid
intubated
vent
dialysis
eyes
motor
verbal
meds
urine
wbc
temperature
respiratoryrate
sodium
heartrate
meanbp
ph
hematocrit
creatinine
albumin
pao2
pco2
bun
glucose
bilirubin
fio2

 

apachepatientresult

apachepatientresultsid
patientunitstayid
physicianspeciality
physicianinterventioncategory
acutephysiologyscore
apachescore
apacheversion
predictedicumortality
actualicumortality
predictediculos
actualiculos
predictedhospitalmortality
actualhospitalmortality
predictedhospitallos
actualhospitallos
preopmi
preopcardiaccath
ptcawithin24h
unabridgedunitlos
unabridgedhosplos
actualventdays
predventdays
unabridgedactualventdays
 
apachepredvar
apachepredvarid
patientunitstayid
sicuday
saps3day1
saps3today
saps3yesterday
gender
teachtype
region
bedcount
admitsource
graftcount
meds
verbal
motor
eyes
age
admitdiagnosis
thrombolytics
diedinhospital
aids
hepaticfailure
lymphoma
metastaticcancer
leukemia
immunosuppression
cirrhosis
electivesurgery
activetx
readmit
ima
midur
ventday1
oobventday1
oobintubday1
diabetes
managementsystem
var03hspxlos
pao2
fio2
ejectfx
creatinine
dischargelocation
visitnumber
amilocation
day1meds
day1verbal
day1motor
day1eyes
day1pao2
day1fio2
 
careplancareprovider
cplcareprovderid
patientunitstayid
careprovidersaveoffset
providertype
specialty
interventioncategory
managingphysician
activeupondischarge

careplaneol

cpleolid
patientunitstayid
cpleolsaveoffset
cpleoldiscussionoffset
activeupondischarge

 

careplangeneral

cplgeneralid
patientunitstayid
activeupondischarge
cplitemoffset
cplgroup
cplitemvalue
 
careplangoal
cplgoalid
patientunitstayid
cplgoaloffset
cplgoalcategory
cplgoalvalue
cplgoalstatus
activeupondischarge
 
careplaninfectiousdisease
cplinfectid
patientunitstayid
activeupondischarge
cplinfectdiseaseoffset
infectdiseasesite
infectdiseaseassessment
responsetotherapy
treatment
 
customlab
customlabid
patientunitstayid
labotheroffset
labothertypeid
labothername
labotherresult
labothervaluetext

 

diagnosis

diagnosisid
patientunitstayid
activeupondischarge
diagnosisoffset
diagnosisstring
icd9code
diagnosispriority
 
infusiondrug
infusiondrugid
patientunitstayid
infusionoffset
drugname
drugrate
infusionrate
drugamount
volumeoffluid
patientweight
 
intakeoutput
intakeoutputid
patientunitstayid
intakeoutputoffset
intaketotal
outputtotal
dialysistotal
nettotal
intakeoutputentryoffset
cellpath
celllabel
cellvaluenumeric
cellvaluetext
 
lab
labid
patientunitstayid
labresultoffset
labtypeid
labname
labresult
labresulttext
labmeasurenamesystem
labmeasurenameinterface
labresultrevisedoffset
 
 

medication

medicationid
patientunitstayid
drugorderoffset
drugstartoffset
drugivadmixture
drugordercancelled
drugname
drughiclseqno
dosage
routeadmin
frequency
loadingdose
prn
drugstopoffset
gtc
 
 
microlab
microlabid
patientunitstayid
culturetakenoffset
culturesite
organism
antibiotic
sensitivitylevel

 

microlab

microlabid
patientunitstayid
culturetakenoffset
culturesite
organism
antibiotic
sensitivitylevel

 

note

noteid
patientunitstayid
noteoffset
noteenteredoffset
notetype
notepath
notevalue
notetext
 
nurseassessment
nurseassessid
patientunitstayid
nurseassessoffset
nurseassessentryoffset
cellattributepath
celllabel
cellattribute
cellattributevalue

 

nursecare

nursecareid
patientunitstayid
celllabel
nursecareoffset
nursecareentryoffset
cellattributepath
cellattribute
cellattributevalue

 

nursecharting

nursingchartid
patientunitstayid
nursingchartoffset
nursingchartentryoffset
nursingchartcelltypecat
nursingchartcelltypevallabel
nursingchartcelltypevalname
nursingchartvalue
 
pasthistory
pasthistoryid
patientunitstayid
pasthistoryoffset
pasthistoryenteredoffset
pasthistorynotetype
pasthistorypath
pasthistoryvalue
pasthistoryvaluetext
 
patient
patientunitstayid
patienthealthsystemstayid
gender
age
ethnicity
hospitalid
wardid
apacheadmissiondx
admissionheight
hospitaladmittime24
hospitaladmitoffset
hospitaladmitsource
hospitaldischargeyear
hospitaldischargetime24
hospitaldischargeoffset
hospitaldischargelocation
hospitaldischargestatus
unittype
unitadmittime24
unitadmitsource
unitvisitnumber
unitstaytype
admissionweight
dischargeweight
unitdischargetime24
unitdischargeoffset
unitdischargelocation
unitdischargestatus
uniquepid
 
physicalexam
physicalexamid
patientunitstayid
physicalexamoffset
physicalexampath
physicalexamvalue
physicalexamtext
 
respiratorycare
respcareid
patientunitstayid
respcarestatusoffset
currenthistoryseqnum
airwaytype
airwaysize
airwayposition
cuffpressure
ventstartoffset
ventendoffset
priorventstartoffset
priorventendoffset
apneaparams
lowexhmvlimit
hiexhmvlimit
lowexhtvlimit
hipeakpreslimit
lowpeakpreslimit
hirespratelimit
lowrespratelimit
sighpreslimit
lowironoxlimit
highironoxlimit
meanairwaypreslimit
peeplimit
cpaplimit
setapneainterval
setapneatv
setapneaippeephigh
setapnearr
setapneapeakflow
setapneainsptime
setapneaie
setapneafio2
 
respiratorycharting
respchartid
patientunitstayid
respchartoffset
respchartentryoffset
respcharttypecat
respchartvaluelabel
respchartvalue
 
treatment
treatmentid
patientunitstayid
treatmentoffset
treatmentstring
activeupondischarge
 
 
vitalaperiodic
vitalaperiodicid
patientunitstayid
observationoffset
noninvasivesystolic
noninvasivediastolic
noninvasivemean
paop
cardiacoutput
cardiacinput
svr
svri
pvr
pvri
 

vitalperiodic

vitalperiodicid
patientunitstayid
observationoffset
temperature
sao2
heartrate
respiration
cvp
etco2
systemicsystolic
systemicdiastolic
systemicmean
pasystolic
padiastolic
pamean
st1
st2
st3
icp

标识符

数据库中使用标识符来标识唯一的概念,如患者、医院、ICU逗留等。这些标识符包括:

  • hospitalid - 唯一标识数据库中的每个医院。
  • uniquepid - 唯一标识患者(即对于同一人而言,它始终是相同的值)。
  • patienthealthsystemsstayid - 唯一标识医院逗留。
  • patientunitstayid - 唯一标识单位stay(通常是医院内的ICU)。


几乎所有表格都使用patientunitstayid作为主要标识符。

时间

所有事件的时间戳都存储为相对于ICU入院时间的偏移量,以分钟为单位。因此,医院入院时间通常为负数。可能需要添加一个ICU入院前的“模糊”时间,因为有时实验室测量是在ICU入院前进行的,例如,查看从(-624)分钟到(2460)分钟从ICU入院开始的所有实验室测量。

数据接口

只有在某些“接口”可用时,才会将每个患者的数据收集到一个共同的数据仓库中。每个接口用于转换和加载某种类型的数据:生命体征接口包含生命体征,实验室接口提供血样的测量数据,依此类推。重要的是要注意,不同的护理单位可能具有不同的接口,并且缺少接口将导致对于给定患者没有数据可用,即使这些测量实际上已经进行了。

输入和输出

药物表实质上是与药房数据交互的接口 - 即已开的药物。 intakeoutput和infusiondrug表应用于液体和药物,分别。判断医院是否实际上正在收集和存档infusiondrug表中的数据是一个挑战。

实验室测试

lab表由约160个“标准”实验室测量数据填充。当医院首次参与eICU计划时,他们必须将这些值映射到其本地系统。因此,这个表中的大多数常见实验室都很好地协调起来。然而,实验室接口可能关闭,并且标准实验室可能记录在customlab表中(例如,在软件升级期间)。原则上,这些停机时间是罕见的,但有关这种情况有多频繁的经验性研究尚未进行。

浏览 (186)
点赞 (1)
收藏
评论