Table: 2017_quarter_2_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	20172	07/01/2016	06/30/2017	Open	Humboldt	01	0109	District	Comparable	Rural	(707) 923-3921	733 CEDAR STREET	GARBERVILLE	95542	MATT REES	17	17	17	34	0	10	14	0	0	3	0	0	1	62	2	501	0	140	3,731	0	0	69	0	0	99	4,540	2,941	4,087	122	306	2,936	1	0	3,106	113	0	1,180	11,851	709,360	0	146,709	1,460,687	0	0	60,358	0	0	59,693	2,436,807	3,287,196	121,657	625,461	3,783,184	1,448	0	2,238,893	105,323	0	1,482,764	11,645,926	0	1,239,470	37,497	559,305	3,397,789	0	405	0	590,729	29,490	0	0	0	0	0	1,029,631	6,884,316	0	0	0	0	0	2,757,084	84,160	212,865	1,846,082	1,043	0	1,708,522	75,833	0	512,828	7,198,417	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	20172	07/01/2016	06/30/2017	Open	San Francisco	04	0423	Non Profit Corp.	Hospital-LTC Emphasis	None	(415) 334-2500	302 SILVER AVENUE	SAN FRANCISCO	94112	DANIEL RUTH	391	391	362	792	703	122	0	0	0	0	0	0	35	1,652	1,475	20,817	16,224	87,774	0	0	0	0	0	0	3,633	128,448	124,182	0	0	0	0	0	0	0	0	0	0	0	43,462,505	3,034,570	46,708,736	0	0	0	0	0	0	2,112,091	95,317,902	0	0	0	0	0	0	0	0	0	0	0	575,304	16,533,127	1,912,946	8,510,913	0	0	0	0	0	0	0	175,422	0	0	0	0	27,707,712	0	0	0	0	0	26,929,378	1,121,624	38,197,823	0	0	0	0	0	0	1,361,365	67,610,190	650,456	66,842,609	0	14,204,373	0	0	0	0	14,572,028	68,434,460	0	0	0	0	0	0	0	0	0	0	0	0	0
106220733	JOHN C. FREMONT HEALTHCARE DISTRICT	20172	07/01/2016	06/30/2017	Open	Mariposa	09	0603	District	Comparable	Rural	(209) 966-3631	5189 HOSPITAL ROAD	MARIPOSA	95338	MATTHEW MATTHIESSEN	34	33	33	202	0	49	0	0	0	25	0	0	5	281	0	1,069	0	8,474	0	0	0	209	0	0	86	9,838	0	21,012	0	11,199	0	0	0	10,172	0	0	1,190	43,573	3,400,592	0	4,477,791	0	0	0	637,374	0	0	80,551	8,596,308	12,801,931	0	1,723,842	0	0	0	11,979,639	0	0	1,093,784	27,599,196	826,423	7,289,335	0	289,671	0	0	0	0	7,580,341	0	0	113,172	0	0	0	654,075	16,753,017	0	0	0	0	0	8,913,188	0	5,878,370	0	0	0	5,036,672	0	0	(385,743)	19,442,487	1,636,695	22,321,940	2,753,378	2,146,691	0	0	0	0	460,215	3,738,899	0	0	0	0	0	0	0	0	0	0	0	0	0
106331216	JOHN F. KENNEDY MEMORIAL HOSPITAL	20172	07/01/2016	06/30/2017	Open	Riverside	12	1103	Investor - Corp.	Comparable	None	(760) 347-6191	47111 MONROE STREET	INDIO	92201	GARY HONTS	145	145	49	974	969	1,113	2,720	11	0	28	849	12	87	6,763	0	4,312	2,963	2,769	6,813	25	0	135	1,917	44	208	19,186	0	3,477	3,405	6,007	25,072	331	0	663	9,076	58	3,415	51,504	123,794,823	96,885,821	63,397,673	168,358,466	674,835	0	3,802,694	63,673,390	1,195,300	6,670,925	528,453,927	41,860,361	43,753,190	31,381,762	153,450,474	2,292,485	0	5,070,363	78,000,812	365,145	18,461,336	374,635,928	4,992,807	148,434,217	124,257,658	78,328,894	284,732,033	(1,886,655)	2,562,204	0	6,380,023	112,444,113	0	1,560,448	0	0	0	20,598,237	782,403,979	0	0	0	0	0	17,220,967	16,381,353	18,337,196	37,076,907	405,116	0	2,373,281	27,557,439	(2)	1,333,619	120,685,876	303,665	132,379,730	0	(4,310)	0	0	0	0	4,376,512	24,799,538	0	0	0	0	0	0	0	0	0	0	8,570,954	8,477,037	14,882,828
106074039	JOHN MUIR BEHAVIORAL HEALTH CENTER	20172	07/01/2016	06/30/2017	Open	Contra Costa	05	0411	Non Profit Corp.	Comparable	None	(925) 939-3000	2740 GRANT STREET	CONCORD	94520	CALVIN KNIGHT	73	70	57	341	63	856	9	0	0	205	1,555	0	23	3,052	0	2,398	375	5,309	55	0	0	1,359	7,933	0	97	17,526	0	2,040	460	0	0	0	0	569	12,618	0	115	15,802	9,272,188	1,428,285	18,312,617	177,514	0	0	4,569,391	27,843,644	0	379,287	61,982,926	3,061,694	684,670	0	0	0	0	812,339	17,291,611	0	158,920	22,009,234	712,378	8,996,636	1,434,908	10,051,641	120,025	0	0	0	3,069,274	24,653,564	0	0	0	0	0	76,422	49,114,848	0	0	0	0	0	3,301,964	678,047	8,260,976	57,489	0	0	2,312,456	20,481,691	0	(215,311)	34,877,312	889,057	36,862,495	2,062,247	(43,461)	0	0	0	0	1,544,675	4,041,472	0	0	0	0	0	0	0	0	0	0	0	0	0
106071018	JOHN MUIR MEDICAL CENTER - CONCORD CAMPUS	20172	07/01/2016	06/30/2017	Open	Contra Costa	05	0411	Non Profit Corp.	Comparable	None	(925) 682-8200	2540 EAST STREET	CONCORD	94520	CALVIN KNIGHT	245	213	147	5,015	1,777	357	1,669	0	0	56	2,041	0	191	11,106	0	24,389	8,330	2,543	8,404	0	0	194	7,444	0	702	52,006	0	34,906	13,419	4,479	28,270	0	0	2,523	53,019	0	5,209	141,825	858,960,600	290,196,724	76,126,493	250,967,696	0	0	8,497,175	315,382,635	0	12,839,225	1,812,970,548	323,529,988	109,888,364	32,648,578	177,926,275	0	0	9,321,794	392,456,891	0	22,804,593	1,068,576,483	5,627,127	1,037,810,676	356,908,837	99,826,134	407,408,516	0	0	0	13,443,547	457,542,758	0	34,164,632	0	0	0	4,354,051	2,417,086,278	0	0	0	1,029,901	1,029,901	144,679,911	43,176,251	8,948,937	21,485,455	0	0	3,414,422	251,326,669	(34,164,632)	26,623,641	465,490,654	4,021,984	466,933,999	0	3,073,399	0	0	0	0	16,474,423	208,415,412	0	0	0	0	0	0	0	0	0	0	0	0	0
106070988	JOHN MUIR MEDICAL CENTER - WALNUT CREEK	20172	07/01/2016	06/30/2017	Open	Contra Costa	05	0411	Non Profit Corp.	Comparable	None	(925) 939-3000	1601 YGNACIO VALLEY ROAD	WALNUT CREEK	94598	CALVIN KNIGHT	572	399	280	7,365	2,194	398	2,287	0	0	282	7,320	0	326	20,172	0	39,094	11,283	3,858	13,646	0	0	1,253	30,898	0	1,808	101,840	0	114,096	26,855	6,072	17,239	0	0	10,365	149,248	0	4,065	327,940	1,095,605,418	307,170,313	108,083,358	383,930,803	0	0	43,450,532	886,723,764	0	25,070,730	2,850,034,918	366,389,360	130,337,072	15,981,622	104,185,393	0	0	12,616,881	455,629,233	0	18,049,250	1,103,188,811	10,029,668	1,301,225,742	411,438,054	91,480,916	427,259,599	0	0	0	45,552,626	722,736,122	0	41,130,595	0	0	0	16,299,361	3,067,152,683	0	0	0	2,540,132	2,540,132	160,769,036	26,069,331	32,584,064	60,856,597	0	0	10,514,787	622,157,007	0	(24,339,644)	888,611,178	12,287,321	812,493,162	0	10,140,700	0	0	0	0	20,505,006	543,941,348	0	0	0	0	0	0	0	0	0	0	0	0	0
106196404	JOYCE EISENBERG KEEFER MEDICAL CENTER	20172	07/01/2016	06/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	60	119	218	0	0	0	0	0	0	74	471	0	6,682	2,755	63,292	0	0	0	0	0	0	17,111	89,840	0	0	0	0	0	0	0	0	0	0	0	0	3,326,750	3,668,103	26,281,814	0	0	0	0	0	0	6,975,926	40,252,593	0	0	0	0	0	0	0	0	0	0	0	0	2,178,329	1,572,583	1,796,280	0	0	0	0	0	0	0	0	0	0	0	208,897	5,756,089	0	0	0	0	0	1,148,421	2,095,520	24,485,534	0	0	0	0	0	0	6,767,029	34,496,504	413,204	29,688,318	0	34,767	0	0	0	0	48,322	56,800,592	0	0	0	0	0	0	0	0	0	0	0	0	0