Table: 2019_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
106141273	NORTHERN INYO HOSPITAL	20193	10/01/2018	12/31/2018	OPEN	Inyo	12 - Inland Counties	1203	District	Comparable	Rural	760-873-5811	150 PIONEER LANE	BISHOP	93514	KEVIN FLANIGAN, MD	25	25	19	202	2	36	42	0	0	10	87	0	4	383	0	620	2	61	98	0	0	19	128	0	8	936	0	6081	144	1277	2399	1	6	534	6391	59	1003	17895	5780916	17553	466786	681753	0	0	243258	1253960	0	36245	8480471	10501011	396377	2217192	3722451	277	941	1211816	8870300	44868	959993	27925226	231677	7217423	202416	1099048	1079933	0	277	626	386203	1554758	0	276330	0	0	0	136474	12185165	0	0	0	0	0	9064504	211494	1584930	3324271	277	315	1068871	8569502	-231462	627830	24220532	1672182	21499327	0	-790469	0	0	0	0	1455555	77230786	0	0	0	0	0	0	0	0	0	0	0	0	0
106190568	NORTHRIDGE HOSPITAL MEDICAL CENTER	20193	10/01/2018	09/30/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	4108	2443	1555	2428	0	0	411	3445	83	397	14870	0	21628	11485	8034	8933	0	0	1886	14258	361	1568	68153	0	19989	8287	12447	28475	0	0	5200	25514	1903	1410	103225	567599102	315226919	199777451	231343860	0	0	51225760	348164569	7575639	35750628	1756663928	177318524	79688049	73186295	154583543	0	0	15666782	157927383	10640631	8054116	677065323	37968966	645713173	337903806	198958782	328308611	0	0	0	47783410	347131298	0	30505250	0	0	0	50859597	2025132893	0	0	0	0	0	87661443	54942551	39430842	54675982	0	0	13338522	152596662	0	5950356	408596358	7535989	421810798	0	4770556	0	0	0	0	8436519	168583881	0	0	0	0	0	0	0	0	0	0	0	0	0
106214034	NOVATO COMMUNITY HOSPITAL	20193	10/01/2018	09/30/2019	OPEN	Marin	04 - West Bay	405	Non Profit Corp.	Comparable	None	415-209-1300	180 ROWLAND WAY	NOVATO	94945	GRANT DAVIES	47	47	21	1300	197	96	187	0	2	48	309	27	28	2194	0	4273	652	456	661	0	4	97	805	63	66	7077	0	4528	580	844	4733	0	14	633	3916	685	380	16313	77866453	11399273	6436687	9760542	0	83428	2870153	18244147	1111068	1139135	128910886	56439119	7052079	4720353	24489847	0	97986	5842149	39754683	3717308	2015581	144129105	2394635	108989819	14778207	8764387	29453682	0	0	86401	5804599	22627435	0	4828376	0	0	0	1586699	199314240	0	0	0	0	0	24289496	3664632	2298105	4795707	0	95013	2852619	34613862	0	1116317	73725751	1370927	87921532	0	852864	0	0	0	0	7465123	39061477	0	0	0	0	0	0	0	0	0	0	0	0	0
106274043	NATIVIDAD MEDICAL CENTER	20193	10/01/2018	09/30/2019	OPEN	Monterey	08 - Mid-Coast	705	City/County	Comparable	None	831-755-4111	1441 CONSTITUTION BOULEVARD	SALINAS	93906	GARY GRAY	172	114	114	1864	0	2362	2789	0	0	1770	0	9	297	9091	0	11919	0	9606	10820	0	0	8272	0	24	825	41466	0	27337	0	29688	79247	0	0	32287	0	2636	9458	180653	216812422	0	191719522	225179070	0	0	185384042	0	2153234	7423805	828672095	50984203	0	52080060	162433369	0	0	91051706	0	3691488	20862542	381103368	28921732	217303468	0	209204373	324009919	-31846131	0	0	154137030	0	0	5844723	0	0	0	0	907575114	0	0	0	0	0	50493155	0	65480742	63602522	0	0	122298717	0	0	325213	302200349	15708547	306108496	0	3845594	0	0	0	0	13722893	118877873	0	0	0	0	0	0	0	0	0	0	0	0	0
106281266	NAPA STATE HOSPITAL	20193	10/01/2018	09/30/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	179	0	0	0	0	0	52	0	0	627	858	0	164796	0	0	0	0	0	321	0	0	291877	456994	0	0	0	0	0	0	0	0	0	0	0	0	95023192	0	0	0	0	0	190985	0	0	167581908	262796085	0	0	0	0	0	0	0	0	0	0	0	0	396	0	0	0	0	0	0	15	0	0	0	0	0	0	16085	16496	0	0	0	0	0	95022797	0	0	0	0	0	190970	0	0	167565822	262779589	0	430887716	0	94031697	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106301304	NEWPORT BAY HOSPITAL	20193	10/01/2018	09/30/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	766	83	0	0	0	0	3	0	0	0	852	0	10654	1169	0	0	0	0	30	0	0	0	11853	0	0	0	0	0	0	0	0	0	0	0	0	14760191	1641425	0	0	0	0	27510	0	0	0	16429126	0	0	0	0	0	0	0	0	0	0	0	0	4416808	658926	0	0	0	0	0	6052	0	0	0	0	0	0	0	5081786	0	0	0	0	0	10343383	982499	0	0	0	0	21458	0	0	0	11347340	125	11785343	0	0	0	0	0	0	0	363	0	0	0	0	0	0	0	0	0	0	0	0	0
106481357	NORTHBAY MEDICAL CENTER	20193	10/01/2018	09/30/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	4267	372	814	2740	0	20	358	1210	52	66	9899	0	21178	1878	4592	13204	0	92	1507	4619	168	323	47561	0	122640	13054	9426	90574	0	48	43838	91700	174	6440	377894	1038552789	104607409	182464331	575466095	0	5233408	85368159	258630389	15273433	13034627	2278630640	575221631	48788395	112067309	525415850	0	1419072	87988980	373694933	5254200	43610414	1773460784	15135326	1481184386	127319365	271094539	1009710002	-3274423	0	4585476	142382654	396109172	0	47443057	0	0	0	3954281	3495643835	0	70079313	0	44630100	114709413	132590034	26076439	26711524	161251256	0	2067004	30974485	280846250	0	10640010	671157002	13041008	452640541	0	11918853	0	0	0	0	90496616	332201045	0	0	0	0	0	0	0	0	0	0	0	0	0
106514033	NORTH VALLEY BEHAVIORAL HEALTH - PHF	20193	10/01/2018	09/30/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	282	282	0	0	0	0	0	0	0	0	0	0	5703	5703	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5129643	5129643	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	5129643	5129643	0	5142817	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0