Table: ccs_approved_hospitals , legal_name like L*

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
1417060237	Lacmartin Luther King	Lacmartin Luther King	Pediatric Community	Full	2/3/2005			Los Angeles	12021 Wilmington Avenue		Los Angeles	CA	90059-3019
1285647933	Lacusc Medical Center	Lacusc Medical Center	Tertiary	Full	1/31/2002			Los Angeles	1200 N State Street		Los Angeles	CA	90033-1029
1699782599	Loma Linda University	Loma Linda University	Tertiary	Full	2/20/1968			San Bernardino	11234 Anderson Street		Loma Linda	CA	92354-2804	(714) 796-7311
1194711952	Lompoc Valley Medical	Lompoc Valley Medical	Limited	Full	3/1/1986			Santa Barbara	1515 E Ocean Avenue		Lompoc	CA	93436-6104	(805) 737-3300
1962442012	Long Beach Memorial	Memorialcare Long Beach	Long	Full	5/1/1980			Los Angeles	2801 Atlantic Avenue		Long Beach	CA	90806-1701	(562) 933-2000
1093728743	Los Angeles County	Los Angeles General Medical	Tertiary	Full	1/31/2002			Los Angeles	2051 Marengo Street	C2k100	Los Angeles	CA	90033-1352
1497778401	Los Angeles County Harbor	La County Harbor UCLA	Tertiary	Full	3/5/2004		9/13/2024	Los Angeles	1000 W Carson Street		Torrance	CA	90502-2004	(310) 222-2345
1417970567	Los Angeles County Olive	La County Olive View-UCLA	Pediatric Community	Full	9/1/1975			Los Angeles	14445 Olive View Drive		Sylmar	CA	91342-1437	(818) 901-3000
1033163019	Los Robles Hospital	Los Robles Hospital	Limited	Full	4/1/1978			Ventura	215 W Janss Road		Thousand Oaks	CA	91360-1899	(702) 855-1022
1306890389	Los Robles Hospital	Thousand Oaks Surgical Hosp	Limited	Full	1/1/1978			Ventura	401 Rolling Oaks Drive		Thousand Oaks	CA	91361-1050	(805) 777-7750
1467442749	Lucile Salter Packard	Lucile Salter Packard Childr	Tertiary	Full	7/3/1989			Santa Clara	725 Welch Road		Palo Alto	CA	94304-1601	(650) 497-8000