- Identify adult sepsis events using the CDC Adult Sepsis Event Toolkit criteria using the Common Longitudinal Intensive Format (CLIF) 2.0 data structure.
- Determine the effect of including lactate in the definition on sepsis prevalence and mortality rates
Please refer to the online CLIF data dictionary, ETL tools, and specific table contacts for more information on constructing the required tables and fields. List all required tables for the project here, and provide a brief rationale for why they are required.
patienthospitalizationADT
microbiology_culturefor blood culture collection- only blood culture collection data necessary, e.g.
fluid_category = "Blood/Buffy Coat",collect_dttm, andcomponent_category == "culture"required
- only blood culture collection data necessary, e.g.
medication_admin_intermittentfor qualifying antibiotic days- only
med_group == "qualifying_CMS_antibioticsrequired (list ofmed_categoriesbelow) med_route_nameandmed_route_categoryalso required
- only
labslab_category %in% c("lactate", "creatinine", "bilirubin_total", "platelet_count")
vitalsmedication_admin_continuousmed_category %in% c("norepinephrine", "epinephrine", "phenylephrine", "vasopressin", "dopamine", "angiotensin")
respiratory_support- only
hospitalization_id,recorded_dttm, anddevice_category == "IMV"required
- only
Adults admitted to inpatient status (location_category %in% c("Ward", "ICU") from 1/1/2020 to 12/31/2021
start_date <- "2020-01-01"
end_date <- "2021-12-31"under construction
1. Run code
Please deposit your entire result_[SITE_NAME] folder in this box folder
