Table: 2017_quarter_3_sum_of_four_quarters , fac_name like J*

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
106121031	JEROLD PHELPS COMMUNITY HOSPITAL	20173	10/01/2016	09/30/2017	Open	Humboldt	01	0109	District	Comparable	Rural	(707) 923-3921	733 CEDAR STREET	GARBERVILLE	95542	MATT REES	17	17	17	31	0	8	12	0	0	2	0	0	1	54	2	449	0	76	3859	0	0	67	0	0	7	4458	2941	4670	147	344	2993	0	0	3121	111	0	1183	12569	597514	0	126598	1508736	0	0	52291	0	0	27140	2312279	3217929	130125	675322	3726262	0	0	2240043	94195	0	1327388	11411264	0	991416	40998	626845	3501368	0	0	0	546904	24274	0	0	0	0	0	992216	6724021	0	0	0	0	0	2824025	89127	175075	1733630	0	0	1745430	69921	0	362314	6999522	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106380842	JEWISH HOME	20173	10/01/2016	09/30/2017	Open	San Francisco	04	0423	Non Profit Corp.	Hospital-LTC Emphasis	None	(415) 334-2500	302 SILVER AVENUE	SAN FRANCISCO	94112-1596	DANIEL RUTH	391	391	358	805	709	124	0	0	0	0	0	0	39	1677	1498	22763	16602	86389	0	0	0	0	0	0	3824	129578	125733	0	0	0	0	0	0	0	0	0	0	0	45192092	3150279	46298718	0	0	0	0	0	0	2225719	96866808	0	0	0	0	0	0	0	0	0	0	0	583898	16689383	1986636	8886962	0	0	0	0	0	0	0	190140	0	0	0	0	28337019	0	0	0	0	0	28502709	1163643	37411756	0	0	0	0	0	0	1451681	68529789	642587	68418045	0	16805000	0	0	0	0	15499882	70077480	0	0	0	0	0	0	0	0	0	0	0	0	0
106220733	JOHN C. FREMONT HEALTHCARE DISTRICT	20173	10/01/2016	09/30/2017	Open	Mariposa	09	0603	District	Comparable	Rural	(209) 966-3631	5189 HOSPITAL ROAD., PO BOX 216	MARIPOSA	95338	MATTHEW MATTHIESSEN	34	33	33	218	0	49	0	0	0	22	0	0	5	294	0	1067	0	8463	0	0	0	259	0	0	88	9877	0	21172	0	10918	0	0	0	10326	0	0	1121	43537	3384403	0	4471364	0	0	0	835467	0	0	89850	8781084	12780416	0	1619624	0	0	0	11791839	0	0	1107545	27299424	816500	7410377	0	105319	0	0	0	0	7411886	0	0	97537	0	0	0	566527	16408146	0	0	0	0	0	8754442	0	5952077	0	0	0	5215420	0	0	-249577	19672362	1779243	23159485	2767313	2199020	0	0	0	0	423589	3643537	0	0	0	0	0	0	0	0	0	0	0	0	0
106331216	JOHN F. KENNEDY MEMORIAL HOSPITAL	20173	10/01/2016	09/30/2017	Open	Riverside	12	1103	Investor - Corp.	Comparable	None	(760) 347-6191	47111 MONROE STREET	INDIO	92201	GARY HONTS	145	145	54	942	1018	1027	2676	12	0	28	830	14	70	6617	0	3988	3119	2530	6606	32	0	116	1910	47	189	18537	0	3428	3479	5726	25747	294	0	649	9416	57	3390	52186	118437887	103086169	59708418	163688102	924969	0	3697733	64544846	1557024	6073102	521718250	42729522	44752903	30240149	155256476	2160746	0	5270336	81072140	386077	18585177	380453526	5236474	143816927	130598097	78528938	282410057	-1812846	2647497	0	7199046	115807348	0	1943102	0	0	0	19584581	785959221	0	0	0	0	0	17350482	17240975	13232475	36534521	438218	0	1598727	27355291	0	2461866	116212555	354795	132570447	0	-4310	0	0	0	0	1319338	23474016	0	0	0	0	0	0	0	0	0	0	8528966	4229489	14882828
106074039	JOHN MUIR BEHAVIORAL HEALTH CENTER	20173	10/01/2016	09/30/2017	Open	Contra Costa	05	0411	Non Profit Corp.	Comparable	None	(925) 939-3000	2740 GRANT STREET	CONCORD	94520	CALVIN KNIGHT	73	70	54	377	71	949	9	0	0	235	1590	0	26	3257	0	2688	396	5845	51	0	0	1540	8062	0	101	18683	0	2042	398	0	0	0	0	551	13024	0	92	16107	10531325	1562960	20081680	195639	0	0	5205772	28672671	0	352950	66602997	3165915	605118	0	0	0	0	791427	17196683	0	126074	21885217	707536	9991027	1504712	11217356	131465	0	0	0	3434418	25016335	0	0	0	0	0	27818	52030667	0	0	0	0	0	3670931	663366	8864324	64174	0	0	2562781	20853019	0	-221048	36457547	401759	35409964	2224003	-109304	0	0	0	0	2526297	5128489	0	0	0	0	0	0	0	0	0	0	0	0	0
106071018	JOHN MUIR MEDICAL CENTER - CONCORD CAMPUS	20173	10/01/2016	09/30/2017	Open	Contra Costa	05	0411	Non Profit Corp.	Comparable	None	(925) 682-8200	2540 EAST STREET	CONCORD	94520	CALVIN KNIGHT	245	207	138	5122	1791	369	1699	0	0	43	2059	0	175	11258	0	25256	8375	2391	8404	0	0	138	7635	0	648	52847	0	33985	13362	4264	28130	0	0	2304	51207	0	4972	138224	891455322	290667542	83378943	260404907	0	0	4900594	322054851	0	9819791	1862681950	329370984	110566678	31375842	178365839	0	0	8403670	391557020	0	24156387	1073796420	3236165	1073070841	358300160	103612496	415427840	0	0	0	9952468	459045072	0	34686789	0	0	0	6097882	2463429713	0	0	0	1014561	1014561	147755464	42934060	11142289	23342906	0	0	2390796	255581360	-34686789	25603132	474063218	3611611	471345456	0	3211063	0	0	0	0	24458755	213732127	0	0	0	0	0	0	0	0	0	0	0	0	0
106070988	JOHN MUIR MEDICAL CENTER - WALNUT CREEK	20173	10/01/2016	09/30/2017	Open	Contra Costa	05	0411	Non Profit Corp.	Comparable	None	(925) 939-3000	1601 YGNACIO VALLEY ROAD	WALNUT CREEK	94598	CAL KNIGHT	554	399	272	7562	2258	411	2335	0	0	241	7238	0	306	20351	0	40387	11646	3641	13220	0	0	1061	30290	0	1701	101946	0	113974	27067	6384	17287	0	0	10165	149439	0	3406	327722	1137754126	314289027	108142423	391240467	0	0	35736352	891849420	0	17811161	2896822976	374132387	133546627	17861803	109777271	0	0	12804393	459249159	0	17119638	1124491278	7470613	1348915157	412357230	92372992	440051890	0	0	0	38688210	728333534	0	38950338	0	0	0	17443445	3124583409	0	0	0	2564753	2564753	162971356	35478424	33631234	60965848	0	0	9852535	625329798	0	-28933597	899295598	14061805	816595700	0	9743138	0	0	0	0	17504005	536576527	0	0	0	0	0	0	0	0	0	0	0	0	0
106196404	JOYCE EISENBERG KEEFER MEDICAL CENTER	20173	10/01/2016	09/30/2017	Open	Los Angeles	11	0905	Non Profit Corp.	Hospital-LTC Emphasis	None	(818) 774-3000	7150 TAMPA AVENUE	RESEDA	91335	ILANA SPRINGER	249	249	247	53	126	227	0	0	0	0	0	0	82	488	0	6208	2988	64230	0	0	0	0	0	0	16342	89768	0	0	0	0	0	0	0	0	0	0	0	0	3022235	3862277	26586714	0	0	0	0	0	0	6865607	40336833	0	0	0	0	0	0	0	0	0	0	0	0	2063499	1549572	1443851	0	0	0	0	0	0	0	0	0	0	0	165673	5222595	0	0	0	0	0	958736	2312705	25142863	0	0	0	0	0	0	6699934	35114238	322719	29975433	0	32780	0	0	0	0	50925	56246361	0	0	0	0	0	0	0	0	0	0	0	0	0