Table: family_pact_providers_profile_cy_2021_2022 , provider_business_legal_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  *

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
1043304009	1043304009	1	1	JWCH INSTITUE INC	06Sep2005	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	19	Los Angeles	None	14371 CLARK AVE	None	BELLFLOWER	CA	907062901	33.903214	-118.134060	78.2m	5540.01
1124182977	1124182977	1	1	JWCH INSTITUTE INC	29Jun2009	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	19	Los Angeles	None	3591 E IMPERIAL HIGHWAY	None	LYNWOOD	CA	902622684	33.930479	-118.205406	78.2sss	5402.02
1275661811	1275661811	1	1	JOHN MARSHALL HIGH	02Oct2006	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	19	Los Angeles	SCHOOL HEALTH CENTER	3939 TRACY ST	None	LOS ANGELES	CA	900273207	34.107740	-118.277634	78.2ff	1952.01
1316597693	1316597693	1	1	JOON CHOI MD A PROFESSIONAL	01Mar2020	022	PHYSICIANS GROUP	None	None	UNKNOWN	0	In state provider	19	Los Angeles	CORPORATION	8100 SUNLAND BLVD	None	SUN VALLEY	CA	913523948	34.217683	-118.370170	78.2ppp	1221.22
1386646404	1386646404	1	1	JAMES CORONA MD	17Sep2009	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	41	Internal Medicine	0	In state provider	11	Glenn	None	203 WALKER ST	# 2	ORLAND	CA	959639904	39.747371	-122.191484	36.1	101
1386708634	1386708634	1	1	JWCH INSTITUTE, INC	29Jun2009	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	19	Los Angeles	JWCH NORWALK REGIONAL	12360 FIRESTONE BLVD	None	NORWALK	CA	906504324	33.906084	-118.069630	78.2jjjj	5522
1417005695	1417005695	1	1	JOHNSON, LORNA M CNM	27Jul2004	005	CERTIFIED NURSE MIDWIFE	303602	16	Obstetrics-Gynecology (M.D. Only) Neonatal	0	In state provider	19	Los Angeles	None	1201 E FLORENCE AVE	None	LOS ANGELES	CA	900012432	33.974765	-118.254103	78.2fff	5350.01
1427220862	1427220862	1	1	JOY CARINO KIMPO WOMENS	08Dec2006	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	15	Kern	HEALTH CENTER	320 JAMES ST	None	SHAFTER	CA	932632033	35.503304	-119.277388	58.1	41.01
1457460503	1457460503	1	1	JAYASINGHE MED GROUP INC	01May1983	022	PHYSICIANS GROUP	FNP024603	None	UNKNOWN	0	In state provider	19	Los Angeles	LOS ANGELES MEDICAL CTR	319 N SOTO ST	None	LOS ANGELES	CA	900331837	34.047290	-118.207479	78.2h	2036
1598829350	1598829350	1	1	JWCH INSTITUTE, INC	29Jun2009	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	19	Los Angeles	None	954 N VERMONT AVE	None	LOS ANGELES	CA	900293529	34.088852	-118.291720	78.2g	1914.10
1679846190	1679846190	1	1	JIMENEZ, ARTHUR E MD INC	24Jan2013	026	PHYSICIANS	A00064270	08	Family Practice	0	In state provider	36	San Bernardino	None	15381 7TH ST	STE 2-3	VICTORVILLE	CA	923953858	34.531206	-117.298456	145.1a	98
1699152058	1699152058	1	1	JOON CHOI, MD. APC	03Oct2017	026	PHYSICIANS	None	16	Obstetrics-Gynecology (M.D. Only) Neonatal	0	In state provider	19	Los Angeles	None	8215 VAN NUYS BLVD	SUITE 104	PANORAMA CITY	CA	914024810	34.220010	-118.448778	78.2zz	1200.20
1699958868	1699958868	1	1	JWCH INSTITUTE, INC	15May2006	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	19	Los Angeles	BELL GARDENS COMM HEALTH	6912 AJAX AVE	None	BELL GARDENS	CA	902014057	33.969702	-118.163038	78.2c	5341.02
1710590971	1710590971	1	1	JAVIER R RIOS MD, A PROFESSI	12Jul2021	022	PHYSICIANS GROUP	None	None	UNKNOWN	0	In state provider	33	Riverside	None	6926 BROCKTON AVE	STE 7	RIVERSIDE	CA	925063804	33.948018	-117.396781	135c	311
1770988370	1770988370	1	1	JWCH INSTITUTE INC	25Feb2016	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	0	In state provider	19	Los Angeles	None	8530 FIRESTONE BLVD	None	DOWNEY	CA	902414926	33.937987	-118.128996	78.2eee	5513
1982876322	1982876322	1	1	JOY CARINO KIMPO FAMILY	01Mar1997	058	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	0	In state provider	15	Kern	MEDICAL CENTER	1001 MAIN ST	None	DELANO	CA	932151731	35.769010	-119.245635	60	50.04