Table 1.

An overview of the data tables in the PIC database.

Table name	Description	Rows
ADMISSIONS	Every unique hospitalization for each patient in the database (defines HADM_ID)	13,449
CHARTEVENTS	All charted observations for the patients from the hospital database, not including bedside monitor trends and lab events.	2,278,978
D_ICD_DIAGNOSES	Dictionary of International Statistical Classification of Diseases and Related Health Problems (ICD-10) codes and International Classification of Diseases for Oncology (ICD-O-3) relating to diagnoses.	25,378
D_ITEMS	Dictionary of local codes (’ITEMIDs’) appearing in the PIC database, except those that relate to laboratory tests.	466
D_LABITEMS	Dictionary of local codes (’ITEMIDs’) appearing in the PIC database that relate to laboratory tests.	832
DIAGNOSES_ICD	Hospital assigned diagnoses, coded using the ICD-10 Chinese code and the ICD-O-3 Chinese code.	13,365
EMR_SYMPTOMS	Structured symptoms extracted from notes, including nursing and physician notes, discharge summaries and so on.	402,142
ICUSTAYS	Every unique ICU stay in the database (defines ICUSTAY_ID).	13,941
INPUTEVENTS	Calculated fluid input data every morning for each patient in ICU.	26,884
LABEVENTS	Laboratory measurements for patients from the hospital database.	10,094,117
MICROBIOLOGYEVENTS	Microbiology culture results and antibiotic sensitivities from the hospital database.	183,869
OR_EXAM_REPORTS	Contains all exams performed during the patient’s stay.	183,809
OUTPUTEVENTS	Output information for patients from the hospital database.	39,891
PATIENTS	Every unique patient in the database (defines SUBJECT_ID).	12,881
PRESCRIPTIONS	Medications ordered for a given patient	1,256,591
SURGERY_VITAL_SIGNS	Vital signs recorded every 5 minutes during the surgery	1,216,011