Table family_pact_providers_profile_cy

Table: family_pact_providers_profile_cy_2019 , provider_business_legal_name like H*

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
1003250093	1003250093	1	1	HURTT FAMILY HEALTH CLINIC	14-Sep-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	30	Orange	INC	1100 B N. TUSTIN AVE	SUITES A, D, F	SANTA ANA	CA	92705	33.751117	-117.836388	116h	754.03
1033593108	1033593108	1	1	HEMET MEDICAL AND DENTAL CEN	6-Nov-17	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	33	Riverside	INC	1023 E FLORIDA AVE	None	HEMET	CA	92543	33.747587	-116.961681	132	434.01
1053324715	1053324715	1	1	HUDSON COMPREHENSIVE HLT	28-Apr-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	HUDSON FAMILY PLANNING	2829 S GRAND AVE	None	LOS ANGELES	CA	90007	34.024316	-118.273658	78.2l	2246
1063562130	1063562130	1	1	HOLLYWOOD CLINIC	6-Jun-01	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	HOLLYWOOD CLINIC	6368 HOLLYWOOD BLVD	None	HOLLYWOOD	CA	90028	34.101591	-118.328814	78.2g	1907
1073565461	1073565461	1	2	HSU, MING-CHANG MD	4-Jan-01	Physicians (026)	PHYSICIANS	A00034714	8	Family Practice	In state provider	19	Los Angeles	None	3318 DEL MAR AVE	APT 205E	ROSEMEAD	CA	91770	34.068604	-118.099546	78.2qqq	4823.03
1104991744	1104991744	1	1	HUMBOLDT STATE UNIVERSTY	27-Nov-07	Exempt from Licensure Clinics (045)	CLINIC EXEMP FROM LICENSURE	CLF1419	99	Unknown (on EDS claims)	In state provider	12	Humboldt	STUDENT HLTH CENTER	PLAZA AVENUE	NEAR LIBRARY CIRCLE	ARCATA	CA	95521	40.874139	-124.081652	39	10
1124130620	1124130620	2	1	HARMONY HEALTH MEDICAL	12-Aug-15	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	58	Yuba	CLINIC & FAMILY RESOURCE	1908 N BEALE ROAD	SUITE E	MARYSVILLE	CA	95901	39.127859	-121.545877	249	403.01
1124300207	1124300207	1	1	HILMAR HEALTH CENTER	25-Oct-13	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	24	Merced	None	7970 N LANDER AVE	SUITE A & B	HILMAR	CA	95324	37.403898	-120.850126	95	4.02
1144557539	1144557539	1	1	HENAWI, I MD INC	1-May-10	Physicians (026)	PHYSICIANS	A00062143	1	General Practice	In state provider	33	Riverside	None	4020 W FLORIDA AVE	None	HEMET	CA	92545	33.745223	-117.015231	132	435.04
1144760943	1144760943	1	1	HURTT FAMILY HEALTH CLINIC-A	21-May-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	30	Orange	INC	947 S ANAHEIM BLVD	SUITE 260	ANAHEIM	CA	92805	33.822047	-117.90948	116l	874.05
1154636793	1154636793	1	1	HIGH DESERT HLTH SYSTEMS	28-Dec-10	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	HIGH DESERT HLTH SYSTEMS	44900 60TH ST W	None	LANCASTER	CA	93536	34.696359	-118.236642	77.5	9012.05
1164728788	1164728788	1	1	HESPERIA CLINICA MEDICA	13-Jun-13	Physicians Group (022)	PHYSICIANS GROUP	None	8	Family Practice	In state provider	36	San Bernardino	FAMILIAR A MEDICAL CORP	15888 MAIN STREET	SUITE 112B	HESPERIA	CA	92345	34.423632	-117.31593	145.1a	100.19
1255435533	1255435533	1	1	HUMBOLDT OPEN DOOR CLIN	1-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	12	Humboldt	None	770 10TH ST	None	ARCATA	CA	95521	40.869801	-124.08624	39	10
1306015425	1306015425	1	1	HUNTINGTON BEACH COMM CLINIC	13-Feb-08	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	30	Orange	HUNTINGTON BCH COMM CLIN	8041 NEWMAN AVE	None	HUNTINGTON BEACH	CA	92647	33.704838	-117.98864	116s	992.12
1306047196	1306047196	1	1	HAYWARD WELLNESS CENTER	1-Jul-98	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	1	Alameda	None	664 SOUTHLAND MALL	None	HAYWARD	CA	94545	37.650817	-122.104778	2n	4368
1306965587	1306965587	1	1	HURTT FAMILY HEALTH CLINIC	13-May-10	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	30	Orange	INC	1 HOPE DR	None	TUSTIN	CA	92782	33.741803	-117.786753	116v	756.07
1336275437	1336275437	1	1	HUCKLEBERRY HOUSE	1-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	38	San Francisco	None	555 COLE ST	None	SAN FRANCISCO	CA	94117	37.77001	-122.45032	162g	166
1346569217	1346569217	1	1	HABIB, SHEHNAZ N MD APC	28-Apr-97	Physicians (026)	PHYSICIANS	A00050211	41	Internal Medicine	In state provider	19	Los Angeles	None	14860 ROSCOE BLVD	SUITE 300	VAN NUYS	CA	91402	34.221468	-118.456871	78.2zz	1200.2
1356569172	1356569172	1	1	HANSEN FAMILY HEALTH CENTER	24-Aug-04	Health Access Program (058)	HEALTH ACCESS PROGRAM	550002588	99	Unknown (on EDS claims)	In state provider	57	Yolo	None	215 W BEAMER ST	None	WOODLAND	CA	95695	38.684883	-121.793848	246.1	109.01
1376565309	1376565309	1	1	HARBOR-UCLA MEDICAL CTR	28-Apr-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	H/UCLA WOMEN CLINIC N28	1000 W CARSON ST	# L4	TORRANCE	CA	90502	33.831586	-118.293386	78.2aaaa	5435.03
1407914260	1407914260	1	3	HILL COUNTRY COMM CLINIC	7-Apr-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	45	Shasta	PO BOX 228	29632 HWY 299 EAST	None	ROUND MOUNTAIN	CA	96084	40.802795	-121.939255	188.1	126.01
1437335759	1437335759	1	1	HSU, YAO W MD INC	11-May-01	Physicians (026)	PHYSICIANS	A61296	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	19	Los Angeles	None	5240 E BEVERLY BLVD	None	LOS ANGELES	CA	90022	34.031448	-118.152553	78.2d	5303.01
1467490425	1467490425	1	1	HARBOR COMMUNITY CLINIC	25-Nov-05	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	None	593 W 6TH ST	None	SAN PEDRO	CA	90731	33.738769	-118.289996	78.2p	2966
1477692408	1477692408	1	1	HAWTHORNE MORNINGSIDE	4-Feb-05	Physicians Group (022)	PHYSICIANS GROUP	FNP028545	8	Family Practice	In state provider	19	Los Angeles	MEDICAL CLINIC	12954 HAWTHORNE BLVD	STE 104	HAWTHORNE	CA	90250	33.914542	-118.352355	78.2bbbb	6024.03
1497761324	1497761324	1	1	HUMPHREY COMPREHENSIVE	28-Apr-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	HUMPHREY FAMILY PLANNING	5850 S MAIN ST	None	LOS ANGELES	CA	90003	33.988724	-118.273922	78.2ggg	2392.02
1528084878	1528084878	1	1	HAN, ABRAHAM P MD	14-Jun-01	Physicians (026)	PHYSICIANS	G00072378	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	19	Los Angeles	None	1850 S AZUSA AVE	STE 309	HACIENDA HEIGHTS	CA	91745	33.988954	-117.93232	78.2pp	4086.28
1568481174	1568481174	1	1	HAKIMIAN, EBRAHIM MD	29-Apr-97	Physicians (026)	PHYSICIANS	A00048918	1	General Practice	In state provider	19	Los Angeles	None	14649 VICTORY BLVD	STE 22	VAN NUYS	CA	91411	34.186653	-118.452161	78.2cc	1283.03
1578605390	1578605390	1	1	HANA MEDICAL GROUP	3-Jun-99	Physicians Group (022)	PHYSICIANS GROUP	A00035505	99	Unknown (on EDS claims)	In state provider	30	Orange	None	8615 KNOTT AVE	STE 3	BUENA PARK	CA	90620	33.837742	-118.011124	116a	1102.01
1629456900	1629456900	1	1	HILLCREST FAMILY HEALTH CENT	2-Dec-15	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	37	San Diego	OF SAN DIEGO INC	4094 4TH AVENUE	None	SAN DIEGO	CA	92103	32.751189	-117.161628	161b	4
1649209743	1649209743	1	1	HOLLYWOOD CROSS MEDICAL	28-Apr-97	Physicians Group (022)	PHYSICIANS GROUP	FNP019131	1	General Practice	In state provider	19	Los Angeles	CLINIC INC	1110 N WESTERN AVE	STE 201	LOS ANGELES	CA	90029	34.090999	-118.309191	78.2g	1909.01
1669617783	1669617783	1	1	HAYFORK COMMUNITY HLTH CLNC	3-Jan-11	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	53	Trinity	None	6961 HIGHWAY 3	None	HAYFORK	CA	96041	40.504781	-123.175191	225	3
1669657219	1669657219	1	1	HEALTH CENTER ROCKLIN CAMPUS	27-Oct-08	Exempt from Licensure Clinics (045)	CLINIC EXEMP FROM LICENSURE	None	99	Unknown (on EDS claims)	In state provider	31	Placer	COLLEGE DISTRICT	5100 SIERRA COLLEGE BLVD	None	ROCKLIN	CA	95677	38.793975	-121.205752	121.2	206.02
1669799896	1669799896	1	1	HUNTINGTON PARK FAMILY	5-Aug-11	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	HEALTH CENTER (SCFHC)	2680 SATURN AVE	STE 110, 220 & 280	HUNTINGTON PARK	CA	90225	33.97674	-118.22288	None	None
1700087590	1700087590	1	1	HIGHLAND HOSPITAL	1-Mar-97	County Hospital Outpatient (061)	COUNTY HOSPITAL OUTPATIENT	140000046	99	Unknown (on EDS claims)	In state provider	1	Alameda	None	1411 E 31ST ST	None	OAKLAND	CA	94602	37.799262	-122.231207	2c	4057
1720269194	1720269194	1	1	HEALTH CARE ANGELS MEDICAL	16-Jun-98	Physicians (026)	PHYSICIANS	A00064183	1	General Practice	In state provider	19	Los Angeles	CLINIC INC	9146 SEPULVEDA BLVD	None	NORTH HILLS	CA	91343	34.236181	-118.46745	78.2kk	1171.01
1730363151	1730363151	1	1	HEALTHRIGHT 360	25-Feb-10	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	38	San Francisco	None	1563 MISSION ST	5TH FL	SAN FRANCISCO	CA	94103	37.773185	-122.418346	162a	177
1760427843	1760427843	1	1	HEALTHRIGHT 360	17-Aug-00	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	38	San Francisco	None	558 CLAYTON ST	None	SAN FRANCISCO	CA	94117	37.770203	-122.44867	162g	166
1770597270	1770597270	1	1	HWANG, JIUNN-BOR MD INC	28-Apr-97	Physicians (026)	PHYSICIANS	A00030755	0	General Practioner (Dentists Only)	In state provider	19	Los Angeles	None	850 S ATLANTIC BLVD	STE 204	MONTEREY PARK	CA	91754	34.051118	-118.13798	78.2nn	4820.02
1811032436	1811032436	1	1	HAWAIIAN GARDENS HLTH CT	17-May-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	HAWAIIAN GARDENS HLTH CT	22310 WARDHAM AVE	None	HAWAIIAN GARDENS	CA	90716	33.826186	-118.06523	78.2n	5552.12
1841437241	1841437241	1	1	H STREET CLINIC INC	16-Jul-15	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	36	San Bernardino	None	1329 NORTH H ST	None	SAN BERNARDINO	CA	92405	34.123981	-117.300904	151g	55
1841612082	1841612082	1	1	HI-DESERT FAMILY HEALTH CLIN	4-May-16	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	36	San Bernardino	CARE DISTRICT	58375 29 PALMS HIGHWAY	None	YUCCA VALLEY	CA	92284	34.125044	-116.409008	144.2	104.11
1851552434	1851552434	1	1	HERNANDEZ, JESUS N MD INC	9-Apr-02	Physicians (026)	PHYSICIANS	A00030246	99	Unknown (on EDS claims)	In state provider	30	Orange	None	1211 W LA PALMA AVENUE	STE 609	ANAHEIM	CA	92801	33.847148	-117.934634	116l	866.01
1891811907	1891811907	1	1	HAZEL HAWKINS MEM HOSP	4-Jan-10	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	35	San Benito	None	301 THE ALAMEDA	STE B3	SAN JUAN BAUTISTA	CA	95045	36.841377	-121.533923	140	2
1922033547	1922033547	1	1	HOLLYWOOD PRESBYTERIAN MED	1-Jan-05	Community Hosp Outpatient (015)	COMMUNITY OUTPATIENT HOSPITAL	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	CENTER LP	1300 N VERMONT AVE	None	LOS ANGELES	CA	90027	34.095557	-118.291741	78.2g	1913.02
1942294285	1942294285	1	1	HORTA, ELISA E MD, MPH	28-Apr-06	Physicians (026)	PHYSICIANS	G00072518	8	Family Practice	In state provider	57	Yolo	PROFESSIONAL MED CORP	2050 LYNDELL TERRACE	STE 150	DAVIS	CA	95616	38.56247	-121.769173	244	105.05
1952705725	1952705725	1	1	HEALING HAND FAMILY CARE CLI	1-Dec-15	Physicians Group (022)	PHYSICIANS GROUP	None	1	General Practice	In state provider	33	Riverside	CLINICS CORP	82013 DR CARREON BLVD	STE M	INDIO	CA	92201	33.707433	-116.233611	128	455.01