Table: 2024_quarter_1_complete_data_set_07_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	20241	01/01/2024	03/31/2024	Open	Humboldt	01 - Northern California	109	District	Comparable	Rural	707-923-3921	733 CEDAR STREET	GARBERVILLE	95542	MATT REES	17	17	17	7	0	1	9	0	0	0	0	0	0	17	0	181	0	91	587	0	0	0	0	0	0	859	0	1601	109	57	1049	0	0	889	48
106380842	JEWISH HOME	20241	01/01/2024	03/31/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	353	168	85	19	22	0	0	0	0	0	19	313	274	3607	2059	21187	1399	0	0	0	0	0	1534	29786	28852	0	0	0	0	0	0	0	0
106220733	JOHN C. FREMONT HEALTHCARE DISTRICT	20241	01/01/2024	03/31/2024	Open	Mariposa	09 - Central	603	District	Comparable	Rural	209-966-3631	5189 HOSPITAL ROAD	MARIPOSA	95338	MICHAEL ZIMMERMAN	34	33	33	54	2	5	18	0	0	12	0	0	2	93	0	265	7	200	1326	0	0	33	0	0	3	1834	1456	3645	204	180	2029	0	0	1947	0
106331216	JOHN F. KENNEDY MEMORIAL HOSPITAL	20241	01/01/2024	03/31/2024	Open	Riverside	12 - Inland Counties	1103	Investor - Corp.	Comparable	None	760-347-6191	47111 MONROE STREET	INDIO	92201	KAREN FAULIS	145	145	56	255	331	128	765	3	0	15	179	4	24	1704	0	793	1144	298	1718	3	0	57	440	4	37	4494	0	804	1295	793	7562	92	0	191	2398
106074039	JOHN MUIR BEHAVIORAL HEALTH CENTER	20241	01/01/2024	03/31/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	34	228	69	0	0	2	379	1	4	792	0	559	285	1341	464	0	0	8	2153	5	20	4835	0	270	190	0	0	0	0	0	3821
106071018	JOHN MUIR MEDICAL CENTER - CONCORD CAMPUS	20241	01/01/2024	03/31/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	1273	696	58	569	0	0	2	407	7	14	3026	0	6046	3582	365	3042	0	0	12	1540	33	70	14690	0	8645	5066	469	9598	0	0	431	12359
106070988	JOHN MUIR MEDICAL CENTER - WALNUT CREEK	20241	01/01/2024	03/31/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	1844	864	91	850	0	0	62	2072	9	4	5796	0	10051	5093	783	4794	0	0	240	6989	41	19	28010	0	18733	8014	335	7075	0	0	499	27961
106196404	JOYCE EISENBERG KEEFER MEDICAL CENTER	20241	01/01/2024	03/31/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	6	17	16	47	0	0	0	0	0	11	97	97	1279	743	2258	16436	0	0	0	0	0	1321	22037	22037	0	0	0	0	0	0	0	0