Table: 2017_quarter_4_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	20174	01/01/2017	12/31/2017	Open	Humboldt	01	0109	District	Comparable	Rural	707-923-3921	733 CEDAR STREET	GARBERVILLE	95542	MATT REES	17	17	17	35	0	7	12	0	0	1	0	0	2	57	0	577	0	16	3,753	0	0	62	0	0	11	4,419	2,910	4,712	130	378	2,992	0	0	3,115	126	0	1,206	12,659	702,144	0	98,933	1,822,129	0	0	42,856	0	0	30,699	2,696,761	2,972,707	154,096	688,918	3,092,528	0	0	2,108,838	123,109	0	1,224,119	10,364,315	0	982,924	48,403	670,397	3,370,961	0	0	0	471,594	30,867	0	0	0	0	0	1,003,855	6,579,001	0	0	0	0	0	2,691,925	105,693	117,454	1,543,696	0	0	1,680,100	92,242	0	250,965	6,482,075	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	20174	01/01/2017	12/31/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	355	808	692	127	0	0	0	0	0	0	35	1,662	1,476	22,825	17,032	85,627	0	0	0	0	0	0	4,024	129,508	125,728	0	0	0	0	0	0	0	0	0	0	0	45,601,736	3,073,268	46,106,188	0	0	0	0	0	0	2,288,172	97,069,364	0	0	0	0	0	0	0	0	0	0	0	583,025	16,715,880	1,897,678	9,253,708	0	0	0	0	0	0	0	189,279	0	0	0	0	28,639,570	0	0	0	0	0	28,885,856	1,175,590	36,852,480	0	0	0	0	0	0	1,515,868	68,429,794	421,485	68,827,592	0	10,364,125	0	0	0	0	19,314,952	76,396,161	0	0	0	0	0	0	0	0	0	0	0	0	0
106220733	JOHN C. FREMONT HEALTHCARE DISTRICT	20174	01/01/2017	12/31/2017	Open	Mariposa	09	0603	District	Comparable	Rural	209-966-3631	5189 HOSPITAL ROAD	MARIPOSA	95338	MATTHEW MATTHIESSEN	34	33	33	217	0	53	0	0	0	25	0	0	6	301	0	1,135	0	8,528	0	0	0	328	0	0	92	10,083	0	21,403	0	10,594	0	0	0	10,601	0	0	1,078	43,676	3,701,808	0	4,553,410	0	0	0	1,071,592	0	0	118,836	9,445,646	12,816,964	0	1,518,859	0	0	0	12,148,711	0	0	1,116,070	27,600,604	727,745	7,757,186	0	(181,726)	0	0	0	0	7,940,401	0	0	64,693	0	0	0	533,297	16,841,596	0	0	0	0	0	8,761,586	0	6,253,995	0	0	0	5,279,902	0	0	(90,829)	20,204,654	1,925,226	23,843,937	2,774,003	2,126,662	0	0	0	0	393,069	3,536,836	0	0	0	0	0	0	0	0	0	0	0	0	0
106331216	JOHN F. KENNEDY MEMORIAL HOSPITAL	20174	01/01/2017	12/31/2017	Open	Riverside	12	1103	Investor - Corp.	Comparable	None	760-347-6191	47111 MONROE STREET	INDIO	92201	GARY HONTS	145	145	58	943	1,077	968	2,616	12	0	41	799	12	70	6,538	0	3,793	3,353	2,361	6,436	34	0	144	1,862	35	189	18,207	0	3,401	3,693	5,532	26,560	285	0	624	9,919	58	3,363	53,435	116,634,232	110,237,852	56,173,171	163,139,472	1,121,478	0	5,291,319	64,071,930	1,297,825	6,117,690	524,084,969	45,071,158	48,366,406	29,574,534	156,959,109	2,167,835	0	5,219,774	86,537,279	386,012	19,064,113	393,346,220	5,361,634	144,738,643	140,620,901	79,011,301	275,577,769	(1,586,711)	2,720,990	0	9,168,599	120,527,502	0	1,683,838	0	0	0	20,320,660	798,145,126	0	0	0	0	0	16,966,747	17,983,357	8,323,115	44,520,812	568,323	0	1,149,573	27,565,451	0	2,208,685	119,286,063	461,518	121,028,356	0	74,552	0	0	0	0	3,644,996	24,901,699	0	0	0	0	0	0	0	0	0	0	2,827,927	0	22,841,552
106074039	JOHN MUIR BEHAVIORAL HEALTH CENTER	20174	01/01/2017	12/31/2017	Open	Contra Costa	05	0411	Non Profit Corp.	Comparable	None	925-939-3000	2740 GRANT STREET	CONCORD	94520	CALVIN KNIGHT	73	70	54	403	89	983	10	0	0	232	1,650	0	25	3,392	0	2,980	556	5,986	80	0	0	1,521	8,349	0	99	19,571	0	1,957	439	0	0	0	0	514	13,553	0	127	16,590	11,394,863	2,130,286	20,449,890	277,954	0	0	5,316,443	29,444,606	0	349,511	69,363,553	3,123,166	672,823	0	0	0	0	737,489	17,425,975	0	127,383	22,086,836	749,015	10,464,578	1,926,344	11,070,040	173,044	0	0	0	3,541,294	25,314,199	0	0	0	0	0	24,877	53,263,391	0	0	0	0	0	4,016,470	876,765	9,379,850	104,910	0	0	2,512,638	21,556,382	0	(260,017)	38,186,998	298,526	34,420,516	2,325,553	(109,145)	0	0	0	0	5,025,243	8,296,784	0	0	0	0	0	0	0	0	0	0	0	0	0
106071018	JOHN MUIR MEDICAL CENTER - CONCORD CAMPUS	20174	01/01/2017	12/31/2017	Open	Contra Costa	05	0411	Non Profit Corp.	Comparable	None	925-682-8200	2540 EAST STREET	CONCORD	94520	CALVIN KNIGHT	245	207	133	5,113	1,840	362	1,700	0	0	35	2,075	0	157	11,282	0	25,155	8,756	2,207	8,219	0	0	93	7,476	0	571	52,477	0	33,434	13,173	4,150	27,929	0	0	2,163	49,232	0	4,795	134,876	903,065,401	303,097,453	78,486,533	261,010,924	0	0	4,837,937	324,548,973	0	7,648,027	1,882,695,248	331,719,922	116,024,381	30,183,527	182,490,070	0	0	7,670,066	373,604,564	0	23,607,502	1,065,300,032	15,154,212	1,087,351,564	377,247,558	105,387,952	420,127,675	0	0	0	8,858,866	447,649,475	0	15,872,120	0	0	0	5,526,439	2,483,175,861	0	0	0	1,034,322	1,034,322	147,433,758	41,874,276	3,282,108	23,373,319	0	0	2,688,137	251,538,384	(15,872,120)	11,535,879	465,853,741	3,240,246	474,224,487	0	3,192,866	0	0	0	0	21,423,366	233,049,688	0	0	0	0	0	0	0	0	0	0	0	0	0
106070988	JOHN MUIR MEDICAL CENTER - WALNUT CREEK	20174	01/01/2017	12/31/2017	Open	Contra Costa	05	0411	Non Profit Corp.	Comparable	None	925-939-3000	1601 YGNACIO VALLEY ROAD	WALNUT CREEK	94598	CALVIN KNIGHT	554	399	276	7,610	2,201	429	2,367	0	0	241	7,292	0	289	20,429	0	39,457	11,146	3,928	14,187	0	0	1,172	31,056	0	1,530	102,476	0	110,842	26,964	6,411	17,011	0	0	9,824	148,503	0	3,010	322,565	1,142,706,178	306,276,961	119,650,130	404,766,645	0	0	43,132,671	918,708,732	0	15,186,904	2,950,428,221	391,438,119	140,615,703	19,528,618	112,475,780	0	0	12,645,532	471,868,135	0	15,310,105	1,163,881,992	23,773,972	1,371,832,715	404,241,414	120,399,399	454,819,404	0	0	0	43,384,027	764,165,013	0	16,391,465	0	0	0	19,111,010	3,218,118,419	0	0	0	2,588,032	2,588,032	162,311,582	42,651,250	18,779,349	62,423,021	0	0	12,394,176	628,999,886	0	(28,779,438)	898,779,826	14,379,760	824,291,333	0	8,933,401	0	0	0	0	22,108,627	540,329,413	0	0	0	0	0	0	0	0	0	0	0	0	0
106196404	JOYCE EISENBERG KEEFER MEDICAL CENTER	20174	01/01/2017	12/31/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	245	46	125	191	30	0	0	0	0	0	78	470	0	5,711	3,074	50,239	14,727	0	0	0	0	0	15,937	89,688	0	0	0	0	0	0	0	0	0	0	0	0	3,559,205	3,977,499	20,838,741	6,431,312	0	0	0	0	0	6,730,719	41,537,476	0	0	0	0	0	0	0	0	0	0	0	12,000	2,621,516	1,503,924	1,436,934	744,143	0	0	0	0	0	0	0	0	0	0	229,565	6,548,082	0	0	0	0	0	937,689	2,473,575	19,401,807	5,687,169	0	0	0	0	0	6,489,154	34,989,394	354,402	29,947,240	0	34,019	0	0	0	0	19,788	55,722,709	0	0	0	0	0	0	0	0	0	0	0	0	0