Table: 2019_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
106070988	JOHN MUIR MEDICAL CENTER - WALNUT CREEK	20193	10/01/2018	09/30/2019	OPEN	Contra Costa	05 - East Bay	411	Non Profit Corp.	Comparable	None	925-939-3000	1601 YGNACIO VALLEY ROAD	WALNUT CREEK	94598	CAL KNIGHT	554	399	274	7381	2371	555	2207	0	0	273	6912	62	136	19897	0	39872	11954	4300	13054	0	0	1221	30848	234	422	101905	0	113972	29022	6919	16329	0	0	11027	138603	833	2020	318725	1212775373	407694030	157546772	411011643	0	0	48209270	953303579	3691488	11346125	3205578280	415890037	169288550	18799821	121460384	0	0	13919935	504386752	4942541	14970636	1263658656	8323653	1442357368	512319783	145941669	463160253	0	0	0	38037879	853649826	0	8634028	0	0	0	21642438	3494066897	0	0	0	0	0	186308042	64662797	30404923	69311773	0	0	24091325	604040505	0	-3649326	975170039	12613089	903560339	0	8372192	0	0	0	0	24520084	505223628	0	0	0	0	0	0	0	0	0	0	0	0	0
106071018	JOHN MUIR MEDICAL CENTER - CONCORD CAMPUS	20193	10/01/2018	09/30/2019	OPEN	Contra Costa	05 - East Bay	411	Non Profit Corp.	Comparable	None	925-682-8200	2540 EAST STREET	CONCORD	94520	CALVIN KNIGHT	245	207	160	5179	1813	443	1899	0	0	40	2276	0	134	11784	0	24772	8905	2694	9286	0	0	175	8888	0	427	55147	0	28546	17677	4017	26445	0	0	2006	40465	0	4704	123860	926246316	377183600	87954319	309725833	0	0	9703019	326453596	0	13240198	2050506881	348530350	160029290	33488528	188935876	0	0	9066526	331506748	0	24935423	1096492741	17873391	1117435181	484216282	117705462	462895750	0	0	0	14403170	417753200	0	13507919	0	0	0	10454201	2656244556	0	0	0	0	0	157341485	52996608	3737385	35765959	0	0	4366375	240207142	0	-3659888	490755066	2766696	501476535	0	3366931	0	0	0	0	18134831	235213880	0	0	0	0	0	0	0	0	0	0	0	0	0
106074039	JOHN MUIR BEHAVIORAL HEALTH CENTER	20193	10/01/2018	09/30/2019	OPEN	Contra Costa	05 - East Bay	411	Non Profit Corp.	Comparable	None	925-939-3000	2740 GRANT STREET	CONCORD	94520	CALVIN KNIGHT	73	50	44	205	36	632	14	0	0	323	1190	0	6	2406	0	1655	247	3582	115	0	0	2642	6458	0	24	14723	0	1168	328	0	0	0	0	29	15960	0	149	17634	6291321	984676	13138292	365742	0	0	9590191	23835264	0	233515	54439001	1524439	408734	14868	0	0	0	22994	17421779	0	170178	19562992	768090	5562732	878151	7538045	240623	0	0	0	5768298	20644221	0	139897	0	0	0	166319	41706376	0	0	0	0	0	2253028	515259	5600247	125119	0	0	3836487	20612821	0	-647344	32295617	275337	40001676	0	0	0	0	0	0	7279089	17175362	0	0	0	0	0	0	0	0	0	0	0	0	0
106121031	JEROLD PHELPS COMMUNITY HOSPITAL	20193	10/01/2018	09/30/2019	OPEN	Humboldt	01 - Northern California	109	District	Comparable	Rural	707-923-3921	733 CEDAR STREET	GARBERVILLE	95542	MATT REES	17	17	17	38	3	6	40	0	0	4	0	0	2	93	16	586	27	102	3070	0	0	9	0	0	148	3942	2058	5024	218	264	3425	0	0	2813	139	0	1220	13103	873395	59834	185192	1731578	0	0	56501	0	0	107569	3014069	3505184	197218	524342	3628316	0	0	1790790	125990	0	1183998	10955838	0	1405612	77932	610206	3458607	0	0	0	317171	30191	0	355195	0	0	0	708818	6963732	0	0	0	0	0	2972967	179119	99328	1901287	0	0	1530119	95799	0	227556	7006175	30344	6379503	0	3482950	0	0	0	0	0	4069302	12150000	0	0	0	0	0	0	0	0	0	0	0	0
106196404	JOYCE EISENBERG KEEFER MEDICAL CENTER	20193	10/01/2018	09/30/2019	OPEN	Los Angeles	11 - Los Angeles	905	Non Profit Corp.	Hospital-LTC Emphasis	None	818-774-3000	7150 TAMPA AVENUE	RESEDA	91335	ILANA SPRINGER	249	249	246	42	91	77	135	0	0	0	0	0	48	393	0	3697	2331	12717	58558	0	0	0	0	0	11253	88556	0	0	0	0	0	0	0	0	0	0	0	0	4070802	2951363	7162501	25599275	0	0	0	0	0	5320057	45103998	0	0	0	0	0	0	0	0	0	0	0	177413	2914942	765224	1243802	4435692	0	0	0	0	0	0	0	0	0	0	64576	9601649	0	0	0	0	0	1155860	2186139	5918700	21163581	0	0	0	0	0	5078069	35502349	477567	32665827	0	10020	0	0	0	0	288798	52665149	0	0	0	0	0	0	0	0	0	0	0	0	0
106220733	JOHN C. FREMONT HEALTHCARE DISTRICT	20193	10/01/2018	09/30/2019	OPEN	Mariposa	09 - Central	603	District	Comparable	Rural	209-966-3631	5189 HOSPITAL RD.	MARIPOSA	95338	MATTHEW MATTHIESSEN	34	33	33	252	0	69	0	0	0	55	0	0	8	384	0	1413	0	8778	0	0	0	270	0	0	23	10484	0	22522	0	11025	0	0	0	11825	0	0	920	46292	4779037	0	4504612	0	0	0	1748844	0	0	114742	11147235	14713528	0	861137	0	0	0	14771936	0	0	1664484	32011085	1351953	9660132	0	-1069335	0	0	0	0	9753972	0	0	78507	0	0	0	535366	20310595	0	0	0	0	0	9493034	0	6435084	0	0	0	6766808	0	0	152799	22847725	2623113	25682127	3136790	2509303	0	0	0	0	1352703	3932399	0	0	0	0	0	0	0	0	0	0	0	0	0
106331216	JOHN F. KENNEDY MEMORIAL HOSPITAL	20193	10/01/2018	09/30/2019	OPEN	Riverside	12 - Inland Counties	1103	Investor - Corp.	Comparable	None	760-347-6191	47111 MONROE STREET	INDIO	92201	GARY HONTS	145	130	58	965	1151	978	2727	11	0	50	858	27	98	6865	0	3776	3376	2774	6767	19	0	154	1974	61	231	19132	0	3911	4398	5719	29446	282	0	866	10468	107	3405	58602	121450968	125635781	79205234	203162043	607905	0	5590977	76120999	1930128	7895474	621599509	60942725	62585222	34675767	199199647	2881950	0	6261082	107227333	919589	20392872	495086187	6616036	165338794	169199638	94875467	368180124	-1549390	2900610	0	8792247	148129169	0	2849717	0	0	0	23387813	988720225	0	0	0	0	0	17054899	19021365	20554924	34181566	589245	0	2678799	32422752	0	1461921	127965471	547487	137202022	0	-298	0	0	0	0	5635088	23165725	0	0	0	0	0	0	0	0	0	0	9807197	11558330	10963514
106380842	JEWISH HOME	20193	10/01/2018	09/30/2019	OPEN	San Francisco	04 - West Bay	423	Non Profit Corp.	Hospital-LTC Emphasis	None	415-334-2500	302 SILVER AVENUE	SAN FRANCISCO	94112-1596	DANIEL RUTH	391	391	353	695	746	67	0	0	0	0	0	0	30	1538	1363	21214	15864	87373	0	0	0	0	0	0	3032	127483	123647	0	0	0	0	0	0	0	0	0	0	0	41278674	3841742	48759244	0	0	0	0	0	0	1809203	95688863	0	0	0	0	0	0	0	0	0	0	0	903864	14580826	2408438	8967312	0	0	0	0	0	0	0	138570	0	0	0	0	26999010	0	0	0	0	0	26697848	1433304	39791932	0	0	0	0	0	0	766769	68689853	448591	74397797	0	3907018	0	0	0	0	52832244	156881288	0	0	0	0	0	0	0	0	0	0	0	0	0