labevents

Hospital level table

labevents

The labevents table stores the results of all laboratory measurements made for a single patient. These include hematology measurements, blood gases, chemistry panels, and less common tests such as genetic assays.

  • d_labitems on itemid

Table columns

Name Postgres data type
subject_id INTEGER NOT NULL
hadm_id INTEGER
stay_id INTEGER
spec_id INTEGER NOT NULL
itemid INTEGER NOT NULL
charttime TIMESTAMP NOT NULL
storetime TIMESTAMP
value VARCHAR(200)
valuenum DOUBLE PRECISION
valueuom VARCHAR(20)
ref_range_lower DOUBLE PRECISION
ref_range_upper DOUBLE PRECISION
flag VARCHAR(10)
priority VARCHAR(7)

subject_id

subject_id is a unique identifier which specifies an individual patient. Any rows associated with a single subject_id pertain to the same individual.

hadm_id

hadm_id is an integer identifier which is unique for each patient hospitalization.


Last modified August 14, 2020: update website to use docsy (adc506c)