Table: primary_care_shortage_areas , mssa_name like P*

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
Amador	5	Plymouth	4490	0.5	0	0.5	8980	5	354	0.079	1	6	Yes	1/30/2020
Amador	6	Pioneer	5671	0.5	1.3	1.5	3780.7	5	678	0.12	2	7	Yes	1/30/2020
Los Angeles	77.1a	Palmdale Central	101863	21	17.6	34.2	2978.5	4	19573	0.192	3	7	Yes	1/30/2020
Los Angeles	78.2b	Pico-Union	149479	66	20.9	81.7	1829.6	2	54189	0.363	5	7	Yes	1/30/2020
Los Angeles	78.2mm	Pasadena South/San Marino/South Pasadena	104431	231.5	55.7	273.3	382.1	0	9991	0.096	1	1	No	1/30/2020
Los Angeles	78.2ooo	Paramount North/Willowbrook	140392	31	24.1	49	2865.1	4	33653	0.24	4	8	Yes	1/30/2020
Los Angeles	78.2ppp	Pacoima East/Sun Valley West	104683	21	9.3	28	3738.7	5	20351	0.194	3	8	Yes	1/30/2020
Los Angeles	78.2ss	Pomona East and South	116575	48.3	48.1	84.4	1381.2	1	26465	0.227	4	5	Yes	1/30/2020
Los Angeles	78.2ww	Pico Rivera/Santa Fe Springs Northwest	100417	46	19.2	60.4	1662.5	2	10957	0.109	2	4	No	1/30/2020
Mendocino	93.3	Potter Valley	1896	0	0	0	None	5	411	0.217	4	9	Yes	1/30/2020
San Diego	153.1	Pala/Pauma Valley	7361	0	0.3	0.2	36805	5	1069	0.145	2	7	Yes	1/30/2020
San Diego	161q	Poway Central/Poway Grove/Rancho Bernardo Southwest/Sabre Springs	81106	109	33.2	133.9	605.7	0	5063	0.062	1	1	No	1/30/2020
San Mateo	175.3	Pacifica/Rockaway Beach/San Pedro Terrace/Sharp Park/Vallemar	38910	2	1	2.8	13896.4	5	1918	0.049	0	5	Yes	1/30/2020
Shasta	189.1	Palo Cedro	4338	0	0.7	0.5	8676	5	383	0.088	1	6	Yes	1/30/2020
Sonoma	209.1	Petaluma	136851	62	42.9	94.2	1452.8	1	15477	0.113	2	3	No	1/30/2020
Tehama	219	Paskenta/Rancho Tehama	4778	0	1	0.8	5972.5	5	1126	0.236	4	9	Yes	1/30/2020