Table: primary_care_shortage_areas
, mssa_name like W*
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 |
Colusa |
16.1 |
Williams |
6024 |
0 |
0.3 |
0.2 |
30120 |
5 |
791 |
0.131 |
2 |
7 |
Yes |
1/30/2020 |
Lassen |
75 |
Westwood |
2688 |
0 |
0.3 |
0.2 |
13440 |
5 |
328 |
0.122 |
2 |
7 |
Yes |
1/30/2020 |
Sonoma |
205.2 |
Windsor |
29615 |
2 |
4.3 |
5.2 |
5695.2 |
5 |
1613 |
0.054 |
1 |
6 |
Yes |
1/30/2020 |
Yolo |
242 |
Winters |
8954 |
6 |
1.3 |
7 |
1279.1 |
1 |
759 |
0.085 |
1 |
2 |
No |
1/30/2020 |
Yolo |
246.1 |
Woodland |
60630 |
61 |
35.3 |
87.5 |
692.9 |
0 |
7451 |
0.123 |
2 |
2 |
No |
1/30/2020 |
Yuba |
248 |
Wheatland |
4492 |
0 |
0 |
0 |
None |
5 |
439 |
0.098 |
1 |
6 |
Yes |
1/30/2020 |