Data Received

• This is the Master CV List

https://docs.google.com/spreadsheets/d/1IFe4XYoQbIMyEeUmQ0Z32sOP0R86GDVd/edit?usp=sharing&ouid=103771572352531710727&rtpof=true&sd=true

CV_ID	NEW_CV_ID	ACTION	FINAL_CV_ID	HIGH_FREQ	FILENAME	CV_NAME_FRIENDLY	CV_NAME_CLEANED	NOTES	LOWER	UPPER
1	1				Albumin_Level_1_060824.csv	Albumin	albumin
2	2				AST_2_061124.csv	AST	AST		10	3000
3	3A	Drop			Base_Excess_Arterial_OR_3_061324.csv	Base Excess Arterial (OR)	base_excess_art
3	3B	Keep	3		Base_Excess_ISTAT_3_061324.csv	Base Excess (iSTAT)	base_excess_istat
5	5			Y	Best_Motor_Response_5_060821.csv	Best Motor Response	best_motor_response
6	6			Y	Best_Verbal_Response_6_060824.csv	Best Verbal Response	best_verbal_response
7	7	Keep	7	Y	Spo2_Pulse_Oximetry_7_073024.csv	Pulse Oximetry	pulse_oximetry		50	100
8	8	Drop			Temperature_Skin_8_060824.csv	Temperature (Skin)	temperature_skin
9	9				Bun_9_060824.csv	BUN	BUN
10	10				Calcium_Level_10_060824.csv	Calcium	calcium		6	14
12	12				CO2_12_061124.csv	CO2	CO2
13	13				Creatinine_Level_13_060824.csv	Creatinine	creatinine			10
14	14				GFR_14_061124.csv	GFR	GFR
18	18				Eye_Opening_Response_18_060824.csv	Eye Opening Response	eye_opening_response
20	20			Y	GCS_Glasgow_Coma_Score_20_060824.csv	GCS	GCS
21	21				Glucose_Level_21_060824.csv	Glucose	glucose
22	22A	Keep	22		HCO3_ISTAT_22_061324.csv	HCO3 (iSTAT)	HCO3
22	22B	Drop			HCO3_VENOUS_OR_22_061324.csv	HCO3 Venous (OR)	HCO3_ven
23	23			Y	Heart_Rate_Monitor_23_060824.csv	Heart Rate	heart_rate		15	200
24	24				Hematocrit_24_060824.csv	Hematocrit	hematocrit
26	26				Hemoglobin_Concentration_26_060824.csv	Hemoglobin	hemoglobin
27	27				TroponinHS_27_061124.csv	Troponin HS	troponin_HS	- high-sensitivity troponin	0	30000
28	28				INR_28_060824.csv	INR	INR		0	10
29	29A	Drop			LACTATE_WB_ISTAT_29_061324.csv	Lactate WB (iSTAT)	lactate_WB_istat
29	29B	Drop			LACTATE_WB_OR_29_061324.csv	Lactate WB (OR)	lactate_WB_OR
29	29C	Keep	29		Lactate_Level_29_061124.csv	Lactate	lactate
31	31A	Keep	31A	Y	Mean_Arterial_Pressure_Cuff_31_061424.csv	Mean Arterial Pressure (Cuff)	MAP_cuff
31	31B	Keep	31B		Mean_Arterial_Pressure_Invasive_31_061424.csv	Mean Arterial Pressue (Invasive)	MAP_invasive
33	33A	Keep	33		PCO2_Art_Istat_33_073024.csv	PCO2 Arterial (iSTAT)	PCO2_art
33	33B	Drop			PCO2_VEN_ISTAT_33_061124.csv	PCO2 Venous (iSTAT)	PCO2_ven
34	34A	Drop			PH_ARTERIAL_34_061324.csv	pH Arterial	pH_art	- pH level of venous blood
34	34B	Keep	34		PH_ARTERIAL_ISTAT_34_061324.csv	pH Arterial (iSTAT)	pH_art_istat
34	34C	Drop			PH_ART_OR_34_061324.csv	pH Arterial (OR)	pH_art_OR
34	34D	Drop			PH_VENOUS_ISTAT_34_061324.csv	pH Venous (iSTAT)	pH_ven_istat
34	34E	Drop			PH_VENOUS_OR_34_061324.csv	pH Venous (OR)	pH_ven_OR
35	35				Platelet_35_060824.csv	Platelet	platelet
36	36				Potassium_Level_36_060824.csv	Potassium	potassium
37	37A	Drop			PO2_ARTERIAL_37_061324.csv	PO2 Arterial	PO2_art	- Partial pressure of oxygen (amount of oxygen gas dissolved in the blood)
37	37B	Keep	37		PO2_ART_ISTAT_37_061324.csv	PO2 Arterial (iSTAT)	PO2_art_istat
37	37C	Drop			PO2_ART_OR_37_061324.csv	PO2 Arterial (OR)	PO2_art_OR
37	37D	Drop			PO2_VEN_ISTAT_37_061324.csv	PO2 Venous (iSTAT)	PO2_ven_istat
37	37E	Drop			PO2_VEN_OR_061324.csv	PO2 Venous (OR)	PO2_ven_OR
38	38				Prothrombin_Time_38_061324.csv	Prothrombin Time	prothrombin_time	- How long it takes the blood to clot
39	39			Y	Respiratory_Rate_39_060824.csv	Respiratory Rate	respiratory_rate
40	40				Sodium_Level_40_060824.csv	Sodium	sodium
41	41			Y	Systolic_Blood_Pressure_41_060824.csv	Systolic Blood Pressure	systolic_blood_pressure
48	48				Bilirubin_Total_48_061124.csv	Bilirubin	bilirubin	- total bilirubin level in the blood
49	49				White_Blood_Cell_Count_49_060824.csv	White Blood Cell Count	white_blood_cell_count
50	50				TC02_ART_ISTAT_50_073024.csv	TCO2 Arterial	TCO2_art	- total carbon dioxide?
51	51	Keep	7		O2SAT%_ART_CAL_ISTAT_51_073024.csv	O2 Saturation %	O2_sat	- O2 saturation percentage	50	100
52	52				FIO2_ISTAT_52_073024.csv	FiO2	FiO2	- fraction of inspired oxygen, measures the percentage of oxygen a patient is inhaling
53	53	Keep	53		TEMPERATURE_ALLILLARY_53_073024.csv	Temperature (Axillary)	temperature_axillary
54	54	Keep	54	Y	TEMPERATURE_ORAL_54_073024.csv	Temperature (Oral)	temperature_oral
55	55	Keep	55		TEMPERATURE_BLADDER_55_073024.csv	Temperature (Bladder)	temperature_bladder