Table: ccs_special_care_centers , center_name like O*

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.93	O'Connor Nicu	Community Neonatal Intensive Care Unit	2/14/2012	Full	10/25/2012	Santa Clara	1063406551	Santa Clara Med Ctr	O'Connor Hospital	2105 Forest Avenue	None	San Jose	CA	95128-1425	(408) 885-7200
7.04.31	Olive View-UCLA Medical Center	Cleft Palate Center	2/19/1985	Full	3/28/1988	Los Angeles	1750305785	Los Angeles Co	La Co Olive View-UCLA	14445 Olive View Drive	None	Sylmar	CA	91342-1437	(818) 901-3000
7.13.90	Olive View-UCLA Medical Center	Community Neonatal Intensive Care Unit	7/1/2010	Full	5/22/2017	Los Angeles	1417970567	Los Angeles County Olive	La County Olive View-UCLA	14445 Olive View Drive	None	Sylmar	CA	91342-1437	(818) 901-3000
7.38.05	Olive View-UCLA Medical Center	HRIF - Community	10/20/1998	Full	5/22/2017	Los Angeles	1417970567	Los Angeles County Olive	La County Olive View-UCLA	14445 Olive View Drive	None	Sylmar	CA	91342-1437	(818) 901-3000
7.20.22	Orange County Global Medical Burn Center	miscellaneous	1/10/2008	Full	None	Orange	1982697678	Wmc Sa Inc	Western Medical Center	1001 N Tustin Avenue	None	Santa Ana	CA	92705-3577	(714) 953-3610
7.13.63	Orange County Global Medical Center	Community Neonatal Intensive Care Unit	7/23/2009	Full	None	Orange	1982697678	Orange County Global Medical	Orange County Global Medical	1001 N Tustin Avenue	None	Santa Ana	CA	92705-3502	(714) 953-3610
7.35.119	Orange County Physicians Hearing Services	Communication Disorders Center Type C	11/14/2007	Full	11/19/2007	Orange	1750324554	Orange County Physicians	Orange County Physicians	26726 Crown Valley Parkway	Suite 210	Mission Viejo	CA	92691-8006	(949) 364-4361
7.03.16	Orthopaedic Institute For Children	Craniofacial Center	11/8/1999	Full	None	Los Angeles	None	Orthopaedic Hosp	Orthopaedic Hosp	2400 S Flower Street	None	Los Angeles	CA	90007-2629	(213) 742-1000
7.08.08	Orthopaedic Institute For Children	Myelomeningocele (Spina Bifida) Center	1/16/1987	Conditional	None	Los Angeles	None	Orthopaedic Hosp	Orthopaedic Hosp	2400 S Flower Street	None	Los Angeles	CA	90007-2629	(213) 742-1000
7.15.13	Orthopaedic Institute For Children	Hemophilia Center	6/26/1989	Full	None	Los Angeles	None	Orthopaedic Hosp	Orthopaedic Hosp	2400 S Flower Street	None	Los Angeles	CA	90007-2629	(213) 742-1000
7.16.16	Orthopaedic Institute For Children	Hematology/Oncology Center	1/1/1987	Conditional	None	Los Angeles	None	Orthopaedic Hosp	Orthopaedic Hosp	2400 S Flower Street	None	Los Angeles	CA	90007-2629	(213) 742-1000
7.20.07	Orthopaedic Institute For Children Neuromuscular	miscellaneous	3/23/1986	Provisional	None	Los Angeles	None	Orthopaedic Hosp	Orthopaedic Hosp	2400 S Flower Street	None	Los Angeles	CA	90007-2629	(213) 742-1000