Table: 2019_quarter_3_sum_of_four_quarters , fac_name like F*

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
106014034	FREMONT HOSPITAL	20193	10/01/2018	09/30/2019	OPEN	Alameda	05 - East Bay	421	Investor - Corp.	Comparable	None	510-796-1100	39001 SUNDALE DRIVE	FREMONT	94538	PATRICIA WILLIAMS	148	148	148	585	52	997	0	0	0	1131	2821	3	5	5594	0	5267	374	6781	0	0	0	7686	21319	15	41	41483	0	958	71	0	0	0	0	2259	6038	5	11	9342	12640800	897600	16274400	0	0	0	18446400	51157474	34526	98400	99549600	354770	52000	0	0	0	0	1417130	3775445	2875	7800	5610020	1283015	6332071	473658	7274628	0	0	0	0	8426491	22896924	0	37401	0	0	0	98146	46822334	0	0	0	0	0	5380484	475942	8999772	0	0	0	11437039	32023170	0	20879	58337286	2801	40083796	3157850	245517	0	0	0	0	340766	30975074	0	0	0	0	0	0	0	0	0	0	0	0	0
106104047	FRESNO SURGICAL HOSPITAL	20193	10/01/2018	09/30/2019	OPEN	Fresno	09 - Central	605	Investor - Ptnr.	Comparable	None	559-431-8000	6125 NORTH FRESNO STREET	FRESNO	93710	KRISTINE KASSAHN	27	27	27	827	166	1	36	0	0	58	760	0	3	1851	0	1270	261	1	54	0	0	89	1072	0	3	2750	0	7072	1571	114	2257	0	0	637	6583	0	202	18436	44005295	9069389	21374	1511889	0	0	3504991	39233701	0	156227	97502866	75206665	18619005	1138243	25014371	0	0	6236011	88460793	0	2969818	217644906	714654	89481617	21023735	1079395	25268082	0	0	0	6877006	88305220	0	0	0	0	0	2672022	235421731	0	0	0	0	0	29015689	6664659	80222	1258178	0	0	2863996	39389274	0	454023	79726041	1297694	75359470	0	0	0	0	0	0	4015035	16303808	0	0	0	0	0	0	0	0	0	0	0	0	0
106301175	FOUNTAIN VALLEY REGIONAL HOSPITAL AND MC - EUCLID	20193	10/01/2018	09/30/2019	OPEN	Orange	13 - Orange	1014	Investor - Corp.	Comparable	None	714-966-7200	17100 EUCLID STREET	FOUNTAIN VALLEY	92708	KENNETH MCFARLAND	400	344	231	3996	2481	1314	7283	23	0	69	2429	94	998	18687	0	23081	11619	7343	29651	65	0	303	9786	324	2579	84751	0	6377	6250	4188	33786	19	0	2120	11061	257	2525	66583	534273525	335222102	136419901	714431767	2172011	0	6332721	239703665	8640349	45977478	2023173519	97751762	120064815	35456323	424177398	337588	0	10460328	148837501	3095668	19222796	859404179	15590538	565484905	412117146	136173665	1076475865	-17203194	2234394	0	15258669	303113571	0	11366856	0	0	0	53831294	2574443709	3389393	74173171	0	19848333	97410897	66540382	46559164	52905753	136306471	275205	0	1209452	95600695	369161	5778603	405544886	1854921	389847286	0	-132345	0	0	0	0	5684540	87720957	0	0	0	0	0	0	0	0	0	0	31651339	23565362	36111865
106301357	FOOTHILL REGIONAL MEDICAL CENTER	20193	10/01/2018	09/30/2019	OPEN	Orange	13 - Orange	1015	Investor - Corp.	Comparable	None	714-619-7700	14662 NEWPORT AVENUE	TUSTIN	92780	ARACELI LONERGAN	127	127	66	607	593	115	1236	0	0	137	87	11	31	2817	0	2730	2489	1389	12849	0	0	400	227	32	127	20243	0	322	1373	369	2310	0	0	513	818	0	445	6150	43325779	50752019	15449108	171848874	0	0	6058268	8319994	151989	1458535	297364566	2619604	20415144	1590369	19234958	0	0	3593786	9668615	0	2915055	60037531	3328425	37867625	55625213	14519417	163738743	-350143	0	0	6699262	13473905	0	19590	0	0	0	2312586	297234623	84221188	0	0	0	84221188	8077758	99376917	2541723	26918259	0	0	2123889	3851057	132400	1366659	144388662	297779	138391263	0	0	0	0	0	0	2704517	25394074	0	0	0	0	0	0	0	0	0	0	0	0	0
106301781	FAIRVIEW DEVELOPMENTAL CENTER	20193	10/01/2018	09/30/2019	OPEN	Orange	13 - Orange	1016	State	State Hospitals	None	714-957-5000	2501 HARBOR BOULEVARD	COSTA MESA	92626	HUGH KOHLER	1218	1179	39	13	0	43	0	0	0	0	0	0	7	63	0	119	0	21574	0	0	0	0	0	0	2636	24329	0	0	0	0	0	0	0	0	0	0	0	0	807637	0	35624329	0	0	0	0	0	0	486009	36917975	0	0	0	0	0	0	0	0	0	0	0	0	135775	0	1738438	0	0	0	0	14450	0	0	0	0	0	0	8154	1896817	0	0	0	0	0	671862	0	33885892	0	0	0	0	0	0	463404	35021158	0	33815034	0	-8127639	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106400480	FRENCH HOSPITAL MEDICAL CENTER - SAN LUIS OBISPO	20193	10/01/2018	09/30/2019	OPEN	San Luis Obispo	08 - Mid-Coast	801	Non Profit Corp.	Comparable	None	805-543-5353	1911 JOHNSON AVENUE	SAN LUIS OBISPO	93401	ALAN IFTINJUK	98	72	60	2455	371	135	498	0	0	142	1422	5	53	5081	0	9996	1373	668	2134	0	0	500	4516	19	265	19471	0	47337	4109	1647	9400	0	0	2836	34623	220	8496	108668	243756156	37410914	11064087	43275167	0	0	12044130	99426164	305971	4974128	452256717	156344151	25128578	4548133	32969068	0	0	11748930	96022977	195559	4994574	331951970	6827850	342418652	48525463	9814278	73820476	0	0	0	20279271	116946695	0	2830522	0	0	0	9017166	630480373	0	4477783	0	12504277	16982060	55489131	13821296	2917233	6866765	0	0	3003094	87611306	0	1001549	170710374	2683286	170711368	0	2390645	0	0	0	0	15463995	71428072	0	0	0	0	0	0	0	0	0	0	0	0	0
106474007	FAIRCHILD MEDICAL CENTER	20193	10/01/2018	09/30/2019	OPEN	Siskiyou	01 - Northern California	203	Non Profit Corp.	Comparable	Rural	530-842-4121	444 BRUCE STREET	YREKA	96097	JONATHON ANDRUS	25	25	25	596	0	420	0	0	0	205	0	0	32	1253	0	2389	0	1256	0	0	0	601	0	0	48	4294	0	58061	0	37937	0	0	0	24390	0	3230	1038	124656	31721266	0	18381218	0	0	0	12279833	0	0	729561	63111878	59136605	0	40533882	0	0	0	39874950	0	3011298	1227742	143784477	4706855	46043747	0	43797708	0	0	0	0	12803202	0	0	512844	0	0	0	4437464	112301820	0	0	0	0	0	44814126	0	15117392	0	0	0	34131880	0	0	531137	94594535	1132765	79994136	0	0	0	0	0	0	4013666	22476124	0	0	0	0	0	0	0	0	0	0	0	0	0