Table: 2023_quarter_2_complete_data_set_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	04/01/2023	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	152	0	108	0	0	0	71	0	0	7	338	0	453	0	277	0	0	0	158	0	0	30	918	0	16403	0	10697	0	0	0	6840	0
106301357	FOOTHILL REGIONAL MEDICAL CENTER	20232	04/01/2023	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	288	195	32	412	0	0	112	121	10	5	1175	0	1393	564	277	3247	0	0	185	271	10	29	5976	0	62	280	87	774	0	0	144	247
106301175	FOUNTAIN VALLEY REGIONAL HOSPITAL AND MC - EUCLID	20232	04/01/2023	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	723	705	151	1348	0	0	12	419	10	131	3499	0	4777	4665	963	6193	0	0	133	1727	45	365	18868	0	897	1584	622	6857	2	0	286	1799
106014034	FREMONT HOSPITAL	20232	04/01/2023	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	84	37	327	0	312	0	126	513	12	4	1415	0	1108	477	2213	0	3209	0	857	3523	12	42	11441	0	208	60	0	0	0	0	484	1622
106400480	FRENCH HOSPITAL MEDICAL CENTER - SAN LUIS OBISPO	20232	04/01/2023	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	581	143	16	141	0	0	44	311	8	4	1248	0	2661	657	77	558	0	0	133	1010	46	8	5150	0	15815	2694	363	3948	0	0	707	12358
106104047	FRESNO SURGICAL HOSPITAL	20232	04/01/2023	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	122	33	0	17	0	0	20	67	0	0	259	0	229	77	0	23	0	0	29	125	0	0	483	0	1470	622	21	524	0	0	185	1216