Table family_pact_providers_profile_cy

Table: family_pact_providers_profile_cy_2019 , 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_desc	provider_address_county_code	provider_address_county_code_description	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
1033326863	1033326863	1	1	JOHN PAUL II MEDICAL CLINIC	15-Jul-08	Physicians (026)	PHYSICIANS	A52551	1	General Practice	In state provider	19	Los Angeles	INC A PROFESSIONAL CORP	7402 SEVILLE AVE	None	HUNTINGTON PARK	CA	90255	33.972219	-118.222467	78.2fff	5348.02
1043451982	1043451982	1	1	JOHN K FLYNN COMMUNITY CLINI	31-Aug-17	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	56	Ventura	None	3100 N ROSE AVE	None	OXNARD	CA	93036	34.233315	-119.155121	241b	50.02
1336367515	1336367515	1	1	JEROLD PHELPS COMM HOSP	12-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	12	Humboldt	CLINIC	509 ELM ST	None	GARBERVILLE	CA	95542	40.10283	-123.794024	44	116
1376681486	1376681486	1	1	JORDAN WELLNESS CENTER	18-Aug-03	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	None	10110 JUNIPER ST	None	LOS ANGELES	CA	90002	33.944825	-118.233201	78.2fff	2421
1386646404	1386646404	1	1	JAMES CORONA MD	17-Sep-09	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	11	Glenn	None	203 WALKER ST	# 2	ORLAND	CA	95963	39.747371	-122.191484	36.1	101
1386708634	1386708634	1	1	JWCH NORWALK REGIONAL	29-Jun-09	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	JWCH NORWALK REGIONAL	12360 FIRESTONE BLVD	None	NORWALK	CA	90650	33.906084	-118.06963	78.2jjjj	5522
1417005695	1417005695	1	1	JOHNSON, LORNA M CNM	26-Jun-97	Certified Nurse Midwife (005)	CERTIFIED NURSE MIDWIFE	303602	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	19	Los Angeles	None	1201 E FLORENCE AVE	None	LOS ANGELES	CA	90001	33.974765	-118.254103	78.2fff	5350.01
1477584993	1477584993	1	1	JOHN F KENNEDY MEM HOSP	31-May-01	Community Hosp Outpatient (015)	COMMUNITY OUTPATIENT HOSPITAL	None	99	Unknown (on EDS claims)	In state provider	33	Riverside	HOSPITAL, INC	47111 MONROE ST	None	INDIO	CA	92201	33.7061	-116.233965	128	452.07
1538246194	1538246194	1	1	JONES, ANTHONY E MD	21-Apr-15	Physicians (026)	PHYSICIANS	A00064757	8	Family Practice	In state provider	1	Alameda	None	400 29TH ST	STE 501	OAKLAND	CA	94609	37.817745	-122.264964	2m	4013
1548298532	1548298532	1	1	JEFFREY GOODMAN SPECIAL CARE	2-Jul-09	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	COMMUNITY SERVICE CENTER	1625 SCHRADER BLVD	FL 3	LOS ANGELES	CA	90028	34.10072	-118.33248	78.2g	1907
1699152058	1699152058	1	1	JOON CHOI, MD. APC	3-Oct-17	Physicians Group (022)	PHYSICIANS GROUP	None	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	19	Los Angeles	None	8215 VAN NUYS BLVD	SUITE 104	PANORAMA CITY	CA	91402	34.22001	-118.448778	78.2zz	1200.2
1699958868	1699958868	1	1	JWCH INSTITUTE, INC	15-May-06	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	BELL GARDENS COMM HEALTH	6912 AJAX AVE	None	BELL GARDENS	CA	90201	33.969702	-118.163038	78.2c	5341.02
1871607713	1871607713	1	1	JURUPA VALLEY COMMUNITY HEAL	7-Jul-04	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	33	Riverside	None	8876 MISSION BLVD	None	JURUPA VALLEY	CA	92509	34.011774	-117.477184	135e	405.01