Table: 2017_quarter_3_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	20173	10/01/2016	09/30/2017	Open	Napa	03	0407	State	State Hospitals	None	(707) 253-5000	2100 NAPA-VALLEJO HIGHWAY	NAPA	94558	FRANK TURLEY	1418	1285	1285	222	0	0	0	0	0	4	0	0	545	771	0	152354	0	0	0	0	0	340	0	0	278062	430756	0	0	0	0	0	0	0	0	0	0	0	0	88462444	0	0	0	0	0	198949	0	0	160725132	249386525	0	0	0	0	0	0	0	0	0	0	0	0	333	0	0	0	0	0	0	0	0	0	0	0	0	0	148670	149003	0	0	0	0	0	88462111	0	0	0	0	0	198949	0	0	160576462	249237522	0	307795902	0	58558380	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106274043	NATIVIDAD MEDICAL CENTER	20173	10/01/2016	09/30/2017	Open	Monterey	08	0705	City/County	Comparable	None	(831) 755-4111	1441 CONSTITUTION BOULEVARD	SALINAS	93906	GARY GRAY	172	137	137	1666	0	2375	2781	0	0	1759	0	26	268	8875	0	10751	0	9709	9525	0	0	8065	0	92	704	38846	0	25935	0	25964	82419	0	0	31104	0	4768	10493	180683	181450977	0	187282679	207536813	0	0	185068653	0	3574394	9954392	774867908	43195589	0	46130322	149490708	0	0	83363998	0	5226957	19231436	346639010	28363092	184151437	0	199676171	306342893	-39367323	0	0	153490910	0	0	8832124	0	0	0	0	841489304	0	0	0	0	0	40495129	0	73104152	50684627	0	0	114941739	0	0	791967	280017614	4416580	263258853	0	12887380	0	0	0	0	17878134	124073763	0	0	0	0	0	0	0	0	0	0	0	0	0
106301304	NEWPORT BAY HOSPITAL	20173	10/01/2016	09/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	857	74	0	0	0	0	4	0	0	0	935	0	10515	976	0	0	0	0	47	0	0	0	11538	0	0	0	0	0	0	0	0	0	0	0	0	14799822	1363260	0	0	0	0	49694	0	0	0	16212776	0	0	0	0	0	0	0	0	0	0	0	0	4835294	575036	0	0	0	0	0	9939	0	0	0	0	0	0	0	5420269	0	0	0	0	0	9964528	788224	0	0	0	0	39755	0	0	0	10792507	800	11092054	0	0	0	0	0	0	0	837	0	0	0	0	0	0	0	0	0	0	0	0	0
106514033	NORTH VALLEY BEHAVIORAL HEALTH - PHF	20173	10/01/2016	09/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	403	403	0	0	0	0	0	0	0	0	0	0	5593	5593	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4913587	4913587	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	4913587	4913587	64541	4890528	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	20173	10/01/2016	09/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	3750	267	768	2341	0	0	359	1132	25	56	8698	0	19592	1408	4439	11267	0	0	1527	4493	81	173	42980	0	88924	5387	10174	84762	0	0	48368	81961	74	6415	326065	893390286	72485264	163141064	470099174	0	0	76306148	210860983	6905827	14753038	1907941784	468287360	27645072	96835203	495794043	0	0	86777666	316527970	2199258	55742859	1549809431	20384737	1245274816	80034355	227225801	913376198	-196116	0	0	97658164	396689147	0	47224850	0	0	0	0	3027671952	0	52141055	0	34996449	87137504	116402830	20095981	32946581	104658074	0	0	65425650	165696255	0	11991396	517216767	34052985	555716960	0	20830152	0	0	0	0	24278717	195424106	0	0	0	0	0	0	0	0	0	0	0	0	0
106454012	NORTHERN CALIFORNIA REHABILITATION HOSPITAL	20173	10/01/2016	09/30/2017	Open	Shasta	01	0209	Investor - Corp.	Comparable	None	(530) 246-9000	2801 EUREKA WAY	REDDING	96001	CHRIS JONES	88	88	74	851	9	0	202	0	0	1	39	0	0	1102	0	19774	215	0	5396	0	0	23	1556	0	0	26964	0	3091	20	1	6	0	0	73	837	0	0	4028	141380152	2381845	0	43892419	0	0	76339	15275591	0	0	203006346	2785498	21794	10258	65404	0	0	46696	506915	0	0	3436565	452614	116124272	1982668	9412	33910184	0	0	0	85567	13251251	0	0	0	0	0	0	165815968	0	0	0	0	0	27588764	420971	846	10047639	0	0	37468	2531255	0	0	40626943	459566	28885322	0	0	0	0	0	0	702592	8165111	0	0	0	0	0	0	0	0	0	0	0	0	0
106141273	NORTHERN INYO HOSPITAL	20173	10/01/2016	09/30/2017	Open	Inyo	12	1203	District	Comparable	Rural	(760) 873-5811	150 PIONEER LANE	BISHOP	93514	KEVIN FLANIGAN, MD	25	25	10	493	18	122	160	0	0	40	208	11	22	1074	0	1645	57	295	391	0	0	107	500	49	59	3103	0	25419	502	5906	14065	0	17	5186	23073	567	1802	76537	18548651	680459	3651330	5124911	0	0	1544532	7518631	741630	934378	38744522	36586982	991677	7706007	13262022	0	22079	6040646	27982370	567838	1814902	94974523	2006294	24787871	281358	9392342	11362388	-2038003	0	11094	5364541	4873790	0	1305466	-10	0	0	326518	57673649	0	0	0	0	0	30347762	1390777	3449995	7577548	0	10985	2220637	30627211	4012	416469	76045396	503618	72916398	9929945	-4062824	0	0	0	0	1748732	78839214	0	0	0	0	0	0	0	0	0	0	0	0	0
106190568	NORTHRIDGE HOSPITAL MEDICAL CENTER	20173	10/01/2016	09/30/2017	Open	Los Angeles	11	0905	Non Profit Corp.	Comparable	None	(818) 885-8500	18300 ROSCOE BOULEVARD	NORTHRIDGE	91325	SALIBA SALO	412	412	190	4206	2128	1633	2312	0	0	456	3494	45	152	14426	0	20502	10341	7469	8535	0	0	1467	15073	159	554	64100	0	20978	8886	10593	28487	12	0	3991	29497	858	6330	109632	528921278	246418908	182837899	194228946	0	0	40679371	334851963	2739348	9587853	1540265566	155209767	74557950	56272003	143030647	67926	0	11354230	162509642	3690715	31146215	637839095	32060269	599068578	266778542	196823239	300913242	0	55058	0	40560222	339420922	0	8127623	0	0	0	23365495	1807173190	0	0	0	0	0	83453071	53448372	34883894	35184661	9997	0	10331137	151593930	0	2026409	370931471	8348454	406171300	0	1448440	0	0	0	0	20585452	185548539	0	0	0	0	0	0	0	0	0	0	0	0	0
106214034	NOVATO COMMUNITY HOSPITAL	20173	10/01/2016	09/30/2017	Open	Marin	04	0405	Non Profit Corp.	Comparable	None	(415) 209-1300	180 ROWLAND WAY	NOVATO	94945	GRANT DAVIES	47	47	20	1163	96	66	177	0	1	21	280	9	8	1821	0	4369	338	312	576	0	4	49	744	13	20	6425	0	14192	1089	1015	6134	1	5	979	15551	941	693	40600	67228008	5463666	3905736	8633866	0	52019	1421997	16058467	299455	427315	103490529	56553897	5642079	3986721	21328958	1500	22043	3439927	45980312	2012721	1869395	140837553	1296124	99692662	8527478	7345801	27065178	0	1500	63453	3754119	26281487	0	2062782	0	0	0	285839	176376423	0	0	0	0	0	24089243	2578267	546656	2897646	0	10609	1107805	35575321	0	1146112	67951659	4035244	79398612	0	468196	0	0	0	0	1336460	35317968	0	0	0	0	0	0	0	0	0	0	0	0	0