Table: 2017_quarter_1_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	20171	04/01/2016	03/31/2017	Open	Humboldt	01	0109	District	Comparable	Rural	(707) 923-3921	733 CEDAR STREET	GARBERVILLE	95542	MATT REES	17	17	17	30	0	10	12	0	0	2	0	0	1	55	2	502	0	401	3,291	0	0	64	0	0	190	4,448	2,941	4,114	110	260	2,848	1	0	3,100	116	0	1,237	11,786	685,722	0	216,119	1,248,715	0	0	40,878	0	0	91,892	2,283,326	3,307,339	161,251	561,161	4,192,259	1,448	0	2,086,153	127,943	0	1,558,024	11,995,578	0	1,192,822	50,053	516,142	3,369,526	0	405	0	564,157	35,824	0	0	0	0	0	1,039,187	6,768,116	0	0	0	0	0	2,800,237	111,198	261,138	2,071,448	1,043	0	1,562,874	92,119	0	610,731	7,510,788	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	20171	04/01/2016	03/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	366	799	678	126	0	0	0	0	0	0	33	1,636	1,452	20,038	15,234	89,308	0	0	0	0	0	0	3,979	128,559	123,775	0	0	0	0	0	0	0	0	0	0	0	42,569,560	3,136,463	46,834,054	0	0	0	0	0	0	2,200,108	94,740,185	0	0	0	0	0	0	0	0	0	0	0	652,809	16,607,467	2,024,295	7,823,743	0	0	0	0	0	0	0	141,386	0	0	0	0	27,249,700	0	0	0	0	0	25,962,093	1,112,168	39,010,311	0	0	0	0	0	0	1,405,913	67,490,485	626,450	66,035,313	0	13,757,518	0	0	0	0	10,645,347	62,253,770	0	0	0	0	0	0	0	0	0	0	0	0	0
106220733	JOHN C. FREMONT HEALTHCARE DISTRICT	20171	04/01/2016	03/31/2017	Open	Mariposa	09	0603	District	Comparable	Rural	(209) 966-3631	5189 HOSPITAL ROAD	MARIPOSA	95338	ALAN MACPHEE	34	33	33	218	0	38	0	0	0	19	0	0	2	277	0	1,179	0	8,376	0	0	0	151	0	0	71	9,777	0	19,985	0	11,050	0	0	0	9,499	0	0	1,156	41,690	3,673,367	0	4,222,823	0	0	0	466,650	0	0	50,533	8,413,373	12,496,668	0	1,647,983	0	0	0	11,489,004	0	0	1,045,201	26,678,856	464,465	6,916,913	0	244,382	0	0	0	0	7,369,951	0	0	112,083	0	0	0	890,472	15,998,266	0	0	0	0	0	9,253,122	0	5,592,832	0	0	0	4,585,703	0	0	(337,694)	19,093,963	1,511,038	21,528,944	2,638,666	2,190,986	0	0	0	0	1,052,426	3,933,842	0	0	0	0	0	0	0	0	0	0	0	0	0
106331216	JOHN F. KENNEDY MEMORIAL HOSPITAL	20171	04/01/2016	03/31/2017	Open	Riverside	12	1103	Investor - Corp.	Comparable	None	(760) 347-6191	47111 MONROE STREET	INDIO	92201	GARY HONTS	145	145	59	976	988	1,179	2,625	10	0	30	863	17	97	6,785	0	4,408	2,986	2,905	6,575	20	0	125	1,988	45	234	19,286	0	3,442	3,385	6,475	23,861	363	0	692	8,950	59	3,257	50,484	123,519,364	95,120,261	65,179,719	160,175,452	538,852	0	3,272,809	63,983,094	1,140,598	7,092,241	520,022,390	41,221,992	42,805,666	32,761,811	147,105,105	2,550,663	0	5,670,172	76,786,920	382,752	17,540,128	366,825,209	4,922,285	147,200,899	121,472,116	78,087,045	271,926,770	(1,810,558)	2,681,766	0	6,428,584	111,193,957	0	1,523,352	0	0	0	20,171,985	763,798,201	0	0	0	0	0	17,540,457	16,453,811	21,665,043	35,353,787	407,749	0	2,398,171	27,973,321	(2)	1,257,061	123,049,398	659,871	132,907,796	0	(4,310)	0	0	0	0	4,311,605	25,465,135	0	0	0	0	0	0	0	0	0	0	11,157,762	12,013,153	13,111,160
106074039	JOHN MUIR BEHAVIORAL HEALTH CENTER	20171	04/01/2016	03/31/2017	Open	Contra Costa	05	0411	Non Profit Corp.	Comparable	None	(925) 939-3000	2740 GRANT STREET	CONCORD	94520	CALVIN KNIGHT	73	70	52	273	51	779	8	0	0	174	1,508	0	22	2,815	0	1,899	328	4,756	54	0	0	1,095	7,756	0	92	15,980	0	1,948	501	0	0	0	0	572	12,994	0	150	16,165	7,210,950	1,220,038	16,469,765	182,894	0	0	3,719,618	26,922,579	0	363,844	56,089,688	2,876,863	666,518	0	0	0	0	805,723	17,537,603	0	169,670	22,056,377	874,923	7,711,888	1,247,161	9,567,513	124,961	0	0	0	2,611,136	24,148,387	0	0	0	0	0	136,173	46,422,142	0	0	0	0	0	2,377,624	639,395	6,902,252	57,933	0	0	1,914,205	20,311,795	0	(479,281)	31,723,923	900,170	38,182,959	2,104,115	454	0	0	0	0	2,896,775	3,947,467	0	0	0	0	0	0	0	0	0	0	0	0	0
106071018	JOHN MUIR MEDICAL CENTER - CONCORD CAMPUS	20171	04/01/2016	03/31/2017	Open	Contra Costa	05	0411	Non Profit Corp.	Comparable	None	(925) 682-8200	2540 EAST STREET	CONCORD	94520	CALVIN KNIGHT	245	213	162	4,879	1,457	358	1,697	0	0	71	2,241	0	184	10,887	0	24,297	6,768	2,554	8,769	0	0	267	8,456	0	633	51,744	0	35,343	13,588	4,746	28,911	0	0	2,691	53,856	0	5,258	144,393	815,812,872	276,349,350	71,488,041	262,535,580	0	0	10,602,407	317,177,077	0	12,227,364	1,766,192,691	321,098,934	112,529,320	31,397,552	177,466,849	0	0	9,129,943	378,519,903	0	25,483,018	1,055,625,519	5,757,009	992,929,490	348,995,680	97,437,045	420,325,941	0	0	0	15,825,763	445,067,948	0	34,442,616	0	0	0	3,844,268	2,364,625,760	0	0	0	1,058,254	1,058,254	143,982,314	39,882,989	5,448,548	19,676,488	0	0	3,906,587	251,687,286	(34,442,616)	28,109,108	458,250,704	4,534,044	458,767,624	0	2,822,511	0	0	0	0	16,027,373	211,652,764	0	0	0	0	0	0	0	0	0	0	0	0	0
106070988	JOHN MUIR MEDICAL CENTER - WALNUT CREEK	20171	04/01/2016	03/31/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	307	7,186	2,080	388	2,266	0	0	289	7,326	0	306	19,841	0	38,435	11,130	3,644	13,388	0	0	1,407	31,102	0	1,592	100,698	0	112,893	25,766	5,657	16,772	0	0	10,700	148,267	0	4,470	324,525	1,061,524,168	300,296,037	101,576,305	384,759,722	0	0	51,146,059	887,949,837	0	25,884,384	2,813,136,512	353,628,426	122,452,808	15,123,753	100,895,919	0	0	12,397,332	443,161,027	0	18,714,806	1,066,374,071	9,546,200	1,256,170,764	394,747,850	89,138,826	425,614,558	0	0	0	52,146,803	715,231,606	0	42,514,416	0	0	0	16,694,969	3,001,805,992	0	0	0	2,457,422	2,457,422	158,981,830	28,000,995	27,561,232	60,041,083	0	0	11,396,588	618,336,680	0	(24,156,395)	880,162,013	13,000,319	802,451,827	0	8,602,744	0	0	0	0	23,277,183	550,171,701	0	0	0	0	0	0	0	0	0	0	0	0	0
106196404	JOYCE EISENBERG KEEFER MEDICAL CENTER	20171	04/01/2016	03/31/2017	Open	Los Angeles	11	0905	Non Profit Corp.	Hospital-LTC Emphasis	None	(818) 774-3000	7150 TAMPA AVENUE	RESEDA	91335	ILANA GROSSMAN	249	249	245	64	131	205	0	0	0	0	0	0	67	467	0	6,149	2,767	63,396	0	0	0	0	0	0	17,652	89,964	0	0	0	0	0	0	0	0	0	0	0	0	3,102,009	3,672,703	26,442,954	0	0	0	0	0	0	7,084,950	40,302,616	0	0	0	0	0	0	0	0	0	0	0	0	2,059,453	1,524,281	2,281,811	0	0	0	0	0	0	0	0	0	0	0	294,311	6,159,856	0	0	0	0	0	1,042,556	2,148,422	24,161,143	0	0	0	0	0	0	6,790,639	34,142,760	394,100	29,657,432	0	17,528	0	0	0	0	48,782	57,374,642	0	0	0	0	0	0	0	0	0	0	0	0	0