Table: primary_care_shortage_areas
, mssa_name like V*
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 |
78.2cc |
Van Nuys Central |
107344 |
41.8 |
14.2 |
52.5 |
2044.6 |
3 |
25429 |
0.237 |
4 |
7 |
Yes |
1/30/2020 |
Los Angeles |
78.2www |
Valinda/West Covina |
127444 |
113 |
55.2 |
154.4 |
825.4 |
0 |
13954 |
0.109 |
2 |
2 |
No |
1/30/2020 |
Sacramento |
139l |
Vineyard |
81806 |
4 |
3 |
6.3 |
12985.1 |
5 |
9259 |
0.113 |
2 |
7 |
Yes |
1/30/2020 |
Solano |
204 |
Vallejo |
145292 |
170.5 |
37.9 |
198.9 |
730.5 |
0 |
20678 |
0.142 |
2 |
2 |
No |
1/30/2020 |
Solano |
202a |
Vacaville |
97949 |
121.5 |
23.3 |
138.9 |
705.2 |
0 |
8312 |
0.085 |
1 |
1 |
No |
1/30/2020 |
Ventura |
241c |
Ventura |
90010 |
218 |
31.1 |
241.3 |
373 |
0 |
9529 |
0.106 |
2 |
2 |
No |
1/30/2020 |