Table: primary_care_shortage_areas , mssa_name like M*

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
Butte	8	Magalia/Paradise/Stirling City	41358	19	25.2	37.9	1091.2	1	6085	0.147	2	3	No	1/30/2020
Los Angeles	78.2nn	Montebello North/Monterey Park/South San Gabriel	81952	51.5	16.9	64.1	1278.5	1	10508	0.128	2	3	No	1/30/2020
Los Angeles	78.2o	Miraleste/Palo Verdes Estates/Portuguese Bend/Rancho Palos Verdes/Rolling Hills/San Pedro West	124685	94.5	13.9	104.9	1188.6	1	8290	0.066	1	2	No	1/30/2020
Los Angeles	78.2z	Mar Vista/Ocean Park/Santa Monica South/Venice	78857	57	28.9	78.7	1002	1	10474	0.133	2	3	No	1/30/2020
Madera	80	Madera	103051	35	43.1	67.3	1531.2	2	23863	0.232	4	6	Yes	1/30/2020
Merced	97.1	Merced Central and North/Merced Southeast	76031	81	28.1	102.1	744.7	0	19290	0.254	5	5	Yes	1/30/2020
Mono	103	Mammoth Lakes	8083	13	6	17.5	461.9	0	618	0.076	1	1	No	1/30/2020
Riverside	135g	Moreno Valley	92987	7.5	12.6	17	5469.8	5	15975	0.172	3	8	Yes	1/30/2020
San Bernardino	151c	Montclair/Ontario Northwest/Upland South	129571	75.5	42.4	107.3	1207.6	1	26646	0.206	4	5	Yes	1/30/2020
San Bernardino	151g	Muscoy/San Bernardino Central	127436	74	31.4	97.5	1307	1	42806	0.336	5	6	Yes	1/30/2020
San Bernardino	151j	Mentone/Redlands South/Yucaipa	100394	111	33.9	136.4	736	0	11878	0.118	2	2	No	1/30/2020
San Diego	161v	Mira Mesa/Scripps Miramar Ranch	118493	87	23.9	104.9	1129.6	1	7465	0.063	1	2	No	1/30/2020
Santa Clara	183o	Milpitas West/Santa Clara Northeast	141747	90.5	11.3	98.9	1433.2	1	11508	0.081	1	2	No	1/30/2020
Shasta	188.2	Manton/Millville/Shingletown/Viola	6195	0.5	1	1.3	4765.4	5	845	0.136	2	7	Yes	1/30/2020
Siskiyou	199	McCloud/Tennant	1363	1.5	0.3	1.7	801.8	0	229	0.168	3	3	No	1/30/2020
Stanislaus	215a	Modesto West	81406	152.5	58.3	196.2	414.9	0	13791	0.169	3	3	No	1/30/2020
Stanislaus	215b	Modesto East	90920	85.5	31.7	109.3	831.8	0	11813	0.13	2	2	No	1/30/2020
Sutter	216	Meridian/Robbins/Yuba City	81557	81.5	34.7	107.5	758.7	0	13392	0.164	3	3	No	1/30/2020
Ventura	238	Meiners Oaks/Oak View/Ojai	31875	20	8	26	1226	1	3598	0.113	2	3	No	1/30/2020
Yuba	249	Marysville	64493	15.5	26.7	35.6	1811.6	2	12180	0.189	3	5	Yes	1/30/2020