Table: licensed_and_certified_healthcare_facility_locations , ao_name like I*

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  *

licensed_certified	flag	t18_19	facid	fac_status_type_code	aspen_facid	ccn	terminat_sw	participation_date	approval_date	npi	can_be_deemed_fac_type	can_be_certified_fac_type	deemed	ao_cd	dmg_efctv_dt	ao_trmntn_dt	ao_name	facname	fac_type_code	fac_fdr	ltc	capacity	address	city	zip	zip9	facadmin	contact_email	contact_fax	contact_phone_number	county_code	county_name	district_number	district_name	isfacmain	parent_facid	fac_fac_relationship_type_code	start_date	license_number	business_name	license_status_description	initial_license_date	license_effective_date	license_expiration_date	entity_type_description	latitude	longitude	location	hcai_id	cclho_code	cclho_name	fips_county_code	birthing_facility_flag	trauma_ped_ctr	trauma_ctr	type_of_care	critical_access_hospital	data_date
CERTIFIED ONLY	None	None	030000321	OPEN	CA030000321	55C0001040	None	11/05/1986	03/13/2019	1699711556	Y	Y	1	20	12/19/2018	None	IMQ	EYE SURGERY CENTER OF NORTHERN CALIFORNIA	ASC	SURGICAL CLINIC	NON-LTC	0	1386 LEAD HILL BLVD, SUITE 130	ROSEVILLE	95661	2936	PULIDO, LISA	None	(916) 723-4449	(916) 723-7400	410	PLACER	03	SACRAMENTO	Y	None	PARENT	None	030000363	None	INACTIVE - CAPEN DECISION	10/18/1988	04/01/2008	03/31/2009	None	38.74844701	-121.258938	(-121.258938,38.748447014)	306344023	31	PLACER	06061	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	030001777	OPEN	CA03001777	05C0001560	None	09/05/2002	04/12/2018	1316192826	Y	Y	1	20	07/24/2017	None	IMQ	EL DORADO SURGERY CENTER	ASC	SURGICAL CLINIC	NON-LTC	0	4300 GOLDEN CENTER DRIVE, SUITE E	PLACERVILLE	95667	6278	PERRY, ANN	CLOCKWOOD@ELDORADOSURGERY.COM	(530) 344-1561	(530) 344-1687	080	EL DORADO	03	SACRAMENTO	Y	None	PARENT	None	030000767	None	INACTIVE - CAPEN DECISION	07/25/2002	06/25/2008	06/24/2009	None	38.706084	-120.82887	(-120.82887,38.706084)	306094021	09	EL DORADO	06017	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	050001450	OPEN	CA050001450	05C0001688	None	09/02/2004	03/13/2018	1912018706	Y	Y	1	20	12/08/2017	None	IMQ	VENTURA SURGERY CENTER INC	ASC	SURGICAL CLINIC	NON-LTC	0	1752 S VICTORIA AVE, SUITE A	VENTURA	93003	6194	COX, JEFF A	None	None	(805) 654-8115	660	VENTURA	05	VENTURA	Y	None	PARENT	None	050000587	VENTURA SURGERY CENTER INC	INACTIVE - CAPEN DECISION	06/14/2004	06/14/2007	06/13/2008	PROFIT CORP	34.259544	-119.208501	(-119.208501,34.259544)	306564128	56	VENTURA	06111	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	070001291	OPEN	CA070001291	05C0001530	None	11/30/2001	04/10/2019	1235155730	Y	Y	1	20	02/24/2019	None	IMQ	MONTPELIER SURGERY CENTER	ASC	SURGICAL CLINIC	NON-LTC	0	2340 MONTPELIER DR, SUITE B	SAN JOSE	95116	1622	NGUYEN, MICHELLE	MAI_NGUYEN@SJGC.COM	(408) 347-9004	(408) 347-1875	530	SANTA CLARA	07	SAN JOSE	Y	None	PARENT	None	070000612	None	INACTIVE - CAPEN DECISION	10/25/2001	11/25/2007	11/24/2008	None	37.364841	-121.847661	(-121.847661,37.364841)	306434147	43	SANTA CLARA	06085	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	240001306	OPEN	CA240001306	05C0001289	None	05/18/1994	06/06/2018	1821141441	Y	Y	1	20	03/14/2018	None	IMQ	MOUNTAIN VIEW SURGERY CENTER AND MEDICAL CLINIC	ASC	SURGICAL CLINIC	NON-LTC	0	10408 INDUSTRIAL CIR	REDLANDS	92374	4548	SPENCER, ELIZABETH	MTVIEWSURGERYCTR@AOL.COM	(909) 796-0023	(909) 796-7803	460	SAN BERNARDINO	24	SAN BERNARDINO	Y	None	PARENT	None	240000549	INLAND ENDOSCOPY CENTER, INC.	INACTIVE - CAPEN DECISION	05/18/1994	04/01/2008	03/31/2009	PROFIT CORP	34.064685	-117.2365335	(-117.2365335,34.064685)	306364140	36	SAN BERNARDINO	06071	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630014330	OPEN	CA630014330	05C0002012	None	01/24/2013	12/26/2018	1851678981	Y	Y	1	20	11/29/2018	None	IMQ	RIDGECREST SPECIALTY SURGERY CENTER	ASC	SURGICAL CLINIC	NON-LTC	0	1200 N CHINA LAKE BLVD	RIDGECREST	93555	2665	TAHERI, DANIEL P	None	(661) 266-8751	(760) 446-9007	140	KERN	12	BAKERSFIELD	Y	None	PARENT	None	None	None	None	None	None	None	None	35.64187704	-117.6697631	(-117.6697631,35.641877039)	None	15	KERN	06029	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630014906	OPEN	CA6300014906	05C0002216	None	12/20/2018	None	1447539747	Y	Y	0	20	12/20/2018	12/20/2021	IMQ	WESTSIDE SURGICAL CENTER, LLC	ASC	SURGICAL CLINIC	NON-LTC	0	9700 BRIMHALL RD	BAKERSFIELD	93312	2777	None	RNDIRECTOR@TEI2020.NET	(661) 829-8657	(661) 588-5400	140	KERN	12	BAKERSFIELD	Y	None	PARENT	None	None	None	None	None	None	None	None	35.369145	-119.1107745	(-119.1107745,35.369145)	None	15	KERN	06029	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630016156	OPEN	CA630016156	05C0002078	None	04/08/2015	08/02/2018	1982954640	Y	Y	1	20	03/13/2018	None	IMQ	BAKERSFIELD SPECIALTY SURGERY CENTER, PC	ASC	SURGICAL CLINIC	NON-LTC	0	5600 CALIFORNIA AVENUE, SUITE 102	BAKERSFIELD	93309	None	TAHERI, DANIEL P	MICHELLES@LALASERCENTER.COM	None	(661) 322-2700	140	KERN	12	BAKERSFIELD	Y	None	PARENT	None	None	None	None	None	None	None	None	35.356212	-119.061783	(-119.061783,35.356212)	None	15	KERN	06029	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630016290	OPEN	CA630016290	05C0002083	None	04/03/2015	11/07/2018	1609108083	Y	Y	0	20	10/09/2018	04/29/2021	IMQ	GENESIS AMBULATORY SURGERY CENTER INC.	ASC	SURGICAL CLINIC	NON-LTC	0	26781 PORTOLA PKWY, SUITE 4E	FOOTHILL RANCH	92610	None	None	None	None	None	400	ORANGE	06	ORANGE	Y	None	PARENT	None	None	None	None	None	None	None	None	33.679269	-117.6619635	(-117.6619635,33.679269)	None	30	ORANGE	06059	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630017578	OPEN	630017578	05C0002165	None	08/16/2017	03/06/2018	1114399656	Y	Y	1	20	08/16/2017	None	IMQ	ENCOMPASS SURGERY CENTER	ASC	SURGICAL CLINIC	NON-LTC	0	7051 ALVARADO RD, SUITE 100	LA MESA	91942	8901	LAJVARDI, ROBERT	LARA.ENCOMPASS@GMAIL.COM	(619) 639-8211	(619) 713-6219	470	SAN DIEGO	10	SAN DIEGO	Y	None	PARENT	None	None	None	None	None	None	None	None	32.772834	-117.045819	(-117.045819,32.772834)	None	37	SAN DIEGO	06073	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630017706	OPEN	630017706	05C0002159	None	12/05/2017	01/05/2018	1467999813	Y	Y	1	20	12/05/2017	None	IMQ	WEBSTER OUTPATIENT SURGERY CENTER, LLC	ASC	SURGICAL CLINIC	NON-LTC	0	200 PORTER DR, SUITE 100	SAN RAMON	94583	None	NORCROSS, PATRICIA	JOHNWESLEY.WILLIAMSON@HKLAW.COM	None	(615) 850-8548	060	CONTRA COSTA	02	EAST BAY	Y	None	PARENT	None	None	None	None	None	None	None	None	37.773819	-121.990446	(-121.990446,37.773819)	None	07	CONTRA COSTA	06013	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630017763	OPEN	CA630017763	05C0002189	None	03/12/2018	12/14/2018	1487197943	Y	Y	1	20	03/12/2018	None	IMQ	COAST CITIES SURGERY CENTER, INC.	ASC	SURGICAL CLINIC	NON-LTC	0	2802 PACIFIC COAST HWY	TORRANCE	90505	None	None	None	(310) 274-5380	(310) 325-1644	200	LOS ANGELES	93	LA ACUTE/ANCILLARY	Y	None	PARENT	None	None	None	None	None	None	None	None	33.793902	-118.336122	(-118.336122,33.793902)	None	19	LOS ANGELES	06037	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630017771	OPEN	CA6930017771	05C0002175	None	04/23/2018	08/02/2018	1659807717	Y	Y	0	20	04/23/2018	01/21/2022	IMQ	TAMPA SURGICAL CENTER	ASC	SURGICAL CLINIC	NON-LTC	0	7640 TAMPA AVE, SUITE 102	RESEDA	91335	1700	POLOSAJIAN, LEO	JAN@CRSMDINC.COM	(818) 343-1612	(818) 718-1600	200	LOS ANGELES	93	LA ACUTE/ANCILLARY	Y	None	PARENT	None	None	None	None	None	None	None	None	34.209522	-118.552896	(-118.552896,34.209522)	None	19	LOS ANGELES	06037	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630017836	OPEN	CA630017836	05C0002229	None	11/08/2019	04/07/2020	1255846762	Y	Y	1	20	11/08/2019	None	IMQ	APEX AMBULATORY SURGERY CENTER, LLC	ASC	SURGICAL CLINIC	NON-LTC	0	1241 E HILLSDALE BLVD, SUITE 210	FOSTER CITY	94404	None	REYZELMAN, ROZANA	None	(650) 539-0876	(650) 389-9383	510	SAN MATEO	22	SAN FRANCISCO	Y	None	PARENT	None	None	None	None	None	None	None	None	37.567962	-122.267574	(-122.267574,37.567962)	None	41	SAN MATEO	06081	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630017861	OPEN	CA630017861	05C0002181	None	07/16/2018	09/28/2018	1568814010	Y	Y	1	20	07/16/2018	None	IMQ	SURGERY CENTER OF CALIFORNIA	ASC	SURGICAL CLINIC	NON-LTC	0	835 3RD AVE, SUITE C	CHULA VISTA	91911	None	MANI, NASRIN	None	(619) 425-4763	(619) 425-4209	470	SAN DIEGO	10	SAN DIEGO	Y	None	PARENT	None	None	None	None	None	None	None	None	32.623155	-117.071667	(-117.071667,32.623155)	None	37	SAN DIEGO	06073	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630017862	OPEN	630017862	05C0002191	None	11/06/2018	12/14/2018	1659885325	Y	Y	1	20	11/06/2018	None	IMQ	GOLDEN SPRINGS SURGICAL CENTER	ASC	SURGICAL CLINIC	NON-LTC	0	67555 E PALM CANYON DR, SUITE F117 - F118	CATHEDRAL CITY	92234	5467	None	ASC@SUMMIT-INSTITUTE.COM	(949) 783-3602	(949) 783-3600	430	RIVERSIDE	25	RIVERSIDE	Y	None	PARENT	None	None	None	None	None	None	None	None	33.78798	-116.48259	(-116.48259,33.78798)	None	33	RIVERSIDE	06065	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630017915	OPEN	CA630017915	05C0002218	None	08/09/2019	11/22/2019	1558802249	Y	Y	1	20	08/09/2019	None	IMQ	SOURCE SURGERY CENTER, LLC	ASC	SURGICAL CLINIC	NON-LTC	0	2801 WILSHIRE BLVD	SANTA MONICA	90403	4801	None	TTDAVIS23@GMAIL.COM	(310) 315-4967	(310) 574-2777	200	LOS ANGELES	93	LA ACUTE/ANCILLARY	Y	None	PARENT	None	None	None	None	None	None	None	None	34.03762158	-118.475571	(-118.475571,34.037621584)	None	19	LOS ANGELES	06037	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630018436	OPEN	CA630018436	05C0002231	None	10/16/2019	04/27/2020	1114400280	Y	Y	1	20	10/16/2019	None	IMQ	ALMA AT ADDISON SURGERY CENTER, LLC	ASC	SURGICAL CLINIC	NON-LTC	0	105 ADDISON AVE	PALO ALTO	94301	None	None	JEANNIE@FORTHEFACE.COM	None	(650) 327-3232	530	SANTA CLARA	07	SAN JOSE	Y	None	PARENT	None	None	None	None	None	None	None	None	37.43966038	-122.1577732	(-122.1577732,37.439660376)	None	43	SANTA CLARA	06085	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630018489	OPEN	630018489	05C0002198	None	12/13/2018	01/11/2019	1427585280	Y	Y	1	20	12/13/2018	None	IMQ	PINNACLE SURGERY CENTER, LLC	ASC	SURGICAL CLINIC	NON-LTC	0	100 N WIGET LN, ROOM 140	WALNUT CREEK	94598	None	ACEVES, IRIS	None	None	None	060	CONTRA COSTA	02	EAST BAY	Y	None	PARENT	None	None	None	None	None	None	None	None	37.925235	-122.023251	(-122.023251,37.925235)	None	07	CONTRA COSTA	06013	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	630018839	OPEN	630018839	05C0002235	None	09/19/2019	05/28/2020	1851647549	Y	Y	1	20	09/19/2019	None	IMQ	CALIFORNIA SURGICAL SPECIALTY GROUP, INC.	ASC	SURGICAL CLINIC	NON-LTC	0	17114 DEVONSHIRE ST, SUITE 100	NORTHRIDGE	91325	1619	None	None	None	None	200	LOS ANGELES	93	LA ACUTE/ANCILLARY	Y	None	PARENT	None	None	None	None	None	None	None	None	34.25724	-118.506033	(-118.506033,34.25724)	None	19	LOS ANGELES	06037	None	None	None	None	None	06/15/2025
CERTIFIED ONLY	None	None	930000792	OPEN	CA930000792	05C0001132	None	09/29/1988	10/15/2019	1609104900	Y	Y	1	20	05/26/2017	None	IMQ	TOWER WOUND CARE CENTER OF SANTA MONICA	ASC	SURGICAL CLINIC	NON-LTC	0	1301 20TH ST, SUITE 470	SANTA MONICA	90404	2090	GARCIA, NOEMI	DRTHOMPSON@ANEWLOOK.COM	(310) 828-8852	(310) 315-0222	200	LOS ANGELES	93	LA ACUTE/ANCILLARY	Y	None	PARENT	None	930000639	PACIFIC SURGICENTER, INC.	INACTIVE - CAPEN DECISION	12/03/1991	12/03/2006	12/02/2007	PROFIT CORP	34.029981	-118.480995	(-118.480995,34.029981)	306194275	19	LOS ANGELES	06037	None	None	None	None	None	06/15/2025