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