Table: 2019_quarter_3_complete_data_set_1_10_20 , 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	07/01/2019	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	1685	546	137	540	0	0	72	1753	6	30	4769	0	9215	2620	1312	2955	0	0	373	7872	23	109	24479	0	28323	7060	1888	3727	0	0	2595	34227	135	648	78603	281036454	91713644	40973542	104871709	0	0	16350430	254823279	555491	2664659	792989208	107295397	43468413	5451352	31352314	0	0	3321352	131206979	1034690	4963345	328093842	3329269	340883120	121053684	44750854	122578644	0	0	0	6596974	223279800	0	1590181	0	0	0	4635812	868698338	0	0	0	0	0	47448731	14128373	1674040	13645379	0	0	13074808	162750458	0	-337077	252384712	3537510	219058037	0	1775471	0	0	0	0	4252243	505223628	0	0	0	0	0	0	0	0	0	0	0	0	0
106071018	JOHN MUIR MEDICAL CENTER - CONCORD CAMPUS	20193	07/01/2019	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	1178	550	104	479	0	0	14	521	0	31	2877	0	5615	2602	730	2310	0	0	83	2006	0	95	13441	0	7031	4042	1025	6440	0	0	479	9546	0	1140	29703	217204696	96041514	22481585	78961056	0	0	2672218	84306181	0	4387122	506054372	80990579	35817113	8741423	46204589	0	0	2272543	77468219	0	6289848	257784314	6410494	261901083	118349151	31065460	120900736	0	0	0	3804455	102311514	0	1790838	0	0	0	5199758	651733489	0	0	0	0	0	36294192	13509476	157548	4264909	0	0	1140306	59462886	0	-2724120	112105197	926077	119470952	0	669481	0	0	0	0	4385349	235213880	0	0	0	0	0	0	0	0	0	0	0	0	0
106074039	JOHN MUIR BEHAVIORAL HEALTH CENTER	20193	07/01/2019	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	34	8	203	3	0	0	85	250	0	0	583	0	353	69	1224	10	0	0	638	1362	0	0	3656	0	340	33	0	0	0	0	0	3662	0	5	4040	1288028	239495	4403990	26486	0	0	2628359	4985593	0	0	13571951	453258	37207	0	0	0	0	0	4152816	0	6057	4649338	323966	1168075	173698	2457853	17598	0	0	0	1485209	4448379	0	0	0	0	0	14462	10089240	0	0	0	0	0	573211	103004	1946137	8888	0	0	1143150	4690030	0	-332371	8132049	72922	10058352	0	0	0	0	0	0	1256434	17175362	0	0	0	0	0	0	0	0	0	0	0	0	0
106121031	JEROLD PHELPS COMMUNITY HOSPITAL	20193	07/01/2019	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	12	0	2	15	0	0	1	0	0	2	32	0	238	0	4	813	0	0	3	0	0	7	1065	0	1382	63	82	868	0	0	804	39	0	386	3624	299363	0	22209	478026	0	0	18942	0	0	28902	847442	1011791	42211	158526	938428	0	0	521775	53960	0	415091	3141782	0	393346	13507	155433	934860	0	0	0	108143	12950	0	355195	0	0	0	0	1973434	0	0	0	0	0	917808	28703	25302	481594	0	0	432573	41010	0	88800	2015790	27312	3432788	0	0	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	07/01/2019	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	11	20	22	33	0	0	0	0	0	8	94	0	952	702	3903	14431	0	0	0	0	0	2568	22556	0	0	0	0	0	0	0	0	0	0	0	0	892683	972601	2324778	6414346	0	0	0	0	0	1027873	11632281	0	0	0	0	0	0	0	0	0	0	0	107413	584869	199979	430400	1222038	0	0	0	0	0	0	0	0	0	0	9572	2554271	0	0	0	0	0	307814	772622	1894378	5192308	0	0	0	0	0	910888	9078010	143553	8574712	0	774	0	0	0	0	142891	52665149	0	0	0	0	0	0	0	0	0	0	0	0	0
106220733	JOHN C. FREMONT HEALTHCARE DISTRICT	20193	07/01/2019	09/30/2019	Open	Mariposa	09 - Central	603	District	Comparable	Rural	209-966-3631	5189 HOSPITAL RD.	MARIPOSA	95338	MATTHEW MATTHIESSEN	34	33	33	58	0	10	0	0	0	17	0	0	2	87	0	327	0	2210	0	0	0	54	0	0	10	2601	0	5715	0	2741	0	0	0	3066	0	0	254	11776	1234356	0	1097883	0	0	0	544625	0	0	37975	2914839	3963708	0	251291	0	0	0	4312391	0	0	460464	8987854	180571	2793625	0	-47232	0	0	0	0	3184207	0	0	15902	0	0	0	299189	6426262	0	0	0	0	0	2404439	0	1396406	0	0	0	1672809	0	0	2777	5476431	486162	6570830	762579	650675	0	0	0	0	719378	3932399	0	0	0	0	0	0	0	0	0	0	0	0	0
106331216	JOHN F. KENNEDY MEMORIAL HOSPITAL	20193	07/01/2019	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	196	279	278	696	2	0	10	206	5	22	1694	0	799	761	702	1645	3	0	32	430	11	48	4431	0	889	1166	1607	6808	69	0	160	2597	37	701	14034	24809920	27622878	21189722	48719829	64878	0	1233379	17408651	408479	1516624	142974360	14409485	15906191	10440977	49640817	723486	0	853857	24893827	305110	4304081	121477831	1518181	35539402	39124371	29108864	92793957	-305814	653396	0	1508258	33925812	0	713589	0	0	0	4962329	239542345	0	0	0	0	0	3680003	4404698	2827649	5566689	134968	0	376504	7571437	0	347898	24909846	106287	31648155	0	-3819	0	0	0	0	13296	23165725	0	0	0	0	0	0	0	0	0	0	1002682	534012	0
106380842	JEWISH HOME	20193	07/01/2019	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	174	154	15	0	0	0	0	0	0	2	345	303	5370	3141	22484	0	0	0	0	0	0	729	31724	30749	0	0	0	0	0	0	0	0	0	0	0	9331932	999881	12545826	0	0	0	0	0	0	466570	23344209	0	0	0	0	0	0	0	0	0	0	0	173847	3183528	763489	1957337	0	0	0	0	0	0	0	55134	0	0	0	0	6133335	0	0	0	0	0	6148404	236392	10588489	0	0	0	0	0	0	237589	17210874	89264	19041266	0	562420	0	0	0	0	18399622	156881288	0	0	0	0	0	0	0	0	0	0	0	0	0