Table: ccs_approved_hospitals , legal_name like A*

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
1891938122	Ahmc Anaheim Reg Med Ctr	Ahmc Anaheim Reg Med Ctr	Special	Full	9/15/1979	None	None	Orange	1111 W La Palma Avenue	None	Anaheim	CA	92801-2804	(714) 774-1450
1275720377	Ahmc San Gabriel Valley	San Gabriel Valley Medical	General Community (over 14 without pediatric license)	Full	12/29/2003	None	None	Los Angeles	438 W Las Tunas Drive	None	San Gabriel	CA	91776-1216	(626) 289-5454
1396764353	Alameda Health System	Highland General Hospital	General Community (over 14 without pediatric license)	Provisional	12/27/2005	None	None	Alameda	1411 E 31st Street	None	Oakland	CA	94602-1018	(510) 437-4800
1518996040	American Hospital Management	Mad River Community Hospital	Limited	Full	9/1/1984	None	9/11/1984	Humboldt	3800 Janes Road	None	Arcata	CA	95521-4788	(951) 652-2811
1366419517	Antelope Valley Healthcare	Antelope Valley Hospital	Pediatric Community	Provisional	12/1/1982	None	None	Los Angeles	1600 W Ave J	None	Lancaster	CA	93534-2814	(661) 949-5000
1770587107	Asante	Rogue Valley Medical Center	Standard	Full	5/12/1980	None	None	None	2825 E Barnett Road	None	Medford	OR	97504-8332	(541) 789-4728