Table family_pact_providers_profile_cys_2020

Table: family_pact_providers_profile_cys_2020_2021 , 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_desc	attention_line	provider_address_line1	provider_address_line2	provider_address_city	provider_address_state	provider_address_zip	provider_phone_number	provider_address_latitude	provider_address_longitude	mssa_id	tract_id
1043304009	1043304009	1	1	Jwch Institue Inc	6-Sep-05	58	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	In state provider	19	Los Angeles	None	14371 Clark Ave	None	Bellflower	CA	90706-2901	(213) 484-1186	33.903214	-118.13406	78.2m	5540.01
1124182977	1124182977	1	1	Jwch Institute Inc	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	19	Los Angeles	None	3591 E Imperial Highway	None	Lynwood	CA	90262-2684	(310) 638-9025	33.930479	-118.205406	78.2sss	5402.02
1275661811	1275661811	1	1	John Marshall High	30-Oct-06	58	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	In state provider	19	Los Angeles	SCHOOL HEALTH CENTER	3939 Tracy St	None	Los Angeles	CA	90027-3207	(323) 644-3880	34.10774	-118.277634	78.2ff	1952.01
1386646404	1386646404	1	1	James Corona Md	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	41	Internal Medicine	In state provider	11	Glenn	None	203 Walker St	# 2	Orland	CA	95963-9904	(530) 865-6430	39.747371	-122.191484	36.1	101
1386708634	1386708634	1	1	Jwch Institute, Inc	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	19	Los Angeles	JWCH NORWALK REGIONAL	12360 Firestone Blvd	None	Norwalk	CA	90650-4324	(562) 281-0305	33.906084	-118.06963	78.2jjjj	5522
1417005695	1417005695	1	1	Johnson, Lorna M Cnm	27-Jul-04	5	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-2432	(323) 588-0084	33.974765	-118.254103	78.2fff	5350.01
1427220862	1427220862	1	1	Joy Carino Kimpo Womens	17-Jun-08	58	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	In state provider	15	Kern	HEALTH CENTER	320 James St	None	Shafter	CA	93263-2033	(661) 459-1800	35.503304	-119.277388	58.1	41.01
1457460503	1457460503	1	1	Jayasinghe Med Group Inc	23-Jun-83	22	PHYSICIANS GROUP	FNP024603	None	UNKNOWN	In state provider	19	Los Angeles	LOS ANGELES MEDICAL CTR	319 N Soto St	None	Los Angeles	CA	90033-1837	(323) 266-6730	34.04729	-118.207479	78.2h	2036
1598829350	1598829350	1	1	Jwch Institute, Inc	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	19	Los Angeles	None	954 N Vermont Ave	None	Los Angeles	CA	90029-3529	(323) 201-4516	34.088852	-118.29172	78.2g	1914.1
1679846190	1679846190	1	1	Jimenez, Arthur E Md Inc	26-Mar-13	26	PHYSICIANS	A00064270	8	Family Practice	In state provider	36	San Bernardino	None	15381 7th St	Ste 2-3	Victorville	CA	92395-3858	(760) 245-2380	34.531206	-117.298456	145.1a	98
1699152058	1699152058	1	1	Joon Choi, Md. Apc	6-Jan-21	26	PHYSICIANS	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-4810	(818) 990-4010	34.22001	-118.448778	78.2zz	1200.2
1699958868	1699958868	1	1	Jwch Institute, Inc	24-May-06	58	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	In state provider	19	Los Angeles	BELL GARDENS COMM HEALTH	6912 Ajax Ave	None	Bell Gardens	CA	90201-4057	(323) 562-5813	33.969702	-118.163038	78.2c	5341.02
1770988370	1770988370	1	1	Jwch Institute Inc	22-Feb-20	200	DEVELOPMENTAL SCREENING AND TRAUMA	None	None	UNKNOWN	In state provider	19	Los Angeles	None	8530 Firestone Blvd	None	Downey	CA	90241-4926	(323) 201-4516	33.937987	-118.128996	78.2eee	5513
1982876322	1982876322	1	1	Joy Carino Kimpo Family	17-Jun-08	58	HEALTH ACCESS PROGRAM	None	None	UNKNOWN	In state provider	15	Kern	MEDICAL CENTER	1001 Main St	None	Delano	CA	93215-1731	(661) 721-7080	35.76901	-119.245635	60	50.04