Table: 2024_quarter_2_complete_data_set_10_30_2024 , 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	20242	04/01/2024	06/30/2024	Open	Humboldt	01 - Northern California	109	District	Comparable	Rural	707-923-3921	733 CEDAR STREET	GARBERVILLE	95542	MATT REES	17	17	17	6	1	2	3	0	0	1	0	0	0	13	0	113	1	245	488	0	0	1	0	0	0	848	666	1601	109	57	1049	0	0	889	48
106380842	JEWISH HOME	20242	04/01/2024	06/30/2024	Open	San Francisco	04 - West Bay	423	Non Profit Corp.	Hospital-LTC Emphasis	None	415-334-2500	302 SILVER AVENUE	SAN FRANCISCO	94112-1596	ADRIENNE GREEN	375	375	361	173	112	27	58	0	0	0	0	0	31	401	361	4960	2240	20729	2480	0	0	0	0	0	1364	31773	31024	0	0	0	0	0	0	0	0
106220733	JOHN C. FREMONT HEALTHCARE DISTRICT	20242	04/01/2024	06/30/2024	Open	Mariposa	09 - Central	603	District	Comparable	Rural	209-966-3631	5189 HOSPITAL ROAD	MARIPOSA	95338	PATRICIA RYAN	34	33	33	43	1	6	11	0	0	20	0	0	1	82	0	238	4	201	1310	0	0	72	0	0	4	1829	1454	3818	215	141	2107	0	0	2247	0
106331216	JOHN F. KENNEDY MEMORIAL HOSPITAL	20242	04/01/2024	06/30/2024	Open	Riverside	12 - Inland Counties	1103	Investor - Corp.	Comparable	None	760-347-6191	47111 MONROE STREET	INDIO	92201	KAREN FAULIS	145	145	50	224	292	97	706	2	0	18	189	1	35	1564	0	618	928	284	1516	5	0	67	445	2	64	3929	0	663	1322	682	7810	91	0	230	2285
106074039	JOHN MUIR BEHAVIORAL HEALTH CENTER	20242	04/01/2024	06/30/2024	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	75	35	229	70	0	0	2	386	0	5	802	0	559	294	1347	466	0	0	8	2217	0	25	4916	0	272	193	0	0	0	0	5	3879
106071018	JOHN MUIR MEDICAL CENTER - CONCORD CAMPUS	20242	04/01/2024	06/30/2024	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	1290	702	61	574	0	0	3	410	3	15	3058	0	6176	3606	374	3053	0	0	24	1578	15	61	14887	0	8819	5180	546	9739	0	0	433	12631
106070988	JOHN MUIR MEDICAL CENTER - WALNUT CREEK	20242	04/01/2024	06/30/2024	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	1872	869	95	800	0	0	123	2050	13	29	5851	0	10233	5136	786	4701	0	0	599	6978	64	29	28526	0	18940	8150	357	7164	0	0	520	28354
106196404	JOYCE EISENBERG KEEFER MEDICAL CENTER	20242	04/01/2024	06/30/2024	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	243	3	24	9	52	0	0	0	0	0	5	93	93	845	731	1675	17658	0	0	0	0	0	1186	22095	22095	0	0	0	0	0	0	0	0