Table: ccs_approved_hospitals , legal_name like C*

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  *

npi	legal_name	business_name	facility_type	facility_status	start_date	end_date	most_recent_review_date	county	address_line_1	address_line_2	city	state	zip_code	phone
1952777245	Casa Colina Hospital And	Casa Colina Hospital	Special	Full	4/1/2016	None	None	Los Angeles	255 East Bonita Avenue	None	Pomona	CA	91767-1923	(909) 596-7733
1639172372	Cedars-Sinai Medical Ctr	Cedars Sinai Med Ctr	Tertiary	Full	1/1/1977	None	None	Los Angeles	8700 Beverly Boulevard	None	Los Angeles	CA	90048-1804	(310) 855-5000
1033247622	Central California	Delano Regional Med Cntr	Limited	Full	10/22/2001	None	10/22/2001	Kern	1401 Garces Highway	None	Delano	CA	93215-3690	(661) 725-4800
1922033547	Cha Hollywood Medical	Hollywood Presbyterian Med	Pediatric Community	Full	3/22/1999	None	None	Los Angeles	1300 N Vermont Avenue	None	Los Angeles	CA	90027-6005	(323) 644-4452
1699868398	Childrens Hosp At	Childrens Hosp of Orange	Pediatric Community	Full	4/6/2009	None	None	Orange	27700 Med Center Road	5th Fl	Mission Viejo	CA	92691-6426	(714) 365-2180
1003961251	Childrens Hospital Medical	Childrens Hospital And Resea	Tertiary	Full	11/1/1984	None	None	Alameda	747 52nd Street	None	Oakland	CA	94609-1809	(510) 428-3000
1811080526	Childrens Hospital of	Childrens Hospital of Orange	Tertiary	Full	12/1/1979	None	None	Orange	1201 W La Veta Avenue	None	Orange	CA	92868-3874	(714) 997-3000
1124073366	Childrens Hospital of La	Childrens Hospital of La	Tertiary	Full	1/1/1955	None	None	Los Angeles	4650 W Sunset Boulevard	None	Los Angeles	CA	90027	(323) 660-2450
1114109337	City of Hope Helford	City of Hope Helford	Special	Full	7/1/1979	None	None	Los Angeles	1500 Duarte Road	None	Duarte	CA	91010-3012	(818) 359-8111
1932197258	Community Hospital	Community Hospital	Limited	Full	7/1/1978	None	None	Monterey	23625 Holman Highway	None	Monterey	CA	93940-5902	(831) 658-3977
1215903018	Community Memorial Health	Community Memorial Hospital	Special	Full	1/23/1998	None	None	Ventura	147 N Brent Street	None	Ventura	CA	93003-2809	(805) 652-5011
1275540171	County of Los Angeles Rancho	National Rehabilitation	Special	Full	3/3/1980	None	None	Los Angeles	7601 Imperial Highway	None	Downey	CA	90242-3456	(562) 401-7022
1699979245	County of Monterey	Natividad Medical Center	Pediatric Community	Full	3/1/1996	None	None	Monterey	1441 Constitution Boulevard	None	Salinas	CA	93906-3100	(831) 755-4111
1821159195	County of Riverside	Riverside University Health	Pediatric Community	Full	4/1/1975	None	None	Riverside	26520 Cactus Avenue	None	Moreno Valley	CA	92555-3927	(951) 486-4470
1790781169	County of San Bernardino	Arrowhead Regional Medical	Pediatric Community	Full	4/14/2000	None	None	San Bernardino	400 N Pepper Avenue	None	Colton	CA	92324-1801	(909) 580-2634
1629167457	County of Ventura	Ventura County Medical Cente	Pediatric Community	Full	4/1/1978	None	None	Ventura	300 Hillmont Avenue	None	Ventura	CA	93003-3099	(805) 652-6000