Table: primary_care_shortage_areas , mssa_name like G*

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
El Dorado	22	Garden Valley/Georgetown/Greenwood/Kelsey/Volcanoville	10507	0	3.3	2.5	4202.8	5	1356	0.129	2	7	Yes	1/30/2020
Humboldt	44	Garberville/Redway	6723	2	6	6.5	1034.3	1	1476	0.22	4	5	Yes	1/30/2020
Los Angeles	78.2bbbb	Gardena West/Hawthorne	78910	8	9.6	15.2	5191.4	5	12987	0.165	3	8	Yes	1/30/2020
Los Angeles	78.2ff	Glassell Park/Glendale Southeast/Silverlake North	98073	92.5	20.2	107.7	910.6	0	19784	0.202	4	4	No	1/30/2020
Los Angeles	78.2hh	Granada Hills/Mission Hills/Porter Ranch	87288	131	30.5	153.9	567.2	0	6135	0.07	1	1	No	1/30/2020
Los Angeles	78.2iiii	Gardena Southeast/Harbor Gateway Central/Lawndale South/Moneta/Redondo Beach North/Torrance North	113145	61.5	18.6	75.5	1498.6	1	13400	0.118	2	3	No	1/30/2020
Los Angeles	78.2rr	Glendale Northeast/La Canada-Flintridge/La Crescenta/Montrose/Sunland/Tujunga/Verdugo City	111106	45	9.7	52.2	2128.5	3	10683	0.096	1	4	No	1/30/2020
Nevada	113	Grass Valley/Nevada City/Penn Valley/Rough and Ready/Wildwood	77416	66	27.2	86.4	896	0	9935	0.128	2	2	No	1/30/2020
Orange	116i	Garden Grove South/Santa Ana West	120364	83	17.2	95.9	1255.1	1	23297	0.194	3	4	No	1/30/2020
Orange	116r	Garden Grove North/Stanton	127633	230	34.1	255.5	499.5	0	23293	0.182	3	3	No	1/30/2020
Riverside	133.3	Glen Valley/Mead Valley	25428	1	0	1	25428	5	7432	0.292	5	10	Yes	1/30/2020
Sacramento	139i	Greenhaven/Land Park/Midtown/Pocket/Riverside/Sutterville	84967	223	79.1	282.3	301	0	7875	0.093	1	1	No	1/30/2020
San Francisco	162e	Golden Gate Park/Parkside/Sunset/West Portal	85091	56	15.3	67.5	1260.6	1	6622	0.078	1	2	No	1/30/2020
Santa Barbara	180.2	Guadalupe	7581	1	2	2.5	3032.4	5	1223	0.161	3	8	Yes	1/30/2020
Santa Barbara	181a	Goleta South/Isla Vista/Santa Barbara South	93617	50	27.7	70.8	1322.3	1	22107	0.236	4	5	Yes	1/30/2020
Santa Barbara	181b	Goleta North/Mission Canyon/Montecito/Riviera/Santa Barbara North	84157	195	44.8	228.6	368.1	0	6937	0.082	1	1	No	1/30/2020
Santa Clara	182	Gilroy/Morgan Hill/Rucker/San Martin	118322	72	21.2	87.9	1346.1	1	10876	0.092	1	2	No	1/30/2020
Siskiyou	195	Gazelle/Grenada/Hilt/Hornbrook/Yreka	16045	13	11.3	21.5	746.3	0	3541	0.221	4	4	No	1/30/2020
Sonoma	205.1	Geyserville/Healdsburg	16092	17	10.6	25	643.7	0	1224	0.076	1	1	No	1/30/2020
Tehama	221	Gerber/Los Flores/Proberta/Red Bluff	35103	16	15.5	27.6	1271.8	1	6907	0.197	3	4	No	1/30/2020