Table: primary_care_shortage_areas , mssa_name like J*

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
Los Angeles 77.3 Juniper Hills/Littlerock/Longview/Pearblossom/Valyermo 18367 0.3 0 0.3 61223.3 5 4145 0.226 4 9 Yes 1/30/2020
San Bernardino 144.2 Joshua Tree/Landers/Morongo Valley/Rimrock/Yucca Valley 41100 10 15.6 21.7 1894 2 9004 0.219 4 6 Yes 1/30/2020
Trinity 223 Junction City/Salyer 2097 0 0 0 None 5 399 0.19 3 8 Yes 1/30/2020