Table: 2017_quarter_2_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	20172	07/01/2016	06/30/2017	Open	Napa	03	0407	State	State Hospitals	None	(707) 253-5000	2100 NAPA-VALLEJO HIGHWAY	NAPA	94558	FRANK TURLEY	1,418	1,270	1,270	285	0	0	0	0	0	4	0	0	500	789	0	185,579	0	0	0	0	0	305	0	0	246,298	432,182	0	0	0	0	0	0	0	0	0	0	0	0	107,474,932	0	0	0	0	0	179,095	0	0	142,943,684	250,597,711	0	0	0	0	0	0	0	0	0	0	0	0	326	0	0	0	0	0	0	0	0	0	0	0	0	0	25,764	26,090	0	0	0	0	0	107,474,606	0	0	0	0	0	179,095	0	0	142,917,920	250,571,621	0	300,670,694	0	50,099,073	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106274043	NATIVIDAD MEDICAL CENTER	20172	07/01/2016	06/30/2017	Open	Monterey	08	0705	City/County	Comparable	None	(831) 755-4111	1441 CONSTITUTION BOULEVARD	SALINAS	93906	GARY GRAY	172	137	137	1,654	0	2,409	2,844	0	0	1,695	0	24	295	8,921	0	11,247	0	9,757	9,428	0	0	7,647	0	90	805	38,974	0	25,873	0	26,188	82,459	0	0	30,498	0	4,607	9,050	178,675	190,623,975	0	181,900,498	204,998,728	0	0	179,570,983	0	3,340,246	11,026,372	771,460,802	43,062,524	0	44,642,416	147,575,924	0	0	80,868,721	0	4,988,035	17,929,441	339,067,061	28,177,196	191,900,887	0	194,456,658	302,969,013	(37,183,189)	0	0	149,308,213	0	0	8,327,832	0	0	0	0	837,956,610	0	0	0	0	0	41,785,612	0	69,260,662	49,614,869	0	0	111,131,490	0	0	778,620	272,571,253	4,516,868	260,163,355	0	13,107,490	0	0	0	0	16,841,237	125,119,568	0	0	0	0	0	0	0	0	0	0	0	0	0
106301304	NEWPORT BAY HOSPITAL	20172	07/01/2016	06/30/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	864	79	0	0	0	0	4	0	0	0	947	0	10,602	1,039	0	0	0	0	47	0	0	0	11,688	0	0	0	0	0	0	0	0	0	0	0	0	14,948,770	1,561,323	0	0	0	0	49,694	0	0	0	16,559,787	0	0	0	0	0	0	0	0	0	0	0	0	4,889,626	655,755	0	0	0	0	0	9,939	0	0	0	0	0	0	0	5,555,320	0	0	0	0	0	10,059,144	905,568	0	0	0	0	39,755	0	0	0	11,004,467	630	11,172,402	0	0	0	0	0	0	0	871	0	0	0	0	0	0	0	0	0	0	0	0	0
106514033	NORTH VALLEY BEHAVIORAL HEALTH - PHF	20172	07/01/2016	06/30/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	442	442	0	0	0	0	0	0	0	0	0	0	5,492	5,492	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4,801,505	4,801,505	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	4,801,505	4,801,505	30,150	4,731,777	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	20172	07/01/2016	06/30/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,988	283	827	2,383	0	0	339	1,185	22	57	9,084	0	20,809	1,463	5,295	11,335	0	0	1,571	4,470	58	171	45,172	0	88,545	5,462	11,565	88,734	0	0	48,561	86,983	83	6,942	336,875	904,478,365	68,924,844	182,916,830	458,035,867	0	0	67,223,157	206,964,072	5,712,180	13,396,115	1,907,651,430	447,758,019	25,326,814	96,194,845	496,121,211	0	0	93,843,905	311,160,054	2,087,306	44,749,846	1,517,242,000	14,243,783	1,237,361,595	69,170,422	247,915,223	896,052,207	(1,208,715)	0	0	93,344,991	423,147,172	0	39,447,337	0	0	0	0	3,019,474,015	0	54,176,720	0	34,499,603	88,676,323	114,874,788	25,081,236	32,405,166	112,281,591	0	0	67,722,071	129,476,557	0	12,254,329	494,095,738	56,065,404	544,274,721	0	17,854,053	0	0	0	0	76,943,080	190,600,346	0	0	0	0	0	0	0	0	0	0	0	0	0
106454012	NORTHERN CALIFORNIA REHABILITATION HOSPITAL	20172	07/01/2016	06/30/2017	Open	Shasta	01	0209	Investor - Corp.	Comparable	None	(530) 246-9000	2801 EUREKA WAY	REDDING	96001	CHRIS JONES	88	88	74	864	8	0	179	0	0	2	41	0	0	1,094	0	20,613	293	0	4,844	0	0	39	1,444	0	0	27,233	0	3,146	20	1	5	0	0	130	698	0	0	4,000	143,819,351	2,937,389	0	37,729,717	0	0	133,503	11,592,244	0	0	196,212,204	2,787,642	21,794	10,258	63,574	0	0	71,104	504,878	0	0	3,459,250	414,292	117,199,821	2,412,134	10,258	28,822,596	0	0	0	140,260	10,117,486	0	0	0	0	0	0	159,116,847	0	0	0	0	0	28,992,880	547,049	0	8,970,695	0	0	64,347	1,979,636	0	0	40,554,607	214,829	28,867,020	0	0	0	0	0	0	375,236	8,359,841	0	0	0	0	0	0	0	0	0	0	0	0	0
106141273	NORTHERN INYO HOSPITAL	20172	07/01/2016	06/30/2017	Open	Inyo	12	1203	District	Comparable	Rural	(760) 873-5811	150 PIONEER LANE	BISHOP	93514	KEVIN FLANIGAN, MD	25	25	10	502	14	118	168	0	0	40	204	13	31	1,090	0	1,676	48	303	404	0	0	115	516	57	76	3,195	0	25,926	509	6,208	14,803	0	18	5,186	24,165	568	2,224	79,607	17,954,399	539,546	3,684,135	5,265,968	0	0	1,537,424	7,160,029	929,490	1,081,453	38,152,444	34,973,661	849,030	7,545,457	13,152,997	0	24,784	5,269,020	26,716,114	562,821	2,280,878	91,374,762	2,001,807	22,892,903	290,468	9,791,993	10,905,702	(2,038,003)	0	11,094	5,114,059	4,589,761	0	1,167,382	(30)	0	0	414,415	55,141,551	0	0	0	0	0	30,035,157	1,098,107	2,922,599	8,066,266	0	13,690	1,692,385	29,286,382	324,959	946,110	74,385,655	452,015	71,155,220	9,376,315	(3,715,054)	0	0	0	0	1,452,123	79,787,383	0	0	0	0	0	0	0	0	0	0	0	0	0
106190568	NORTHRIDGE HOSPITAL MEDICAL CENTER	20172	07/01/2016	06/30/2017	Open	Los Angeles	11	0905	Non Profit Corp.	Comparable	None	(818) 885-8500	18300 ROSCOE BOULEVARD	NORTHRIDGE	91325	SALIBA SALO	412	412	185	4,145	2,091	1,724	2,125	0	0	324	3,494	43	193	14,139	0	20,351	10,225	7,946	8,063	0	0	1,238	15,525	152	644	64,144	0	20,725	8,701	10,754	27,516	0	0	4,066	28,642	949	6,866	108,219	521,042,387	238,213,254	182,257,073	184,752,260	0	0	35,553,653	344,271,951	2,582,065	11,039,593	1,519,712,236	155,603,457	74,669,822	58,459,336	140,237,954	0	0	11,549,855	163,099,531	4,042,391	34,250,691	641,913,037	30,957,153	579,925,173	257,810,031	191,746,714	281,843,611	0	0	0	36,925,832	360,082,852	0	8,430,559	0	0	0	26,327,671	1,774,049,596	0	0	0	0	0	95,362,622	54,511,387	41,637,755	42,124,860	0	0	9,188,443	142,973,237	0	1,777,373	387,575,677	9,070,506	409,690,887	0	1,324,962	0	0	0	0	19,440,361	188,802,847	0	0	0	0	0	0	0	0	0	0	0	0	0
106214034	NOVATO COMMUNITY HOSPITAL	20172	07/01/2016	06/30/2017	Open	Marin	04	0405	Non Profit Corp.	Comparable	None	(415) 209-1300	180 ROWLAND WAY	NOVATO	94945	GRANT DAVIES	47	47	23	1,138	83	51	187	0	0	27	275	10	15	1,786	0	4,273	295	254	598	0	0	61	696	16	39	6,232	0	22,137	1,562	1,142	7,093	0	3	1,344	22,362	1,141	837	57,621	66,788,116	4,777,965	3,131,153	9,006,915	0	0	1,587,348	15,693,887	366,237	784,505	102,136,126	56,263,018	4,900,040	3,871,164	21,281,839	0	15,114	3,479,480	46,904,614	2,070,380	1,907,159	140,692,808	1,242,434	99,313,036	7,326,195	6,340,439	27,683,500	0	0	4,505	4,080,425	26,392,933	0	2,187,223	0	0	0	155,372	174,726,062	0	0	0	0	0	23,738,098	2,351,810	661,878	2,605,254	0	10,609	986,403	36,023,597	0	1,725,223	68,102,872	3,970,944	78,560,909	0	471,637	0	0	0	0	1,536,005	35,726,106	0	0	0	0	0	0	0	0	0	0	0	0	0