SchemaSpy Analysis of mimic.mimiciii - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Thu Oct 12 12:29 EDT 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

mimic.mimiciii contains 534 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
microbiologyevents ab_itemid int4 10  √  null Foreign key. Identifies the antibody.
microbiologyevents ab_name varchar 30  √  null Name of the antibody used.
d_items abbreviation varchar 100  √  null Abbreviation associated with the item.
callout acknowledgetime timestamp 22  √  null Time at which the call out request was acknowledged.
inputevents_cv amount float8 17,17  √  null Amount of the item administered to the patient.
inputevents_mv amount float8 17,17  √  null Amount of the item administered to the patient.
inputevents_cv amountuom varchar 30  √  null Unit of measurement for the amount.
inputevents_mv amountuom varchar 30  √  null Unit of measurement for the amount.
callout callout_wardid int4 10  √  null Identifies the ward where the patient is to be discharged to. A value of 1 indicates the first available ward. A value of 0 indicates home.
inputevents_mv cancelreason int2 5  √  null Reason for cancellation, if cancelled.
procedureevents_mv cancelreason int2 5  √  null
d_items category varchar 100  √  null Category of data which the concept falls under.
noteevents category varchar 50  √  null Category of the note, e.g. Discharge summary.
chartevents cgid int4 10  √  null Foreign key. Identifies the caregiver.
chartevents_1 cgid int4 10  √  null
chartevents_10 cgid int4 10  √  null
chartevents_11 cgid int4 10  √  null
chartevents_12 cgid int4 10  √  null
chartevents_13 cgid int4 10  √  null
chartevents_14 cgid int4 10  √  null
chartevents_2 cgid int4 10  √  null
chartevents_3 cgid int4 10  √  null
chartevents_4 cgid int4 10  √  null
chartevents_5 cgid int4 10  √  null
chartevents_6 cgid int4 10  √  null
chartevents_7 cgid int4 10  √  null
chartevents_8 cgid int4 10  √  null
chartevents_9 cgid int4 10  √  null
inputevents_cv cgid int4 10  √  null Foreign key. Identifies the caregiver.
inputevents_mv cgid int4 10  √  null Foreign key. Identifies the caregiver.
noteevents cgid int4 10  √  null Foreign key. Identifies the caregiver.
outputevents cgid int4 10  √  null
procedureevents_mv cgid int4 10  √  null
cptevents chartdate timestamp 22  √  null Date when the event occured, if available.
microbiologyevents chartdate timestamp 22  √  null Date when the event occured.
noteevents chartdate timestamp 22  √  null Date when the note was charted.
chartevents charttime timestamp 22  √  null Time when the event occured.
chartevents_1 charttime timestamp 22  √  null
chartevents_10 charttime timestamp 22  √  null
chartevents_11 charttime timestamp 22  √  null
chartevents_12 charttime timestamp 22  √  null
chartevents_13 charttime timestamp 22  √  null
chartevents_14 charttime timestamp 22  √  null
chartevents_2 charttime timestamp 22  √  null
chartevents_3 charttime timestamp 22  √  null
chartevents_4 charttime timestamp 22  √  null
chartevents_5 charttime timestamp 22  √  null
chartevents_6 charttime timestamp 22  √  null
chartevents_7 charttime timestamp 22  √  null
chartevents_8 charttime timestamp 22  √  null
chartevents_9 charttime timestamp 22  √  null
inputevents_cv charttime timestamp 22  √  null Time of that the input was started or received.
labevents charttime timestamp 22  √  null Time when the event occured.
microbiologyevents charttime timestamp 22  √  null Time when the event occured, if available.
noteevents charttime timestamp 22  √  null Date and time when the note was charted. Note that some notes (e.g. discharge summaries) do not have a time associated with them: these notes have NULL in this column.
outputevents charttime timestamp 22  √  null
d_cpt codesuffix varchar 5  √  null Text element of the Current Procedural Terminology, if any.
inputevents_mv comments_canceledby varchar 40  √  null The title of the caregiver who canceled the order.
procedureevents_mv comments_canceledby varchar 30  √  null
inputevents_mv comments_date timestamp 22  √  null Time at which the caregiver edited or cancelled the order.
procedureevents_mv comments_date timestamp 22  √  null
inputevents_mv comments_editedby varchar 30  √  null The title of the caregiver who edited the order.
procedureevents_mv comments_editedby varchar 30  √  null
d_items conceptid int4 10  √  null Identifier used to harmonize concepts identified by multiple ITEMIDs. CONCEPTIDs are planned but not yet implemented (all values are NULL).
inputevents_mv continueinnextdept int2 5  √  null Indicates whether the item will be continued in the next department where the patient is transferred to.
procedureevents_mv continueinnextdept int2 5  √  null
cptevents cpt_number int4 10  √  null Numerical element of the Current Procedural Terminology code.
cptevents cpt_suffix varchar 5  √  null Text element of the Current Procedural Terminology, if any. Indicates code category.
callout curr_careunit varchar 15  √  null If the ward where the patient is currently residing is an ICU, the ICU type is listed here.
transfers curr_careunit varchar 20  √  null Current careunit.
services curr_service varchar 20  √  null Current service type.
callout curr_wardid int4 10  √  null Identifies the ward where the patient is currently residing.
transfers curr_wardid int2 5  √  null Identifier for the current ward the patient is located in.
callout currentreservationtime timestamp 22  √  null Latest time at which a ward was reserved for the call out request.
d_items dbsource varchar 20  √  null Source database of the item.
transfers dbsource varchar 20  √  null Source database of the item.
admissions deathtime timestamp 22  √  null Time of death.
caregivers description varchar 30  √  null More detailed description of the caregiver, if available.
cptevents description varchar 200  √  null Description of the Current Procedural Terminology, if available.
drgcodes description varchar 255  √  null Description of the Diagnosis-Related Group
noteevents description varchar 255  √  null A more detailed categorization for the note, sometimes entered by free-text.
admissions diagnosis varchar 255  √  null Diagnosis.
microbiologyevents dilution_comparison varchar 20  √  null The comparison component of DILUTION_TEXT: either <= (less than or equal), = (equal), or >= (greater than or equal), or null when not available.
microbiologyevents dilution_text varchar 10  √  null The dilution amount tested for and the comparison which was made against it (e.g. <=4).
microbiologyevents dilution_value float8 17,17  √  null The value component of DILUTION_TEXT: must be a floating point number.
callout discharge_wardid int4 10  √  null The ward to which the patient was discharged.
patients dod timestamp 22  √  null Date of death. Null if the patient was alive at least 90 days post hospital discharge.
patients dod_hosp timestamp 22  √  null Date of death recorded in the hospital records.
patients dod_ssn timestamp 22  √  null Date of death recorded in the social security records.
prescriptions dose_unit_rx varchar 120  √  null Unit of measurement associated with the dose.
prescriptions dose_val_rx varchar 120  √  null Dose of the drug prescribed.
drgcodes drg_mortality int2 5  √  null Relative mortality, available for type APR only.
drgcodes drg_severity int2 5  √  null Relative severity, available for type APR only.
prescriptions drug_name_generic varchar 100  √  null Generic drug name.
prescriptions drug_name_poe varchar 100  √  null Name of the drug on the Provider Order Entry interface.
admissions edouttime timestamp 22  √  null
admissions edregtime timestamp 22  √  null
prescriptions enddate timestamp 22  √  null Date when the prescription ended.
inputevents_mv endtime timestamp 22  √  null Time when the event ended.
procedureevents_mv endtime timestamp 22  √  null
chartevents error int4 10  √  null Flag to highlight an error with the event.
chartevents_1 error int4 10  √  null
chartevents_10 error int4 10  √  null
chartevents_11 error int4 10  √  null
chartevents_12 error int4 10  √  null
chartevents_13 error int4 10  √  null
chartevents_14 error int4 10  √  null
chartevents_2 error int4 10  √  null
chartevents_3 error int4 10  √  null
chartevents_4 error int4 10  √  null
chartevents_5 error int4 10  √  null
chartevents_6 error int4 10  √  null
chartevents_7 error int4 10  √  null
chartevents_8 error int4 10  √  null
chartevents_9 error int4 10  √  null
datetimeevents error int2 5  √  null Flag to highlight an error with the event.
transfers eventtype varchar 20  √  null Type of event, for example admission or transfer.
callout firstreservationtime timestamp 22  √  null First time at which a ward was reserved for the call out request.
labevents flag varchar 20  √  null Flag indicating whether the lab test value is considered abnormal (null if the test was normal).
prescriptions form_unit_disp varchar 120  √  null Unit of measurement associated with the formulation.
prescriptions form_val_disp varchar 120  √  null Amount of the formulation dispensed.
prescriptions formulary_drug_cd varchar 120  √  null Formulary drug code.
prescriptions gsn varchar 200  √  null Generic Sequence Number.
chartevents hadm_id int4 10  √  null Foreign key. Identifies the hospital stay.
chartevents_1 hadm_id int4 10  √  null
chartevents_10 hadm_id int4 10  √  null
chartevents_11 hadm_id int4 10  √  null
chartevents_12 hadm_id int4 10  √  null
chartevents_13 hadm_id int4 10  √  null
chartevents_14 hadm_id int4 10  √  null
chartevents_2 hadm_id int4 10  √  null
chartevents_3 hadm_id int4 10  √  null
chartevents_4 hadm_id int4 10  √  null
chartevents_5 hadm_id int4 10  √  null
chartevents_6 hadm_id int4 10  √  null
chartevents_7 hadm_id int4 10  √  null
chartevents_8 hadm_id int4 10  √  null
chartevents_9 hadm_id int4 10  √  null
datetimeevents hadm_id int4 10  √  null Foreign key. Identifies the hospital stay.
inputevents_cv hadm_id int4 10  √  null Foreign key. Identifies the hospital stay.
inputevents_mv hadm_id int4 10  √  null Foreign key. Identifies the hospital stay.
labevents hadm_id int4 10  √  null Foreign key. Identifies the hospital stay.
microbiologyevents hadm_id int4 10  √  null Foreign key. Identifies the hospital stay.
noteevents hadm_id int4 10  √  null Foreign key. Identifies the hospital stay.
outputevents hadm_id int4 10  √  null
admissions hospital_expire_flag int2 5  √  null
diagnoses_icd icd9_code varchar 10  √  null ICD9 code for the diagnosis.
chartevents icustay_id int4 10  √  null Foreign key. Identifies the ICU stay.
chartevents_1 icustay_id int4 10  √  null
chartevents_10 icustay_id int4 10  √  null
chartevents_11 icustay_id int4 10  √  null
chartevents_12 icustay_id int4 10  √  null
chartevents_13 icustay_id int4 10  √  null
chartevents_14 icustay_id int4 10  √  null
chartevents_2 icustay_id int4 10  √  null
chartevents_3 icustay_id int4 10  √  null
chartevents_4 icustay_id int4 10  √  null
chartevents_5 icustay_id int4 10  √  null
chartevents_6 icustay_id int4 10  √  null
chartevents_7 icustay_id int4 10  √  null
chartevents_8 icustay_id int4 10  √  null
chartevents_9 icustay_id int4 10  √  null
datetimeevents icustay_id int4 10  √  null Foreign key. Identifies the ICU stay.
inputevents_cv icustay_id int4 10  √  null Foreign key. Identifies the ICU stay.
inputevents_mv icustay_id int4 10  √  null Foreign key. Identifies the ICU stay.
outputevents icustay_id int4 10  √  null
prescriptions icustay_id int4 10  √  null Foreign key. Identifies the ICU stay.
procedureevents_mv icustay_id int4 10  √  null
transfers icustay_id int4 10  √  null Foreign key. Identifies the ICU stay.
microbiologyevents interpretation varchar 5  √  null Interpretation of the test.
transfers intime timestamp 22  √  null Time when the patient was transferred into the unit.
noteevents iserror bpchar 1  √  null Flag to highlight an error with the note.
outputevents iserror int4 10  √  null
microbiologyevents isolate_num int2 5  √  null Isolate number associated with the test.
inputevents_mv isopenbag int2 5  √  null Indicates whether the bag containing the solution is open.
procedureevents_mv isopenbag int2 5  √  null
chartevents itemid int4 10  √  null Foreign key. Identifies the charted item.
chartevents_1 itemid int4 10  √  null
chartevents_10 itemid int4 10  √  null
chartevents_11 itemid int4 10  √  null
chartevents_12 itemid int4 10  √  null
chartevents_13 itemid int4 10  √  null
chartevents_14 itemid int4 10  √  null
chartevents_2 itemid int4 10  √  null
chartevents_3 itemid int4 10  √  null
chartevents_4 itemid int4 10  √  null
chartevents_5 itemid int4 10  √  null
chartevents_6 itemid int4 10  √  null
chartevents_7 itemid int4 10  √  null
chartevents_8 itemid int4 10  √  null
chartevents_9 itemid int4 10  √  null
inputevents_cv itemid int4 10  √  null Foreign key. Identifies the charted item.
inputevents_mv itemid int4 10  √  null Foreign key. Identifies the charted item.
outputevents itemid int4 10  √  null
procedureevents_mv itemid int4 10  √  null
caregivers label varchar 15  √  null Title of the caregiver, for example MD or RN.
d_items label varchar 200  √  null Label identifying the item.
admissions language varchar 10  √  null Language.
inputevents_cv linkorderid int4 10  √  null Identifier linking orders across multiple administrations. LINKORDERID is always equal to the first occuring ORDERID of the series.
inputevents_mv linkorderid int4 10  √  null Identifier linking orders across multiple administrations. LINKORDERID is always equal to the first occuring ORDERID of the series.
procedureevents_mv linkorderid int4 10  √  null
d_items linksto varchar 50  √  null Table which contains data for the given ITEMID.
procedureevents_mv location varchar 30  √  null
procedureevents_mv locationcategory varchar 30  √  null
d_labitems loinc_code varchar 100  √  null Logical Observation Identifiers Names and Codes (LOINC) mapped to the item, if available.
icustays los float8 17,17  √  null Length of stay in the ICU in fractional days.
transfers los float8 17,17  √  null Length of stay in the unit in minutes.
admissions marital_status varchar 50  √  null Marital status.
prescriptions ndc varchar 120  √  null National Drug Code.
inputevents_cv newbottle int4 10  √  null Indicates when a new bottle of the solution was hung at the bedside.
outputevents newbottle bpchar 1  √  null
inputevents_mv ordercategorydescription varchar 50  √  null The type of item administered.
procedureevents_mv ordercategorydescription varchar 50  √  null
inputevents_mv ordercategoryname varchar 100  √  null A group which the item corresponds to.
procedureevents_mv ordercategoryname varchar 100  √  null
inputevents_mv ordercomponenttypedescription varchar 200  √  null The role of the item administered in the order.
inputevents_cv orderid int4 10  √  null Identifier linking items which are grouped in a solution.
inputevents_mv orderid int4 10  √  null Identifier linking items which are grouped in a solution.
procedureevents_mv orderid int4 10  √  null
microbiologyevents org_itemid int4 10  √  null Foreign key. Identifies the organism.
microbiologyevents org_name varchar 100  √  null Name of the organism.
inputevents_cv originalamount float8 17,17  √  null Amount of the item which was originally charted.
inputevents_mv originalamount float8 17,17  √  null Amount of the item which was originally charted.
inputevents_cv originalamountuom varchar 30  √  null Unit of measurement for the original amount.
inputevents_cv originalrate float8 17,17  √  null Rate of administration originally chosen for the item.
inputevents_mv originalrate float8 17,17  √  null Rate of administration originally chosen for the item.
inputevents_cv originalrateuom varchar 30  √  null Unit of measurement for the rate originally chosen.
inputevents_cv originalroute varchar 30  √  null Route of administration originally chosen for the item.
inputevents_cv originalsite varchar 30  √  null Anatomical site for the original administration of the item.
icustays outtime timestamp 22  √  null Time of discharge from the ICU.
transfers outtime timestamp 22  √  null Time when the patient was transferred out of the unit.
d_items param_type varchar 30  √  null Type of item, for example solution or ingredient.
inputevents_mv patientweight float8 17,17  √  null For drugs dosed by weight, the value of the weight used in the calculation.
transfers prev_careunit varchar 20  √  null Previous careunit.
services prev_service varchar 20  √  null Previous service type.
transfers prev_wardid int2 5  √  null Identifier for the previous ward the patient was located in.
prescriptions prod_strength varchar 120  √  null Strength of the drug (product).
inputevents_cv rate float8 17,17  √  null Rate at which the item is being administered to the patient.
inputevents_mv rate float8 17,17  √  null Rate at which the item is being administered to the patient.
inputevents_cv rateuom varchar 30  √  null Unit of measurement for the rate.
inputevents_mv rateuom varchar 30  √  null Unit of measurement for the rate.
admissions religion varchar 50  √  null Religon.
chartevents resultstatus varchar 50  √  null Result status of lab data.
chartevents_1 resultstatus varchar 50  √  null
chartevents_10 resultstatus varchar 50  √  null
chartevents_11 resultstatus varchar 50  √  null
chartevents_12 resultstatus varchar 50  √  null
chartevents_13 resultstatus varchar 50  √  null
chartevents_14 resultstatus varchar 50  √  null
chartevents_2 resultstatus varchar 50  √  null
chartevents_3 resultstatus varchar 50  √  null
chartevents_4 resultstatus varchar 50  √  null
chartevents_5 resultstatus varchar 50  √  null
chartevents_6 resultstatus varchar 50  √  null
chartevents_7 resultstatus varchar 50  √  null
chartevents_8 resultstatus varchar 50  √  null
chartevents_9 resultstatus varchar 50  √  null
datetimeevents resultstatus varchar 50  √  null Result status of lab data.
prescriptions route varchar 120  √  null Route of administration, for example intravenous or oral.
inputevents_mv secondaryordercategoryname varchar 100  √  null A secondary group for those items with more than one grouping possible.
procedureevents_mv secondaryordercategoryname varchar 100  √  null
cptevents sectionheader varchar 50  √  null High-level section of the Current Procedural Terminology code.
diagnoses_icd seq_num int4 10  √  null Priority of the code. Sequence 1 is the primary code.
microbiologyevents spec_itemid int4 10  √  null Foreign key. Identifies the specimen.
microbiologyevents spec_type_desc varchar 100  √  null Description of the specimen.
prescriptions startdate timestamp 22  √  null Date when the prescription started.
inputevents_mv starttime timestamp 22  √  null Time when the event started.
procedureevents_mv starttime timestamp 22  √  null
inputevents_mv statusdescription varchar 30  √  null The current status of the order: stopped, rewritten, running or cancelled.
procedureevents_mv statusdescription varchar 30  √  null
chartevents stopped varchar 50  √  null Text string indicating the stopped status of an event (i.e. stopped, not stopped).
chartevents_1 stopped varchar 50  √  null
chartevents_10 stopped varchar 50  √  null
chartevents_11 stopped varchar 50  √  null
chartevents_12 stopped varchar 50  √  null
chartevents_13 stopped varchar 50  √  null
chartevents_14 stopped varchar 50  √  null
chartevents_2 stopped varchar 50  √  null
chartevents_3 stopped varchar 50  √  null
chartevents_4 stopped varchar 50  √  null
chartevents_5 stopped varchar 50  √  null
chartevents_6 stopped varchar 50  √  null
chartevents_7 stopped varchar 50  √  null
chartevents_8 stopped varchar 50  √  null
chartevents_9 stopped varchar 50  √  null
datetimeevents stopped varchar 50  √  null Event was explicitly marked as stopped. Infrequently used by caregivers.
inputevents_cv stopped varchar 30  √  null Event was explicitly marked as stopped. Infrequently used by caregivers.
outputevents stopped varchar 30  √  null
chartevents storetime timestamp 22  √  null Time when the event was recorded in the system.
chartevents_1 storetime timestamp 22  √  null
chartevents_10 storetime timestamp 22  √  null
chartevents_11 storetime timestamp 22  √  null
chartevents_12 storetime timestamp 22  √  null
chartevents_13 storetime timestamp 22  √  null
chartevents_14 storetime timestamp 22  √  null
chartevents_2 storetime timestamp 22  √  null
chartevents_3 storetime timestamp 22  √  null
chartevents_4 storetime timestamp 22  √  null
chartevents_5 storetime timestamp 22  √  null
chartevents_6 storetime timestamp 22  √  null
chartevents_7 storetime timestamp 22  √  null
chartevents_8 storetime timestamp 22  √  null
chartevents_9 storetime timestamp 22  √  null
inputevents_cv storetime timestamp 22  √  null Time when the event was recorded in the system.
inputevents_mv storetime timestamp 22  √  null Time when the event was recorded in the system.
noteevents storetime timestamp 22  √  null
outputevents storetime timestamp 22  √  null
procedureevents_mv storetime timestamp 22  √  null
callout submit_careunit varchar 15  √  null If the ward where the call was submitted was an ICU, the ICU type is listed here.
callout submit_wardid int4 10  √  null Identifies the ward where the call out request was submitted.
cptevents subsectionheader varchar 255  √  null Subsection of the Current Procedural Terminology code.
noteevents text text 2147483647  √  null Content of the note.
cptevents ticket_id_seq int4 10  √  null Sequence number of the event, derived from the ticket ID.
inputevents_mv totalamount float8 17,17  √  null The total amount in the solution for the given item.
inputevents_mv totalamountuom varchar 50  √  null Unit of measurement for the total amount in the solution.
d_items unitname varchar 100  √  null Unit associated with the item.
chartevents value varchar 255  √  null Value of the event as a text string.
chartevents_1 value varchar 255  √  null
chartevents_10 value varchar 255  √  null
chartevents_11 value varchar 255  √  null
chartevents_12 value varchar 255  √  null
chartevents_13 value varchar 255  √  null
chartevents_14 value varchar 255  √  null
chartevents_2 value varchar 255  √  null
chartevents_3 value varchar 255  √  null
chartevents_4 value varchar 255  √  null
chartevents_5 value varchar 255  √  null
chartevents_6 value varchar 255  √  null
chartevents_7 value varchar 255  √  null
chartevents_8 value varchar 255  √  null
chartevents_9 value varchar 255  √  null
datetimeevents value timestamp 22  √  null Value of the event as a text string.
labevents value varchar 200  √  null Value of the event as a text string.
outputevents value float8 17,17  √  null
procedureevents_mv value float8 17,17  √  null
chartevents valuenum float8 17,17  √  null Value of the event as a number.
chartevents_1 valuenum float8 17,17  √  null
chartevents_10 valuenum float8 17,17  √  null
chartevents_11 valuenum float8 17,17  √  null
chartevents_12 valuenum float8 17,17  √  null
chartevents_13 valuenum float8 17,17  √  null
chartevents_14 valuenum float8 17,17  √  null
chartevents_2 valuenum float8 17,17  √  null
chartevents_3 valuenum float8 17,17  √  null
chartevents_4 valuenum float8 17,17  √  null
chartevents_5 valuenum float8 17,17  √  null
chartevents_6 valuenum float8 17,17  √  null
chartevents_7 valuenum float8 17,17  √  null
chartevents_8 valuenum float8 17,17  √  null
chartevents_9 valuenum float8 17,17  √  null
labevents valuenum float8 17,17  √  null Value of the event as a number.
chartevents valueuom varchar 50  √  null Unit of measurement.
chartevents_1 valueuom varchar 50  √  null
chartevents_10 valueuom varchar 50  √  null
chartevents_11 valueuom varchar 50  √  null
chartevents_12 valueuom varchar 50  √  null
chartevents_13 valueuom varchar 50  √  null
chartevents_14 valueuom varchar 50  √  null
chartevents_2 valueuom varchar 50  √  null
chartevents_3 valueuom varchar 50  √  null
chartevents_4 valueuom varchar 50  √  null
chartevents_5 valueuom varchar 50  √  null
chartevents_6 valueuom varchar 50  √  null
chartevents_7 valueuom varchar 50  √  null
chartevents_8 valueuom varchar 50  √  null
chartevents_9 valueuom varchar 50  √  null
labevents valueuom varchar 20  √  null Unit of measurement.
outputevents valueuom varchar 30  √  null
procedureevents_mv valueuom varchar 30  √  null
chartevents warning int4 10  √  null Flag to highlight that the value has triggered a warning.
chartevents_1 warning int4 10  √  null
chartevents_10 warning int4 10  √  null
chartevents_11 warning int4 10  √  null
chartevents_12 warning int4 10  √  null
chartevents_13 warning int4 10  √  null
chartevents_14 warning int4 10  √  null
chartevents_2 warning int4 10  √  null
chartevents_3 warning int4 10  √  null
chartevents_4 warning int4 10  √  null
chartevents_5 warning int4 10  √  null
chartevents_6 warning int4 10  √  null
chartevents_7 warning int4 10  √  null
chartevents_8 warning int4 10  √  null
chartevents_9 warning int4 10  √  null
datetimeevents warning int2 5  √  null Flag to highlight that the value has triggered a warning.
callout acknowledge_status varchar 20 The status of the response to the call out request.
admissions admission_location varchar 50 Admission location.
admissions admission_type varchar 50 Type of admission, for example emergency or elective.
admissions admittime timestamp 22 Time of admission to the hospital.
callout callout_outcome varchar 20 The result of the call out request; either a cancellation or a discharge.
callout callout_service varchar 10 Identifies the service that the patient is called out to.
callout callout_status varchar 20 Current status of the call out request.
d_cpt category int2 5 Code category.
d_labitems category varchar 100 Category of item, for example chemistry or hematology.
caregivers cgid int4 10 Unique caregiver identifier.
datetimeevents cgid int4 10 Foreign key. Identifies the caregiver.
datetimeevents charttime timestamp 22 Time when the event occured.
cptevents costcenter varchar 10 Center recording the code, for example the ICU or the respiratory unit.
cptevents cpt_cd varchar 10 Current Procedural Terminology code.
callout createtime timestamp 22 Time at which the call out request was created.
icustays dbsource varchar 20 Source database of the item.
admissions discharge_location varchar 50 Discharge location
admissions dischtime timestamp 22 Time of discharge from the hospital.
patients dob timestamp 22 Date of birth.
drgcodes drg_code varchar 20 Diagnosis-Related Group code
drgcodes drg_type varchar 20 Type of Diagnosis-Related Group, for example APR is All Patient Refined
prescriptions drug varchar 100 Name of the drug.
prescriptions drug_type varchar 100 Type of drug.
admissions ethnicity varchar 200 Ethnicity.
patients expire_flag int4 10 Flag indicating that the patient has died.
icustays first_careunit varchar 20 First careunit associated with the ICU stay.
icustays first_wardid int2 5 Identifier for the first ward the patient was located in.
d_labitems fluid varchar 100 Fluid associated with the item, for example blood or urine.
patients gender varchar 5 Gender.
admissions hadm_id int4 10 Primary key. Identifies the hospital stay.
callout hadm_id int4 10 Foreign key. Identifies the hospital stay.
cptevents hadm_id int4 10 Foreign key. Identifies the hospital stay.
diagnoses_icd hadm_id int4 10 Foreign key. Identifies the hospital stay.
drgcodes hadm_id int4 10 Foreign key. Identifies the hospital stay.
icustays hadm_id int4 10 Foreign key. Identifies the hospital stay.
prescriptions hadm_id int4 10 Foreign key. Identifies the hospital stay.
procedureevents_mv hadm_id int4 10
procedures_icd hadm_id int4 10 Foreign key. Identifies the hospital stay.
services hadm_id int4 10 Foreign key. Identifies the hospital stay.
transfers hadm_id int4 10 Foreign key. Identifies the hospital stay.
admissions has_chartevents_data int2 5 Hospital admission has at least one observation in the CHARTEVENTS table.
d_icd_diagnoses icd9_code varchar 10 ICD9 code - note that this is a fixed length character field, as whitespaces are important in uniquely identifying ICD-9 codes.
d_icd_procedures icd9_code varchar 10 ICD9 code - note that this is a fixed length character field, as whitespaces are important in uniquely identifying ICD-9 codes.
procedures_icd icd9_code varchar 10 ICD9 code associated with the procedure.
icustays icustay_id int4 10 Primary key. Identifies the ICU stay.
admissions insurance varchar 255 Insurance type.
icustays intime timestamp 22 Time of admission to the ICU.
d_items itemid int4 10 Primary key. Identifies the charted item.
d_labitems itemid int4 10 Foreign key. Identifies the charted item.
datetimeevents itemid int4 10 Foreign key. Identifies the charted item.
labevents itemid int4 10 Foreign key. Identifies the charted item.
d_labitems label varchar 100 Label identifying the item.
icustays last_careunit varchar 20 Last careunit associated with the ICU stay.
icustays last_wardid int2 5 Identifier for the last ward the patient is located in.
d_icd_diagnoses long_title varchar 255 Long title associated with the code.
d_icd_procedures long_title varchar 255 Long title associated with the code.
d_cpt maxcodeinsubsection int4 10 Maximum code within the subsection.
d_cpt mincodeinsubsection int4 10 Minimum code within the subsection.
callout outcometime timestamp 22 Time at which the outcome (cancelled or discharged) occurred.
callout request_cdiff int2 5 Indicates if special precautions are required.
callout request_mrsa int2 5 Indicates if special precautions are required.
callout request_resp int2 5 Indicates if special precautions are required.
callout request_tele int2 5 Indicates if special precautions are required.
callout request_vre int2 5 Indicates if special precautions are required.
admissions row_id int4 10 Unique row identifier.
callout row_id int4 10 Unique row identifier.
caregivers row_id int4 10 Unique row identifier.
chartevents row_id int4 10 Unique row identifier.
chartevents_1 row_id int4 10
chartevents_10 row_id int4 10
chartevents_11 row_id int4 10
chartevents_12 row_id int4 10
chartevents_13 row_id int4 10
chartevents_14 row_id int4 10
chartevents_2 row_id int4 10
chartevents_3 row_id int4 10
chartevents_4 row_id int4 10
chartevents_5 row_id int4 10
chartevents_6 row_id int4 10
chartevents_7 row_id int4 10
chartevents_8 row_id int4 10
chartevents_9 row_id int4 10
cptevents row_id int4 10 Unique row identifier.
d_cpt row_id int4 10 Unique row identifier.
d_icd_diagnoses row_id int4 10 Unique row identifier.
d_icd_procedures row_id int4 10 Unique row identifier.
d_items row_id int4 10 Unique row identifier.
d_labitems row_id int4 10 Unique row identifier.
datetimeevents row_id int4 10 Unique row identifier.
diagnoses_icd row_id int4 10 Unique row identifier.
drgcodes row_id int4 10 Unique row identifier.
icustays row_id int4 10 Unique row identifier.
inputevents_cv row_id int4 10 Unique row identifier.
inputevents_mv row_id int4 10 Unique row identifier.
labevents row_id int4 10 Unique row identifier.
microbiologyevents row_id int4 10 Unique row identifier.
noteevents row_id int4 10 Unique row identifier.
outputevents row_id int4 10
patients row_id int4 10 Unique row identifier.
prescriptions row_id int4 10 Unique row identifier.
procedureevents_mv row_id int4 10
procedures_icd row_id int4 10 Unique row identifier.
services row_id int4 10 Unique row identifier.
transfers row_id int4 10 Unique row identifier.
d_cpt sectionheader varchar 50 Section header.
d_cpt sectionrange varchar 100 Range of codes within the high-level section.
procedures_icd seq_num int4 10 Lower procedure numbers occurred earlier.
d_icd_diagnoses short_title varchar 50 Short title associated with the code.
d_icd_procedures short_title varchar 50 Short title associated with the code.
datetimeevents storetime timestamp 22 Time when the event was recorded in the system.
admissions subject_id int4 10 Foreign key. Identifies the patient.
callout subject_id int4 10 Foreign key. Identifies the patient.
chartevents subject_id int4 10 Foreign key. Identifies the patient.
chartevents_1 subject_id int4 10
chartevents_10 subject_id int4 10
chartevents_11 subject_id int4 10
chartevents_12 subject_id int4 10
chartevents_13 subject_id int4 10
chartevents_14 subject_id int4 10
chartevents_2 subject_id int4 10
chartevents_3 subject_id int4 10
chartevents_4 subject_id int4 10
chartevents_5 subject_id int4 10
chartevents_6 subject_id int4 10
chartevents_7 subject_id int4 10
chartevents_8 subject_id int4 10
chartevents_9 subject_id int4 10
cptevents subject_id int4 10 Foreign key. Identifies the patient.
datetimeevents subject_id int4 10 Foreign key. Identifies the patient.
diagnoses_icd subject_id int4 10 Foreign key. Identifies the patient.
drgcodes subject_id int4 10 Foreign key. Identifies the patient.
icustays subject_id int4 10 Foreign key. Identifies the patient.
inputevents_cv subject_id int4 10 Foreign key. Identifies the patient.
inputevents_mv subject_id int4 10 Foreign key. Identifies the patient.
labevents subject_id int4 10 Foreign key. Identifies the patient.
microbiologyevents subject_id int4 10 Foreign key. Identifies the patient.
noteevents subject_id int4 10 Foreign key. Identifies the patient.
outputevents subject_id int4 10
patients subject_id int4 10 Primary key. Identifies the patient.
prescriptions subject_id int4 10 Foreign key. Identifies the patient.
procedureevents_mv subject_id int4 10
procedures_icd subject_id int4 10 Foreign key. Identifies the patient.
services subject_id int4 10 Foreign key. Identifies the patient.
transfers subject_id int4 10 Foreign key. Identifies the patient.
d_cpt subsectionheader varchar 255 Subsection header.
d_cpt subsectionrange varchar 100 Range of codes within the subsection.
services transfertime timestamp 22 Time when the transfer occured.
callout updatetime timestamp 22 Last time at which the call out request was updated.
datetimeevents valueuom varchar 50 Unit of measurement.