Diagnose

Sepsis (nhiễm trùng huyết)

table mimiciv_hosp.d_icd_diagnoses và mimiciv_hosp.diagnoses_icd

icd_code	icd_version	long_title
5712	9	Alcoholic cirrhosis of liver
5715	9	Cirrhosis of liver without mention of alcohol
5716	9	Biliary cirrhosis
K703	10	Alcoholic cirrhosis of liver
K717	10	Toxic liver disease with fibrosis and cirrhosis of liver
K743	10	Primary biliary cirrhosis
K744	10	Secondary biliary cirrhosis
K745	10	Biliary cirrhosis, unspecified
K746	10	Other and unspecified cirrhosis of liver

Truy vấn

SELECT * FROM mimiciv_hosp.d_icd_diagnoses WHERE icd_code IN('5712', '5715', '5716', 'K703', 'K717', 'K743', 'K744', 'K745', 'K746');

Continuous Renal Replacement Therapy (thay thế thận)

itemid	label	linksto
230177	CRRT - Filter Type	chartevents
227290	CRRT mode	chartevents
225956	Reason for CRRT Filter Change	chartevents

SELECT * FROM mimiciv_icu.d_items WHERE itemid IN(227290, 230177, 225956);

icd_code	icd_version	long_title
5851	9	Chronic kidney disease, Stage I
5852	9	Chronic kidney disease, Stage II (mild)
5853	9	Chronic kidney disease, Stage III (moderate)
5854	9	Chronic kidney disease, Stage IV (severe)
5855	9	Chronic kidney disease, Stage V
5856	9	End stage renal disease
5859	9	Chronic kidney disease, unspecified
N18	10	Chronic kidney disease (CKD)
N181	10	Chronic kidney disease, stage 1
N182	10	Chronic kidney disease, stage 2 (mild)
N183	10	Chronic kidney disease, stage 3 (moderate)
N1830	10	Chronic kidney disease, stage 3 unspecified
N1831	10	Chronic kidney disease, stage 3a
N1832	10	Chronic kidney disease, stage 3b
N184	10	Chronic kidney disease, stage 4 (severe)
N185	10	Chronic kidney disease, stage 5
N186	10	End stage renal disease
N189	10	Chronic kidney disease, unspecified

SELECT DISTINCT subject_id, hadm_id FROM  mimiciv_hosp.diagnoses_icd
	WHERE icd_code LIKE '585%' OR icd_code LIKE 'N18%';

icd_code	icd_version	long_title
5845	9	Acute kidney failure with lesion of tubular necrosis
5846	9	Acute kidney failure with lesion of renal cortical necrosis
5847	9	Acute kidney failure with lesion of renal medullary [papillary] necrosis
5848	9	Acute kidney failure with other specified pathological lesion in kidney
5849	9	Acute kidney failure, unspecified
N17	10	Acute kidney failure
N170	10	Acute kidney failure with tubular necrosis
N171	10	Acute kidney failure with acute cortical necrosis
N172	10	Acute kidney failure with medullary necrosis
N178	10	Other acute kidney failure
N179	10	Acute kidney failure, unspecified

SELECT * FROM mimiciv_hosp.d_icd_diagnoses WHERE icd_code LIKE '584%' OR icd_code LIKE 'N17%';

icd_code	icd_version	long_title
5110	9	Endoscopic retrograde cholangiopancreatography [ERCP]
5213	9	Endoscopic retrograde pancreatography [ERP]

SELECT * FROM mimiciv_hosp.d_icd_procedures WHERE icd_code IN ('9670','9671','9672', '5A1935Z', '5A1945Z', '5A1955Z');

icd_code	icd_version	long_title
9670	9	Continuous invasive mechanical ventilation of unspecified duration
9671	9	Continuous invasive mechanical ventilation for less than 96 consecutive hours
9672	9	Continuous invasive mechanical ventilation for 96 consecutive hours or more
5A1935Z	10	Respiratory Ventilation, Less than 24 Consecutive Hours
5A1945Z	10	Respiratory Ventilation, 24-96 Consecutive Hours
5A1955Z	10	Respiratory Ventilation, Greater than 96 Consecutive Hours

SELECT * FROM mimiciv_icu.d_items WHERE itemid = 222315;

itemid	label	abbreviation	linksto
222315	Vasopressin	Vasopressin	inputevents

itemid	label	fluid	category
50889	C-Reactive Protein	Blood	Chemistry
51652	High-Sensitivity CRP	Blood	Chemistry

SELECT * FROM mimiciv_hosp.d_labitems WHERE itemid IN(50889, 51652);