Table: 2017_quarter_4_sum_of_four_quarters , 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	01/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	181	0	0	0	0	0	5	0	0	614	800	0	163,625	0	0	0	0	0	361	0	0	269,594	433,580	0	0	0	0	0	0	0	0	0	0	0	0	94,583,183	0	0	0	0	0	210,974	0	0	155,567,785	250,361,942	0	0	0	0	0	0	0	0	0	0	0	0	374	0	0	0	0	0	0	0	0	0	0	0	0	0	189,765	190,139	0	0	0	0	0	94,582,809	0	0	0	0	0	210,974	0	0	155,378,020	250,171,803	0	312,965,644	0	62,793,841	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106274043	NATIVIDAD MEDICAL CENTER	20174	01/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	1,743	0	2,398	2,758	0	0	1,775	0	26	269	8,969	0	10,774	0	10,027	9,781	0	0	8,460	0	86	649	39,777	0	25,516	0	26,095	81,084	0	0	31,187	0	4,543	10,512	178,937	185,821,784	0	190,988,458	205,467,402	0	0	190,478,953	0	3,162,438	11,211,812	787,130,847	43,752,846	0	47,950,244	152,856,537	0	0	84,838,159	0	5,121,866	20,235,914	354,755,566	30,632,732	187,899,447	0	202,927,765	302,354,577	(30,676,350)	0	0	158,695,885	0	0	8,345,848	0	0	0	0	860,179,904	0	0	0	0	0	41,675,183	0	66,687,286	55,969,361	0	0	116,621,225	0	0	753,454	281,706,509	3,764,706	265,715,837	0	13,153,789	0	0	0	0	16,373,163	123,094,329	0	0	0	0	0	0	0	0	0	0	0	0	0
106301304	NEWPORT BAY HOSPITAL	20174	01/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	860	76	0	0	0	0	3	0	0	0	939	0	10,551	1,030	0	0	0	0	34	0	0	0	11,615	0	0	0	0	0	0	0	0	0	0	0	0	14,726,425	1,447,082	0	0	0	0	31,817	0	0	0	16,205,324	0	0	0	0	0	0	0	0	0	0	0	0	4,431,187	607,774	0	0	0	0	0	6,364	0	0	0	0	0	0	0	5,045,325	0	0	0	0	0	10,295,238	839,308	0	0	0	0	25,453	0	0	0	11,159,999	730	11,189,080	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	01/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	374	374	0	0	0	0	0	0	0	0	0	0	5,690	5,690	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5,071,768	5,071,768	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	5,071,768	5,071,768	65,655	5,227,802	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	01/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	3,647	281	715	2,331	0	7	341	1,118	26	67	8,533	0	18,892	1,448	4,050	10,987	0	98	1,612	4,222	144	238	41,691	0	90,110	5,619	8,933	82,365	0	79	41,093	78,951	82	6,463	313,695	893,555,637	77,242,256	157,284,048	465,759,530	0	5,197,693	76,938,674	225,511,726	7,003,445	15,691,611	1,924,184,620	484,351,528	30,400,236	95,847,770	506,061,854	0	464,992	87,239,570	319,358,192	2,314,237	55,582,453	1,581,620,832	22,588,797	1,260,808,848	92,119,656	216,260,498	927,039,752	(3,063)	0	5,379,551	95,112,326	402,202,011	0	46,776,827	0	0	0	0	3,068,285,203	0	52,838,685	0	35,743,699	88,582,384	117,098,317	15,522,836	36,874,383	97,620,317	0	283,134	69,065,918	178,411,606	0	11,226,122	526,102,633	7,168,104	556,437,129	0	18,540,210	0	0	0	0	51,342,991	221,267,503	0	0	0	0	0	0	0	0	0	0	0	0	0
106141273	NORTHERN INYO HOSPITAL	20174	01/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	524	18	111	164	0	0	43	209	11	16	1,096	0	1,789	60	294	390	0	0	114	522	53	43	3,265	0	25,242	522	5,803	13,975	0	8	5,247	23,372	628	1,757	76,554	20,338,328	687,886	3,569,657	5,333,287	0	0	1,752,744	8,035,683	706,271	587,171	41,011,027	37,693,339	1,239,417	7,458,538	13,368,311	0	15,366	5,997,213	29,122,428	784,144	2,008,346	97,687,102	1,944,852	26,901,081	481,574	8,548,879	12,055,614	(2,830,580)	0	9,032	5,650,942	5,199,538	0	1,498,427	(4)	0	0	245,987	59,705,342	0	0	0	0	0	31,130,586	1,445,728	4,756,893	7,198,987	0	6,334	2,099,015	31,958,573	(8,008)	404,679	78,992,787	484,603	75,443,391	10,517,468	(3,634,342)	0	0	0	0	955,042	77,977,523	0	0	0	0	0	0	0	0	0	0	0	0	0
106190568	NORTHRIDGE HOSPITAL MEDICAL CENTER	20174	01/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	4,319	2,191	1,686	2,419	0	0	473	3,410	19	113	14,630	0	21,293	10,653	7,179	8,759	0	0	1,670	14,762	123	603	65,042	0	20,939	8,889	11,266	29,584	12	0	4,447	28,812	639	5,381	109,969	543,567,046	254,981,646	182,386,731	203,351,276	0	0	44,724,211	332,490,920	2,114,507	9,086,733	1,572,703,070	159,083,660	76,739,477	58,445,896	146,081,361	67,926	0	12,390,218	163,541,010	2,483,381	27,711,276	646,544,205	35,465,874	614,382,256	274,683,913	175,489,569	315,940,155	0	55,058	0	44,277,141	338,294,356	0	3,445,437	0	0	0	17,791,549	1,819,825,308	0	0	0	0	0	86,270,930	56,255,586	60,522,332	32,568,237	9,997	0	11,625,152	150,259,199	0	1,910,534	399,421,967	8,241,617	422,250,928	0	1,603,874	0	0	0	0	20,678,891	183,069,704	0	0	0	0	0	0	0	0	0	0	0	0	0
106214034	NOVATO COMMUNITY HOSPITAL	20174	01/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	1,156	108	73	181	0	1	22	271	14	7	1,833	0	4,158	400	320	639	0	4	63	753	19	14	6,370	0	5,986	567	807	5,195	1	5	640	7,678	598	604	22,081	64,103,711	5,992,864	3,996,586	9,405,639	0	52,019	1,596,256	15,240,620	471,497	353,204	101,212,396	55,987,430	6,363,928	3,960,546	21,461,205	1,500	22,043	4,010,090	45,946,630	2,052,370	2,077,210	141,882,952	1,075,738	98,460,117	10,264,039	6,675,627	26,911,964	0	1,500	63,453	4,041,866	24,829,975	0	2,274,473	0	0	0	457,958	175,056,710	0	0	0	0	0	21,631,024	2,092,753	1,281,505	3,954,880	0	10,609	1,564,480	36,357,275	0	1,146,112	68,038,638	4,930,976	82,971,917	0	2,274,071	0	0	0	0	1,905,810	35,162,212	0	0	0	0	0	0	0	0	0	0	0	0	0