Table: hqfur_2023_quarter_2_sum_of_four_quarters_10_16_2023 , fac_name like F*

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
106474007	FAIRCHILD MEDICAL CENTER	20232	07/01/2022	06/30/2023	Open	Siskiyou	01 - Northern California	203	Non Profit Corp.	Comparable	Rural	530-842-4121	444 BRUCE STREET	YREKA	96097	JONATHON ANDRUS	25	25	25	544	0	387	0	0	0	306	0	0	25	1262	0	2055	0	1386	0	0	0	782	0	0	128	4351	0	45825	0	29632	0	0	0	21681	0
106301357	FOOTHILL REGIONAL MEDICAL CENTER	20232	07/01/2022	06/30/2023	Open	Orange	13 - Orange	1015	Investor - Corp.	Comparable	None	714-619-7700	14662 NEWPORT AVENUE	TUSTIN	92780	ARACELI LONERGAN	147	147	66	1015	755	139	1703	0	0	356	409	15	52	4444	0	4803	2676	1218	13649	0	0	614	893	15	128	23996	0	289	1075	321	2971	0	0	565	1111
106301175	FOUNTAIN VALLEY REGIONAL HOSPITAL AND MC - EUCLID	20232	07/01/2022	06/30/2023	Open	Orange	13 - Orange	1014	Investor - Corp.	Comparable	None	714-966-7200	17100 EUCLID STREET	FOUNTAIN VALLEY	92708	RANDY ROGERS	400	334	217	2689	2660	684	5649	1	0	67	1680	65	376	13871	0	18693	18582	4170	26746	2	0	452	7193	274	975	77087	0	3915	6044	2412	29080	7	0	1122	7906
106014034	FREMONT HOSPITAL	20232	07/01/2022	06/30/2023	Open	Alameda	05 - East Bay	421	Investor - Corp.	Comparable	None	510-796-1100	39001 SUNDALE DRIVE	FREMONT	94538	PATRICIA WILLIAMS	148	148	148	309	200	1274	0	1164	0	472	2164	17	16	5616	0	3875	2132	8619	0	11962	0	3080	14199	50	119	44036	0	664	136	0	0	0	0	1657	5280
106400480	FRENCH HOSPITAL MEDICAL CENTER - SAN LUIS OBISPO	20232	07/01/2022	06/30/2023	Open	San Luis Obispo	08 - Mid-Coast	801	Non Profit Corp.	Comparable	None	805-543-5353	1911 JOHNSON AVENUE	SAN LUIS OBISPO	93401	ALAN IFTINJUK	98	72	62	2315	586	84	595	0	0	160	1302	28	49	5119	0	10573	2625	356	2191	0	0	509	4248	138	174	20814	0	60452	9002	1528	14425	0	0	2806	45659
106104047	FRESNO SURGICAL HOSPITAL	20232	07/01/2022	06/30/2023	Open	Fresno	09 - Central	605	Investor - Ptnr.	Comparable	None	559-431-8000	6125 NORTH FRESNO STREET	FRESNO	93710	DANIELLE HOLDRIDGE-ZEUNER	27	27	27	481	125	0	59	0	0	73	254	0	20	1012	0	917	273	0	82	0	0	124	497	0	39	1932	0	6238	2248	98	1943	0	0	659	5026