Table family_pact_providers_profile_cy

Table: family_pact_providers_profile_cy_2019 , provider_business_legal_name like K*

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
1013311448	1013311448	1	1	KHEIR WILSHIRE CLINIC	5-May-15	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	INFORMATION & RESEARCH	3255 WILSHIRE BLVD	STE 120	LOS ANGELES	CA	90010	34.061805	-118.292895	78.2e	2121.01
1023167541	1023167541	1	1	KERN CO	6-Oct-97	Community Clinics (041)	COMMUNITY CLINIC	None	99	Unknown (on EDS claims)	In state provider	15	Kern	PUBLIC HEALTH	1800 MOUNT VERNON AVE	None	BAKERSFIELD	CA	93306	35.383041	-118.967549	66b	12.01
1033598412	1033598412	1	1	KINGSBURG COMMUNITY HEALTH C	9-Nov-18	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	None	1250 SMITH STREET	None	KINGSBURG	CA	93631	36.512871	-119.548922	30	72.01
1043272172	1043272172	1	1	KAWEAH DELTA EXETER HLTH	8-Aug-98	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	54	Tulare	SAN JUAN HEALTH CENTER	1014 SAN JUAN AVE	None	EXETER	CA	93221	36.298896	-119.132496	228.2	15.01
1073578134	1073578134	1	1	KAMRAS & POLANSKY MDS IN	6-Jan-97	Physicians Group (022)	PHYSICIANS GROUP	YYY49032Y	99	Unknown (on EDS claims)	In state provider	34	Sacramento	None	5821 JAMESON CT	None	CARMICHAEL	CA	95608	38.651156	-121.328832	139b	76.01
1104067636	1104067636	1	1	KAWEAH DELTA LINDSAY HLTH CL	10-Oct-11	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	54	Tulare	None	839 N SEQUOIA AVE	None	LINDSAY	CA	93247	36.212938	-119.096107	228.2	26.01
1104881523	1104881523	1	1	KUMARATNE, MOHAN P MD	15-Mar-02	Physicians (026)	PHYSICIANS	A35327	1	General Practice	In state provider	30	Orange	None	17692 BEACH BLVD	STE 200	HUNTINGTON BEACH	CA	92647	33.705708	-117.989099	116s	992.12
1144371436	1144371436	1	1	KIM, MEE SOOK, MD	28-Apr-97	Physicians (026)	PHYSICIANS	A00039215	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	19	Los Angeles	None	14624 SHERMAN WAY	STE 207	VAN NUYS	CA	91405	34.201206	-118.451927	78.2zz	1272.2
1154614097	1154614097	1	1	KAWEAH DELTA WOODLAKE	12-Jan-12	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	54	Tulare	DISTRICT	180 E ANTELOPE AVE	None	WOODLAKE	CA	93286	36.415571	-119.097881	228.1	7.02
1205845583	1205845583	1	1	KIM, HYUK DO INC	3-Apr-03	Physicians (026)	PHYSICIANS	20A7982	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	19	Los Angeles	None	13563 VAN NUYS BLVD	None	PACOIMA	CA	91331	34.261391	-118.428525	78.2ppp	1046.2
1376687061	1376687061	1	1	KINGS CO HLTH DEPT 2	1-Mar-97	County Clinics not assoc w/hosp (048)	COUNTY CLINICS NOT ASSOCIATED WITH HOSPITAL	ZZT11796	99	Unknown (on EDS claims)	In state provider	16	Kings	OUTPATIENT CLINIC	330 CAMPUS DR	None	HANFORD	CA	93230	36.326796	-119.663642	69	10.02
1407841620	1407841620	1	1	KOTHAPA, SANGAMITRA MD	22-Jun-99	Physicians (026)	PHYSICIANS	A00043502	8	Family Practice	In state provider	30	Orange	INC	1226 N BROADWAY	None	SANTA ANA	CA	92701	33.755483	-117.869735	116b	750.03
1417378597	1417378597	1	1	KEDREN COMMUNITY CARE CLINIC	28-May-14	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	CENTER INC	4211 SOUTH AVALON BLVD	SUITE A	LOS ANGELES	CA	90011	34.007344	-118.265245	78.2ggg	2283.2
1427089150	1427089150	1	1	KINGS COMPREHENSIVE	1-Mar-97	Physicians Group (022)	PHYSICIANS GROUP	FNP022686	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	16	Kings	WOMEN'S HLTHCARE MED GRP	460 GREENFIELD AVE	STE 1	HANFORD	CA	93230	36.331054	-119.657461	69	10.01
1437377454	1437377454	1	1	KHEIR HEALTH SVS CTR	10-Mar-05	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	KHEIR HEALTH SVS CTR	3727 W 6TH ST	STE 200	LOS ANGELES	CA	90020	34.063555	-118.303534	78.2e	2118.02
1497933691	1497933691	1	1	KORYO HEALTH FOUNDATION	28-Apr-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	19	Los Angeles	None	1058 S VERMONT AVE	None	LOS ANGELES	CA	90006	34.050843	-118.291606	78.2b	2134.02
1588663769	1588663769	1	1	KAWEAH DELTA MED CTR	15-May-97	Community Hosp Outpatient (015)	COMMUNITY OUTPATIENT HOSPITAL	120000580	99	Unknown (on EDS claims)	In state provider	54	Tulare	DISTRICT	400 W MINERAL KING AVE	None	VISALIA	CA	93291	36.327346	-119.293437	233	12
1730279423	1730279423	1	1	KARUK TRIBAL HEALTH	1-May-06	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	47	Siskiyou	None	1519 S OREGON ST	None	YREKA	CA	96097	41.717309	-122.642054	195	7.02
1750608931	1750608931	1	1	KAMALI, POURANG MD INC	17-Nov-11	Physicians (026)	PHYSICIANS	None	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	37	San Diego	None	769 MEDICAL CENTER CT	STE 301	CHULA VISTA	CA	91911	32.618563	-117.024187	161s	133.1
1760545503	1760545503	1	6	KATUKOTA, VIJAY C A MEDICAL	14-Sep-10	Physicians Group (022)	PHYSICIANS GROUP	None	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	19	Los Angeles	None	459 S AZUSA AVENUE	SUITE F	AZUSA	CA	91702	34.114996	-117.907741	78.2zzz	4044.02
1760596712	1760596712	1	1	KERN WOMENS HEALTH GROUP	1-Jan-09	Physicians Group (022)	PHYSICIANS GROUP	FNP033148	16	Obstetrics-Gynecology (M.D. Only) Neonatal	In state provider	15	Kern	GROUP INC	2005 17TH STREET	None	BAKERSFIELD	CA	93301	35.374371	-119.02478	66d	17
1780718957	1780718957	1	1	KERN VALLEY MEDICAL CTR	1-Sep-04	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	KERN VALLEY MEDICAL CTR	6310 LAKE ISABELLA BLVD	None	LAKE ISABELLA	CA	93240	35.628167	-118.472665	63	52.04
1841607801	1841607801	1	1	KAWEAH DELTA DINUBA HEALTH	1-Feb-16	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	54	Tulare	DISTRICT	355 MONTE VISTA DRIVE	STE A	DINUBA	CA	93618	36.540128	-119.403985	227.1	5.02
1871627042	1871627042	1	1	KERN RIVER HELATH CTR	1-Mar-97	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	15	Kern	PO BOX 1150	67 EVANS RD	None	WOFFORD HEIGHTS	CA	93285	35.706666	-118.457985	63	52.01
1952483406	1952483406	1	1	KARUK COMMUNITY HLTH CLINIC	23-Feb-05	Health Access Program (058)	HEALTH ACCESS PROGRAM	230000041	99	Unknown (on EDS claims)	In state provider	47	Siskiyou	KARUK TRIBE OF CALIF	64236 SECOND AVENUE	None	HAPPY CAMP	CA	96039	41.792364	-123.381045	193	5
1962567388	1962567388	1	1	KERMAN HEALTH CENTER	19-Feb-99	Health Access Program (058)	HEALTH ACCESS PROGRAM	None	99	Unknown (on EDS claims)	In state provider	10	Fresno	KERMAN HEALTH CENTER	449 S MADERA AVE	None	KERMAN	CA	93630	36.728602	-120.060296	29	40.01