Table: hqfur_2023_quarter_4_sum_of_four_quarters_04_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	20234	01/01/2023	12/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	607	0	470	0	0	0	303	0	0	29	1409	0	2020	0	1365	0	0	0	721	0	0	151	4257	0	62417	0	40703	0	0	0	26027	0
106301357	FOOTHILL REGIONAL MEDICAL CENTER	20234	01/01/2023	12/31/2023	Open	Orange	13 - Orange	1015	Investor - Corp.	Comparable	None	714-619-7700	14662 NEWPORT AVENUE	TUSTIN	92780	ARACELI LONERGAN	147	147	92	1233	805	136	1621	0	0	477	350	22	68	4712	0	5450	2872	694	13069	0	0	896	755	22	166	23924	0	285	1024	333	2959	0	0	650	983
106301175	FOUNTAIN VALLEY REGIONAL HOSPITAL AND MC - EUCLID	20234	01/01/2023	12/31/2023	Open	Orange	13 - Orange	1014	Investor - Corp.	Comparable	None	714-966-7200	17100 EUCLID STREET	FOUNTAIN VALLEY	92708	RANDY ROGERS	400	334	224	2835	2695	673	5737	1	0	65	1628	45	387	14066	0	19592	18902	3761	26400	42	0	424	6527	259	1015	76922	0	3742	5796	2416	27535	5	0	1205	7159
106014034	FREMONT HOSPITAL	20234	01/01/2023	12/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	307	213	1246	0	1273	0	469	1910	15	20	5453	0	3994	2452	8827	0	13461	0	3243	12791	37	177	44982	0	701	270	0	0	0	0	2041	5133
106400480	FRENCH HOSPITAL MEDICAL CENTER - SAN LUIS OBISPO	20234	01/01/2023	12/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	65	2377	622	94	584	0	0	163	1285	36	18	5179	0	10745	2824	428	2290	0	0	541	4069	123	38	21058	0	62949	10421	1447	15151	0	0	2688	48681
106104047	FRESNO SURGICAL HOSPITAL	20234	01/01/2023	12/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	490	112	0	60	0	0	61	265	0	10	998	0	861	248	0	77	0	0	95	485	0	18	1784	0	5512	2554	94	1880	0	0	581	4713