Table: primary_care_shortage_areas , mssa_name like L*

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
Alameda	1.1	Livermore Central and West/Spring Town	58273	46	5	49.8	1172.5	1	3149	0.054	1	2	No	1/30/2020
Colusa	16.2	Loduga/Maxwell/Princeton/Stonyford	2379	0	0	0	None	5	412	0.173	3	8	Yes	1/30/2020
Contra Costa	18i	Lafayette/Martinez South/Moraga/Orinda/Pleasant Hill/Rheem Valley/Rossmoor Leisure World/Walnut Creek Southwest	113632	123.5	29.2	145.4	781.5	0	4676	0.041	0	0	No	1/30/2020
Kern	58.2	Lost Hills/Wasco	24169	6.5	8	12.5	1933.5	2	6730	0.278	5	7	Yes	1/30/2020
Lake	70.2	Lucerne/Nice/Upper Lake	9049	1	3.7	3.7	2445.7	3	2341	0.259	5	8	Yes	1/30/2020
Lake	71.2	Lower Lake	9987	0.5	0	0.5	19974	5	1394	0.14	2	7	Yes	1/30/2020
Los Angeles	77.2	Lake Los Angeles	17436	0.3	0.3	0.5	34872	5	4785	0.274	5	10	Yes	1/30/2020
Los Angeles	77.1c	Lancaster Central/Palmdale North Central	107541	24.1	26.6	44	2444.1	3	33209	0.309	5	8	Yes	1/30/2020
Los Angeles	78.2jjj	Long Beach West Central	113913	27	21.9	43.4	2624.7	4	34702	0.305	5	9	Yes	1/30/2020
Los Angeles	78.2p	Long Beach Port/San Pedro East/Wilmington	114570	22	22.5	38.9	2945.2	4	28546	0.249	4	8	Yes	1/30/2020
Los Angeles	78.2rrr	La Mirada/Santa Fe Springs South	101318	67	43.6	99.7	1016.2	1	7213	0.071	1	2	No	1/30/2020
Los Angeles	78.2uu	La Habra Heights/Whittier	85487	121.5	51.5	160.2	533.6	0	9735	0.114	2	2	No	1/30/2020
Los Angeles	78.2vv	Los Nietos/Santa Fe Springs Northeast	93085	10	4	13	7160.4	5	12238	0.131	2	7	Yes	1/30/2020
Mendocino	90	Laytonville/Leggett/Piercy	3596	2	1.7	3.2	1123.8	1	975	0.271	5	6	Yes	1/30/2020
Merced	97.3	Le Grand/Planada	7775	2.5	2.7	4.5	1727.8	2	2218	0.285	5	7	Yes	1/30/2020
Orange	115.2a	Lake Forest East/Mission Viejo Central and South	116381	125	37.4	153	760.7	0	6745	0.058	1	1	No	1/30/2020
Orange	115.2d	Laguna Beach/Laguna Woods	80187	75.5	42.7	107.5	745.9	0	7989	0.1	1	1	No	1/30/2020
Riverside	131a	Lake Elsinore/Murrieta West/Sedco Hills/Wildomar	154507	69	32.3	93.2	1657.8	2	20702	0.134	2	4	No	1/30/2020
San Bernardino	145.3	Lucerne Valley	5237	0	0	0	None	5	1330	0.254	5	10	Yes	1/30/2020
San Bernardino	148	Lytle Creek/Wrightwood	6720	0	0	0	None	5	806	0.12	2	7	Yes	1/30/2020
San Diego	161f	La Mesa/Rolando South	85180	136.5	44.6	170	501.1	0	12693	0.149	2	2	No	1/30/2020
San Diego	161l	Lemon Grove South/Paradise Hills	83744	5	1	5.8	14438.6	5	10647	0.127	2	7	Yes	1/30/2020
San Francisco	162h	Laurel Heights/Ocean Beach North/Richmond/Sutro Heights	93429	270	45.8	304.4	306.9	0	8879	0.095	1	1	No	1/30/2020
San Joaquin	164.1	Lathrop/Manteca	87488	52.5	13.3	62.4	1402.1	1	10636	0.122	2	3	No	1/30/2020
San Joaquin	166	Lodi	67809	37.8	17.3	50.8	1334.8	1	11458	0.169	3	4	No	1/30/2020
San Joaquin	167	Lockeford/North Woodbridge	40455	0	0.7	0.5	80910	5	4710	0.116	2	7	Yes	1/30/2020
San Mateo	175.2	La Honda/Loma Mar/Pescadero/San Gregorio/Sky Londa	3946	0	0	0	None	5	753	0.191	3	8	Yes	1/30/2020
Santa Barbara	178.2	Los Alamos	7163	3	3	5.3	1351.5	1	736	0.103	2	3	No	1/30/2020
Santa Barbara	179	Lompoc/Mission Hills/Vandenberg	56591	39.5	7.5	45.2	1252	1	9516	0.168	3	4	No	1/30/2020
Santa Clara	183a	Los Altos/Los Altos Hills/Palo Alto Central/Stanford	128262	886	246.3	1070.7	119.8	0	7213	0.056	1	1	No	1/30/2020
Sutter	218	Live Oak	10349	0	1.3	1	10349	5	2161	0.209	4	9	Yes	1/30/2020