Table: hqfur_2023_quarter_1_sum_of_four_quarters_07_14_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	20231	04/01/2022	03/31/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	549	0	367	0	0	0	292	0	0	26	1234	0	2238	0	1429	0	0	0	830	0	0	113	4610	0	37927	0	24357	0	0	0	20461	0
106301357	FOOTHILL REGIONAL MEDICAL CENTER	20231	04/01/2022	03/31/2023	Open	Orange	13 - Orange	1015	Investor - Corp.	Comparable	None	714-619-7700	14662 NEWPORT AVENUE	TUSTIN	92780	ARACELI LONERGAN	147	147	68	940	761	152	1655	0	0	330	394	5	66	4303	0	4381	2686	1300	16024	0	0	665	841	5	135	26037	0	440	996	279	2561	0	0	492	985
106301175	FOUNTAIN VALLEY REGIONAL HOSPITAL AND MC - EUCLID	20231	04/01/2022	03/31/2023	Open	Orange	13 - Orange	1014	Investor - Corp.	Comparable	None	714-966-7200	17100 EUCLID STREET	FOUNTAIN VALLEY	92708	RANDY ROGERS	400	334	232	2596	2539	740	5806	1	0	74	1691	71	289	13807	0	17986	17747	4372	27496	2	0	398	7259	266	702	76228	0	3989	5983	2458	29645	5	0	1090	8209
106014034	FREMONT HOSPITAL	20231	04/01/2022	03/31/2023	Open	Alameda	05 - East Bay	421	Investor - Corp.	Comparable	None	510-796-1100	39001 SUNDALE DRIVE	FREMONT	94538	PATRICIA WILLIAMS	148	148	148	285	212	1381	0	1059	0	476	2202	7	21	5643	0	3500	2254	9555	0	10784	0	3213	14500	43	141	43990	0	573	115	0	0	0	0	1662	4673
106400480	FRENCH HOSPITAL MEDICAL CENTER - SAN LUIS OBISPO	20231	04/01/2022	03/31/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	68	2287	596	95	592	0	0	146	1311	27	65	5119	0	10081	2622	343	2280	0	0	490	4248	149	229	20442	0	59288	8136	1510	13831	0	0	2811	43837
106104047	FRESNO SURGICAL HOSPITAL	20231	04/01/2022	03/31/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	451	119	0	59	0	0	68	256	0	20	973	0	867	250	0	82	0	0	131	503	0	39	1872	0	6331	2194	105	1906	0	0	678	5129