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

provider_number	npi_provider_number	owner_number	service_location_number	provider_business_legal_name	enrollment_status_effective_date	provider_type_code	provider_type_code_desc	provider_license_number	provider_specialty_code	provider_specialty_code_desc	out_of_state_ind	out_of_state_ind_desc	provider_address_county_code	provider_address_county_code_description	attention_line	provider_address_line1	provider_address_line2	provider_address_city	provider_address_state	provider_address_zip	provider_address_latitude	provider_address_longitude	mssa_id	tract_id
1073927877	1073927877	1	1	IRVINE VALLEY COLLEGE, HEALT	8-Jun-15	Exempt from Licensure Clinics (045)	CLINIC EXEMP FROM LICENSURE	None	99	Unknown (on EDS claims)	0	In state provider	30	Orange	COMMUNITY COLLEGE DISTRI	5500 IRVINE CENTER DRIVE	SC 150	IRVINE	CA	92618	33.679185	-117.778355	116o	525.17
1114290780	1114290780	1	1	INDIAN HEALTH CENTER OF	3-May-16	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	0	In state provider	43	Santa Clara	SANTA CLARA VALLEY	455 O'CONNOR DRIVE	STE 200	SAN JOSE	CA	95128	37.326705	-121.939855	183j	5020.01
1164643862	1164643862	1	1	INDIAN HEALTH CENTER OF	2-Jan-20	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	0	In state provider	43	Santa Clara	SANTA CLARA VALLEY	1333 MERIDIAN AVE	None	SAN JOSE	CA	95125	37.301556	-121.913574	183e	5023.01
1215030747	1215030747	1	1	INTEGRATIVE MEDICAL CTR	27-Mar-97	Physicians Group (022)	PHYSICIANS GROUP	FNP12667	99	Unknown (on EDS claims)	0	In state provider	30	Orange	None	526 W 17TH ST	None	SANTA ANA	CA	92706	33.759988	-117.872775	116b	751
1215035274	1215035274	1	1	ISKAROUS, RAGAA Z MD INC	19-Jan-11	Physicians (026)	PHYSICIANS	A00045155	1	General Practice	0	In state provider	19	Los Angeles	None	11003 LAKEWOOD AVE	STE 201	DOWNEY	CA	90241	33.937355	-118.12324	78.2eee	5509.01
1225188204	1225188204	1	1	IMPERIAL CLINIC	6-Jun-01	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	0	In state provider	19	Los Angeles	IMPERIAL CLINIC	837 W IMPERIAL HWY	None	LOS ANGELES	CA	90044	33.930968	-118.29038	78.2s	2412.02
1245483825	1245483825	1	1	INLAND WOMENS CARE	30-Dec-10	Physicians Group (022)	PHYSICIANS GROUP	FNP038355	16	Obstetrics-Gynecology (M.D. Only) Neonatal	0	In state provider	36	San Bernardino	ASSOCIATES	255 TERRACINA BLVD	STE 205A	REDLANDS	CA	92373	34.03816	-117.206039	151j	83.01
1275562969	1275562969	1	1	INLAND BEHAVIORAL SVS	1-Jul-00	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	0	In state provider	36	San Bernardino	HEALTH CENTER	665 N D ST	None	SAN BERNARDINO	CA	92401	34.111371	-117.291881	151g	57.01
1477953933	1477953933	1	1	IBARRA FAMILY HEALTH CENTER	7-Aug-15	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	0	In state provider	37	San Diego	OF SAN DIEGO INC	4874 POLK AVENUE	None	SAN DIEGO	CA	92105	32.751328	-117.089571	161d	27.07
1487613766	1487613766	2	1	INLAND CENTER MEDICAL GROUP	1-Mar-12	Physicians Group (022)	PHYSICIANS GROUP	None	13	Neurology (M.D. only)	0	In state provider	36	San Bernardino	None	9220 HAVEN AVENUE	SUITE 210	RANCHO CUCAMONGA	CA	91730	34.086016	-117.575867	151b	21.1
1528063153	1528063153	1	1	I'SOT INC	5-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	0	In state provider	25	Modoc	None	670 COUNTY ROAD 83	None	CANBY	CA	96015	41.443794	-120.895524	98	3
1568658086	1568658086	1	1	INFINITE WOMENS CARE	19-Mar-09	Physicians (026)	PHYSICIANS	20A9842	16	Obstetrics-Gynecology (M.D. Only) Neonatal	0	In state provider	24	Merced	None	600 WEST I ST	STE C	LOS BANOS	CA	93635	37.061785	-120.862745	94	22.01
1629462312	1629462312	1	1	INDIAN HEALTH CENTER OF SANT	27-Mar-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	0	In state provider	43	Santa Clara	OF SANTA CLARA	2039 FOREST AVENUE	STE 105	SAN JOSE	CA	95128	37.327064	-121.934245	183j	5005
1790718351	1790718351	1	1	IMPERIAL BEACH HEALTH CT	6-Jan-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	0	In state provider	37	San Diego	None	949 PALM AVE	None	IMPERIAL BEACH	CA	91932	32.58379	-117.113362	161j	105.02
1861449522	1861449522	1	1	INDIAN HLTH COUNCIL, INC	8-Jan-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	0	In state provider	37	San Diego	None	50100 GOLSH ROAD	None	VALLEY CENTER	CA	92082	33.277133	-116.951859	153.2	191.06
1881997963	1881997963	1	1	INDIAN HEALTH CENTER OF SANT	1-May-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	0	In state provider	43	Santa Clara	CLARA VALLEY	1642 E CAPITOL EXPY	None	SAN JOSE	CA	95121	37.306075	-121.811998	183h	5033.37
1932271517	1932271517	1	1	INYO COUNTY HEALTH DEPT	14-Mar-97	County Clinics not assoc w/hosp (048)	COUNTY CLINICS NOT ASSOCIATED WITH HOSPITAL	ZZT11964	99	Unknown (on EDS claims)	0	In state provider	14	Inyo	CLINIC	155 E MARKET	None	INDEPENDENCE	CA	93526	36.802768	-118.199076	54	5
1942487848	1942487848	1	1	ISLA VISTA NEIGHBORHOOD	17-Jul-05	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	0	In state provider	42	Santa Barbara	CLINICS	970 EMBARCADERO DEL MAR	None	GOLETA	CA	93117	34.411629	-119.857055	181a	29.24