Table family_pact_providers_profile_cys_2020

Table: family_pact_providers_profile_cys_2020_2021 , 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_desc	provider_address_county_code	provider_address_county_desc	attention_line	provider_address_line1	provider_address_line2	provider_address_city	provider_address_state	provider_address_zip	provider_phone_number	provider_address_latitude	provider_address_longitude	mssa_id	tract_id
1023122967	1023122967	1	1	Indio Family Care Center	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	33	Riverside	None	47923 Oasis St	None	Indio	CA	92201-6950	(909) 358-4487	33.700857	-116.220937	128	455.01
1114290780	1114290780	1	1	Indian Health Center Of	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	43	Santa Clara	SANTA CLARA VALLEY	455 O'connor Drive	Ste 200	San Jose	CA	95128-1633	(408) 445-3400	37.326705	-121.939855	183j	5020.01
1164643862	1164643862	1	1	Indian Health Center Of	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	43	Santa Clara	SANTA CLARA VALLEY	1333 Meridian Ave	None	San Jose	CA	95125-5250	(408) 445-3400	37.301556	-121.913574	183e	5023.01
1215030747	1215030747	1	1	Integrative Medical Ctr	1-Dec-93	22	PHYSICIANS GROUP	FNP12667	None	UNKNOWN	In state provider	30	Orange	None	526 W 17th St	None	Santa Ana	CA	92706-3619	(714) 558-9355	33.759988	-117.872775	116b	751
1215246996	1215246996	1	1	Imperial Beach Community	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	37	San Diego	CLINIC	1016 Outer Road	None	San Diego	CA	92154-1351	(619) 429-3733	32.578619	-117.083338	161j	101.07
1245483825	1245483825	1	1	Inland Women's Care Associat	3-Feb-09	22	PHYSICIANS GROUP	FNP038355	None	UNKNOWN	In state provider	36	San Bernardino	ASSOCIATES	255 Terracina Blvd	Ste 205a	Redlands	CA	92373-4870	(909) 307-5736	34.03816	-117.206039	151j	83.01
1275562969	1275562969	1	1	Inland Behavioral And Health	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	36	San Bernardino	HEALTH CENTER	665 N D St	None	San Bernardino	CA	92401-1109	(909) 881-6146	34.111371	-117.291881	151g	57.01
1487613766	1487613766	2	1	Inland Center Med Grp Pc	20-Jun-16	27	PODIATRISTS	None	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	36	San Bernardino	None	9220 Haven Avenue	Suite 210	Rancho Cucamonga	CA	91730-8551	(909) 989-7551	34.086016	-117.575867	151b	21.1
1578823647	1578823647	1	1	Inland Behavioral And Health	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	33	Riverside	SERVICES INC	1070 E Ramsey Street	None	Banning	CA	92220-5924	(909) 881-6146	33.925352	-116.864988	134	442
1629462312	1629462312	1	1	Indian Health Center	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	43	Santa Clara	OF SANTA CLARA	2039 Forest Avenue	Ste 105	San Jose	CA	95128-4833	(408) 445-3400	37.327064	-121.934245	183j	5005
1790718351	1790718351	1	1	Imperial Beach Health Ct	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	37	San Diego	None	949 Palm Ave	None	Imperial Beach	CA	91932-1503	(619) 429-5387	32.58379	-117.113362	161j	105.02
1861449522	1861449522	1	1	Indian Health Council, Inc	25-Jan-22	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	37	San Diego	None	50100 Golsh Rd	None	Valley Center	CA	92082-5338	(760) 749-1410	33.277133	-116.951859	153.2	191.06
1881997963	1881997963	1	1	Indian Health Center Of Sant	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	43	Santa Clara	CLARA VALLEY	1642 E Capitol Expy	None	San Jose	CA	95121-1800	(408) 445-3400	37.306075	-121.811998	183h	5033.37
1942487848	1942487848	1	1	Isla Vista Neighborhood	9-May-08	58	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	In state provider	42	Santa Barbara	CLINIC	970 Embarcadero Del Mar	None	Isla Vista	CA	93117-4869	(805) 617-7858	34.411629	-119.857055	181a	29.24