Table: primary_care_shortage_areas , mssa_name like D*

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	2k	Dublin/Pleasanton/Santa Rita/Sunol	127835	169	44.8	202.6	631	0	5042	0.039	0	0	No	1/30/2020
Alameda	2m	Dimond/Montclair/Oakland East/Oakmore/Piedmont/Piedmont Pines/Trestle Glen	120643	390	83.9	452.9	266.4	0	11180	0.093	1	1	No	1/30/2020
Butte	7.4	Durham	5644	0	0	0	None	5	564	0.1	1	6	Yes	1/30/2020
Kern	60	Delano/McFarland	60420	43.5	14.6	54.4	1110.7	1	16363	0.271	5	6	Yes	1/30/2020
Lassen	74	Doyle	1867	0	0.3	0.2	9335	5	225	0.121	2	7	Yes	1/30/2020
Los Angeles	77.1b	Desert View Highlands/Lancaster West/Palmdale Northwest/Quartz Hill	99440	97.8	43.4	130.3	763.2	0	12856	0.129	2	2	No	1/30/2020
Los Angeles	78.2eee	Downey Northeast	82646	126.5	49.1	163.3	506.1	0	8317	0.101	2	2	No	1/30/2020
Los Angeles	78.2mmm	Downtown Southeast/Florence North	105359	11.5	26.9	31.7	3323.6	5	36132	0.343	5	10	Yes	1/30/2020
Los Angeles	78.2q	Del Aire/Inglewood West/Los Angeles International Airport	101856	63.5	49.9	100.9	1009.5	1	15576	0.153	3	4	No	1/30/2020
Los Angeles	78.2sss	Downey Southwest/Lynwood North Central/South Gate East	95508	69.5	45.3	103.5	922.8	0	15873	0.166	3	3	No	1/30/2020
Los Angeles	78.2vvv	Diamond Bar/Industry East/Phillips Ranch/Pomona West/Walnut	113823	72	21.2	87.9	1294.9	1	8572	0.075	1	2	No	1/30/2020
Merced	94	Dos Palos/Gustine/Los Banos	59460	10	19.9	24.9	2388	3	13005	0.219	4	7	Yes	1/30/2020
Orange	115.1	Dana Point/San Clemente/San Juan Capistrano	116086	76	23.8	93.9	1236.3	1	10187	0.088	1	2	No	1/30/2020
Placer	117	Dollar Point/Kings Beach/Sunnyside/Tahoe City/Tahoe Vista	10464	1	2	2.5	4185.6	5	1214	0.116	2	7	Yes	1/30/2020
San Diego	157	Dulzura/Engineer Springs/Indian Springs/Jamacha/Jamul	16218	3	4.7	6.5	2495.1	3	1149	0.071	1	4	No	1/30/2020
San Diego	161c	Downtown/Golden Hill/Logan Heights	82416	151.5	74.1	207.1	398	0	23565	0.286	5	5	Yes	1/30/2020
Santa Clara	183d	Downtown San Jose	79372	53	10.9	61.2	1296.9	1	16577	0.209	4	5	Yes	1/30/2020
Santa Cruz	185.2	Davenport	4354	0	1	0.8	5442.5	5	542	0.124	2	7	Yes	1/30/2020
Siskiyou	198	Dunsmuir	1934	0	0	0	None	5	366	0.189	3	8	Yes	1/30/2020
Siskiyou	200	Dorris/Macdoel/Mount Hebron	1753	0	0	0	None	5	425	0.242	4	9	Yes	1/30/2020
Solano	201	Dixon	22359	10	1.3	11	2032.6	3	2738	0.122	2	5	Yes	1/30/2020
Stanislaus	212.1	Denair/Turlock	76162	59.5	20.8	75.1	1014.1	1	12487	0.164	3	4	No	1/30/2020
Tehama	220	Dairyville/Manton/Mineral/Paynes Creek	4358	0	0	0	None	5	623	0.143	2	7	Yes	1/30/2020
Trinity	224	Douglas City/Lewiston/Trinity Center/Weaverville	6830	3.5	4	6.5	1050.8	1	1221	0.179	3	4	No	1/30/2020
Tulare	227.1	Dinuba	34692	15.2	10.6	23.1	1501.8	2	9685	0.279	5	7	Yes	1/30/2020
Yolo	244	Davis	68403	131	16.8	143.6	476.3	0	21053	0.308	5	5	Yes	1/30/2020