About this Dataset

Surgical Site Infections (SSIs) For Operative Procedures In California Hospitals

These datasets show surgical site infections (SSIs) reported by California hospitals to the California Department of Public Health (CDPH), Healthcare-Associated Infections (HAI) Program, via the Centers for Disease Control and Prevention National Healthcare Safety Network (NHSN), in accordance with Health and Safety Code (HSC) section 1288.55. California hospitals track and report deep incisional and organ/space SSIs for adults and pediatric (<18 years of age) patients for 28 types of operative procedures: abdominal aortic aneurysm repair; abdominal hysterectomy; appendix surgery; bile duct, liver or pancreatic surgery, cardiac surgery; Cesarean section; colon surgery; coronary artery bypass graft with both chest and donor site incisions; coronary artery bypass graft with chest incision only*; exploratory abdominal surgery (laparotomy); gallbladder surgery; gastric surgery; heart transplant; hip prosthesis; kidney surgery; kidney transplant; knee prosthesis; laminectomy; liver transplant; open reduction of fracture; ovarian surgery; pacemaker surgery; rectal surgery; small bowel surgery; spinal fusion; spleen surgery; thoracic surgery; vaginal hysterectomy The SSI data tables include information on the statewide and hospital-specific SSI incidence by operative procedure types, displaying procedure counts, number of infections observed (reported) and predicted. NHSN calculates the number of predicted infections using procedure-specific risk adjustment logistic regression models based on 2015 national baseline data and that accounts for particular patient-level factors and hospital characteristics found to be significant predictors of SSI incidence. Detailed information about the variables included in each dataset are described in the accompanying data dictionaries for the year of interest. For more information about NHSN’s statistical models, please review the “NHSN Guide to the SIR” at https://www.cdc.gov/nhsn/ps-analysis-resources/index.html To link the CDPH facility IDs with those from other Departments, like HCAI, please refer to the "Licensed Facility Cross-Walk" Open Data table at https://data.chhs.ca.gov/dataset/licensed-facility-crosswalk For more information about HAIs in California hospitals, please visit: https://www.cdph.ca.gov/Programs/CHCQ/HAI/Pages/AnnualHAIReports.aspx
Organization: State of California
Last updated: 2024-11-26T22:34:50.884908
Tags: abdominal, aortic-aneurysm, appendicitis, arthroplasty, artificial, bile-ducts-and-extrahepatic, bone, california-department-of-public-health, cardiac-surgery, cesarean, cholecystectomy, colectomy, colorectal-surgery, community-hospitals, coronary-artery-bypass, coronary-bypass-graft, digestive-system-surgical-procedures, fractures, gallbladder, gastrectomy, hai, healthcare, heart-transplant, hip-prothesis, hip-replacement, hospitals, hysterectomy, hysterectomy-abdominal, hysterectomy-vaginal, hysteroscopy, internal-mammary-coronary-artery-anastomosis, kidney, kidney-transplantation, knee-prothesis, laminectomy, laparotomy, liver-transplantation, nosocomial-infections, open-reduction-of-fracture, operative-procedures, ovarian, ovarian-surgery, ovary, pacemaker, pancreatic, rectal-neoplasms, rectal-surgery, small-bowel-surgery, spinal-fusion, spine, splenectomy, ssi, surgical, surgical-procedure, surgical-site-infections, surveillance, thoracic-surgery

Tables

Hospitals Who Did Not Report Surgical Procedures, 2016

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.hospitals_who_did_not_report_surgical_procedures_2016

7.42 KB
38 rows
7 columns


CREATE TABLE hospitals_who_did_not_report_surgical_procedures_2016 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "county" VARCHAR,
  "facility_id" BIGINT,
  "facility_name" VARCHAR,
  "notes" VARCHAR
);

Hospitals Who Did Not Report Surgical Procedures, 2017

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.hospitals_who_did_not_report_surgical_procedures_2017

7.89 KB
57 rows
7 columns


CREATE TABLE hospitals_who_did_not_report_surgical_procedures_2017 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "county" VARCHAR,
  "facility_id" BIGINT,
  "facility_name" VARCHAR,
  "notes" VARCHAR
);

Hospitals Who Did Not Report Surgical Procedures, 2018

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.hospitals_who_did_not_report_surgical_procedures_2018

7.84 KB
56 rows
7 columns


CREATE TABLE hospitals_who_did_not_report_surgical_procedures_2018 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "county" VARCHAR,
  "facility_id" BIGINT,
  "facility_name" VARCHAR,
  "notes" VARCHAR
);

Hospitals Who Did Not Report Surgical Procedures, 2019

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.hospitals_who_did_not_report_surgical_procedures_2019

9.23 KB
55 rows
9 columns


CREATE TABLE hospitals_who_did_not_report_surgical_procedures_2019 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" BIGINT,
  "facility_name" VARCHAR,
  "facility_type" VARCHAR,
  "number_months_expected" BIGINT,
  "notes" VARCHAR
);

Hospitals Who Did Not Report Surgical Procedures, 2022

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.hospitals_who_did_not_report_surgical_procedures_2022

9.53 KB
64 rows
9 columns


CREATE TABLE hospitals_who_did_not_report_surgical_procedures_2022 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" BIGINT,
  "facility_name" VARCHAR,
  "facility_type" VARCHAR,
  "number_months_expected" BIGINT,
  "notes" VARCHAR
);

Hospitals Who Did Not Report Surgical Procedures, January 1 – December 31, 2021

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.hospitals_who_did_not_report_surgical_procedures_janua_6ea16e55

9.33 KB
58 rows
9 columns


CREATE TABLE hospitals_who_did_not_report_surgical_procedures_janua_6ea16e55 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" BIGINT,
  "facility_name" VARCHAR,
  "facility_type" VARCHAR,
  "number_months_expected" BIGINT,
  "notes" VARCHAR
);

Hospitals Who Did Not Report Surgical Procedures, January 1 – December 31, 2023

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.hospitals_who_did_not_report_surgical_procedures_janua_b88d8ac1

9.69 KB
73 rows
9 columns


CREATE TABLE hospitals_who_did_not_report_surgical_procedures_janua_b88d8ac1 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" BIGINT,
  "facility_name" VARCHAR,
  "facility_type" VARCHAR,
  "number_months_expected" BIGINT,
  "notes" VARCHAR
);

Hospitals Who Did Not Report Surgical Procedures, January 1 – June 30, 2020 (Updated Annually)

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.hospitals_who_did_not_report_surgical_procedures_janua_e22ba22e

13.16 KB
66 rows
16 columns


CREATE TABLE hospitals_who_did_not_report_surgical_procedures_janua_e22ba22e (
  "year" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" BIGINT,
  "facility_name" VARCHAR,
  "facility_type" VARCHAR,
  "notes" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR
);

Hospitals Who Did Not Report Surgical Procedures, July 1 – December 31, 2020 (Updated Annually)

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.hospitals_who_did_not_report_surgical_procedures_july__aaf712cf

8.71 KB
62 rows
8 columns


CREATE TABLE hospitals_who_did_not_report_surgical_procedures_july__aaf712cf (
  "year" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" BIGINT,
  "facility_name" VARCHAR,
  "facility_type" VARCHAR,
  "notes" VARCHAR
);

SSI In Adult Patients, 2016

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_adult_patients_2016

93.72 KB
6459 rows
16 columns


CREATE TABLE ssi_in_adult_patients_2016 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "county" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "operative_procedure" VARCHAR,
  "procedure_count" BIGINT,
  "predicted_infection_count" DOUBLE,
  "infection_count" BIGINT,
  "sir" VARCHAR,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "sir_2015" VARCHAR,
  "notes" VARCHAR
);

SSI In Adult Patients, 2017

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_adult_patients_2017

109.43 KB
6841 rows
19 columns


CREATE TABLE ssi_in_adult_patients_2017 (
  "year" DOUBLE,
  "state" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "hospital_type" VARCHAR,
  "county" VARCHAR,
  "procedure_count" DOUBLE,
  "infection_count" DOUBLE,
  "predicted_infection_count" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "sir_2015" DOUBLE,
  "on_track_toward_2020_goal_0_88_2017" VARCHAR,
  "notes" VARCHAR
);

SSI In Adult Patients, 2018

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_adult_patients_2018

87.18 KB
6789 rows
19 columns


CREATE TABLE ssi_in_adult_patients_2018 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "county" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "hospital_type" VARCHAR,
  "operative_procedure" VARCHAR,
  "procedure_count" BIGINT,
  "infections_reported" BIGINT,
  "infections_predicted" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "on_track_toward_2020_goal_0_82_2018" VARCHAR,
  "sir_2015" DOUBLE,
  "notes" VARCHAR
);

SSI In Adult Patients, 2019

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_adult_patients_2019

86.42 KB
6677 rows
19 columns


CREATE TABLE ssi_in_adult_patients_2019 (
  "year" DOUBLE,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "procedure_count" DOUBLE,
  "infections_reported" DOUBLE,
  "infections_predicted" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "on_track" VARCHAR,
  "sir_2015" DOUBLE,
  "notes" VARCHAR
);

SSI In Adult Patients 2021

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_adult_patients_2021

83.76 KB
6504 rows
19 columns


CREATE TABLE ssi_in_adult_patients_2021 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "procedure_count" BIGINT,
  "infections_reported" BIGINT,
  "infections_predicted" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "met_2020_goal" VARCHAR,
  "sir_2015" DOUBLE,
  "notes" VARCHAR
);

SSI In Adult Patients 2022

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_adult_patients_2022

83.95 KB
6452 rows
19 columns


CREATE TABLE ssi_in_adult_patients_2022 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "procedure_count" BIGINT,
  "infections_reported" BIGINT,
  "infections_predicted" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "met_2020_goal" VARCHAR,
  "sir_2015" DOUBLE,
  "notes" VARCHAR
);

SSI In Adult Patients, January 1 – June 30, 2020 (Updated Annually)

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_adult_patients_january_1_june_30_2020_updated_annually

41.87 KB
5735 rows
12 columns


CREATE TABLE ssi_in_adult_patients_january_1_june_30_2020_updated_annually (
  "year" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "procedure_count" BIGINT,
  "infections_reported" BIGINT,
  "infections_predicted" DOUBLE
);

SSI In Adult Patients, July 1 – December 31, 2020 (Updated Annually)

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_adult_patients_july_1_december_31_2020_updated_annually

70.71 KB
6019 rows
26 columns


CREATE TABLE ssi_in_adult_patients_july_1_december_31_2020_updated_annually (
  "year" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "procedure_count" BIGINT,
  "infections_reported" BIGINT,
  "infections_predicted" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "notes" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR
);

SSI In Pediatric Patients, 2016

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_pediatric_patients_2016

24.26 KB
1494 rows
12 columns


CREATE TABLE ssi_in_pediatric_patients_2016 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "county" VARCHAR,
  "facility_id" BIGINT,
  "facility_name" VARCHAR,
  "operative_procedure" VARCHAR,
  "procedure_count" BIGINT,
  "predicted_infection_count" DOUBLE,
  "infection_count" BIGINT,
  "unnamed_10" VARCHAR,
  "notes" VARCHAR
);

SSI In Pediatric Patients, 2017

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_pediatric_patients_2017

34.3 KB
1759 rows
18 columns


CREATE TABLE ssi_in_pediatric_patients_2017 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "hospital_type" VARCHAR,
  "county" VARCHAR,
  "procedure_count" BIGINT,
  "infection_count" BIGINT,
  "predicted_infection_count" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "on_track_toward_2020_goal_0_88_2017" VARCHAR,
  "notes" VARCHAR
);

SSI In Pediatric Patients, 2018

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_pediatric_patients_2018

32.38 KB
1736 rows
18 columns


CREATE TABLE ssi_in_pediatric_patients_2018 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "hospital_type" VARCHAR,
  "county" VARCHAR,
  "procedure_count" BIGINT,
  "infections_reported" BIGINT,
  "infections_predicted" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "on_track_to_achieve_2020_goal_0_82_in_2018" VARCHAR,
  "notes" VARCHAR
);

SSI In Pediatric Patients, 2019

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_pediatric_patients_2019

33.43 KB
1684 rows
18 columns


CREATE TABLE ssi_in_pediatric_patients_2019 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "procedure_count" BIGINT,
  "infections_reported" BIGINT,
  "infections_predicted" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "on_track" VARCHAR,
  "notes" VARCHAR
);

SSI In Pediatric Patients 2022

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_pediatric_patients_2022

32.18 KB
1531 rows
18 columns


CREATE TABLE ssi_in_pediatric_patients_2022 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "procedure_count" BIGINT,
  "infections_reported" BIGINT,
  "infections_predicted" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "met_2020_goal" VARCHAR,
  "notes" VARCHAR
);

SSI In Pediatric Patients, January 1 – December 31, 2021

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_pediatric_patients_january_1_december_31_2021

31.16 KB
1406 rows
18 columns


CREATE TABLE ssi_in_pediatric_patients_january_1_december_31_2021 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "procedure_count" BIGINT,
  "infections_reported" BIGINT,
  "infections_predicted" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "met_2020_goal" VARCHAR,
  "notes" VARCHAR
);

SSI In Pediatric Patients, January 1 – December 31, 2023

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_pediatric_patients_january_1_december_31_2023

32.4 KB
1534 rows
18 columns


CREATE TABLE ssi_in_pediatric_patients_january_1_december_31_2023 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "procedure_count" BIGINT,
  "infections_reported" BIGINT,
  "infections_predicted" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "met_2020_goal" VARCHAR,
  "notes" VARCHAR
);

SSI In Pediatric Patients, January 1 – June 30, 2020 (Updated Annually)

@usgov.ca_gov_surgical_site_infections_ssis_for_operative_pro_d2163bf7.ssi_in_pediatric_patients_january_1_june_30_2020_updat_08934850

21.44 KB
1190 rows
12 columns


CREATE TABLE ssi_in_pediatric_patients_january_1_june_30_2020_updat_08934850 (
  "year" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "operative_procedure" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "procedure_count" BIGINT,
  "infections_reported" BIGINT,
  "infections_predicted" DOUBLE
);