Table: primary_care_shortage_areas , mssa_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  *

mssa_county	mssa_id	mssa_name	total_population	est_physicians	est_fnppa	est_providers	provider_ratio	score_provider_ratio	pop_100fpl	pct_100fpl	score_poverty	score_total	pcsa	effective_date
Alameda	2n	Hayward Central	119983	10	5	13.7	8757.9	5	12585	0.105	2	7	Yes	1/30/2020
Fresno	28	Huron	8016	2	1	2.7	2968.9	4	3411	0.426	5	9	Yes	1/30/2020
Glenn	36.2	Hamilton City	3886	0	0	0	None	5	653	0.168	3	8	Yes	1/30/2020
Humboldt	38	Hoopa/Willow Creek	5728	1.5	7.7	7.2	795.6	0	2199	0.384	5	5	Yes	1/30/2020
Los Angeles	78.2aaaa	Harbor Gateway South/Lomita/Torrance East Central	115735	431.5	90.5	499.4	231.7	0	14716	0.127	2	2	No	1/30/2020
Los Angeles	78.2ccc	Huntington Park/South Gate West/Walnut Park	106158	51.5	22.8	68.6	1547.5	2	25250	0.238	4	6	Yes	1/30/2020
Los Angeles	78.2f	Hollywood Hills/Hollywood West/Mount Olympus/West Hollywood	93929	271	24.2	289.1	324.9	0	12635	0.135	2	2	No	1/30/2020
Los Angeles	78.2g	Hollywood South Central/Inner Sunset	111965	745.5	65.1	794.3	141	0	26983	0.241	4	4	No	1/30/2020
Los Angeles	78.2pp	Hacienda Heights/Industry Central	102418	37	15	48.2	2124.9	3	10351	0.101	2	5	Yes	1/30/2020
Los Angeles	78.2t	Hermosa Beach/Lawndale North/Manhattan Beach/Redondo Beach North	95667	45	29.5	67.1	1425.7	1	6140	0.064	1	2	No	1/30/2020
Los Angeles	78.2x	Hancock Park/Mid-City West/Park La Brea	126217	311.5	98.9	385.7	327.2	0	14039	0.111	2	2	No	1/30/2020
Mendocino	93.5	Hopland	2275	0	0	0	None	5	415	0.182	3	8	Yes	1/30/2020
Orange	116s	Huntington Beach North/Seal Beach East/Westminster	128512	132.5	38.8	161.6	795.2	0	25310	0.197	3	3	No	1/30/2020
Orange	116t	Huntington Beach South	83242	57.5	24.9	76.2	1092.4	1	4642	0.056	1	2	No	1/30/2020
Orange	116u	Huntington Beach West/Seal Beach West	89287	38	23.9	55.9	1597.3	2	6825	0.076	1	3	No	1/30/2020
Riverside	133.2	Homeland/Lakeview/San Jacinto	32019	0	0.3	0.2	160095	5	4663	0.146	2	7	Yes	1/30/2020
San Benito	140	Hollister/Paicines/Panoche/San Juan Bautista	58318	17	9.9	24.4	2390.1	3	5670	0.097	1	4	No	1/30/2020
San Bernardino	145.1a	Hesperia West/Mountain View Acres/Victorville Central and South	185393	99	58	142.5	1301	1	40353	0.218	4	5	Yes	1/30/2020
San Bernardino	151k	Highland/San Bernardino East	119130	87.5	33.3	112.5	1058.9	1	36041	0.303	5	6	Yes	1/30/2020
Siskiyou	193	Happy Camp	1780	0	0.3	0.2	8900	5	581	0.326	5	10	Yes	1/30/2020
Stanislaus	214	Hughson	46895	11.5	6.6	16.5	2842.1	4	8916	0.19	3	7	Yes	1/30/2020