Table family_pact_providers_profile_cy

Table: family_pact_providers_profile_cy_2019 , provider_business_legal_name like U*

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_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
1043216021	1043216021	1	1	UNITED INDIAN HEALTH	29-Oct-03	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	8	Del Norte	SERVICES INC	1675 NORTHCREST DR	None	CRESCENT CITY	CA	95531	41.775751	-124.199769	19	1.04
1093023277	1093023277	1	1	UNIVERSAL COMMUNITY HEALTH	19-Apr-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	CENTER	1005 E WASHINGTON BLVD	STE A	LOS ANGELES	CA	90021	34.025688	-118.252933	78.2mmm	2260.01
1134101686	1134101686	1	1	UN HLTH CTRS SAN JOAQUIN	9-Aug-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	PO BOX 1990	16928 11TH ST	None	HURON	CA	93234	36.20539	-120.102483	28	78.02
1174913776	1174913776	1	2	UNIVERSAL COMMUNITY HEALTH	31-Aug-17	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	None	2801 SOUTH SAN PEDRO ST	None	LOS ANGELES	CA	90011	34.019812	-118.262438	78.2l	2267
1174984041	1174984041	1	1	UNICARE COMMUNITY HEALTH CEN	9-Apr-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	36	San Bernardino	CENTER, INC	16127 FOOTHILL BLVD	None	FONTANA	CA	92335	34.106542	-117.453053	151h	28.03
1184606634	1184606634	1	1	UNITED HLTH CTRS	9-Aug-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	None	121 BARBOZA ST	None	MENDOTA	CA	93640	36.765512	-120.383672	25	83.01
1184722779	1184722779	1	1	UNIVERSITY OF CALIF UNIV	1-Jul-08	Community Hosp Outpatient (015)	COMMUNITY OUTPATIENT HOSPITAL	370800782	99	Unknown (on EDS claims)	In state provider	37	San Diego	MEDICAL CENTER-SAN DIEGO	200 W ARBOR DR	None	SAN DIEGO	CA	92103	32.753784	-117.164978	161b	4
1205102068	1205102068	1	1	UNIVERSITY COMMUNITY HEALTH	9-Jul-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	33	Riverside	None	2933 UNIVERSITY AVE	None	RIVERSIDE	CA	92507	33.977562	-117.365144	135a	304
1255549879	1255549879	1	1	UN HLTH CTRS SAN JOAQU	1-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	HURON	16928 11TH STREET	None	HURON	CA	93234	36.20539	-120.102483	28	78.02
1265854061	1265854061	1	1	UNICARE COMMUNITY HEALTH CEN	26-Aug-15	Health Access Program (058)	HEALTH ACCESS PROGRAM	550002949	99	Unknown (on EDS claims)	In state provider	36	San Bernardino	CENTER INC	570 S MT VERNON AVE	STE G	SAN BERNARDINO	CA	92410	34.090692	-117.313886	151f	124
1275591802	1275591802	1	1	UC REGENTS UCLA FAMILY	10-Jun-02	Physicians Group (022)	PHYSICIANS GROUP	None	47	Miscellaneous	In state provider	19	Los Angeles	HEALTH CENTER	1920 COLORADO AVE	None	SANTA MONICA	CA	90404	34.025654	-118.477318	78.2kkkk	7017.02
1295944015	1295944015	1	1	UNITED HLTH CTRS	1-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	None	121 BARBOZA ST	None	MENDOTA	CA	93640	36.765512	-120.383672	25	83.01
1336350438	1336350438	1	1	UN HLTH CTRS SAN JOAQU	1-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	ORANGE COVE	445 11TH ST	None	ORANGE COVE	CA	93646	36.627221	-119.319001	32	65.02
1346474723	1346474723	1	3	UNIVERSITY MATERNITY AND FAM	2-Jan-10	Physicians (026)	PHYSICIANS	A00069815	8	Family Practice	In state provider	36	San Bernardino	None	8990 SIERRA AVE	SUITE J AND K	FONTANA	CA	92335	34.090487	-117.435765	151f	31.02
1346607603	1346607603	1	1	UNIFIED CARE MEDICAL GROUP	8-Aug-16	Physicians (026)	PHYSICIANS	A20957	1	General Practice	In state provider	19	Los Angeles	INC	2040 PACIFIC COAST HWY	UNIT S	LOMITA	CA	90717	33.78951	-118.315695	78.2o	6701
1356763155	1356763155	1	1	UNICARE COMMUNITY HEALTH	26-Aug-15	Health Access Program (058)	HEALTH ACCESS PROGRAM	550002953	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	CENTER INC	1501 E HOLT AVENUE	STE A	POMONA	CA	91767	34.063208	-117.720788	78.2ss	4027.02
1386934875	1386934875	1	1	USC EISNER FAMILY MEDICINE	1-Jul-11	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	CENTER	1400 S GRAND AVE	SUITE 101	LOS ANGELES	CA	90015	34.03718	-118.265408	78.2ffff	2240.1
1417939968	1417939968	1	1	UN HLTH CTRS SAN JOAQUIN	9-Aug-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	54	Tulare	None	476 E WASHINGTON AVE	None	EARLIMART	CA	93219	35.884294	-119.271473	231	44
1447604582	1447604582	1	1	UNICARE COMMUNITY HEALTH	3-Apr-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	36	San Bernardino	CENTER INC	308 N LA CADENA DR	None	COLTON	CA	92324	34.06808	-117.324092	151f	125
1457347239	1457347239	1	1	UHS-CORONA, INC	1-Jan-04	Community Hosp Outpatient (015)	COMMUNITY OUTPATIENT HOSPITAL	None	99	Unknown (on EDS claims)	In state provider	33	Riverside	None	800 S MAIN ST	None	CORONA	CA	92882	33.87333	-117.566679	135d	416
1457534968	1457534968	1	1	UCSJ STUDENT HEALTH SRVS	17-Apr-08	Physicians Group (022)	PHYSICIANS GROUP	None	7	Dermatology	In state provider	43	Santa Clara	STUDENT HEALTH CENTER	1 WASHINGTON SQ	None	SAN JOSE	CA	95192	37.335922	-121.881743	183d	5009.01
1457724924	1457724924	1	1	UNITED HEALTH CENTERS OF THE	3-May-16	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	OF THE SAN JOAQUIN VLY	601 3RD STREET	None	PARLIER	CA	93648	36.614252	-119.525347	32	68.02
1477979722	1477979722	1	1	UNITED HEALTH CENTERS	10-Dec-14	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	16	Kings	SAN JOAQUIN VALLEY	1270 N LEMOORE AVE	None	LEMOORE	CA	93245	36.3161	-119.780795	69	4.03
1497150593	1497150593	1	1	UNITED HEALTH CENTERS OF TH	15-Dec-15	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	OF THE SAN JOAQUIN VLY	6425 W BOWLES	None	RAISIN CITY	CA	93652	36.601014	-119.906238	30	76
1497751572	1497751572	1	1	UNITED INDIAN HEALTH SVS	18-Aug-03	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	12	Humboldt	EUREKA	1600 WEEOT WAY	None	ARCATA	CA	95521	40.89826	-124.094173	39	11.01
1528478211	1528478211	1	1	UNITED HEALTH CENTERS	10-Dec-14	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	SAN JOAQUIN VALLEY	1560 E MANNING AVE	None	REEDLEY	CA	93654	36.604124	-119.432514	32	66.04
1558632570	1558632570	1	1	UNITED HEALTH CENTERS OF THE	6-Apr-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	16	Kings	SAN JOAQUIN VALLEY	1209 WHITLEY AVE	None	CORCORAN	CA	93212	36.098061	-119.562403	68	14.02
1568649226	1568649226	2	1	UPTIMUM MEDICAL GROUP AND	16-Nov-18	Physicians (026)	PHYSICIANS	A48240	41	Internal Medicine	In state provider	19	Los Angeles	IPA INC	2220 W MANCHESTER BLVD	None	INGLEWOOD	CA	90305	33.959923	-118.318325	78.2r	6007.04
1568663573	1568663573	1	1	URGENT CARE AMERICA	1-Dec-07	Physicians Group (022)	PHYSICIANS GROUP	FNP001223	8	Family Practice	In state provider	19	Los Angeles	MEDICAL CLINIC INC	13470 TELEGRAPH RD	None	WHITTIER	CA	90605	33.938916	-118.044588	78.2vv	5029.02
1598790529	1598790529	1	2	UNIVERSITY OF CA IRVINE	12-Apr-19	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	30	Orange	ANAHEIM	300 W CARL KARCHER WAY	None	ANAHEIM	CA	92801	33.850842	-117.920402	116l	865.01
1629018817	1629018817	1	2	UNITED MEDICAL CENTER	1-May-97	Physicians (026)	PHYSICIANS	G00048366	30	Radiology, Pedodontist (Dentists Only)	In state provider	36	San Bernardino	MEYER, BRUCE D MD	1996 NORTH D ST	None	SAN BERNARDINO	CA	92405	34.133793	-117.291922	151g	54
1629198791	1629198791	1	1	UNITED CARE FAMILY MEDICAL	19-Mar-12	Physicians Group (022)	PHYSICIANS GROUP	None	1	General Practice	In state provider	19	Los Angeles	CORPORATION	2324 W PICO BLVD	None	LOS ANGELES	CA	90006	34.047262	-118.287597	78.2b	2211.1
1629599535	1629599535	1	1	UNITED HEALTH CENTERS OF THE	13-Nov-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	SAN JOAQUIN VALLEY	1570 7TH STREET	None	SANGER	CA	93657	36.706003	-119.559559	31	60
1649252198	1649252198	1	1	UN HLTH CTRS SAN JOAQUIN	9-Aug-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	ORANGE COVE	445 11TH ST	None	ORANGE COVE	CA	93646	36.627221	-119.319001	32	65.02
1659580926	1659580926	1	1	UN HLTH CTRS SAN JOAQU	1-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	54	Tulare	EARLIMART	476 E WASHINGTON AVE	None	EARLIMART	CA	93219	35.884294	-119.271473	231	44
1689880072	1689880072	1	1	UN HLTH CTRS SAN JOAQU	1-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	PARLIER	650 S ZEDIKER AVE	None	PARLIER	CA	93648	36.633221	-119.520673	32	68.02
1710309513	1710309513	1	1	UNICARE COMMUNITY HEALTH	26-Aug-15	Health Access Program (058)	HEALTH ACCESS PROGRAM	550002956	99	Unknown (on EDS claims)	In state provider	36	San Bernardino	CENTER INC	437 N EUCLID AVE	None	ONTARIO	CA	91762	34.067462	-117.651217	151c	14
1720171242	1720171242	1	1	UMMA COMMUNITY CLINIC	20-Jan-06	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	UMMA COMMUNITY CLINIC	711 W FLORENCE AVE	None	LOS ANGELES	CA	90044	33.974649	-118.286057	78.2s	2376
1740335678	1740335678	1	1	UNITED AMER IND INV INC	22-Mar-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	INVOLVEMENT	1125 W 6TH ST	STE 103	LOS ANGELES	CA	90017	34.054205	-118.262475	78.2ffff	2092
1760671077	1760671077	1	2	UNIVERSAL MEDICAL CLINIC	21-Apr-08	Physicians Group (022)	PHYSICIANS GROUP	FNP36837	1	General Practice	In state provider	19	Los Angeles	None	18701 SHERMAN WAY	STE 4	RESEDA	CA	91335	34.201179	-118.540408	78.2hhhh	1310.2
1811105554	1811105554	1	1	UNITED HLTH CTRS OF SJ	1-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	THE SAN JOAQUIN VALLEY	2502 JENSEN AVE	None	SANGER	CA	93657	36.706737	-119.571975	31	60
1811185259	1811185259	1	1	URBAN INDIAN HLTH BOARD	10-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	38	San Francisco	None	160 CAPP ST	None	SAN FRANCISCO	CA	94110	37.764144	-122.418535	162c	201
1821593971	1821593971	1	1	UNITED HEALTH CENTERS OF THE	24-May-19	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	16	Kings	SAN JOAQUIN VALLEY	250 E HANFORD ARMONA RD	None	LEMOORE	CA	93245	36.313463	-119.776828	69	4.03
1851325906	1851325906	1	1	UNIV OF CALIF, IRVINE	1-Jul-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	30	Orange	UCI FAMILY HEALTH CTR	800 N MAIN ST	None	SANTA ANA	CA	92701	33.751182	-117.867611	116b	750.02
1851373401	1851373401	1	1	UNITED HLTH CTRS OF SJ	9-Aug-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	None	517 S MADERA AVE	None	KERMAN	CA	93630	36.72717	-120.060315	29	40.01
1851709406	1851709406	1	1	UPLAND ONTARIO MEDICAL CLIN	26-Jun-17	Physicians Group (022)	PHYSICIANS GROUP	None	1	General Practice	In state provider	36	San Bernardino	None	1520 N MOUNTAIN AVE	BLDG F STE 128	ONTARIO	CA	91762	34.061468	-117.664432	151c	16
1952471542	1952471542	1	1	UKIAH VALLEY PRIMARY CARE	1-Jul-13	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	23	Mendocino	None	260 HOSPITAL DRIVE	None	UKIAH	CA	95482	39.152407	-123.203663	93.1	115
1982079620	1982079620	1	1	UNITED HEALTH CENTERS OF THE	13-Mar-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	SAN JOAQUIN VALLEY	106 E MAIN ST	None	FOWLER	CA	93625	36.628827	-119.678773	31	16
1982667663	1982667663	1	1	UCLA DEPT OF PEDIATRICS	3-Oct-05	Physicians Group (022)	PHYSICIANS GROUP	None	40	Pediatrics, Periodontist (Dentists Only)	In state provider	19	Los Angeles	GRP PRACTICE	10833 LE CONTE AVE	12311 MDCC	LOS ANGELES	CA	90095	34.068289	-118.444883	78.2w	2653.01