Table: managed_care_pref_mon_dashboard_provider_ratios
, plan_parent_reporting_name like A*
plan_parent_reporting_name |
month |
pcps_per_2_000_members |
physicians_per_1_200_members |
AAH |
202302 |
3 |
65 |
AAH |
202303 |
3 |
64 |
AAH |
202304 |
3 |
63 |
AAH |
202305 |
3 |
62 |
AAH |
202306 |
3 |
62 |
AAH |
202307 |
3 |
62 |
AAH |
202308 |
3 |
64 |
AAH |
202309 |
3 |
65 |
AAH |
202310 |
3 |
65 |
AAH |
202311 |
3 |
66 |
AAH |
202312 |
3 |
66 |
AAH |
202401 |
3 |
25 |
Aetna |
202302 |
22 |
90 |
Aetna |
202303 |
23 |
88 |
Aetna |
202304 |
22 |
87 |
Aetna |
202305 |
22 |
86 |
Aetna |
202306 |
22 |
92 |
Aetna |
202307 |
22 |
92 |
Aetna |
202308 |
23 |
93 |
Aetna |
202309 |
23 |
94 |
Aetna |
202310 |
24 |
99 |
Aetna |
202311 |
26 |
105 |
Aetna |
202312 |
29 |
116 |
Aetna |
202401 |
0 |
0 |
AHF |
202302 |
47 |
2,067 |
AHF |
202303 |
51 |
2,081 |
AHF |
202304 |
46 |
2,066 |
AHF |
202305 |
46 |
2,140 |
AHF |
202306 |
45 |
2,129 |
AHF |
202307 |
47 |
2,100 |
AHF |
202308 |
47 |
2,175 |
AHF |
202309 |
49 |
2,170 |
AHF |
202310 |
47 |
2,220 |
AHF |
202311 |
49 |
2,208 |
AHF |
202312 |
51 |
2,185 |
AHF |
202401 |
51 |
2,163 |
Anthem |
202302 |
4 |
20 |
Anthem |
202303 |
4 |
20 |
Anthem |
202304 |
4 |
18 |
Anthem |
202305 |
4 |
20 |
Anthem |
202306 |
4 |
20 |
Anthem |
202307 |
4 |
20 |
Anthem |
202308 |
4 |
19 |
Anthem |
202309 |
4 |
20 |
Anthem |
202310 |
5 |
21 |
Anthem |
202311 |
5 |
22 |
Anthem |
202312 |
5 |
23 |
Anthem |
202401 |
6 |
29 |