Table: 2023_quarter_2_complete_data_set_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	04/01/2023	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	11	1	3	3	0	0	1	0	0	0	19	0	161	2	154	490	0	0	44	0	0	0	851	664	1495	55	73	1019	0	0	1030	81
106380842	JEWISH HOME	20232	04/01/2023	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	187	113	47	0	0	0	0	0	0	17	364	319	4930	2728	21779	0	0	0	0	0	0	1331	30768	893	0	0	0	0	0	0	0	0
106220733	JOHN C. FREMONT HEALTHCARE DISTRICT	20232	04/01/2023	06/30/2023	Open	Mariposa	09 - Central	603	District	Comparable	Rural	209-966-3631	5189 HOSPITAL ROAD	MARIPOSA	95338	LISA HOYLE	34	33	33	51	0	22	0	0	0	13	0	0	2	88	3	371	0	1839	0	0	0	74	0	0	15	2299	1420	4172	0	2151	0	0	0	2105	0
106331216	JOHN F. KENNEDY MEMORIAL HOSPITAL	20232	04/01/2023	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	212	271	133	663	4	0	15	150	10	18	1476	0	641	1174	348	1480	9	0	30	331	23	45	4081	0	702	1205	874	7975	88	0	221	2243
106074039	JOHN MUIR BEHAVIORAL HEALTH CENTER	20232	04/01/2023	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	70	28	213	68	0	0	0	405	2	7	793	0	561	235	1291	441	0	0	0	2352	11	27	4918	0	376	111	0	0	0	0	0	4078
106071018	JOHN MUIR MEDICAL CENTER - CONCORD CAMPUS	20232	04/01/2023	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	1114	679	76	555	0	0	6	362	7	14	2813	0	5685	3892	578	3064	0	0	21	1532	35	39	14846	0	7979	4874	741	8503	0	0	415	10736
106070988	JOHN MUIR MEDICAL CENTER - WALNUT CREEK	20232	04/01/2023	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	1703	703	82	717	0	0	65	1646	10	41	4967	0	8701	4079	1254	4090	0	0	317	7671	55	98	26265	0	27840	16141	471	7332	0	0	645	29809
106196404	JOYCE EISENBERG KEEFER MEDICAL CENTER	20232	04/01/2023	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	7	23	12	43	0	0	0	0	0	2	87	87	519	836	1451	16796	0	0	0	0	0	1603	21205	21205	0	0	0	0	0	0	0	0