Table: primary_care_shortage_areas , mssa_name like S*

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	2g	San Leandro West/San Lorenzo West/Hayward West	102435	159.5	28.1	180.5	567.5	0	9938	0.097	1	1	No	1/30/2020
El Dorado	24	South Lake Tahoe	29312	12	9.3	18.9	1550.9	2	3862	0.132	2	4	No	1/30/2020
Kern	58.1	Shafter	20570	7.5	6.3	12.2	1686.1	2	5177	0.252	5	7	Yes	1/30/2020
Lassen	72	Susanville	15662	18	13.3	28	559.4	0	2394	0.153	3	3	No	1/30/2020
Los Angeles	78.2ggg	South Central Northeast	133713	26.8	68.3	78.1	1712.1	2	43436	0.325	5	7	Yes	1/30/2020
Los Angeles	78.2jj	Sherman Oaks/Studio City/Valley Village	134833	94	32.1	118	1142.7	1	10798	0.08	1	2	No	1/30/2020
Los Angeles	78.2k	South Central Northwest	78614	4	6	8.5	9248.7	5	17789	0.226	4	9	Yes	1/30/2020
Los Angeles	78.2kkkk	Santa Monica Central/Sawtelle/West Los Angeles	87942	308.5	49.3	345.4	254.6	0	10060	0.114	2	2	No	1/30/2020
Los Angeles	78.2s	South Central Southwest	91354	7	2.7	9	10150.4	5	33736	0.369	5	10	Yes	1/30/2020
Modoc	99	Surprise Valley	1102	0	0	0	None	5	172	0.156	3	8	Yes	1/30/2020
Monterey	109.2	Salinas/Spreckels	153612	200	46.8	235.1	653.4	0	26549	0.173	3	3	No	1/30/2020
Orange	116b	Santa Ana Central	112026	68	16.5	80.4	1393.4	1	29637	0.265	5	6	Yes	1/30/2020
Orange	116g	Santa Ana South	119730	83	48	119	1006.1	1	18443	0.154	3	4	No	1/30/2020
San Joaquin	168	South Woodbridge/Thornton	25731	1	2.3	2.7	9530	5	2448	0.095	1	6	Yes	1/30/2020
San Joaquin	169a	Stockton North Central/Stockton Northeast	99032	138.3	43.5	170.9	579.5	0	24901	0.251	5	5	Yes	1/30/2020
San Joaquin	169c	Stockton Northwest/Stockton West	87191	52.5	19.9	67.4	1293.6	1	13733	0.158	3	4	No	1/30/2020
San Luis Obispo	172	San Luis Obispo	54673	115	43.3	147.5	370.7	0	15938	0.292	5	5	Yes	1/30/2020
Santa Clara	183c	Sunnyvale South	97454	71	18.9	85.2	1143.8	1	5720	0.059	1	2	No	1/30/2020
Santa Clara	183h	San Jose Southeast	138680	56	11.3	64.5	2150.1	3	16884	0.122	2	5	Yes	1/30/2020
Santa Clara	183j	San Jose Northwest	94493	378	56.2	420.1	224.9	0	12386	0.131	2	2	No	1/30/2020
Santa Clara	183n	Santa Clara South and West	129190	78	12.9	87.7	1473.1	1	8900	0.069	1	2	No	1/30/2020
Sonoma	210.1	Santa Rosa	196357	341	141.9	447.4	438.9	0	22354	0.114	2	2	No	1/30/2020
Stanislaus	212.3	Salida	26803	0	0.3	0.2	134015	5	3836	0.143	2	7	Yes	1/30/2020
Tulare	232	Springville	5586	1	0.7	1.5	3724	5	1065	0.191	3	8	Yes	1/30/2020
Ventura	240a	Simi Valley East	93391	54.5	14.9	65.7	1421.5	1	5616	0.06	1	2	No	1/30/2020
Ventura	240c	Simi Valley West/Thousand Oaks East	86823	46	4.6	49.5	1754	2	4623	0.053	1	3	No	1/30/2020