Table: family_pact_providers_profile_cys_2020_2021 , 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	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
1003250093	1003250093	1	1	Hurtt Family Health Clinic	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	30	Orange	INC	1100 B N. Tustin Ave	Suites A, D, F	Santa Ana	CA	92705-3509	(714) 247-0300	33.751117	-117.836388	116h	754.03
1013156520	1013156520	1	1	Hull, Janice L Md Inc	27-Jan-11	26	PHYSICIANS	A00080999	16	Obstetrics-Gynecology (M.D. Only) Neonatal	0	In state provider	19	Los Angeles	None	8475 S Van Ness Ave	Suite 101	Inglewood	CA	90305-1566	(323) 778-7990	33.960868	-118.317759	None	None
1033235973	1033235973	1	1	Hazel Hawkins Memorial	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	35	San Benito	HEALTH CLINIC	930 Sunset Dr	Building 3	Hollister	CA	95023-5620	(831) 636-2664	36.8351	-121.385743	140	6
1104991744	1104991744	1	1	Humboldt State Universty	26-Sep-07	45	CLINIC EXEMP FROM LICENSURE	CLF1419	None	UNKNOWN	0	In state provider	12	Humboldt	STUDENT HLTH CENTER	Plaza Avenue	Near Library Circle	Arcata	CA	95521-8299	(707) 826-3146	40.874139	-124.081652	39	10
1114031051	1114031051	1	1	Hemet Family Care Center	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	33	Riverside	None	880 N State St	None	Hemet	CA	92543-1459	(951) 766-2450	33.761717	-116.971874	132	435.07
1124130620	1124130620	2	1	Harmony Health Medical	21-Mar-16	58	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	58	Yuba	CLINIC & FAMILY RESOURCE	1908 N Beale Road	Suite E	Marysville	CA	95901-6937	(530) 743-6888	39.127859	-121.545877	249	403.01
1144385766	1144385766	1	2	Hy Phung Ngo Md Inc	23-Dec-08	26	PHYSICIANS	A00069736	41	Internal Medicine	0	In state provider	19	Los Angeles	None	5801 S Figueroa Street	None	Los Angeles	CA	90003-1016	(323) 971-3883	33.989727	-118.282663	78.2ggg	2327
1144557539	1144557539	1	1	Henawi, I Md Inc	22-Apr-10	26	PHYSICIANS	A00062143	1	General Practice	0	In state provider	33	Riverside	None	4020 W Florida Ave	None	Hemet	CA	92545-5279	(951) 765-5000	33.745223	-117.015231	132	435.04
1144760943	1144760943	1	1	Hurtt Family Health Clinic,	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	30	Orange	INC	947 S Anaheim Blvd	Suite 260	Anaheim	CA	92805-5582	(714) 247-0300	33.822047	-117.90948	116l	874.05
1164557815	1164557815	1	1	Health Center #3	1-Mar-97	58	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	38	San Francisco	None	1525 Silver Ave	None	San Francisco	CA	94134-1229	(415) 715-0310	37.732483	-122.40564	162f	257.01
1164728788	1164728788	1	1	Hesperia Clinica Medica	30-May-13	22	PHYSICIANS GROUP	None	8	Family Practice	0	In state provider	36	San Bernardino	FAMILIAR A MEDICAL CORP	15888 Main Street	Suite 112b	Hesperia	CA	92345-3467	(760) 948-2242	34.423632	-117.31593	145.1a	100.19
1205076536	1205076536	1	1	Hazel Hawkins Memorial	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	35	San Benito	HOSPITAL	321 1st Street	None	Hollister	CA	95023-3712	(831) 638-1652	36.855669	-121.402339	140	4
1205465747	1205465747	1	2	Healing Grove Health Center	1-Jan-21	22	PHYSICIANS GROUP	None	None	UNKNOWN	0	In state provider	43	Santa Clara	None	226 W Alma Ave	Suite 10	San Jose	CA	95110-3520	(408) 583-6338	37.313128	-121.878658	183d	5031.13
1255435533	1255435533	1	1	Humboldt Open Door Clin	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	12	Humboldt	None	770 10th St	None	Arcata	CA	95521-6210	(707) 826-8610	40.869801	-124.08624	39	10
1366592982	1366592982	1	1	H Joseph Khan M D Inc	26-Dec-00	22	PHYSICIANS GROUP	FNP027745	8	Family Practice	0	In state provider	30	Orange	PARAMOUNT CARE MED	1629 W 17th St	Ste A&b	Santa Ana	CA	92706-3335	(714) 647-1300	33.760086	-117.890487	116h	753.02
1407914260	1407914260	1	3	Hill Country Comm Clinic	15-Oct-97	58	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	45	Shasta	PO BOX 228	29632 Hwy 299 East	None	Round Mountain	CA	96084-0000	(916) 337-6243	40.802795	-121.939255	188.1	126.01
1417082165	1417082165	1	1	Health Center #2	1-Mar-97	58	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	38	San Francisco	None	1301 Pierce St	None	San Francisco	CA	94115-4005	(415) 292-1300	37.781964	-122.435815	162g	158.01
1437335759	1437335759	1	1	Hsu, Yao W Md Inc	28-Apr-08	26	PHYSICIANS	A61296	16	Obstetrics-Gynecology (M.D. Only) Neonatal	0	In state provider	19	Los Angeles	None	5240 E Beverly Blvd	None	Los Angeles	CA	90022-2002	(323) 727-9904	34.031448	-118.152553	78.2d	5303.01
1467490425	1467490425	1	1	Harbor Community Clinic	6-Mar-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	19	Los Angeles	None	593 W 6th St	None	San Pedro	CA	90731-2521	(310) 547-0202	33.738769	-118.289996	78.2p	2966
1477692408	1477692408	1	1	Hawthorne Morningside	2-Apr-03	22	PHYSICIANS GROUP	FNP028545	8	Family Practice	0	In state provider	19	Los Angeles	MEDICAL CLINIC	12954 Hawthorne Blvd	Ste 104	Hawthorne	CA	90250-4418	(310) 679-0269	33.914542	-118.352355	78.2bbbb	6024.03
1497840656	1497840656	1	1	Humboldt Open Door Cln	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	8	Del Norte	DEL NORTE COMM HLTH CTR	550 E Washington Blvd	Ste 100	Crescent City	CA	95531-8342	(707) 465-6925	41.772734	-124.198201	19	1.04
1528084878	1528084878	1	1	Han, Abraham P Md	28-Aug-92	26	PHYSICIANS	G00072378	16	Obstetrics-Gynecology (M.D. Only) Neonatal	0	In state provider	19	Los Angeles	None	1850 S Azusa Ave	Ste 309	Hacienda Heights	CA	91745-6854	(818) 810-5998	33.988954	-117.93232	78.2pp	4086.28
1538141627	1538141627	1	1	Hanford Community Hospital	19-Dec-79	16	COMMUNITY INPATIENT HOSPITAL	550001439	None	UNKNOWN	0	In state provider	16	Kings	None	115 Mall Drive	None	Hanford	CA	93230-3513	(559) 582-9000	36.327307	-119.668471	69	10.02
1538180245	1538180245	1	1	Health And Life	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	34	Sacramento	ORGANIZATION INC	2200 Del Paso Blvd	None	Sacramento	CA	95815-3102	(916) 642-1867	38.610077	-121.450815	139j	69
1578605390	1578605390	1	1	Hana Medical Group	13-Oct-95	22	PHYSICIANS GROUP	A00035505	None	UNKNOWN	0	In state provider	30	Orange	None	8615 Knott Ave	Ste 3	Buena Park	CA	90620-3886	(714) 527-4833	33.837742	-118.011124	116a	1102.01
1679691810	1679691810	1	1	Hollywood Sunset Free Cl	7-Feb-97	40	FREE CLINIC	ZZT11942	None	UNKNOWN	0	In state provider	19	Los Angeles	None	3324 W Sunset Blvd	None	Los Angeles	CA	90026-2190	(213) 660-2400	34.086732	-118.275453	78.2a	1954
1700911765	1700911765	1	1	Health Center #1	1-Mar-97	58	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	38	San Francisco	None	3850 17th St	None	San Francisco	CA	94114-2031	(415) 487-7500	37.762703	-122.431844	162g	203
1730363151	1730363151	1	1	Healthright 360	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	38	San Francisco	None	1563 Mission St	5th Fl	San Francisco	CA	94103-2543	(415) 746-1940	37.773185	-122.418346	162a	177
1740336734	1740336734	1	1	Health And Life	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	34	Sacramento	ORGANIZATION INC	7275 E Southgate Dr	Ste 204-206	Sacramento	CA	95823-2628	(916) 642-1867	38.493421	-121.437707	139k	50.02
1841437241	1841437241	1	1	H Street Clinic Inc	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	36	San Bernardino	None	1329 North H St	None	San Bernardino	CA	92405-5039	(909) 381-0803	34.123981	-117.300904	151g	55
1942256094	1942256094	1	1	Huntington Park Clinica	9-Oct-21	27	PODIATRISTS	None	None	UNKNOWN	0	In state provider	19	Los Angeles	MEDICA GENERAL, MED CNTR	6347 Pacific Blvd	None	Huntington Park	CA	90255-4101	(323) 583-8383	33.982689	-118.225228	78.2ccc	5326.05
1942294285	1942294285	1	1	Horta, Elisa E Md, Mph	25-May-04	26	PHYSICIANS	G00072518	16	Obstetrics-Gynecology (M.D. Only) Neonatal	0	In state provider	57	Yolo	PROFESSIONAL MED CORP	2050 Lyndell Terrace	Ste 150	Davis	CA	95616-6206	(530) 758-1563	38.56247	-121.769173	244	105.05