Table: hqfur_2023_quarter_3_sum_of_four_quarters_01_16_2024 , 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	20233	10/01/2022	09/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	572	0	449	0	0	0	341	0	0	27	1389	0	1922	0	1487	0	0	0	765	0	0	142	4316	0	53515	0	34756	0	0	0	23609	0
106301357	FOOTHILL REGIONAL MEDICAL CENTER	20233	10/01/2022	09/30/2023	Open	Orange	13 - Orange	1015	Investor - Corp.	Comparable	None	714-619-7700	14662 NEWPORT AVENUE	TUSTIN	92780	ARACELI LONERGAN	147	147	66	1027	687	124	1585	0	0	352	381	17	45	4218	0	4869	2643	1338	12984	0	0	594	897	17	125	23467	0	295	1050	336	2982	0	0	617	1024
106301175	FOUNTAIN VALLEY REGIONAL HOSPITAL AND MC - EUCLID	20233	10/01/2022	09/30/2023	Open	Orange	13 - Orange	1014	Investor - Corp.	Comparable	None	714-966-7200	17100 EUCLID STREET	FOUNTAIN VALLEY	92708	RANDY ROGERS	400	334	207	2755	2745	677	5627	1	0	58	1647	49	404	13963	0	18659	18818	4102	26405	2	0	362	6757	245	1017	76367	0	3821	5866	2435	28301	5	0	1172	7443
106014034	FREMONT HOSPITAL	20233	10/01/2022	09/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	311	198	1293	0	1226	0	485	1991	16	18	5538	0	3947	2194	8761	0	12750	0	3208	13102	47	150	44159	0	656	145	0	0	0	0	1806	5105
106400480	FRENCH HOSPITAL MEDICAL CENTER - SAN LUIS OBISPO	20233	10/01/2022	09/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	58	2344	578	93	579	0	0	152	1283	37	33	5099	0	10688	2616	386	2177	0	0	491	4166	154	102	20780	0	61553	9671	1497	14878	0	0	2702	47224
106104047	FRESNO SURGICAL HOSPITAL	20233	10/01/2022	09/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	493	130	0	53	0	0	65	267	0	18	1026	0	904	291	0	70	0	0	109	511	0	37	1922	0	5825	2463	108	1902	0	0	582	4824