About this Dataset

California Inpatient Severe Sepsis

The datasets include severe sepsis information on 1) the number of severe sepsis cases, percent of hospital-acquired and non-hospital-acquired severe sepsis cases, and the percent of in-hospital severe sepsis deaths; 2) the average length of stay for severe sepsis hospitalizations, the respective median charge per day, and the expected payer for severe sepsis hospitalizations; 3) the severe sepsis patients who were alive at discharge and died within 30 days of discharge; and 4) the hospital-acquired severe sepsis in different type of hospitals (hospital size, location, teaching, and ownership). ICD-9-CM codes were used for data before October 1, 2015, and ICD-10-CM codes were used for data on or after October 1, 2015.
Organization: State of California
Last updated: 2025-07-23T16:19:18.947329
Tags: death, deaths, department-of-health-care-access-and-information, disposition, healtcare, hospital-acquired, hospitalizations, infections, length-of-stay, location, median-charges, payers, sepsis, severe-sepsis

Tables

Severe Sepsis

@usgov.ca_gov_california_inpatient_severe_sepsis_47c85.severe_sepsis

36.32 kB
14 rows
42 columns

CREATE TABLE severe_sepsis (
  "year" BIGINT,
  "numberofseveresepsis" BIGINT,
  "hospitaldeath" BIGINT,
  "numsvrspsswohspdth" BIGINT,
  "pctofinhspdth" DOUBLE,
  "numberofhospacquired" BIGINT,
  "numberofnonhospacquired" BIGINT,
  "pctofhospacquired" DOUBLE,
  "pctofnonhospacquired" DOUBLE,
  "numberofmedicare" BIGINT,
  "numberofmedicaid" BIGINT,
  "numberofprivatecoverage" BIGINT,
  "numberofselfpay" BIGINT,
  "numberofotherpayer" BIGINT,
  "pctofmedicare" DOUBLE,
  "pctofmedicaid" DOUBLE,
  "pctofprivatecoverage" DOUBLE,
  "pctofselfpay" DOUBLE,
  "pctofotherpayer" DOUBLE,
  "meanlos" DOUBLE,
  "medianchrgday" BIGINT,
  "n__of_acute_care" DOUBLE  -- % Of Acute Care,
  "n__of_home_health_service" DOUBLE  -- % Of Home Health Service,
  "n__of_other_care" DOUBLE  -- % Of Other Care,
  "n__of_residential_care" DOUBLE  -- % Of Residential Care,
  "n__of_home_routine" DOUBLE  -- % Of Home (Routine),
  "n__of_skilled_nursing_intermediat" DOUBLE  -- % Of Skilled Nursing/Intermediat,
  "n__of_hospice_care" DOUBLE  -- % Of Hospice Care,
  "n__of_hospital_acquired_severe_se" DOUBLE  -- % Of Hospital-Acquired Severe Se,
  "n__of_non_hospital_acquired_sever" DOUBLE  -- % Of Non-Hospital-Acquired Sever,
  "rate_in_teaching_hospital" DOUBLE,
  "rate_in_non_teaching_hospital" DOUBLE,
  "rate_in_urban_hospital" DOUBLE,
  "rate_in_rural_hospital" DOUBLE,
  "rate_in_hospital_with_1_99_beds" DOUBLE,
  "rate_in_hospital_with_100_199_be" DOUBLE,
  "rate_in_hospital_with_200_299_be" DOUBLE,
  "rate_in_hospital_with_300_399_be" DOUBLE,
  "rate_in_hospital_with_400_or_mor" DOUBLE,
  "rate_in_nonprofit_hospital" DOUBLE,
  "rate_in_investor_owned_hospital" DOUBLE,
  "rate_in_governmental_hospital" DOUBLE
);