Table: 2017_quarter_4_complete_data_set_4_13_18 , fac_name like N*

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  *

fac_no	fac_name	year_qtr	beg_date	end_date	op_status	county_name	hsa	hfpa	type_cntrl	type_hosp	teach_rurl	phone	address	city	zip_code	ceo	lic_beds	avl_beds	stf_beds	dis_mcar	dis_mcar_mc	dis_mcal	dis_mcal_mc	dis_cnty	dis_cnty_mc	dis_thrd	dis_thrd_mc	dis_indgnt	dis_oth	dis_tot	dis_ltc	day_mcar	day_mcar_mc	day_mcal	day_mcal_mc	day_cnty	day_cnty_mc	day_thrd	day_thrd_mc	day_indgnt	day_oth	day_tot	day_ltc	vis_mcar	vis_mcar_mc	vis_mcal	vis_mcal_mc	vis_cnty	vis_cnty_mc	vis_thrd	vis_thrd_mc	vis_indgnt	vis_oth	vis_tot	grip_mcar	grip_mcar_mc	grip_mcal	grip_mcal_mc	grip_cnty	grip_cnty_mc	grip_thrd	grip_thrd_mc	grip_indgnt	grip_oth	grip_tot	grop_mcar	grop_mcar_mc	grop_mcal	grop_mcal_mc	grop_cnty	grop_cnty_mc	grop_thrd	grop_thrd_mc	grop_indgnt	grop_oth	grop_tot	bad_debt	cadj_mcar	cadj_mcar_mc	cadj_mcal	cadj_mcal_mc	disp_855	cadj_cnty	cadj_cnty_mc	cadj_thrd	cadj_thrd_mc	char_hb	char_oth	sub_indgnt	tch_allow	tch_supp	ded_oth	ded_tot	cap_mcar	cap_mcal	cap_cnty	cap_thrd	cap_tot	net_mcar	net_mcar_mc	net_mcal	net_mcal_mc	net_cnty	net_cnty_mc	net_thrd	net_thrd_mc	net_indgnt	net_oth	net_tot	oth_op_rev	tot_op_exp	phy_comp	nonop_rev	dis_pips	day_pips	exp_pips	exp_pops	cap_exp	fix_assets	disp_trnfr	dis_tot_cc	pat_day_tot_cc	tot_out_vis_cc	gros_inpat_rev_cc	gros_outpat_rev_cc	contr_adj_cc	othr_deduct_cc	cap_prem_rev_cc	net_pat_rev_cc	qa_fees	qa_suppl_pay	mngd_care_qa_pay
106281266	NAPA STATE HOSPITAL	20174	10/01/2017	12/31/2017	Open	Napa	03	0407	State	State Hospitals	None	707-253-5000	2100 NAPA-VALLEJO HIGHWAY	NAPA	94558	FRANK TURLEY	1,418	1,315	1,315	47	0	0	0	0	0	2	0	0	171	220	0	60,503	0	0	0	0	0	28	0	0	49,691	110,222	0	0	0	0	0	0	0	0	0	0	0	0	34,409,252	0	0	0	0	0	16,110	0	0	28,260,284	62,685,646	0	0	0	0	0	0	0	0	0	0	0	0	198	0	0	0	0	0	0	0	0	0	0	0	0	0	41,095	41,293	0	0	0	0	0	34,409,054	0	0	0	0	0	16,110	0	0	28,219,189	62,644,353	0	80,046,425	0	17,402,072	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106274043	NATIVIDAD MEDICAL CENTER	20174	10/01/2017	12/31/2017	Open	Monterey	08	0705	City/County	Comparable	None	831-755-4111	1441 CONSTITUTION BOULEVARD	SALINAS	93906	GARY GRAY	172	137	137	456	0	584	696	0	0	460	0	8	66	2,270	0	2,784	0	2,614	2,581	0	0	2,298	0	26	178	10,481	0	6,325	0	6,800	20,214	0	0	8,301	0	958	2,366	44,964	47,889,256	0	47,888,893	49,184,864	0	0	52,013,088	0	872,164	3,381,912	201,230,177	11,299,849	0	12,711,303	39,251,367	0	0	22,731,497	0	1,068,386	6,291,476	93,353,878	9,598,700	48,403,608	0	51,140,605	71,447,159	(7,852,500)	0	0	46,078,579	0	0	1,971,321	0	0	0	0	220,787,472	0	0	0	0	0	10,785,497	0	17,312,091	16,989,072	0	0	28,666,005	0	0	43,918	73,796,583	596,977	65,769,170	0	3,482,186	0	0	0	0	1,968,030	123,094,329	0	0	0	0	0	0	0	0	0	0	0	0	0
106301304	NEWPORT BAY HOSPITAL	20174	10/01/2017	12/31/2017	Open	Orange	13	1016	Investor - Corp.	Comparable	None	949-650-9750	1501 EAST 16TH STREET	NEWPORT BEACH	92663	JAMES E PARKHURST	36	36	36	231	20	0	0	0	0	2	0	0	0	253	0	2,757	252	0	0	0	0	22	0	0	0	3,031	0	0	0	0	0	0	0	0	0	0	0	0	3,764,484	364,243	0	0	0	0	14,223	0	0	0	4,142,950	0	0	0	0	0	0	0	0	0	0	0	0	1,074,330	152,981	0	0	0	0	0	2,845	0	0	0	0	0	0	0	1,230,156	0	0	0	0	0	2,690,154	211,262	0	0	0	0	11,378	0	0	0	2,912,794	85	2,986,692	0	0	0	0	0	0	0	804	0	0	0	0	0	0	0	0	0	0	0	0	0
106514033	NORTH VALLEY BEHAVIORAL HEALTH - PHF	20174	10/01/2017	12/31/2017	Open	Sutter	02	0227	Investor - Corp.	Psychiatric Health Facilities	None	530-790-2520	1535 PLUMAS COURT	YUBA CITY	95993	ARNE HYSON	16	16	16	0	0	0	0	0	0	0	0	0	90	90	0	0	0	0	0	0	0	0	0	0	1,414	1,414	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,314,221	1,314,221	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,314,221	1,314,221	1,114	1,477,917	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106481357	NORTHBAY MEDICAL CENTER	20174	10/01/2017	12/31/2017	Open	Solano	03	0408	Non Profit Corp.	Comparable	None	707-646-5000	1200 B. GALE WILSON BOULEVARD	FAIRFIELD	94533	B KONARD JONES	182	182	182	870	73	161	581	0	7	71	276	9	20	2,068	0	4,695	328	665	2,743	0	98	472	949	80	79	10,109	0	23,878	1,401	2,316	21,019	0	79	10,511	21,418	37	1,798	82,457	217,305,818	17,963,794	30,642,995	112,312,127	0	5,197,693	24,692,019	55,779,887	1,275,866	2,986,111	468,156,310	129,989,166	7,848,078	23,305,861	127,799,176	0	464,992	24,909,622	83,999,820	977,286	10,541,282	409,835,283	9,340,784	317,807,325	23,187,132	40,978,181	229,236,728	(3,063)	0	5,379,551	25,826,774	101,880,244	0	5,773,029	0	0	0	0	759,406,685	0	13,009,778	0	8,624,749	21,634,527	29,487,659	2,624,740	12,973,738	23,884,353	0	283,134	23,774,867	46,524,212	0	666,732	140,219,435	2,043,996	145,203,589	0	4,864,184	0	0	0	0	28,432,629	221,267,503	0	0	0	0	0	0	0	0	0	0	0	0	0
106141273	NORTHERN INYO HOSPITAL	20174	10/01/2017	12/31/2017	Open	Inyo	12	1203	District	Comparable	Rural	760-873-5811	150 PIONEER LANE	BISHOP	93514	KEVIN FLANIGAN, MD	25	25	10	137	4	19	39	0	0	10	55	1	2	267	0	501	10	64	88	0	0	25	144	8	1	841	0	6,207	133	1,301	3,173	0	1	1,346	6,106	177	426	18,870	5,958,979	108,720	703,128	1,275,543	0	0	320,793	2,381,688	249,040	1,307	10,999,198	9,949,047	436,316	1,711,677	3,335,648	0	610	1,351,732	7,860,344	305,573	626,556	25,577,503	466,046	8,159,171	232,918	1,893,936	3,640,094	(2,277,577)	0	0	1,527,827	1,485,404	0	521,614	(4)	0	0	92,011	15,741,440	0	0	0	0	0	7,748,855	312,118	2,798,446	971,097	0	610	144,698	8,756,628	33,003	69,806	20,835,261	149,229	20,088,077	2,890,645	(587,645)	0	0	0	0	140,875	77,977,523	0	0	0	0	0	0	0	0	0	0	0	0	0
106190568	NORTHRIDGE HOSPITAL MEDICAL CENTER	20174	10/01/2017	12/31/2017	Open	Los Angeles	11	0905	Non Profit Corp.	Comparable	None	818-885-8500	18300 ROSCOE BOULEVARD	NORTHRIDGE	91325	SALIBA SALO	412	412	200	1,105	542	444	671	0	0	99	841	0	32	3,734	0	5,727	2,537	1,968	2,272	0	0	467	3,585	0	148	16,704	0	5,253	2,167	3,231	7,727	0	0	1,325	7,344	0	927	27,974	141,859,323	61,871,109	45,989,034	57,232,553	0	0	13,465,622	84,916,092	0	1,210,265	406,543,998	39,375,953	18,397,790	16,085,607	36,174,176	0	0	3,776,704	41,649,671	0	5,393,328	160,853,229	11,355,601	157,160,573	65,377,385	13,743,338	83,795,560	0	0	0	13,138,666	85,655,494	0	(873,366)	0	0	0	2,919,980	432,273,231	0	0	0	0	0	23,390,740	14,602,997	44,742,558	9,426,541	0	0	3,711,330	38,816,474	0	433,356	135,123,996	2,175,851	123,149,239	0	570,722	0	0	0	0	1,886,769	183,069,704	0	0	0	0	0	0	0	0	0	0	0	0	0
106214034	NOVATO COMMUNITY HOSPITAL	20174	10/01/2017	12/31/2017	Open	Marin	04	0405	Non Profit Corp.	Comparable	None	415-209-1300	180 ROWLAND WAY	NOVATO	94945	GRANT DAVIES	47	47	21	300	28	22	39	0	0	8	68	9	0	474	0	916	112	59	164	0	0	27	186	13	0	1,477	0	1,303	120	148	1,182	0	0	138	1,552	136	130	4,709	14,774,627	1,443,736	903,554	2,204,923	0	0	540,822	3,889,930	306,592	0	24,064,184	13,215,505	1,593,609	820,384	5,053,181	0	0	1,329,544	12,014,661	653,436	624,503	35,304,823	392,569	22,583,456	2,521,896	913,954	6,200,870	0	0	0	1,413,691	6,242,460	0	960,028	0	0	0	231,934	41,460,858	0	0	0	0	0	5,406,676	515,449	809,984	1,057,234	0	0	456,675	9,662,131	0	0	17,908,149	1,849,491	24,038,393	0	2,258,102	0	0	0	0	849,096	35,162,212	0	0	0	0	0	0	0	0	0	0	0	0	0