Table: primary_care_shortage_areas , mssa_name like N*

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
Los Angeles	76.1b	Newhall/Santa Clarita East/Valencia	120793	35	17.3	48	2516.5	4	13144	0.109	2	6	Yes	1/30/2020
Los Angeles	78.2bb	North Hollywood Central and North	98953	21.5	18.2	35.2	2811.2	4	23661	0.239	4	8	Yes	1/30/2020
Los Angeles	78.2iii	North Long Beach	93251	10	7.6	15.7	5939.6	5	20546	0.22	4	9	Yes	1/30/2020
Los Angeles	78.2jjjj	Norwalk/Studebaker	105912	48.5	15.2	59.9	1768.1	2	14967	0.141	2	4	No	1/30/2020
Los Angeles	78.2kk	North Hills/Northridge North	116589	59.5	19.2	73.9	1577.7	2	21014	0.18	3	5	Yes	1/30/2020
Los Angeles	78.2zz	Northridge South/Reseda North	114038	313	45	346.7	328.9	0	20393	0.179	3	3	No	1/30/2020
Napa	112.1	Napa Central	63398	68	22.3	84.7	748.5	0	5046	0.08	1	1	No	1/30/2020
Napa	112.2	Napa Northeast/Rutherford/Yountville	31661	39	14.6	49.9	634.5	0	2337	0.074	1	1	No	1/30/2020
Nevada	114	North Bloomfield/North San Juan/Truckee	20421	19	9.9	26.4	773.5	0	1926	0.094	1	1	No	1/30/2020
Santa Clara	183i	New Almaden/San Jose Southwest	110607	182	20.9	197.6	559.8	0	4867	0.044	0	0	No	1/30/2020
Sutter	217	Nicolaus/Pleasant Grove	2540	0	0	0	None	5	252	0.099	1	6	Yes	1/30/2020