Table MIMIC-IV

Table patients

mimiciv_hosp.patients (364.627 rows)

column_name	data_type	Constraints
subject_id	integer	primary key
gender	character
anchor_age	smallint
anchor_year	smallint
anchor_year_group	character varying
dod	date	null

Table admissions

mimiciv_hosp.admissions (546.028 rows)

column_name	data_type	Constraints
subject_id	integer
hadm_id	integer	primary key
admittime	timestamp without time zone
dischtime	timestamp without time zone
deathtime	timestamp without time zone
admission_type	character varying
admit_provider_id	character varying
admission_location	character varying
discharge_location	character varying
insurance	character varying
language	character varying
marital_status	character varying
race	character varying
edregtime	timestamp without time zone
edouttime	timestamp without time zone
hospital_expire_flag	smallint

Table icustays

mimiciv_icu.icustays (94.458 rows)

column_name	data_type	Constraints
subject_id	integer
hadm_id	integer
stay_id	integer	primary key
first_careunit	character varying
last_careunit	character varying
intime	timestamp without time zone
outtime	timestamp without time zone	null
los	double precision	null

Table d_icd_diagnoses

mimiciv_hosp.d_icd_diagnoses (112.107 rows)

column_name	data_type	Constraints
icd_code	character	primary key
icd_version	smallint
long_title	varying

Table diagnoses_icd

mimiciv_hosp.diagnoses_icd (6.364.488 rows)

column_name	data_type	Constraints
subject_id	integer
hadm_id	integer
seq_num	integer
icd_code	character
icd_version	smallint

Table d_items

mimiciv_icu.d_items (4.095)

column_name	data_type	Constraints
itemid	integer	primary key
label	character varying
abbreviation	character varying
linksto	character varying
category	character varying
unitname	character varying
param_type	character varying
lownormalvalue	double precision
highnormalvalue	double precision

SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'd_items' AND table_schema = 'mimiciv_icu';

Table chartevents

mimiciv_icu.chartevents (432.997.491)

column_name	data_type	Constraints
subject_id	integer
hadm_id	integer
stay_id	integer
caregiver_id	integer
charttime	timestamp without time zone
storetime	timestamp without time zone
itemid	integer
value	character varying
valuenum	double precision
valueuom	character varying
warning	smallint

SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'chartevents' AND table_schema = 'mimiciv_icu';

Table d_labitems

mimiciv_hosp.d_labitems; (1.650)

column_name	data_type	Constraints
itemid	integer	Primary key
label	character varying
fluid	character varying
category	character varying

Table labevents

mimiciv_hosp.labevents (158.374.764 rows)

column_name	data_type	Constraints
labevent_id	integer	Primary key
subject_id	integer
hadm_id	integer
specimen_id	integer
itemid	integer
order_provider_id	character varying
charttime	timestamp without time zone
storetime	timestamp without time zone
value	character varying
valuenum	double precision
valueuom	character varying
ref_range_lower	double precision
ref_range_upper	double precision
flag	character varying
priority	character varying
comments	text

SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'labevents' AND table_schema = 'mimiciv_hosp';