Table: licensed_and_certified_healthcare_facilities , 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  *

x	y	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	oshpd_id	cclho_code	cclho_name	fips_county_code	birthing_facility_flag	trauma_ped_ctr	trauma_ctr	type_of_care	critical_access_hospital	data_date	objectid
-13498483.2322931	4685702.55220241	CERTIFIED ONLY	None	None	030000321	OPEN	CA030000321	55C0001040	None	1986/11/05 08:00:00+00	2019/03/13 07:00:00+00	1699711556	Y	Y	1	20	19DEC2018:00:00:00	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	1988/10/18 07:00:00+00	2008/04/01 07:00:00+00	2009/03/31 07:00:00+00	None	38.74844701	-121.258938	(-121.258938,38.748447014)	None	31	PLACER	06061	None	None	None	None	None	2024/10/15 07:00:00+00	76
-13450608.2815266	4679657.64670673	CERTIFIED ONLY	None	None	030001777	OPEN	CA03001777	05C0001560	None	2002/09/05 07:00:00+00	2018/04/12 07:00:00+00	1316192826	Y	Y	1	20	24JUL2017:00:00:00	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	2002/07/25 07:00:00+00	2008/06/25 07:00:00+00	2009/06/24 07:00:00+00	None	38.706084	-120.82887	(-120.82887,38.706084)	None	09	EL DORADO	06017	None	None	None	None	None	2024/10/15 07:00:00+00	365
-13270229.6295494	4063705.91438441	CERTIFIED ONLY	None	None	050001450	OPEN	CA050001450	05C0001688	None	2004/09/02 07:00:00+00	2018/03/13 07:00:00+00	1912018706	Y	Y	1	20	08DEC2017:00:00:00	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	2004/06/14 07:00:00+00	2007/06/14 07:00:00+00	2008/06/13 07:00:00+00	PROFIT CORP	34.259544	-119.208501	(-119.208501,34.259544)	None	56	VENTURA	06111	None	None	None	None	None	2024/10/15 07:00:00+00	514
-13564019.5768714	4490083.66400226	CERTIFIED ONLY	None	None	070001291	OPEN	CA070001291	05C0001530	None	2001/11/30 08:00:00+00	2019/04/10 07:00:00+00	1235155730	Y	Y	1	20	24FEB2019:00:00:00	None	IMQ	MONTPELIER AMBULATORY SURGICAL CENTER	ASC	SURGICAL CLINIC	NON-LTC	0	2340 MONTPELIER DR, SUITE B	SAN JOSE	95116	1622	BACH NGUYEN, MAI	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	2001/10/25 07:00:00+00	2007/11/25 08:00:00+00	2008/11/24 08:00:00+00	None	37.364841	-121.847661	(-121.847661,37.364841)	None	43	SANTA CLARA	06085	None	None	None	None	None	2024/10/15 07:00:00+00	1844
-13050711.2115886	4037490.95180143	CERTIFIED ONLY	None	None	240001306	OPEN	CA240001306	05C0001289	None	1994/05/18 07:00:00+00	2018/06/06 07:00:00+00	1821141441	Y	Y	1	20	14MAR2018:00:00:00	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	1994/05/18 07:00:00+00	2008/04/01 07:00:00+00	2009/03/31 07:00:00+00	PROFIT CORP	34.064685	-117.2365335	(-117.2365335,34.064685)	None	36	SAN BERNARDINO	06071	None	None	None	None	None	2024/10/15 07:00:00+00	3356
-13116702.240627	3992690.78472055	CERTIFIED ONLY	None	None	630012696	OPEN	CA630012696	05C0001924	None	2010/02/01 08:00:00+00	2019/05/09 07:00:00+00	1023250438	Y	Y	1	20	03JAN2019:00:00:00	None	IMQ	O C MULTISPECIALTY SURGERY CENTER, L.P.	ASC	SURGICAL CLINIC	NON-LTC	0	14642 NEWPORT AVE, SUITE 100	TUSTIN	92780	6057	None	None	None	(310) 821-2549	400	ORANGE	06	ORANGE	Y	None	PARENT	None	None	None	None	None	None	None	None	33.730641	-117.829341	(-117.829341,33.730641)	None	30	ORANGE	06059	None	None	None	None	None	2024/10/15 07:00:00+00	5455
-13259350.7653324	4214160.32083148	CERTIFIED ONLY	None	None	630014906	OPEN	CA6300014906	05C0002216	None	2018/12/20 08:00:00+00	None	1447539747	Y	Y	0	20	20DEC2018:00:00:00	20DEC2021:00:00:00	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	2024/10/15 07:00:00+00	6392
-13098938.1100571	4251455.43711263	CERTIFIED ONLY	None	None	630014330	OPEN	CA630014330	05C0002012	None	2013/01/24 08:00:00+00	2018/12/26 08:00:00+00	1851678981	Y	Y	1	20	29NOV2018:00:00:00	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	2024/10/15 07:00:00+00	6421
-13098069.8625567	3985816.56538362	CERTIFIED ONLY	None	None	630016290	OPEN	CA630016290	05C0002083	None	2015/04/03 07:00:00+00	2018/11/07 08:00:00+00	1609108083	Y	Y	0	20	09OCT2018:00:00:00	29APR2021:00:00:00	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	2024/10/15 07:00:00+00	7436
-13253897.0564992	4212394.91772913	CERTIFIED ONLY	None	None	630016156	OPEN	CA630016156	05C0002078	None	2015/04/08 07:00:00+00	2018/08/02 07:00:00+00	1982954640	Y	Y	1	20	13MAR2018:00:00:00	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	2024/10/15 07:00:00+00	7820
-13626815.1242669	4951550.91063297	CERTIFIED ONLY	None	None	630017608	OPEN	630017608	05C0002168	None	2017/08/24 07:00:00+00	2018/04/27 07:00:00+00	None	Y	Y	1	20	24AUG2017:00:00:00	None	IMQ	DANIEL B. LENSINK MEDICAL CORPORATION	ASC	SURGICAL CLINIC	NON-LTC	0	2770 EUREKA WAY, SUITE 300	REDDING	96001	None	None	DAN@LENSINKEYESURGERY.COM	(530) 229-3945	(530) 229-7700	550	SHASTA	23	CHICO	Y	None	PARENT	None	None	None	None	None	None	None	None	40.586571	-122.411763	(-122.411763,40.586571)	None	45	SHASTA	06089	None	None	None	None	None	2024/10/15 07:00:00+00	8044
-13598541.1090642	4500568.24788157	CERTIFIED ONLY	None	None	630018436	OPEN	CA630018436	05C0002231	None	2019/10/16 07:00:00+00	2020/04/27 07:00:00+00	1114400280	Y	Y	1	20	16OCT2019:00:00:00	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	2024/10/15 07:00:00+00	8053
-13583566.1662598	4568869.40307537	CERTIFIED ONLY	None	None	630018489	OPEN	630018489	05C0002198	None	2018/12/13 08:00:00+00	2019/01/11 08:00:00+00	1427585280	Y	Y	1	20	13DEC2018:00:00:00	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	2024/10/15 07:00:00+00	8098
-13032358.3567597	3845390.25488969	CERTIFIED ONLY	None	None	630017861	OPEN	CA630017861	05C0002181	None	2018/07/16 07:00:00+00	2018/09/28 07:00:00+00	1568814010	Y	Y	1	20	16JUL2018:00:00:00	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	2024/10/15 07:00:00+00	8120
-12966782.6050817	4000368.32566932	CERTIFIED ONLY	None	None	630017862	OPEN	630017862	05C0002191	None	2018/11/06 08:00:00+00	2018/12/14 08:00:00+00	1659885325	Y	Y	1	20	06NOV2018:00:00:00	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	2024/10/15 07:00:00+00	8132
-13579914.3303643	4547523.11253684	CERTIFIED ONLY	None	None	630017706	OPEN	630017706	05C0002159	None	2017/12/05 08:00:00+00	2018/01/05 08:00:00+00	1467999813	Y	Y	1	20	05DEC2017:00:00:00	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	2024/10/15 07:00:00+00	8250
-13188640.2351623	4033854.80452454	CERTIFIED ONLY	None	None	630017915	OPEN	CA630017915	05C0002218	None	2019/08/09 07:00:00+00	2019/11/22 08:00:00+00	1558802249	Y	Y	1	20	09AUG2019:00:00:00	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	2024/10/15 07:00:00+00	8348
-13173116.8434907	4001161.5586218	CERTIFIED ONLY	None	None	630017763	OPEN	CA630017763	05C0002189	None	2018/03/12 07:00:00+00	2018/12/14 08:00:00+00	1487197943	Y	Y	1	20	12MAR2018:00:00:00	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	2024/10/15 07:00:00+00	8514
-13197248.0147879	4056970.52864336	CERTIFIED ONLY	None	None	630017771	OPEN	CA6930017771	05C0002175	None	2018/04/23 07:00:00+00	2018/08/02 07:00:00+00	1659807717	Y	Y	0	20	23APR2018:00:00:00	21JAN2022:00:00:00	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	2024/10/15 07:00:00+00	8533
-13610764.0782089	4518571.83574027	CERTIFIED ONLY	None	None	630017836	OPEN	CA630017836	05C0002229	None	2019/11/08 08:00:00+00	2020/04/07 07:00:00+00	1255846762	Y	Y	1	20	08NOV2019:00:00:00	None	IMQ	APEX AMBULATORY SURGERY CENTER, INC.	ASC	SURGICAL CLINIC	NON-LTC	0	1241 E HILLSDALE BLVD, SUITE 210	FOSTER CITY	94404	None	NGO, JOLIE	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	2024/10/15 07:00:00+00	8756
-13029480.9705617	3865190.14891482	CERTIFIED ONLY	None	None	630017578	OPEN	630017578	05C0002165	None	2017/08/16 07:00:00+00	2018/03/06 08:00:00+00	1114399656	Y	Y	1	20	16AUG2017:00:00:00	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	2024/10/15 07:00:00+00	8892
-13192031.2494909	4063395.59636962	CERTIFIED ONLY	None	None	630018839	OPEN	630018839	05C0002235	None	2019/09/19 07:00:00+00	2020/05/28 07:00:00+00	1851647549	Y	Y	1	20	19SEP2019:00:00:00	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	2024/10/15 07:00:00+00	9637
-13189244.0320804	4032828.4527185	CERTIFIED ONLY	None	None	930000792	OPEN	CA930000792	05C0001132	None	1988/09/29 07:00:00+00	2019/10/15 07:00:00+00	1609104900	Y	Y	1	20	26MAY2017:00:00:00	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	1991/12/03 08:00:00+00	2006/12/03 08:00:00+00	2007/12/02 08:00:00+00	PROFIT CORP	34.029981	-118.480995	(-118.480995,34.029981)	None	19	LOS ANGELES	06037	None	None	None	None	None	2024/10/15 07:00:00+00	14779