Table: hqfur_2023_quarter_2_sum_of_four_quarters_10_16_2023 , 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
106121031	JEROLD PHELPS COMMUNITY HOSPITAL	20232	07/01/2022	06/30/2023	Open	Humboldt	01 - Northern California	109	District	Comparable	Rural	707-923-3921	733 CEDAR STREET	GARBERVILLE	95542	MATT REES	17	17	17	55	1	4	20	0	0	2	0	1	0	83	3	697	2	461	2349	0	0	48	0	26	0	3583	2727	5966	247	308	4255	1	0	8846	332
106380842	JEWISH HOME	20232	07/01/2022	06/30/2023	Open	San Francisco	04 - West Bay	423	Non Profit Corp.	Hospital-LTC Emphasis	None	415-334-2500	302 SILVER AVENUE	SAN FRANCISCO	94112-1596	MARY CONNICK	375	375	342	813	365	121	0	0	0	0	0	0	103	1402	1229	20457	14401	86732	0	0	0	0	0	0	37638	159228	3613	0	0	0	0	0	0	0	0
106220733	JOHN C. FREMONT HEALTHCARE DISTRICT	20232	07/01/2022	06/30/2023	Open	Mariposa	09 - Central	603	District	Comparable	Rural	209-966-3631	5189 HOSPITAL RD.	MARIPOSA	95338	LISA HOYLE	34	33	33	205	0	57	0	0	0	75	0	0	8	345	3	1356	0	7327	0	0	0	332	0	0	277	9292	1420	17250	0	8595	0	0	0	7946	0
106331216	JOHN F. KENNEDY MEMORIAL HOSPITAL	20232	07/01/2022	06/30/2023	Open	Riverside	12 - Inland Counties	1103	Investor - Corp.	Comparable	None	760-347-6191	47111 MONROE STREET	INDIO	92201	KAREN FAULIS	145	145	50	1001	1110	562	2818	17	0	65	562	47	63	6245	0	3090	4707	1468	6390	31	0	193	1418	103	123	17523	0	2944	4622	3500	32946	330	0	871	8590
106074039	JOHN MUIR BEHAVIORAL HEALTH CENTER	20232	07/01/2022	06/30/2023	Open	Contra Costa	05 - East Bay	411	Non Profit Corp.	Comparable	None	925-939-3000	2740 GRANT STREET	CONCORD	94520	MICHAEL S. THOMAS	73	55	55	352	115	821	228	0	0	73	1564	4	26	3183	0	2566	846	4905	1435	0	0	457	8998	20	122	19349	0	1558	606	0	0	0	0	4	14936
106071018	JOHN MUIR MEDICAL CENTER - CONCORD CAMPUS	20232	07/01/2022	06/30/2023	Open	Contra Costa	05 - East Bay	411	Non Profit Corp.	Comparable	None	925-682-8200	2540 EAST STREET	CONCORD	94520	MICHAEL S THOMAS	244	215	175	4556	2627	335	2154	0	0	17	1572	27	49	11337	0	24516	15758	2342	12548	0	0	43	6432	122	136	61897	0	30842	18616	2879	32189	0	0	1686	40719
106070988	JOHN MUIR MEDICAL CENTER - WALNUT CREEK	20232	07/01/2022	06/30/2023	Open	Contra Costa	05 - East Bay	411	Non Profit Corp.	Comparable	None	925-939-3000	1601 YGNACIO VALLEY ROAD	WALNUT CREEK	94598	MICHAEL S THOMAS	554	399	317	6926	2704	450	2787	0	0	219	6730	61	89	19966	0	39847	16230	4875	16558	0	0	1159	31872	253	186	110980	0	110168	63066	2050	27037	0	0	2237	115608
106196404	JOYCE EISENBERG KEEFER MEDICAL CENTER	20232	07/01/2022	06/30/2023	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	248	234	26	62	60	170	0	0	0	0	0	17	335	168	3550	2877	11652	60587	0	0	0	0	0	5899	84565	42070	0	0	0	0	0	0	0	0