Table family_pact_providers_profile_cy

Table: family_pact_providers_profile_cy_2019 , provider_business_legal_name like O*

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
1003856402	1003856402	1	1	OVI MOAS MD A PROFESSION	31-Oct-97	Physicians (026)	PHYSICIANS	A00035730	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	19	Los Angeles	None	9815 LAS TUNAS DR	None	TEMPLE CITY	CA	91780	34.107336	-118.056401	78.2dddd	4319
1003885518	1003885518	1	1	ORANGE & SAN BERN CO	30-Oct-00	Community Clinics (041)	COMMUNITY CLINIC	None	99	Unknown (on EDS claims)	In state provider	36	San Bernardino	ORANGE & SAN BERN CO	1873 COMMERCENTER W	None	SAN BERNARDINO	CA	92408	34.067916	-117.286162	151f	124
1033426002	1033426002	1	1	OMNI FAMILY HELATH	21-Dec-10	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	1014 CALLOWAY DRIVE	BLDG F	BAKERSFIELD	CA	93312	35.392827	-119.122089	66d	38.07
1043241821	1043241821	1	1	ONTARIO CLINICA MEDICA	12-Mar-97	Physicians Group (022)	PHYSICIANS GROUP	FNP020842	8	Family Practice	In state provider	36	San Bernardino	FAMILIAR	403 W F ST	None	ONTARIO	CA	91762	34.069429	-117.654823	151c	14
1063684413	1063684413	1	1	OILDALE COMM HEALTH CTR	16-Mar-05	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	OILDALE COMM HEALTH CTR	525 ROBERTS LN	None	BAKERSFIELD	CA	93308	35.408606	-119.031233	66a	4
1073997326	1073997326	1	1	OMNI FAMILY HEALTH	16-Jul-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	4151 MEXICALI DRIVE	None	BAKERSFIELD	CA	93313	35.317752	-119.081668	66c	31.23
1083755631	1083755631	1	1	OVERFELT NEIGHBORHOOD	1-Sep-06	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	43	Santa Clara	OF SANTA CLARA COUNTY	1835 CUNNINGHAM AVE	None	SAN JOSE	CA	95122	37.329682	-121.829731	183e	5035.04
1083940597	1083940597	1	1	OC URGENTCARE MEDICAL	29-Mar-12	Physicians Group (022)	PHYSICIANS GROUP	None	8	Family Practice	In state provider	30	Orange	GROUP INCORPORATED	631 S BROOKHURST ST	SUITE # 101	ANAHEIM	CA	92804	33.824352	-117.958938	116c	877.01
1164672747	1164672747	1	1	ORANGE & BUTLER COMM HLT	14-Oct-08	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	HEALTH CENTER	1350 SOUTH ORANGE AVE	None	FRESNO	CA	93702	36.729147	-119.763665	35e	4
1164806410	1164806410	1	1	OMNI FAMILY HEALTH	3-Dec-17	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	1022 CALLOWAY DRIVE	None	BAKERSFIELD	CA	93312	35.365417	-119.114148	66d	38.12
1245777358	1245777358	1	1	OMNI FAMILY HEALTH	14-Dec-17	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	None	925 G STREET	None	REEDLEY	CA	93654	36.598178	-119.452641	32	66.02
1275617169	1275617169	1	1	OPERATION SAMAHAN COMMUNITY	28-Aug-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	37	San Diego	None	2835 HIGHLAND AVE	SUITE A	NATIONAL CITY	CA	91950	32.660558	-117.091927	161k	116.02
1295913366	1295913366	1	1	OLE HEALTH	1-Jan-10	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	28	Napa	CLINIC OLE	1222 PINE ST	STE A	SAINT HELENA	CA	94574	38.506025	-122.472105	111.1	2016.02
1306852496	1306852496	1	1	OMNI FAMILY HEALTH	26-Sep-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	1215 JEFFERSON ST	None	DELANO	CA	93215	35.771991	-119.244972	60	50.04
1316163736	1316163736	1	1	OJAI VALLEY COMMUNITY HEALTH	1-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	56	Ventura	None	1200 MARICOPA HWY	None	OJAI	CA	93023	34.442068	-119.262664	238	9.01
1326585431	1326585431	1	1	OMNI FAMILY HEALTH	16-Jul-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	None	1530 E MANNING AVENUE	None	REEDLEY	CA	93654	36.604125	-119.432889	32	66.04
1336173020	1336173020	1	1	OPEN DOOR COMM HLTH CTRS	8-Nov-06	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	12	Humboldt	SPECIALIST CENTER	2426 BUHNE ST	None	EUREKA	CA	95501	40.785957	-124.140326	39	6
1336525906	1336525906	1	2	OAK PARK FAMILY HEALTH CENTE	20-Sep-16	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	37	San Diego	OF SAN DIEGO INC	5160 FEDERAL BLVD	None	SAN DIEGO	CA	92105	32.721447	-117.083502	161f	27.12
1396721197	1396721197	1	2	OMNI WOMENS HLT MED GRP	18-Apr-05	Physicians Group (022)	PHYSICIANS GROUP	FNP030976	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	10	Fresno	HEALTH MEDICAL GRP INC	2210 E ILLINOIS	STE 201	FRESNO	CA	93701	36.74503	-119.78478	35c	5.02
1427220870	1427220870	1	1	OMNI FAMILY HEALTH	8-Dec-06	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	655 S CENTRAL VALLEY HWY	None	SHAFTER	CA	93263	35.496554	-119.266365	58.1	41.02
1447297379	1447297379	1	1	ONE COMMUNITY HEALTH	1-Jul-14	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	34	Sacramento	EDUCATION & SVS-SACTO	1500 21ST ST	None	SACRAMENTO	CA	95811	38.570826	-121.480908	139i	13
1447496468	1447496468	1	1	OLIVE MEDICAL CENTER INC	7-Dec-11	Physicians (026)	PHYSICIANS	A41985	1	General Practice	In state provider	19	Los Angeles	None	2252 BEVERLY BLVD	STE 101	LOS ANGELES	CA	90057	34.067766	-118.27282	78.2ffff	2085.02
1467858696	1467858696	1	1	OMNI FAMILY HEALTH	16-Jul-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	210 N CHESTER AVE	None	BAKERSFIELD	CA	93308	35.406952	-119.020929	66a	4
1477522019	1477522019	1	1	ORCHARD HOSPITAL	13-Oct-98	Community Hosp Outpatient (015)	COMMUNITY OUTPATIENT HOSPITAL	40300802	99	Unknown (on EDS claims)	In state provider	4	Butte	None	240 SPRUCE ST	None	GRIDLEY	CA	95948	39.366966	-121.690577	9	35.02
1497130280	1497130280	1	1	OLE HEALTH	8-Apr-16	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	48	Solano	None	470 CHADBOURNE ROAD	STE A	FAIRFIELD	CA	94534	38.235172	-122.083839	202b	2524.02
1528398773	1528398773	1	1	OC FAMILY MEDICAL CENTER	9-Feb-10	Physicians (026)	PHYSICIANS	A00092067	8	Family Practice	In state provider	30	Orange	None	2401 W CHAPMAN AVE	SUITE 201	ORANGE	CA	92868	33.787891	-117.878143	116q	761.01
1558875203	1558875203	1	1	OMNI FAMILY HEALTH	4-Jun-19	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	1701 STINE ROAD	None	BAKERSFIELD	CA	93309	35.339488	-119.050542	66c	28.14
1578535845	1578535845	1	6	ONTARIO HEALTH CENTER	23-Jan-17	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	36	San Bernardino	None	150 E HOLT BLVD	None	ONTARIO	CA	91761	34.063374	-117.650205	151c	14
1598768962	1598768962	1	1	OCCIDENTAL AREA HEALTH	1-May-00	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	49	Sonoma	OCCIDENTAL AREA HEALTH	3802 MAIN ST	None	OCCIDENTAL	CA	95465	38.408661	-122.947471	210.2	1543.02
1598858169	1598858169	1	1	OPEN DOOR MCKINLEYVILLE	21-Jul-99	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	12	Humboldt	OPEN DOOR MCKINLEYVILLE	1644 CENTRAL AVE	STE A,B,C,D,E&F	MCKINLEYVILLE	CA	95519	40.93509	-124.100882	40	105.01
1639185317	1639185317	1	1	OCEANSIDE CARLSBAD COMM CLIN	6-Jan-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	37	San Diego	OCEANSIDE CLINIC	605 CROUCH STREET	BLDG C	OCEANSIDE	CA	92054	33.196018	-117.353708	156a	185.09
1649318338	1649318338	3	1	OSTOYA, PAUL W MD INC	23-Dec-97	Physicians (026)	PHYSICIANS	A00052252	99	Unknown (on EDS claims)	In state provider	10	Fresno	None	1095 E WARNER AVE	STE 101	FRESNO	CA	93710	36.836212	-119.769775	35f	54.06
1649442088	1649442088	1	1	OMNI FAMILY HEALTH	1-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	21138 PASO ROBLES HWY	None	LOST HILLS	CA	93249	35.678848	-119.792484	58.2	45
1699812099	1699812099	1	1	ORANGE CNTY HLTH DEPT	1-Mar-97	County Clinics not assoc w/hosp (048)	COUNTY CLINICS NOT ASSOCIATED WITH HOSPITAL	ZZT11732F	99	Unknown (on EDS claims)	In state provider	30	Orange	None	1725 W 17TH ST	None	SANTA ANA	CA	92706	33.76006	-117.892138	116h	753.02
1760660831	1760660831	1	1	OLE HEALTH	1-Jan-10	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	28	Napa	CLINIC OLE	911 WASHINGTON ST	None	CALISTOGA	CA	94515	38.578096	-122.577062	111.2	2020
1760704035	1760704035	1	1	ORANUSI, VICTOR A. MD INC	1-May-10	Physicians (026)	PHYSICIANS	A00063000	38	Geriatrics	In state provider	19	Los Angeles	None	3737 MARTIN LUTHER KING	STE 105	LYNWOOD	CA	90262	33.928529	-118.200486	78.2sss	5402.03
1780928986	1780928986	1	1	OMNI FAMILY HEALTH	23-Feb-13	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	4600 PANAMA LANE	SUITE 102B	BAKERSFIELD	CA	93313	35.295989	-119.053828	66c	31.14
1821237355	1821237355	1	1	OMNI FAMILY HEALTH	13-Aug-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	1133 N CHELSEA ST	None	RIDGECREST	CA	93555	35.638142	-117.675674	64	54.01
1831335116	1831335116	1	1	ORCHARD MEDICAL CENTER	28-May-09	Physicians (026)	PHYSICIANS	A66698	8	Family Practice	In state provider	10	Fresno	INC	555 SIXTH ST	None	ORANGE COVE	CA	93646	36.62521	-119.312366	32	65.02
1841331626	1841331626	1	1	OAKDALE COMMUNITY HEALTH CTR	1-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	50	Stanislaus	None	1420 W H ST	None	OAKDALE	CA	95361	37.758018	-120.862179	211	2.02
1841476686	1841476686	1	1	OMNI FAMILY HEALTH	5-Nov-08	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	3409 CALLOWAY DR	STE 300	BAKERSFIELD	CA	93312	35.391031	-119.110086	66d	38.07
1851713929	1851713929	1	1	OMNI FAMILY HEALTH	16-Jul-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	4131 MING AVE	None	BAKERSFIELD	CA	93309	35.339464	-119.049305	66c	28.14
1861867590	1861867590	1	1	OMNI FAMILY HEALTH	27-Feb-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	None	659 CENTRAL VALLEY HWY	None	SHAFTER	CA	93263	35.504066	-119.276012	58.1	41.01
1881617934	1881617934	1	1	OIVE VIEW-UCLA MED CTR	28-Apr-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	OLIVE VIEW-UCLA MED CTR	14445 OLIVE VIEW DR	None	SYLMAR	CA	91342	34.324172	-118.448013	78.2gg	1060.1
1902106198	1902106198	1	1	OLE HEALTH	6-Apr-11	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	28	Napa	None	300 HARTLE COURT	None	NAPA	CA	94559	38.287257	-122.288484	112.1	2002.03
1962506295	1962506295	1	1	OROVILLE FAMILY PRACTICE	10-Apr-07	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	4	Butte	None	2809 OLIVE HIGHWAY	SUITE 210 & 320	OROVILLE	CA	95966	39.50469	-121.542356	10	30.01
1982756425	1982756425	1	1	OROVILLE HOSPITAL	8-Dec-99	Community Hosp Outpatient (015)	COMMUNITY OUTPATIENT HOSPITAL	42390937	99	Unknown (on EDS claims)	In state provider	4	Butte	None	2767 OLIVE HWY	None	OROVILLE	CA	95966	39.504939	-121.54275	10	27