Table: ccs_approved_hospitals , legal_name like P*

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
1457321317	Palomar Health	Palomar Health Dntwn Campus	Pediatric Community	Full	12/7/1983	None	12/7/1983	San Diego	555 E Valley Parkway	None	Escondido	CA	92025-3048	(760) 739-3000
1457321317	Palomar Health	Palomar Health Downtown Camp	Pediatric Community	Full	12/7/1983	None	None	San Diego	2185 Citracado Parkway	None	Escondido	CA	92025-4159	(760) 739-3000
1407828429	Pasadena Hosp Assn, Ltd	Huntington Memorial Hosp	Pediatric Community	Full	12/4/2003	None	None	Los Angeles	100 W California Boulevard	None	Pasadena	CA	91105-3010	(626) 397-5000
1508859323	Pih Health Good Samaritan	Pih Health Good Samaritan Ho	Standard	Full	1/1/1989	None	None	Los Angeles	1225 Wilshire Boulevard	None	Los Angeles	CA	90017-1901	(213) 977-2121
1043215379	Pih Health Hospital Whittier	Pih Health Hospital Whittier	Standard	Full	8/1/1974	None	None	Los Angeles	12401 Washington Boulevard	None	Whittier	CA	90602-1006	(562) 698-0811
1073519443	Pioneers Memorial Health	Pioneers Memorial Health	Standard	Full	10/4/1985	None	None	Imperial	207 W Legion Road	None	Brawley	CA	92227-7780	(760) 351-3333
1407813660	Pomona Valley Hospital	Pomona Valley Comm Hospi	Pediatric Community	Full	11/8/1974	None	None	Los Angeles	1798 N Garey Avenue	None	Pomona	CA	91767-2918	(909) 865-9500
1114547114	Prime Healthcare Services	St Francis Medical Center	Pediatric Community	Conditional	8/13/2020	None	6/22/2021	Los Angeles	3630 E Imperial Highway	None	Lynwood	CA	90262	(310) 900-8900
1336328244	Prime Hlthcare Centinela LLC	Centinela Hosp Med Ctr	Standard	Full	1/1/1980	None	None	Los Angeles	555 E Hardy Street	None	Inglewood	CA	90301-4011	(310) 673-4660
1336173269	Providence Health System	Providence Saint Joseph Med	Special	Full	4/8/1998	None	None	Los Angeles	501 S Buena Vista	None	Burbank	CA	91505-4866	None
1477587632	Providence Health System	Providence Holy Cross	Special	Full	1/8/2014	12/31/2055	None	Los Angeles	15031 Rinaldi Street	None	Mission Hills	CA	91345-1207	(818) 365-8057
1902844988	Providence Health System	Providence Little Co of Mary	Pediatric Community	Full	11/1/2005	None	None	Los Angeles	4101 Torrance Boulevard	None	Torrance	CA	90503-4607	(310) 540-7676
1124026273	Providence Saint Johns	Saint Johns Health Center	Standard	Full	1/1/1985	None	None	Los Angeles	2121 Santa Monica Boulevard	None	Santa Monica	CA	90404-2303	(310) 829-5511