Table: managed_care_pref_mon_dashboard_provider_ratios
, plan_parent_reporting_name like all*
| 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 |
| Blue Shield |
202302 |
9 |
35 |
| Blue Shield |
202303 |
9 |
34 |
| Blue Shield |
202304 |
8 |
32 |
| Blue Shield |
202305 |
9 |
31 |
| Blue Shield |
202306 |
8 |
32 |
| Blue Shield |
202307 |
8 |
32 |
| Blue Shield |
202308 |
8 |
31 |
| Blue Shield |
202309 |
8 |
32 |
| Blue Shield |
202310 |
8 |
32 |
| Blue Shield |
202311 |
7 |
31 |
| Blue Shield |
202312 |
7 |
29 |
| Blue Shield |
202401 |
5 |
23 |
| CalOptima |
202302 |
8 |
21 |
| CalOptima |
202303 |
8 |
21 |
| CalOptima |
202304 |
8 |
20 |
| CalOptima |
202305 |
8 |
20 |
| CalOptima |
202306 |
8 |
21 |
| CalOptima |
202307 |
8 |
21 |
| CalOptima |
202308 |
8 |
21 |
| CalOptima |
202309 |
8 |
21 |
| CalOptima |
202310 |
8 |
22 |
| CalOptima |
202311 |
8 |
23 |
| CalOptima |
202312 |
8 |
23 |
| CalOptima |
202401 |
2 |
8 |
| CalViva |
202302 |
2 |
5 |
| CalViva |
202303 |
2 |
5 |
| CalViva |
202304 |
2 |
5 |
| CalViva |
202305 |
2 |
5 |
| CalViva |
202306 |
2 |
5 |
| CalViva |
202307 |
2 |
5 |
| CalViva |
202308 |
2 |
5 |
| CalViva |
202309 |
2 |
6 |
| CalViva |
202310 |
2 |
5 |
| CalViva |
202311 |
2 |
6 |
| CalViva |
202312 |
0 |
1 |
| CalViva |
202401 |
2 |
6 |
| CCAH |
202302 |
3 |
35 |
| CCAH |
202303 |
3 |
35 |
| CCAH |
202304 |
2 |
35 |
| CCAH |
202305 |
2 |
35 |
| CCAH |
202306 |
2 |
35 |
| CCAH |
202307 |
2 |
35 |
| CCAH |
202308 |
2 |
37 |
| CCAH |
202309 |
2 |
37 |
| CCAH |
202310 |
3 |
38 |
| CCAH |
202311 |
3 |
39 |
| CCAH |
202312 |
3 |
39 |
| CCAH |
202401 |
2 |
36 |
| CCHP |
202302 |
9 |
42 |
| CCHP |
202303 |
9 |
41 |
| CCHP |
202304 |
9 |
41 |
| CCHP |
202305 |
9 |
40 |
| CCHP |
202306 |
8 |
40 |
| CCHP |
202307 |
8 |
41 |
| CCHP |
202308 |
8 |
41 |
| CCHP |
202309 |
7 |
40 |
| CCHP |
202310 |
26 |
71 |
| CCHP |
202311 |
27 |
72 |
| CCHP |
202312 |
27 |
73 |
| CCHP |
202401 |
2 |
23 |
| CenCal |
202302 |
3 |
25 |
| CenCal |
202303 |
3 |
25 |
| CenCal |
202304 |
3 |
24 |
| CenCal |
202305 |
3 |
24 |
| CenCal |
202306 |
2 |
24 |
| CenCal |
202307 |
2 |
24 |
| CenCal |
202308 |
2 |
24 |
| CenCal |
202309 |
2 |
24 |
| CenCal |
202310 |
2 |
25 |
| CenCal |
202311 |
2 |
26 |
| CenCal |
202312 |
2 |
26 |
| CenCal |
202401 |
2 |
25 |
| CH&W |
202302 |
22 |
52 |
| CH&W |
202303 |
21 |
51 |
| CH&W |
202304 |
22 |
52 |
| CH&W |
202305 |
22 |
52 |
| CH&W |
202306 |
18 |
43 |
| CH&W |
202307 |
22 |
52 |
| CH&W |
202308 |
22 |
52 |
| CH&W |
202309 |
23 |
53 |
| CH&W |
202310 |
23 |
55 |
| CH&W |
202311 |
24 |
56 |
| CH&W |
202312 |
0 |
1 |
| CH&W |
202401 |
0 |
0 |
| CHG |
202302 |
5 |
14 |
| CHG |
202303 |
5 |
13 |
| CHG |
202304 |
5 |
13 |
| CHG |
202305 |
5 |
13 |
| CHG |
202306 |
5 |
13 |
| CHG |
202307 |
5 |
13 |
| CHG |
202308 |
5 |
13 |
| CHG |
202309 |
5 |
13 |
| CHG |
202310 |
5 |
14 |
| CHG |
202311 |
5 |
14 |
| CHG |
202312 |
5 |
14 |
| CHG |
202401 |
5 |
12 |
| CHPIV |
202302 |
0 |
0 |
| CHPIV |
202303 |
0 |
0 |
| CHPIV |
202304 |
0 |
0 |
| CHPIV |
202305 |
0 |
0 |
| CHPIV |
202306 |
0 |
0 |
| CHPIV |
202307 |
0 |
0 |
| CHPIV |
202308 |
0 |
0 |
| CHPIV |
202309 |
0 |
0 |
| CHPIV |
202310 |
0 |
0 |
| CHPIV |
202311 |
0 |
0 |
| CHPIV |
202312 |
0 |
0 |
| CHPIV |
202401 |
18 |
51 |
| Family Mosaic Project |
202302 |
0 |
450 |
| Family Mosaic Project |
202303 |
0 |
360 |
| Family Mosaic Project |
202304 |
0 |
360 |
| Family Mosaic Project |
202305 |
0 |
360 |
| Family Mosaic Project |
202306 |
0 |
327 |
| Family Mosaic Project |
202307 |
0 |
300 |
| Family Mosaic Project |
202308 |
0 |
450 |
| Family Mosaic Project |
202309 |
0 |
600 |
| Family Mosaic Project |
202310 |
0 |
600 |
| Family Mosaic Project |
202311 |
0 |
600 |
| Family Mosaic Project |
202312 |
0 |
600 |
| Family Mosaic Project |
202401 |
0 |
0 |
| FFS |
202302 |
0 |
0 |
| FFS |
202303 |
0 |
0 |
| FFS |
202304 |
0 |
0 |
| FFS |
202305 |
0 |
0 |
| FFS |
202306 |
0 |
0 |
| FFS |
202307 |
0 |
0 |
| FFS |
202308 |
0 |
0 |
| FFS |
202309 |
0 |
0 |
| FFS |
202310 |
0 |
0 |
| FFS |
202311 |
0 |
0 |
| FFS |
202312 |
0 |
0 |
| FFS |
202401 |
0 |
0 |
| GCHP |
202302 |
22 |
81 |
| GCHP |
202303 |
22 |
81 |
| GCHP |
202304 |
22 |
76 |
| GCHP |
202305 |
22 |
77 |
| GCHP |
202306 |
22 |
77 |
| GCHP |
202307 |
22 |
78 |
| GCHP |
202308 |
22 |
79 |
| GCHP |
202309 |
23 |
81 |
| GCHP |
202310 |
23 |
83 |
| GCHP |
202311 |
23 |
86 |
| GCHP |
202312 |
24 |
88 |
| GCHP |
202401 |
2 |
30 |
| Health Net |
202302 |
5 |
9 |
| Health Net |
202303 |
5 |
9 |
| Health Net |
202304 |
5 |
9 |
| Health Net |
202305 |
5 |
10 |
| Health Net |
202306 |
5 |
10 |
| Health Net |
202307 |
5 |
10 |
| Health Net |
202308 |
5 |
10 |
| Health Net |
202309 |
5 |
10 |
| Health Net |
202310 |
5 |
10 |
| Health Net |
202311 |
5 |
10 |
| Health Net |
202312 |
5 |
8 |
| Health Net |
202401 |
6 |
10 |
| HPSJ |
202302 |
2 |
6 |
| HPSJ |
202303 |
1 |
6 |
| HPSJ |
202304 |
1 |
6 |
| HPSJ |
202305 |
1 |
6 |
| HPSJ |
202306 |
1 |
32 |
| HPSJ |
202307 |
1 |
32 |
| HPSJ |
202308 |
1 |
32 |
| HPSJ |
202309 |
2 |
33 |
| HPSJ |
202310 |
2 |
34 |
| HPSJ |
202311 |
2 |
36 |
| HPSJ |
202312 |
2 |
35 |
| HPSJ |
202401 |
2 |
4 |
| HPSM |
202302 |
3 |
115 |
| HPSM |
202303 |
3 |
115 |
| HPSM |
202304 |
3 |
114 |
| HPSM |
202305 |
3 |
114 |
| HPSM |
202306 |
3 |
113 |
| HPSM |
202307 |
3 |
113 |
| HPSM |
202308 |
3 |
114 |
| HPSM |
202309 |
3 |
118 |
| HPSM |
202310 |
3 |
122 |
| HPSM |
202311 |
3 |
125 |
| HPSM |
202312 |
4 |
128 |
| HPSM |
202401 |
2 |
63 |
| IEHP |
202302 |
5 |
11 |
| IEHP |
202303 |
5 |
10 |
| IEHP |
202304 |
5 |
10 |
| IEHP |
202305 |
5 |
10 |
| IEHP |
202306 |
5 |
10 |
| IEHP |
202307 |
5 |
10 |
| IEHP |
202308 |
5 |
10 |
| IEHP |
202309 |
2 |
3 |
| IEHP |
202310 |
5 |
11 |
| IEHP |
202311 |
5 |
11 |
| IEHP |
202312 |
5 |
11 |
| IEHP |
202401 |
2 |
3 |
| Kaiser |
202302 |
52 |
123 |
| Kaiser |
202303 |
52 |
123 |
| Kaiser |
202304 |
51 |
121 |
| Kaiser |
202305 |
50 |
121 |
| Kaiser |
202306 |
50 |
121 |
| Kaiser |
202307 |
49 |
121 |
| Kaiser |
202308 |
49 |
122 |
| Kaiser |
202309 |
49 |
124 |
| Kaiser |
202310 |
54 |
126 |
| Kaiser |
202311 |
54 |
127 |
| Kaiser |
202312 |
55 |
129 |
| Kaiser |
202401 |
11 |
27 |
| Kern |
202302 |
15 |
43 |
| Kern |
202303 |
15 |
43 |
| Kern |
202304 |
15 |
43 |
| Kern |
202305 |
15 |
43 |
| Kern |
202306 |
15 |
43 |
| Kern |
202307 |
15 |
43 |
| Kern |
202308 |
15 |
44 |
| Kern |
202309 |
15 |
45 |
| Kern |
202310 |
16 |
46 |
| Kern |
202311 |
16 |
47 |
| Kern |
202312 |
16 |
47 |
| Kern |
202401 |
1 |
8 |
| LA Care |
202302 |
4 |
12 |
| LA Care |
202303 |
4 |
12 |
| LA Care |
202304 |
4 |
12 |
| LA Care |
202305 |
4 |
12 |
| LA Care |
202306 |
1 |
3 |
| LA Care |
202307 |
4 |
12 |
| LA Care |
202308 |
4 |
12 |
| LA Care |
202309 |
4 |
12 |
| LA Care |
202310 |
4 |
12 |
| LA Care |
202311 |
4 |
13 |
| LA Care |
202312 |
5 |
13 |
| LA Care |
202401 |
3 |
9 |
| Molina |
202302 |
4 |
14 |
| Molina |
202303 |
4 |
15 |
| Molina |
202304 |
4 |
15 |
| Molina |
202305 |
4 |
15 |
| Molina |
202306 |
5 |
19 |
| Molina |
202307 |
5 |
19 |
| Molina |
202308 |
4 |
13 |
| Molina |
202309 |
5 |
19 |
| Molina |
202310 |
5 |
19 |
| Molina |
202311 |
5 |
19 |
| Molina |
202312 |
5 |
19 |
| Molina |
202401 |
0 |
17 |
| MVHP |
202302 |
0 |
0 |
| MVHP |
202303 |
0 |
0 |
| MVHP |
202304 |
0 |
0 |
| MVHP |
202305 |
0 |
0 |
| MVHP |
202306 |
0 |
0 |
| MVHP |
202307 |
0 |
0 |
| MVHP |
202308 |
0 |
0 |
| MVHP |
202309 |
0 |
0 |
| MVHP |
202310 |
0 |
0 |
| MVHP |
202311 |
0 |
0 |
| MVHP |
202312 |
0 |
0 |
| MVHP |
202401 |
95 |
231 |
| Partnership |
202302 |
11 |
39 |
| Partnership |
202303 |
11 |
40 |
| Partnership |
202304 |
11 |
39 |
| Partnership |
202305 |
11 |
39 |
| Partnership |
202306 |
11 |
39 |
| Partnership |
202307 |
11 |
40 |
| Partnership |
202308 |
11 |
40 |
| Partnership |
202309 |
10 |
41 |
| Partnership |
202310 |
12 |
42 |
| Partnership |
202311 |
12 |
43 |
| Partnership |
202312 |
13 |
43 |
| Partnership |
202401 |
2 |
19 |
| Rady Childrens Hosp |
202302 |
0 |
0 |
| Rady Childrens Hosp |
202303 |
0 |
0 |
| Rady Childrens Hosp |
202304 |
0 |
0 |
| Rady Childrens Hosp |
202305 |
0 |
0 |
| Rady Childrens Hosp |
202306 |
0 |
0 |
| Rady Childrens Hosp |
202307 |
0 |
0 |
| Rady Childrens Hosp |
202308 |
0 |
0 |
| Rady Childrens Hosp |
202309 |
0 |
0 |
| Rady Childrens Hosp |
202310 |
0 |
0 |
| Rady Childrens Hosp |
202311 |
0 |
0 |
| Rady Childrens Hosp |
202312 |
0 |
0 |
| Rady Childrens Hosp |
202401 |
0 |
0 |
| SCAN Health Plan |
202302 |
368 |
608 |
| SCAN Health Plan |
202303 |
368 |
615 |
| SCAN Health Plan |
202304 |
380 |
632 |
| SCAN Health Plan |
202305 |
383 |
639 |
| SCAN Health Plan |
202306 |
376 |
624 |
| SCAN Health Plan |
202307 |
378 |
624 |
| SCAN Health Plan |
202308 |
381 |
625 |
| SCAN Health Plan |
202309 |
383 |
645 |
| SCAN Health Plan |
202310 |
388 |
653 |
| SCAN Health Plan |
202311 |
384 |
650 |
| SCAN Health Plan |
202312 |
369 |
615 |
| SCAN Health Plan |
202401 |
364 |
613 |
| SCFHP |
202302 |
23 |
56 |
| SCFHP |
202303 |
23 |
56 |
| SCFHP |
202304 |
22 |
56 |
| SCFHP |
202305 |
22 |
56 |
| SCFHP |
202306 |
22 |
56 |
| SCFHP |
202307 |
21 |
56 |
| SCFHP |
202308 |
21 |
57 |
| SCFHP |
202309 |
21 |
58 |
| SCFHP |
202310 |
24 |
59 |
| SCFHP |
202311 |
25 |
60 |
| SCFHP |
202312 |
25 |
61 |
| SCFHP |
202401 |
5 |
23 |
| SFHP |
202302 |
37 |
96 |
| SFHP |
202303 |
37 |
95 |
| SFHP |
202304 |
36 |
95 |
| SFHP |
202305 |
34 |
89 |
| SFHP |
202306 |
35 |
94 |
| SFHP |
202307 |
35 |
95 |
| SFHP |
202308 |
34 |
96 |
| SFHP |
202309 |
34 |
97 |
| SFHP |
202310 |
39 |
99 |
| SFHP |
202311 |
40 |
99 |
| SFHP |
202312 |
41 |
101 |
| SFHP |
202401 |
6 |
30 |
| United |
202302 |
0 |
0 |
| United |
202303 |
0 |
0 |
| United |
202304 |
0 |
0 |
| United |
202305 |
0 |
0 |
| United |
202306 |
0 |
0 |
| United |
202307 |
0 |
0 |
| United |
202308 |
0 |
0 |
| United |
202309 |
0 |
0 |
| United |
202310 |
0 |
0 |
| United |
202311 |
0 |
0 |
| United |
202312 |
0 |
0 |
| United |
202401 |
0 |
0 |