Table: family_pact_providers_profile_cy_2021_2022 , provider_business_legal_name like W*

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  *

provider_number	npi_provider_number	owner_number	service_location_number	provider_business_legal_name	enrollment_status_effective_date	provider_type_code	provider_type_code_desc	provider_license_number	provider_specialty_code	provider_specialty_code_desc	out_of_state_ind	out_of_state_ind_desc	provider_address_county_code	provider_address_county_desc	attention_line	provider_address_line1	provider_address_line2	provider_address_city	provider_address_state	provider_address_zip	provider_address_latitude	provider_address_longitude	mssa_id	tract_id
1033272521	1033272521	1	1	WOMENS TOTAL CARE MEDICAL	01Jun2000	026	PHYSICIANS	A00044407	16	Obstetrics-Gynecology (M.D. Only) Neonatal	0	In state provider	42	Santa Barbara	CLINIC INC	314 W JUNIPERO ST	None	SANTA BARBARA	CA	931054305	34.431341	-119.723353	181b	3.02
1063496396	1063496396	2	1	WESTERN SIERRA MEDICAL	02Jun2010	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	29	Nevada	CLINIC INC	844 OLD TUNNEL ROAD	None	GRASS VALLEY	CA	959458524	39.242138	-121.031009	113	8.02
1083003321	1083003321	1	1	WHITE MEMORIAL COMMUNITY	01Apr2018	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	19	Los Angeles	HEALTH CENTER	1828 E CESAR E CHAVEZ AV	SUITE 5000	LOS ANGELES	CA	900332496	34.050489	-118.216032	78.2ffff	2035
1356344758	1356344758	1	1	WEST COUNTY HEALTH CENTERS	03Feb2006	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	49	Sonoma	None	16387 FIRST STREET	None	GUERNEVILLE	CA	954460000	38.501940	-122.997131	207	1537.04
1407033301	1407033301	1	1	WESTSIDE NEIGHBORHOOD	17Jul2005	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	42	Santa Barbara	CLINIC	628 W MICHELTORENA ST	None	SANTA BARBARA	CA	931014131	34.419291	-119.715644	181a	11.01
1437375953	1437375953	1	1	WALK-IN MEDICAL CARE	19Apr2007	022	PHYSICIANS GROUP	FNP017979	None	UNKNOWN	0	In state provider	19	Los Angeles	None	18326 PIONEER BLVD	None	ARTESIA	CA	907015533	33.865287	-118.082211	78.2rrr	5549
1447332036	1447332036	1	1	WELLSPACE HEALTH	09Feb2010	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	34	Sacramento	None	8233 E STOCKTON BLVD	SUITE D	SACRAMENTO	CA	958288203	38.458962	-121.409001	139h	93.20
1447332036	1447332036	1	14	WELLSPACE HEALTH	25May2021	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	34	Sacramento	INTERMITTENT	7601 HOSPITAL DR	SUITE 220	SACRAMENTO	CA	958235408	38.464241	-121.415612	139h	96.06
1447332036	1447332036	1	15	WELLSPACE HEALTH	29Jun2021	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	34	Sacramento	INTERMITTENT	3946 NORWOOD AVE	None	SACRAMENTO	CA	958383300	38.639436	-121.456910	139j	67.02
1457472177	1457472177	1	1	WEST OAKLAND HEALTH CTR	09Jun1997	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	01	Alameda	None	700 ADELINE ST	None	OAKLAND	CA	946072608	37.803961	-122.288171	2c	4025
1467696203	1467696203	1	1	WESTSIDE MEDICAL GROUP	21Jul2009	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	10	Fresno	None	1107 O STREET	None	FIREBAUGH	CA	936222224	36.858817	-120.456357	25	84.01
1477649119	1477649119	1	1	WATTS HEALTHCARE	18Aug2003	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	19	Los Angeles	CORPORATION	10300 COMPTON AVE	None	LOS ANGELES	CA	900023628	33.943243	-118.246239	78.2fff	2427
1548789050	1548789050	1	1	WELLSPACE HEALTH	25May2021	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	34	Sacramento	None	2433 MARCONI AVE	None	SACRAMENTO	CA	958214807	38.618042	-121.405255	139j	62.01
1588843155	1588843155	1	1	WE CARE MORE FAMILY	15Aug2005	010	GROUP CERTIFIED NURSE PRACTITIONER	RN426211	None	UNKNOWN	0	In state provider	19	Los Angeles	None	3737 MARTIN LUTHER KING	# 605B	LYNWOOD	CA	902623513	33.928529	-118.200486	78.2sss	5402.03
1598768962	1598768962	1	1	WEST COUNTY HEALTH CTRS	01May2000	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	49	Sonoma	OCCIDENTAL AREA HEALTH	3802 MAIN ST	None	OCCIDENTAL	CA	954650100	38.408661	-122.947471	210.2	1543.02
1730165564	1730165564	1	1	WOODGLEN OB-GYN MED GRP	01Jan1996	022	PHYSICIANS GROUP	None	16	Obstetrics-Gynecology (M.D. Only) Neonatal	0	In state provider	19	Los Angeles	NAJI BOUZ & N KASSAR MDS	315 E ROUTE 66	STE 201	GLENDORA	CA	917406257	34.128817	-117.861010	78.2qq	4011.02
1730282286	1730282286	1	1	WALTER JAYASINGHE MD APC	31Dec1988	022	PHYSICIANS GROUP	FNP024603	None	UNKNOWN	0	In state provider	19	Los Angeles	LOS ANGELES MEDICAL CTR	2010 WILSHIRE BLVD	FL 2	LOS ANGELES	CA	900573507	34.057437	-118.274815	78.2ffff	2089.03
1760479745	1760479745	1	1	W L BROWN MEDICAL CORP	05Sep1987	022	PHYSICIANS GROUP	None	16	Obstetrics-Gynecology (M.D. Only) Neonatal	0	In state provider	10	Fresno	None	6225 N FRESNO ST	SUITE 104	FRESNO	CA	937105268	36.827016	-119.781423	35f	45.04
1811060262	1811060262	1	1	WHITE MEMORIAL GYN OB	01Jan1979	022	PHYSICIANS GROUP	FNP004602	None	UNKNOWN	0	In state provider	19	Los Angeles	MEDICAL GROUP	1701 CESAR CHAVEZ AVENUE	STE 200 225	LOS ANGELES	CA	900336720	34.049148	-118.207603	78.2h	2036
1831287978	1831287978	1	1	WESTSIDE FAMILY HLTH CTR	20May2009	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	19	Los Angeles	None	3861 SEPULVEDA BLVD	None	CULVER CITY	CA	902304605	34.011807	-118.416327	78.2y	7028.01
1851513469	1851513469	1	1	WESTERN SIERRA MED CLIN	04May2000	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	46	Sierra	None	209 NEVADA ST	None	DOWNIEVILLE	CA	959360286	39.559105	-120.829588	191	100
1871553347	1871553347	1	1	WOMAN TO WOMAN OB & GYN	31Mar1986	022	PHYSICIANS GROUP	P12304	None	UNKNOWN	0	In state provider	36	San Bernardino	MEDICAL GROUP	249 E HIGHLAND AVE	None	SAN BERNARDINO	CA	924043700	34.135927	-117.280692	151g	54
1932194586	1932194586	1	1	WILMINGTON COMMUNITY CLN	01Aug2004	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	19	Los Angeles	None	1009 N AVALON BLVD	None	WILMINGTON	CA	907444505	33.783041	-118.262690	78.2p	2945.20
1962499616	1962499616	1	1	WANG, GEORGE H	01Jan2002	026	PHYSICIANS	A00073256	None	UNKNOWN	0	In state provider	19	Los Angeles	OB/GYN MEDICAL CORP	2211 S ATLANTIC BLVD	STE B	MONTEREY PARK	CA	917546833	34.038357	-118.145128	78.2nn	4827.01
1972863611	1972863611	1	1	WILMINGTON URGENT CARE AND	10Jan2013	026	PHYSICIANS	A00097561	None	UNKNOWN	0	In state provider	19	Los Angeles	FAMILY CLINIC INC	714 N AVALON BLVD	None	WILMINGTON	CA	907445809	33.778733	-118.262346	78.2p	2948.20
1992142277	1992142277	1	1	WEST SIDE HEALTH CARE	19Dec2017	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	15	Kern	DISTRICT	100 E NORTH ST	None	TAFT	CA	932683606	35.139727	-119.451950	57.2	35
1992736086	1992736086	1	1	WINTERS HEATHCARE FNDTN	01Mar2006	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	57	Yolo	None	172 EAST GRANT AVE	None	WINTERS	CA	956941780	38.526234	-121.967445	242	113
1992894539	1992894539	1	1	WRIGHT, BENNY L DO	03Apr2015	026	PHYSICIANS	20A13319	16	Obstetrics-Gynecology (M.D. Only) Neonatal	0	In state provider	24	Merced	None	502 WASHINGTON AVE	None	LOS BANOS	CA	936353460	37.055966	-120.853095	94	23.01