Table: primary_care_shortage_areas , mssa_name like I*

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
Amador 4 Ione/Jackson/Pine Grove/Sutter Creek 23400 27 9.6 34.2 684.2 0 2532 0.108 2 2 No 1/30/2020
Kern 64 Inyokern/Ridgecrest 35263 18 10.3 25.7 1372.1 1 6342 0.18 3 4 No 1/30/2020
Los Angeles 78.2r Inglewood East/Lennox 77443 12 13 21.7 3568.8 5 16689 0.216 4 9 Yes 1/30/2020
Orange 116d Irvine South/Newport Beach/Newport Coast/San Joaquin Hills 145141 152.5 39.8 182.4 795.7 0 13969 0.096 1 1 No 1/30/2020
Orange 116o Irvine Central/Tustin East 99394 199 40.5 229.4 433.3 0 9531 0.096 1 1 No 1/30/2020
Riverside 130 Idyllwild/Pine Cove 12466 0 3.3 2.5 4986.4 5 2121 0.17 3 8 Yes 1/30/2020
Tulare 228.1 Ivanhoe/Woodlake 15665 2 3.6 4.7 3333 5 5361 0.342 5 10 Yes 1/30/2020