Table family_pact_providers_profile_cy_2021

Table: family_pact_providers_profile_cy_2021_2022 , 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_desc	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	14Sep2018	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	30	Orange	INC	1100 B N. TUSTIN AVE	SUITES A, D, F	SANTA ANA	CA	927053509	33.751117	-117.836388	116h	754.03
1013156520	1013156520	1	1	HULL, JANICE L MD INC	01Nov2002	026	PHYSICIANS	A00080999	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	19	Los Angeles	None	8475 S VAN NESS AVE	SUITE 101	INGLEWOOD	CA	903051566	33.960868	-118.317759	None	None
1033235973	1033235973	1	1	HAZEL HAWKINS MEMORIAL	04Jan2010	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	35	San Benito	HEALTH CLINIC	930 SUNSET DR	BUILDING 3	HOLLISTER	CA	950235620	36.835100	-121.385743	140	6
1104991744	1104991744	1	1	HUMBOLDT STATE UNIVERSTY	18Jun2007	045	CLINIC EXEMP FROM LICENSURE	CLF1419	None	UNKNOWN	In state provider	12	Humboldt	STUDENT HLTH CENTER	PLAZA AVENUE	NEAR LIBRARY CIRCLE	ARCATA	CA	955218299	40.874139	-124.081652	39	10
1114031051	1114031051	1	1	HEMET FAMILY CARE CENTER	01Mar1997	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	33	Riverside	None	880 N STATE ST	None	HEMET	CA	925431459	33.761717	-116.971874	132	435.07
1124130620	1124130620	2	1	HARMONY HEALTH MEDICAL	12Aug2015	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	In state provider	58	Yuba	CLINIC & FAMILY RESOURCE	1908 N BEALE ROAD	SUITE E	MARYSVILLE	CA	959016937	39.127859	-121.545877	249	403.01
1144385766	1144385766	1	2	HY PHUNG NGO MD INC	22Oct2008	026	PHYSICIANS	A00069736	None	UNKNOWN	In state provider	19	Los Angeles	None	5801 S FIGUEROA STREET	None	LOS ANGELES	CA	900031016	33.989727	-118.282663	78.2ggg	2327
1144760943	1144760943	1	1	HURTT FAMILY HEALTH CLINIC,	21May2018	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	30	Orange	INC	947 S ANAHEIM BLVD	SUITE 260	ANAHEIM	CA	928055582	33.822047	-117.909480	116l	874.05
1164557815	1164557815	1	1	HEALTH CENTER #3	01Mar1997	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	In state provider	38	San Francisco	None	1525 SILVER AVE	None	SAN FRANCISCO	CA	941341229	37.732483	-122.405640	162f	257.01
1164728788	1164728788	1	1	HESPERIA CLINICA MEDICA	08Nov2012	022	PHYSICIANS GROUP	None	None	UNKNOWN	In state provider	36	San Bernardino	FAMILIAR A MEDICAL CORP	15888 MAIN STREET	SUITE 112B	HESPERIA	CA	923453467	34.423632	-117.315930	145.1a	100.19
1205465747	1205465747	1	2	HEALING GROVE HEALTH CENTER	20Apr2020	022	PHYSICIANS GROUP	None	None	UNKNOWN	In state provider	43	Santa Clara	None	226 W ALMA AVE	SUITE 10	SAN JOSE	CA	951103520	37.313128	-121.878658	183d	5031.13
1255435533	1255435533	1	1	HUMBOLDT OPEN DOOR CLIN	01Mar1997	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	12	Humboldt	None	770 10TH ST	None	ARCATA	CA	955216210	40.869801	-124.086240	39	10
1306965587	1306965587	1	1	HURTT FAMILY HEALTH CLINIC,	13May2010	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	30	Orange	INC	1 HOPE DR	None	TUSTIN	CA	927820221	33.741803	-117.786753	116v	756.07
1366592982	1366592982	1	1	H JOSEPH KHAN M D INC	22May2000	022	PHYSICIANS GROUP	FNP027745	None	UNKNOWN	In state provider	30	Orange	PARAMOUNT CARE MED	1629 W 17TH ST	STE A&B	SANTA ANA	CA	927063335	33.760086	-117.890487	116h	753.02
1407914260	1407914260	1	3	HILL COUNTRY COMM CLINIC	07Apr1997	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	In state provider	45	Shasta	PO BOX 228	29632 HWY 299 EAST	None	ROUND MOUNTAIN	CA	960840000	40.802795	-121.939255	188.1	126.01
1417082165	1417082165	1	1	HEALTH CENTER #2	01Mar1997	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	In state provider	38	San Francisco	None	1301 PIERCE ST	None	SAN FRANCISCO	CA	941154005	37.781964	-122.435815	162g	158.01
1437335759	1437335759	1	1	HSU, YAO W MD INC	01Oct1999	026	PHYSICIANS	A61296	None	UNKNOWN	In state provider	19	Los Angeles	None	5240 E BEVERLY BLVD	None	LOS ANGELES	CA	900222002	34.031448	-118.152553	78.2d	5303.01
1467490425	1467490425	1	1	HARBOR COMMUNITY CLINIC	25Nov2005	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	19	Los Angeles	None	593 W 6TH ST	None	SAN PEDRO	CA	907312521	33.738769	-118.289996	78.2p	2966
1477692408	1477692408	1	1	HAWTHORNE MORNINGSIDE MEDICA	30Oct2001	022	PHYSICIANS GROUP	FNP028545	None	UNKNOWN	In state provider	19	Los Angeles	L CLINIC	15901 HAWTHORNE BLVD	SUITE 250	LAWNDALE	CA	902609025	33.886420	-118.352682	78.2iiii	6040.01
1497840656	1497840656	1	1	HUMBOLDT OPEN DOOR CLN	01Mar1997	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	08	Del Norte	DEL NORTE COMM HLTH CTR	550 E WASHINGTON BLVD	STE 100	CRESCENT CITY	CA	955318342	41.772734	-124.198201	19	1.04
1528084878	1528084878	1	1	HAN, ABRAHAM P MD	01Sep1991	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	917456854	33.988954	-117.932320	78.2pp	4086.28
1538141627	1538141627	1	1	HANFORD COMMUNITY HOSPITAL	01Dec1977	016	COMMUNITY INPATIENT HOSPITAL	550001439	None	UNKNOWN	In state provider	16	Kings	None	115 MALL DRIVE	None	HANFORD	CA	932303513	36.327307	-119.668471	69	10.02
1538180245	1538180245	1	1	HEALTH AND LIFE	30Nov2009	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	34	Sacramento	ORGANIZATION INC	2200 DEL PASO BLVD	None	SACRAMENTO	CA	958153102	38.610077	-121.450815	139j	69
1578605390	1578605390	1	1	HANA MEDICAL GROUP	01Oct1994	022	PHYSICIANS GROUP	A00035505	None	UNKNOWN	In state provider	30	Orange	None	8615 KNOTT AVE	STE 3	BUENA PARK	CA	906203886	33.837742	-118.011124	116a	1102.01
1679691810	1679691810	1	1	HOLLYWOOD SUNSET FREE CL	07Feb1997	040	FREE CLINIC	ZZT11942	None	UNKNOWN	In state provider	19	Los Angeles	None	3324 W SUNSET BLVD	None	LOS ANGELES	CA	900262190	34.086732	-118.275453	78.2a	1954
1700911765	1700911765	1	1	HEALTH CENTER #1	01Mar1997	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	In state provider	38	San Francisco	None	3850 17TH ST	None	SAN FRANCISCO	CA	941142031	37.762703	-122.431844	162g	203
1730363151	1730363151	1	1	HEALTHRIGHT 360	25Feb2010	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	38	San Francisco	None	1563 MISSION ST	5TH FL	SAN FRANCISCO	CA	941032543	37.773185	-122.418346	162a	177
1841437241	1841437241	1	1	H STREET CLINIC INC	16Jul2015	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	36	San Bernardino	None	1329 NORTH H ST	None	SAN BERNARDINO	CA	924055039	34.123981	-117.300904	151g	55
1841437241	1841437241	1	4	H STREET CLINIC INC	24Jun2021	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	33	Riverside	INTERMITTENT	1490 1494 W SIXTH ST	None	COACHELLA	CA	922361712	33.678788	-116.176549	128	457.07
1891811907	1891811907	1	1	HAZEL HAWKINS HEALTH CLN	04Jan2010	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	35	San Benito	None	301 THE ALAMEDA	STE B3	SAN JUAN BAUTISTA	CA	950459746	36.841377	-121.533923	140	2
1942256094	1942256094	1	1	HUNTINGTON PARK CLINICA MEDI	05Mar1996	027	PODIATRISTS	None	None	UNKNOWN	In state provider	19	Los Angeles	MEDICA GENERAL, MED CNTR	6347 PACIFIC BLVD	None	HUNTINGTON PARK	CA	902554101	33.982689	-118.225228	78.2ccc	5326.05
1942294285	1942294285	1	1	HORTA, ELISA E MD, MPH	25May2004	026	PHYSICIANS	G00072518	None	UNKNOWN	In state provider	57	Yolo	PROFESSIONAL MED CORP	2050 LYNDELL TERRACE	STE 150	DAVIS	CA	956166206	38.562470	-121.769173	244	105.05