Table: primary_care_shortage_areas , mssa_name like F*

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	2d	Fruitvale/Melrose/Oakland Airport	135406	42.5	48.2	78.7	1720.5	2	31323	0.231	4	6	Yes	1/30/2020
Alameda	2i	Fremont South/Mission San Jose/Newark South/Warm Springs	96094	25	10.3	32.7	2938.7	4	3732	0.039	0	4	No	1/30/2020
Alameda	2l	Fremont East/Niles/Union City Central	122221	97	25.1	115.8	1055.4	1	6483	0.053	1	2	No	1/30/2020
Fresno	25	Firebaugh/Mendota	22027	2	3.6	4.7	4686.6	5	8444	0.383	5	10	Yes	1/30/2020
Fresno	35a	Fresno Northwest	138199	90.3	84.8	153.9	898	0	13221	0.096	1	1	No	1/30/2020
Fresno	35c	Fresno West Central	83009	59.8	104.2	138	601.5	0	31479	0.379	5	5	Yes	1/30/2020
Fresno	35d	Fresno East Central	95655	15.3	17.9	28.7	3332.9	5	39336	0.411	5	10	Yes	1/30/2020
Fresno	35e	Fresno South and West	93102	4	10	11.5	8095.8	5	33853	0.364	5	10	Yes	1/30/2020
Fresno	35f	Fresno North Central	79673	100.3	83.7	163.1	488.5	0	20086	0.252	5	5	Yes	1/30/2020
Humboldt	42	Ferndale/Fortuna/Rio Dell/Scotia	25659	8	13	17.7	1449.7	1	3813	0.149	2	3	No	1/30/2020
Kern	57.1	Fort Tejon/Frazier Park/Lebec/Pine Mountain	8351	0.5	0	0.5	16702	5	1705	0.204	4	9	Yes	1/30/2020
Los Angeles	78.2fff	Firestone/Florence South/Watts	136403	44	15.9	55.9	2440.1	3	47328	0.347	5	8	Yes	1/30/2020
Mendocino	89	Fort Bragg/Westport	11484	8.3	9.3	15.2	755.5	0	2069	0.18	3	3	No	1/30/2020
Orange	116f	Fullerton Central and South	106134	103	44.5	136.4	778.1	0	16342	0.154	3	3	No	1/30/2020
Orange	116j	Fountain Valley/Huntington Beach Central	80319	162.5	46.5	197.4	406.9	0	7435	0.093	1	1	No	1/30/2020
Orange	116v	Foothill Ranch/IrvineNortheast/Lake Forest West/Portola Hills/Tustin East	132093	36	19.9	50.9	2595.1	4	10788	0.082	1	5	Yes	1/30/2020
Placer	120	Foresthill	6534	1	0	1	6534	5	626	0.096	1	6	Yes	1/30/2020
Riverside	131b	French Valley/Murrieta East/Temecula/Winchester	160430	50	26.5	69.9	2295.1	3	13653	0.085	1	4	No	1/30/2020
Sacramento	139e	Folsom/Orangevale	110552	72	49.1	108.8	1016.1	1	7059	0.064	1	2	No	1/30/2020
Sacramento	139f	Florin/Fruitridge/Oak Park/Parkway/South Sacramento	124342	363	86.4	427.8	290.7	0	35349	0.284	5	5	Yes	1/30/2020
Sacramento	139k	Freeport/Meadowview	87716	23	20.6	38.5	2278.3	3	22445	0.256	5	8	Yes	1/30/2020
San Bernardino	151e	Fontana North/Rancho Cucamonga Northwest/Rialto Northeast	198013	34	42.4	65.8	3009.3	5	14496	0.073	1	6	Yes	1/30/2020
San Bernardino	151h	Fontana Central/Rialto Central	137445	54	24.2	72.2	1903.7	2	29571	0.215	4	6	Yes	1/30/2020
San Joaquin	165	Farmington/Linden	6215	1	0	1	6215	5	534	0.086	1	6	Yes	1/30/2020
San Joaquin	169b	French Camp/Stockton South/Stockton Southeast	136198	84.5	29.4	106.6	1277.7	1	37832	0.278	5	6	Yes	1/30/2020
San Mateo	176f	Foster City/Redwood Shores/San Mateo East	97273	82	19.3	96.4	1009.1	1	7322	0.075	1	2	No	1/30/2020
Santa Cruz	184	Freedom/Watsonville	55777	60	21.1	75.8	735.8	0	8662	0.155	3	3	No	1/30/2020
Solano	202b	Fairfield	113641	204	39.3	233.5	486.7	0	13849	0.122	2	2	No	1/30/2020
Sonoma	207	Forestville/Fort Ross/Guerneville/Jenner/Monte Rio/Occidental/Sea Ranch	25111	11	9.3	18	1395.1	1	3271	0.13	2	3	No	1/30/2020
Trinity	225	Forest Glen/Hayfork/Hyampom/Peanut	2982	0.5	1	1.3	2293.8	3	613	0.206	4	7	Yes	1/30/2020
Tulare	233	Farmersville/Goshen/Visalia	151207	61	95	132.2	1143.8	1	33595	0.222	4	5	Yes	1/30/2020
Ventura	237	Fillmore/Los Padres National Forest/Piru/Santa Paula/Saticoy	68291	34	23.2	51.4	1328.6	1	11462	0.168	3	4	No	1/30/2020