Table: ssi_in_pediatric_patients_2017 , 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	hai	operative_procedure	facility_id	facility_name	hospital_category_riskadjustment	hospital_type	county	procedure_count	infection_count	predicted_infection_count	sir	sir_ci_95_lower_limit	sir_ci_95_upper_limit	comparison	on_track_toward_2020_goal_0_88_2017	notes
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	All Procedures	250000017	John F. Kennedy Memorial Hospital	Acute Care Hospital	Community (125-250 Beds)	Riverside	69	0	0.072	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Appendix surgery	250000017	John F. Kennedy Memorial Hospital	Acute Care Hospital	Community (125-250 Beds)	Riverside	52	0	0.036	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Cesarean section	250000017	John F. Kennedy Memorial Hospital	Acute Care Hospital	Community (125-250 Beds)	Riverside	9	0	0.028	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Exploratory abdominal surgery (laparotomy)	250000017	John F. Kennedy Memorial Hospital	Acute Care Hospital	Community (125-250 Beds)	Riverside	1	0	0.003	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Gallbladder surgery	250000017	John F. Kennedy Memorial Hospital	Acute Care Hospital	Community (125-250 Beds)	Riverside	6	0	0.004	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Open reduction of fracture	250000017	John F. Kennedy Memorial Hospital	Acute Care Hospital	Community (125-250 Beds)	Riverside	1	0	0.001	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	All Procedures	140000196	John Muir Medical Center, Concord Campus	Acute Care Hospital	Major Teaching	Contra Costa	2	0	0.013	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Appendix surgery	140000196	John Muir Medical Center, Concord Campus	Acute Care Hospital	Major Teaching	Contra Costa	2	0	0.013	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	All Procedures	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	Contra Costa	146	0	1.046	0.00	0	2.87	Same	Yes	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Appendix surgery	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	Contra Costa	78	0	0.459	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Colon surgery	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	Contra Costa	2	0	0.13	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Exploratory abdominal surgery (laparotomy)	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	Contra Costa	7	0	0.023	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Laminectomy	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	Contra Costa	13	0	0.083	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Open reduction of fracture	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	Contra Costa	23	0	0.061	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Small bowel surgery	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	Contra Costa	3	0	0.077	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Spinal fusion	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	Contra Costa	16	0	0.209	None	None	None	None	None	None
2017	California	Healthcare Associated Infection, Surgical Site Infections (SSI)	Thoracic surgery	140000187	John Muir Medical Center, Walnut Creek Campus	Acute Care Hospital	Major Teaching	Contra Costa	4	0	0.003	None	None	None	None	None	None