Table: 2019_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
106141273	NORTHERN INYO HOSPITAL	20194	01/01/2019	06/30/2019	OPEN	Inyo	12 - Inland Counties	1203	District	Comparable	Rural	760-873-5811	150 PIONEER LANE	BISHOP	93514	KEVIN S FLANIGAN	25	25	19	328	12	71	88	0	0	10	125	1	13	648	0	1022	32	136	210	0	0	23	256	1	34	1714	0	13686	422	2117	5622	1	4	934	14950	62	2211	40009	9199173	248430	1082645	1441299	0	0	174666	2284187	7371	174275	14612046	23322708	927634	4366343	7978903	144	9365	2127728	19596125	260568	2115312	60704830	1736836	15023409	421432	3819789	12419937	0	0	8031	860791	3267249	0	855172	0	0	0	1428690	39841336	0	0	0	0	0	17498472	754632	1629199	-2999735	144	1334	1441603	18613063	-587233	-875939	35475540	2169142	44262607	0	1151455	0	0	0	0	2660587	779578820	0	0	0	0	0	0	0	0	0	0	0	0	0
106190568	NORTHRIDGE HOSPITAL MEDICAL CENTER	20194	01/01/2019	12/31/2019	OPEN	Los Angeles	11 - Los Angeles	905	Non Profit Corp.	Comparable	None	818-885-8500	18300 ROSCOE BOULEVARD	NORTHRIDGE	91325	PAUL WATKINS	394	394	198	4104	2604	1497	2389	0	0	313	3391	117	458	14873	0	21013	12295	7729	9220	0	0	1536	14032	475	1759	68059	0	19961	8629	12287	28708	0	0	5143	25399	1750	1765	103642	564905244	336416001	197144905	241105704	0	0	47397758	347876893	8738857	34989739	1778575101	176558711	83313935	75335089	160720972	0	0	15882111	162423170	10391672	9140481	693766141	41045414	643695857	360827906	200029068	343218297	0	0	0	44679636	348479767	0	34849336	0	0	0	51812001	2068637282	0	0	0	0	0	85999723	56770654	29024502	55306306	0	0	11807044	154747613	0	10048118	403703960	6632228	417785698	0	70876856	0	0	0	0	75852230	233263882	0	0	0	0	0	0	0	0	0	0	0	0	0
106214034	NOVATO COMMUNITY HOSPITAL	20194	01/01/2019	12/31/2019	OPEN	Marin	04 - West Bay	405	Non Profit Corp.	Comparable	None	415-209-1300	180 ROWLAND WAY	NOVATO	94945	GRANT DAVIES	47	47	23	1349	199	82	197	0	1	47	301	33	9	2218	0	4463	662	366	692	0	3	100	755	85	15	7141	0	4560	584	875	4961	0	18	667	3992	635	304	16596	81313749	11376231	5927788	10257571	0	57284	2574369	18431307	1376078	286037	131600414	56637475	6869742	4820134	24998665	0	145196	5997225	40950826	3608680	1704940	145732883	2506243	111088282	14654630	6722984	30697577	0	0	133020	5648804	22093228	0	4984758	0	0	0	691511	199221037	0	0	0	0	0	25708674	3564200	3937741	4553391	0	69460	2836642	36581092	0	861060	78112260	803754	81887752	0	981206	0	0	0	0	6824587	39754112	0	0	0	0	0	0	0	0	0	0	0	0	0
106274043	NATIVIDAD MEDICAL CENTER	20194	01/01/2019	12/31/2019	OPEN	Monterey	08 - Mid-Coast	705	City/County	Comparable	None	831-755-4111	1441 CONSTITUTION BOULEVARD	SALINAS	93906	GARY GRAY	172	114	114	1861	0	2327	2767	0	0	1805	0	11	309	9080	0	12038	0	9247	10479	0	0	8659	0	24	893	41340	0	27363	0	29767	79243	0	0	31613	0	2565	9673	180224	220351991	0	188255301	221791415	0	0	185122432	0	2192384	10635627	828349150	50920648	0	52706221	162075303	0	0	90217947	0	3671112	22360435	381951666	33790555	217392910	0	210524958	317842633	-30543666	0	0	152297805	0	0	5863497	0	0	0	0	907168692	0	0	0	0	0	53879727	0	60019633	66024085	0	0	123042574	0	0	166105	303132124	19060988	309837791	0	4706312	0	0	0	0	13525281	118948426	0	0	0	0	0	0	0	0	0	0	0	0	0
106281266	NAPA STATE HOSPITAL	20194	01/01/2019	12/31/2019	OPEN	Napa	03 - North Bay	407	State	State Hospitals	None	707-253-5000	2100 NAPA-VALLEJO HIGHWAY	NAPA	94558	FRANK TURLEY	1418	1299	1299	213	0	0	0	0	0	6	0	0	620	839	0	165969	0	0	0	0	0	239	0	0	290904	457112	0	0	0	0	0	0	0	0	0	0	0	0	95283485	0	0	0	0	0	143713	0	0	166471731	261898929	0	0	0	0	0	0	0	0	0	0	0	0	733	0	0	0	0	0	0	0	0	0	0	0	0	0	65952	66685	0	0	0	0	0	95282753	0	0	0	0	0	143713	0	0	166405778	261832244	0	446467352	0	110558678	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106301304	NEWPORT BAY HOSPITAL	20194	01/01/2019	12/31/2019	OPEN	Orange	13 - Orange	1016	Investor - Corp.	Comparable	None	949-650-9750	1501 EAST 16TH STREET	NEWPORT BEACH	92663	JAMES E PARKHURST	36	36	36	720	108	0	0	0	0	2	0	0	0	830	0	10278	1505	0	0	0	0	9	0	0	0	11792	0	0	0	0	0	0	0	0	0	0	0	0	14465557	1965677	0	0	0	0	14852	0	0	0	16446086	0	0	0	0	0	0	0	0	0	0	0	0	3973322	778877	0	0	0	0	0	3267	0	0	0	0	0	0	0	4755466	0	0	0	0	0	10492235	1186800	0	0	0	0	11585	0	0	0	11690620	475	11744234	0	0	0	0	0	0	0	207	0	0	0	0	0	0	0	0	0	0	0	0	0
106481357	NORTHBAY MEDICAL CENTER	20194	01/01/2019	12/31/2019	OPEN	Solano	03 - North Bay	408	Non Profit Corp.	Comparable	None	707-646-5000	1200 B. GALE WILSON BLVD.	FAIRFIELD	94533	B KONARD JONES	182	182	182	4269	408	812	2757	0	17	368	1205	42	90	9968	0	21256	2115	4522	13367	0	64	1539	4646	165	373	48047	0	126736	13872	10998	94895	0	43	47019	95056	178	6741	395538	1044099602	113449204	198051663	598472208	0	4361592	80680311	266033470	13066524	15309939	2333524513	593911997	55154312	117766522	541636952	0	1027723	93673062	381669993	4808522	46452951	1836102034	7445065	1501065929	139844842	286746708	1050245592	-2966637	0	4376864	141809630	433912444	0	53480950	0	0	0	7357846	3623319233	0	59801409	0	45742971	105544380	136945670	28758674	32038114	149664977	0	1012451	32543743	259533990	0	11354075	651851694	18848084	621663831	0	27621461	0	0	0	0	61910596	333886596	0	0	0	0	0	0	0	0	0	0	0	0	0
106514033	NORTH VALLEY BEHAVIORAL HEALTH - PHF	20194	01/01/2019	12/31/2019	OPEN	Sutter	02 - Golden Empire	227	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	285	285	0	0	0	0	0	0	0	0	0	0	5642	5642	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5155309	5155309	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	5155309	5155309	0	5227848	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0