Table: ssi_in_ped_pats_jan_1_jun_30_2020_upd_ann , facility_name like J*

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  *

year	state	county	hai	operative_procedure	facility_id	facility_name	hospital_category_riskadjustment	facility_type	procedure_count	infections_reported	infections_predicted
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	All procedures	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	57	0	0.45
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	Appendix surgery	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	24	0	0.16
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	Cardiac surgery	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	1	0	0
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	Colon surgery	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	2	0	0.02
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	Exploratory abdominal surgery (laparotomy)	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	7	0	0.05
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	Gallbladder surgery	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	1	0	0
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	Laminectomy	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	2	0	0.01
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	Open reduction of fracture	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	8	0	0.02
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	Small bowel surgery	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	3	0	0.08
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	Spinal fusion	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	7	0	0.08
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	Thoracic surgery	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	2	0	0.03
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	All procedures	140000196	John Muir Medical Center, Concord Campus	Acute Care Hospital	Major Teaching	2	0	0
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	Appendix surgery	140000196	John Muir Medical Center, Concord Campus	Acute Care Hospital	Major Teaching	1	0	0
2020H1	California	Contra Costa	Surgical Site Infections (SSI)	Thoracic surgery	140000196	John Muir Medical Center, Concord Campus	Acute Care Hospital	Major Teaching	1	0	0
2020H1	California	Riverside	Surgical Site Infections (SSI)	All procedures	250000017	John F. Kennedy Memorial Hospital	Acute Care Hospital	Community, 125-250 Beds	22	1	0.02
2020H1	California	Riverside	Surgical Site Infections (SSI)	Appendix surgery	250000017	John F. Kennedy Memorial Hospital	Acute Care Hospital	Community, 125-250 Beds	17	1	0.01
2020H1	California	Riverside	Surgical Site Infections (SSI)	Cesarean section	250000017	John F. Kennedy Memorial Hospital	Acute Care Hospital	Community, 125-250 Beds	3	0	0
2020H1	California	Riverside	Surgical Site Infections (SSI)	Gallbladder surgery	250000017	John F. Kennedy Memorial Hospital	Acute Care Hospital	Community, 125-250 Beds	2	0	0