eicu.eicu_crd contains 391 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
admissiondrug	admissiondrugid	int4	10
admissiondrug	drugadmitfrequency	varchar	1000
admissiondrug	drugdosage	numeric	11,4	√		null
admissiondrug	drugenteredoffset	int4	10
admissiondrug	drughiclseqno	int4	10	√		null
admissiondrug	drugname	varchar	255
admissiondrug	drugnotetype	varchar	255	√		null
admissiondrug	drugoffset	int4	10
admissiondrug	drugunit	varchar	1000	√		null
admissiondrug	patientunitstayid	int4	10
admissiondrug	rxincluded	varchar	5	√		null
admissiondrug	specialtytype	varchar	255	√		null
admissiondrug	usertype	varchar	255
admissiondrug	writtenineicu	varchar	5	√		null
admissiondx	admissiondxid	int4	10
admissiondx	admitdxenteredoffset	int4	10
admissiondx	admitdxname	varchar	255	√		null
admissiondx	admitdxpath	varchar	500
admissiondx	admitdxtext	varchar	255	√		null
admissiondx	patientunitstayid	int4	10
allergy	allergyenteredoffset	int4	10
allergy	allergyid	int4	10
allergy	allergyname	varchar	255	√		null
allergy	allergynotetype	varchar	255	√		null
allergy	allergyoffset	int4	10
allergy	allergytype	varchar	255	√		null
allergy	drughiclseqno	int4	10	√		null
allergy	drugname	varchar	255
allergy	patientunitstayid	int4	10
allergy	rxincluded	varchar	5	√		null
allergy	specialtytype	varchar	255	√		null
allergy	usertype	varchar	255
allergy	writtenineicu	varchar	5	√		null
apacheapsvar	albumin	float8	17,17	√		null
apacheapsvar	apacheapsvarid	int4	10	√		null
apacheapsvar	bilirubin	float8	17,17	√		null
apacheapsvar	bun	float8	17,17	√		null
apacheapsvar	creatinine	float8	17,17	√		null
apacheapsvar	dialysis	int2	5	√		null
apacheapsvar	eyes	int2	5	√		null
apacheapsvar	fio2	float8	17,17	√		null
apacheapsvar	glucose	float8	17,17	√		null
apacheapsvar	heartrate	float8	17,17	√		null
apacheapsvar	hematocrit	float8	17,17	√		null
apacheapsvar	intubated	int2	5	√		null
apacheapsvar	meanbp	float8	17,17	√		null
apacheapsvar	meds	int2	5	√		null
apacheapsvar	motor	int2	5	√		null
apacheapsvar	pao2	float8	17,17	√		null
apacheapsvar	patientunitstayid	int4	10	√		null
apacheapsvar	pco2	float8	17,17	√		null
apacheapsvar	ph	float8	17,17	√		null
apacheapsvar	respiratoryrate	float8	17,17	√		null
apacheapsvar	sodium	float8	17,17	√		null
apacheapsvar	temperature	float8	17,17	√		null
apacheapsvar	urine	float8	17,17	√		null
apacheapsvar	vent	int2	5	√		null
apacheapsvar	verbal	int2	5	√		null
apacheapsvar	wbc	float8	17,17	√		null
apachepatientresult	actualhospitallos	float8	17,17	√		null
apachepatientresult	actualhospitalmortality	varchar	50	√		null
apachepatientresult	actualiculos	float8	17,17	√		null
apachepatientresult	actualicumortality	varchar	50	√		null
apachepatientresult	actualventdays	float8	17,17	√		null
apachepatientresult	acutephysiologyscore	int4	10	√		null
apachepatientresult	apachepatientresultsid	int4	10
apachepatientresult	apachescore	int4	10	√		null
apachepatientresult	apacheversion	varchar	5
apachepatientresult	patientunitstayid	int4	10
apachepatientresult	physicianinterventioncategory	varchar	50	√		null
apachepatientresult	physicianspeciality	varchar	50	√		null
apachepatientresult	predictedhospitallos	float8	17,17	√		null
apachepatientresult	predictedhospitalmortality	varchar	50	√		null
apachepatientresult	predictediculos	float8	17,17	√		null
apachepatientresult	predictedicumortality	varchar	50	√		null
apachepatientresult	predventdays	float8	17,17	√		null
apachepatientresult	preopcardiaccath	int4	10	√		null
apachepatientresult	preopmi	int4	10	√		null
apachepatientresult	ptcawithin24h	int4	10	√		null
apachepatientresult	unabridgedactualventdays	float8	17,17	√		null
apachepatientresult	unabridgedhosplos	float8	17,17	√		null
apachepatientresult	unabridgedunitlos	float8	17,17	√		null
apachepredvar	activetx	int2	5	√		null
apachepredvar	admitdiagnosis	varchar	11	√		null
apachepredvar	admitsource	int2	5	√		null
apachepredvar	age	int2	5	√		null
apachepredvar	aids	int2	5	√		null
apachepredvar	amilocation	int2	5	√		null
apachepredvar	apachepredvarid	int4	10	√		null
apachepredvar	bedcount	int2	5	√		null
apachepredvar	cirrhosis	int2	5	√		null
apachepredvar	creatinine	float8	17,17	√		null
apachepredvar	day1eyes	int2	5	√		null
apachepredvar	day1fio2	float8	17,17	√		null
apachepredvar	day1meds	int2	5	√		null
apachepredvar	day1motor	int2	5	√		null
apachepredvar	day1pao2	float8	17,17	√		null
apachepredvar	day1verbal	int2	5	√		null
apachepredvar	diabetes	int2	5	√		null
apachepredvar	diedinhospital	int2	5	√		null
apachepredvar	dischargelocation	int2	5	√		null
apachepredvar	ejectfx	float8	17,17	√		null
apachepredvar	electivesurgery	int2	5	√		null
apachepredvar	eyes	int2	5	√		null
apachepredvar	fio2	float8	17,17	√		null
apachepredvar	gender	int2	5	√		null
apachepredvar	graftcount	int2	5	√		null
apachepredvar	hepaticfailure	int2	5	√		null
apachepredvar	ima	int2	5	√		null
apachepredvar	immunosuppression	int2	5	√		null
apachepredvar	leukemia	int2	5	√		null
apachepredvar	lymphoma	int2	5	√		null
apachepredvar	managementsystem	int2	5	√		null
apachepredvar	meds	int2	5	√		null
apachepredvar	metastaticcancer	int2	5	√		null
apachepredvar	midur	int2	5	√		null
apachepredvar	motor	int2	5	√		null
apachepredvar	oobintubday1	int2	5	√		null
apachepredvar	oobventday1	int2	5	√		null
apachepredvar	pao2	float8	17,17	√		null
apachepredvar	patientunitstayid	int4	10	√		null
apachepredvar	readmit	int2	5	√		null
apachepredvar	region	int2	5	√		null
apachepredvar	saps3day1	int2	5	√		null
apachepredvar	saps3today	int2	5	√		null
apachepredvar	saps3yesterday	int2	5	√		null
apachepredvar	sicuday	int2	5	√		null
apachepredvar	teachtype	int2	5	√		null
apachepredvar	thrombolytics	int2	5	√		null
apachepredvar	var03hspxlos	float8	17,17	√		null
apachepredvar	ventday1	int2	5	√		null
apachepredvar	verbal	int2	5	√		null
apachepredvar	visitnumber	int2	5	√		null
careplancareprovider	activeupondischarge	varchar	10
careplancareprovider	careprovidersaveoffset	int4	10
careplancareprovider	cplcareprovderid	int4	10
careplancareprovider	interventioncategory	varchar	255	√		null
careplancareprovider	managingphysician	varchar	50	√		null
careplancareprovider	patientunitstayid	int4	10
careplancareprovider	providertype	varchar	255	√		null
careplancareprovider	specialty	varchar	255	√		null
careplaneol	activeupondischarge	varchar	10	√		null
careplaneol	cpleoldiscussionoffset	int4	10	√		null
careplaneol	cpleolid	int4	10
careplaneol	cpleolsaveoffset	int4	10
careplaneol	patientunitstayid	int4	10
careplangeneral	activeupondischarge	varchar	10
careplangeneral	cplgeneralid	int4	10
careplangeneral	cplgroup	varchar	255
careplangeneral	cplitemoffset	int4	10
careplangeneral	cplitemvalue	varchar	1024	√		null
careplangeneral	patientunitstayid	int4	10
careplangoal	activeupondischarge	varchar	10
careplangoal	cplgoalcategory	varchar	255	√		null
careplangoal	cplgoalid	int4	10
careplangoal	cplgoaloffset	int4	10
careplangoal	cplgoalstatus	varchar	255	√		null
careplangoal	cplgoalvalue	varchar	1000	√		null
careplangoal	patientunitstayid	int4	10
careplaninfectiousdisease	activeupondischarge	varchar	10
careplaninfectiousdisease	cplinfectdiseaseoffset	int4	10
careplaninfectiousdisease	cplinfectid	int4	10
careplaninfectiousdisease	infectdiseaseassessment	varchar	64	√		null
careplaninfectiousdisease	infectdiseasesite	varchar	64	√		null
careplaninfectiousdisease	patientunitstayid	int4	10
careplaninfectiousdisease	responsetotherapy	varchar	32	√		null
careplaninfectiousdisease	treatment	varchar	32	√		null
customlab	customlabid	int4	10
customlab	labothername	varchar	64	√		null
customlab	labotheroffset	int4	10
customlab	labotherresult	varchar	64	√		null
customlab	labothertypeid	int4	10
customlab	labothervaluetext	varchar	128	√		null
customlab	patientunitstayid	int4	10
diagnosis	activeupondischarge	varchar	64	√		null
diagnosis	diagnosisid	int4	10
diagnosis	diagnosisoffset	int4	10
diagnosis	diagnosispriority	varchar	10
diagnosis	diagnosisstring	varchar	200
diagnosis	icd9code	varchar	100	√		null
diagnosis	patientunitstayid	int4	10
hospital	hospitalid	int4	10
hospital	numbedscategory	varchar	32	√		null
hospital	region	varchar	64	√		null
hospital	teachingstatus	bool	1	√		null
infusiondrug	drugamount	varchar	255	√		null
infusiondrug	drugname	varchar	255
infusiondrug	drugrate	varchar	255	√		null
infusiondrug	infusiondrugid	int4	10
infusiondrug	infusionoffset	int4	10
infusiondrug	infusionrate	varchar	255	√		null
infusiondrug	patientunitstayid	int4	10
infusiondrug	patientweight	varchar	255	√		null
infusiondrug	volumeoffluid	varchar	255	√		null
intakeoutput	celllabel	varchar	255	√		null
intakeoutput	cellpath	varchar	500	√		null
intakeoutput	cellvaluenumeric	numeric	12,4
intakeoutput	cellvaluetext	varchar	255
intakeoutput	dialysistotal	numeric	12,4	√		null
intakeoutput	intakeoutputentryoffset	int4	10
intakeoutput	intakeoutputid	int4	10
intakeoutput	intakeoutputoffset	int4	10
intakeoutput	intaketotal	numeric	12,4	√		null
intakeoutput	nettotal	numeric	12,4	√		null
intakeoutput	outputtotal	numeric	12,4	√		null
intakeoutput	patientunitstayid	int4	10
lab	labid	int4	10
lab	labmeasurenameinterface	varchar	255	√		null
lab	labmeasurenamesystem	varchar	255	√		null
lab	labname	varchar	256	√		null
lab	labresult	numeric	11,4	√		null
lab	labresultoffset	int4	10
lab	labresultrevisedoffset	int4	10	√		null
lab	labresulttext	varchar	255	√		null
lab	labtypeid	numeric	3
lab	patientunitstayid	int4	10
medication	dosage	varchar	60	√		null
medication	drughiclseqno	int4	10	√		null
medication	drugivadmixture	varchar	6
medication	drugname	varchar	220	√		null
medication	drugordercancelled	varchar	6
medication	drugorderoffset	int4	10
medication	drugstartoffset	int4	10
medication	drugstopoffset	int4	10
medication	frequency	varchar	255	√		null
medication	gtc	int4	10
medication	loadingdose	varchar	120
medication	medicationid	int4	10
medication	patientunitstayid	int4	10
medication	prn	varchar	6
medication	routeadmin	varchar	120	√		null
microlab	antibiotic	varchar	255	√		null
microlab	culturesite	varchar	255
microlab	culturetakenoffset	int4	10
microlab	microlabid	int4	10
microlab	organism	varchar	255
microlab	patientunitstayid	int4	10
microlab	sensitivitylevel	varchar	255	√		null
note	noteenteredoffset	int4	10
note	noteid	int4	10
note	noteoffset	int4	10
note	notepath	varchar	255
note	notetext	varchar	500	√		null
note	notetype	varchar	50
note	notevalue	varchar	150	√		null
note	patientunitstayid	int4	10
nurseassessment	cellattribute	varchar	255
nurseassessment	cellattributepath	varchar	255
nurseassessment	cellattributevalue	varchar	4000	√		null
nurseassessment	celllabel	varchar	255
nurseassessment	nurseassessentryoffset	int4	10
nurseassessment	nurseassessid	int4	10
nurseassessment	nurseassessoffset	int4	10
nurseassessment	patientunitstayid	int4	10
nursecare	cellattribute	varchar	255
nursecare	cellattributepath	varchar	255
nursecare	cellattributevalue	varchar	4000	√		null
nursecare	celllabel	varchar	255
nursecare	nursecareentryoffset	int4	10
nursecare	nursecareid	int4	10
nursecare	nursecareoffset	int4	10
nursecare	patientunitstayid	int4	10
nursecharting	nursingchartcelltypecat	varchar	255
nursecharting	nursingchartcelltypevallabel	varchar	255	√		null
nursecharting	nursingchartcelltypevalname	varchar	255	√		null
nursecharting	nursingchartentryoffset	int4	10
nursecharting	nursingchartid	int8	19
nursecharting	nursingchartoffset	int4	10
nursecharting	nursingchartvalue	varchar	255	√		null
nursecharting	patientunitstayid	int4	10
pasthistory	pasthistoryenteredoffset	int4	10
pasthistory	pasthistoryid	int4	10
pasthistory	pasthistorynotetype	varchar	40	√		null
pasthistory	pasthistoryoffset	int4	10
pasthistory	pasthistorypath	varchar	255
pasthistory	pasthistoryvalue	varchar	100	√		null
pasthistory	pasthistoryvaluetext	varchar	255	√		null
pasthistory	patientunitstayid	int4	10
patient	admissionheight	numeric	10,2	√		null
patient	admissionweight	numeric	10,2	√		null
patient	age	varchar	10	√		null
patient	apacheadmissiondx	varchar	1000	√		null
patient	dischargeweight	numeric	10,2	√		null
patient	ethnicity	varchar	50	√		null
patient	gender	varchar	25	√		null
patient	hospitaladmitoffset	int4	10	√		null
patient	hospitaladmitsource	varchar	30	√		null
patient	hospitaladmittime24	varchar	8	√		null
patient	hospitaldischargelocation	varchar	100	√		null
patient	hospitaldischargeoffset	int4	10	√		null
patient	hospitaldischargestatus	varchar	10	√		null
patient	hospitaldischargetime24	varchar	8	√		null
patient	hospitaldischargeyear	int2	5	√		null
patient	hospitalid	int4	10	√		null
patient	patienthealthsystemstayid	int4	10	√		null
patient	patientunitstayid	int4	10
patient	uniquepid	varchar	10	√		null
patient	unitadmitsource	varchar	100	√		null
patient	unitadmittime24	varchar	8	√		null
patient	unitdischargelocation	varchar	100	√		null
patient	unitdischargeoffset	int4	10	√		null
patient	unitdischargestatus	varchar	10	√		null
patient	unitdischargetime24	varchar	8	√		null
patient	unitstaytype	varchar	15	√		null
patient	unittype	varchar	50	√		null
patient	unitvisitnumber	int4	10	√		null
patient	wardid	int4	10	√		null
physicalexam	patientunitstayid	int4	10
physicalexam	physicalexamid	int4	10	√		null
physicalexam	physicalexamoffset	int4	10
physicalexam	physicalexampath	varchar	255
physicalexam	physicalexamtext	varchar	500	√		null
physicalexam	physicalexamvalue	varchar	100	√		null
respiratorycare	airwayposition	varchar	32	√		null
respiratorycare	airwaysize	varchar	10	√		null
respiratorycare	airwaytype	varchar	30	√		null
respiratorycare	apneaparams	varchar	80	√		null
respiratorycare	cpaplimit	numeric	11,4	√		null
respiratorycare	cuffpressure	numeric	5,1	√		null
respiratorycare	currenthistoryseqnum	int4	10	√		null
respiratorycare	hiexhmvlimit	numeric	11,4	√		null
respiratorycare	highironoxlimit	numeric	11,4	√		null
respiratorycare	hipeakpreslimit	numeric	11,4	√		null
respiratorycare	hirespratelimit	numeric	11,4	√		null
respiratorycare	lowexhmvlimit	numeric	11,4	√		null
respiratorycare	lowexhtvlimit	numeric	11,4	√		null
respiratorycare	lowironoxlimit	numeric	11,4	√		null
respiratorycare	lowpeakpreslimit	numeric	11,4	√		null
respiratorycare	lowrespratelimit	numeric	11,4	√		null
respiratorycare	meanairwaypreslimit	numeric	11,4	√		null
respiratorycare	patientunitstayid	int4	10	√		null
respiratorycare	peeplimit	numeric	11,4	√		null
respiratorycare	priorventendoffset	int4	10	√		null
respiratorycare	priorventstartoffset	int4	10	√		null
respiratorycare	respcareid	int4	10	√		null
respiratorycare	respcarestatusoffset	int4	10	√		null
respiratorycare	setapneafio2	varchar	80	√		null
respiratorycare	setapneaie	varchar	80	√		null
respiratorycare	setapneainsptime	varchar	80	√		null
respiratorycare	setapneainterval	varchar	80	√		null
respiratorycare	setapneaippeephigh	varchar	80	√		null
respiratorycare	setapneapeakflow	varchar	80	√		null
respiratorycare	setapnearr	varchar	80	√		null
respiratorycare	setapneatv	varchar	80	√		null
respiratorycare	sighpreslimit	numeric	11,4	√		null
respiratorycare	ventendoffset	int4	10	√		null
respiratorycare	ventstartoffset	int4	10	√		null
respiratorycharting	patientunitstayid	int4	10	√		null
respiratorycharting	respchartentryoffset	int4	10	√		null
respiratorycharting	respchartid	int4	10	√		null
respiratorycharting	respchartoffset	int4	10	√		null
respiratorycharting	respcharttypecat	varchar	255	√		null
respiratorycharting	respchartvalue	varchar	1000	√		null
respiratorycharting	respchartvaluelabel	varchar	255	√		null
treatment	activeupondischarge	varchar	10	√		null
treatment	patientunitstayid	int4	10	√		null
treatment	treatmentid	int4	10	√		null
treatment	treatmentoffset	int4	10	√		null
treatment	treatmentstring	varchar	200	√		null
vitalaperiodic	cardiacinput	float8	17,17	√		null
vitalaperiodic	cardiacoutput	float8	17,17	√		null
vitalaperiodic	noninvasivediastolic	float8	17,17	√		null
vitalaperiodic	noninvasivemean	float8	17,17	√		null
vitalaperiodic	noninvasivesystolic	float8	17,17	√		null
vitalaperiodic	observationoffset	int4	10
vitalaperiodic	paop	float8	17,17	√		null
vitalaperiodic	patientunitstayid	int4	10
vitalaperiodic	pvr	float8	17,17	√		null
vitalaperiodic	pvri	float8	17,17	√		null
vitalaperiodic	svr	float8	17,17	√		null
vitalaperiodic	svri	float8	17,17	√		null
vitalaperiodic	vitalaperiodicid	int4	10
vitalperiodic	cvp	int4	10	√		null
vitalperiodic	etco2	int4	10	√		null
vitalperiodic	heartrate	int4	10	√		null
vitalperiodic	icp	int4	10	√		null
vitalperiodic	observationoffset	int4	10	√		null
vitalperiodic	padiastolic	int4	10	√		null
vitalperiodic	pamean	int4	10	√		null
vitalperiodic	pasystolic	int4	10	√		null
vitalperiodic	patientunitstayid	int4	10	√		null
vitalperiodic	respiration	int4	10	√		null
vitalperiodic	sao2	int4	10	√		null
vitalperiodic	st1	float8	17,17	√		null
vitalperiodic	st2	float8	17,17	√		null
vitalperiodic	st3	float8	17,17	√		null
vitalperiodic	systemicdiastolic	int4	10	√		null
vitalperiodic	systemicmean	int4	10	√		null
vitalperiodic	systemicsystolic	int4	10	√		null
vitalperiodic	temperature	numeric	11,4	√		null
vitalperiodic	vitalperiodicid	int8	19	√		null