Table: ccs_special_care_centers , center_name like Z*

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  *

scc_num	center_name	scc_type	scc_effective_date	facility_status	most_recent_review_date	county	npi	provider_name	business_name	address_line_1	address_line_2	city	state	zip_code	phone
7.13.04	Zuckerberg San Francisco General Hospital And Trauma Center	Community Neonatal Intensive Care Unit	2/18/1997	Full	1/19/1999	San Francisco	None	San Francisco Gen Hosp	San Francisco Gen Hosp	1001 Potrero Avenue	None	San Francisco	CA	94110-3594	(415) 821-8200
7.17.05	Zuckerberg San Francisco General Hospital And Trauma Center	Sickle Cell Center	5/12/1994	Conditional	None	San Francisco	None	San Francisco Gen Hosp	San Francisco Gen Hosp	1001 Potrero Avenue	None	San Francisco	CA	94110-3594	(415) 821-8200
7.21.03	Zuckerberg San Francisco General Hospital And Trauma Center	Prosthetics and Orthotics Facility	2/5/2003	Provisional	None	San Francisco	None	San Francisco Gen Hosp	San Francisco Gen Hosp	1001 Potrero Avenue	None	San Francisco	CA	94110-3594	(415) 821-8200
7.26.04	Zuckerberg San Francisco General Hospital And Trauma Center	Infectious Diseases and Immunologic Disorders	6/13/1988	Conditional	None	San Francisco	None	San Francisco Gen Hosp	San Francisco Gen Hosp	1001 Potrero Avenue	None	San Francisco	CA	94110-3594	(415) 821-8200
7.33.129	Zuckerberg San Francisco General Hospital And Trauma Center	Communication Disorders Center Type A	8/20/2015	Full	None	San Francisco	1083648810	San Francisco Gen Hosp	San Francisco Gen Hosp	1001 Potrero Avenue	None	San Francisco	CA	94110-3594	(415) 206-8455