Table: 2024_quarter_2_complete_data_set_10_30_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	20242	04/01/2024	06/30/2024	Open	Siskiyou	01 - Northern California	203	Non Profit Corp.	Comparable	Rural	530-842-4121	444 BRUCE STREET	YREKA	96097	JONATHON ANDRUS	25	25	25	182	0	94	0	0	0	62	0	0	5	343	0	875	0	262	0	0	0	151	0	0	16	1304	0	17259	0	13953	0	0	0	11613	0
106301357	FOOTHILL REGIONAL MEDICAL CENTER	20242	04/01/2024	06/30/2024	Open	Orange	13 - Orange	1015	Investor - Corp.	Comparable	None	714-619-7700	14662 NEWPORT AVENUE	TUSTIN	92780	ARACELI LONERGAN	147	147	70	397	169	27	376	0	0	140	78	0	16	1203	0	1849	745	103	3015	0	0	323	209	0	47	6291	0	83	251	66	646	0	0	183	251
106014034	FREMONT HOSPITAL	20242	04/01/2024	06/30/2024	Open	Alameda	05 - East Bay	421	Investor - Corp.	Comparable	None	510-796-1100	39001 SUNDALE DRIVE	FREMONT	94538	PATRICIA WILLIAMS	148	148	148	80	56	284	0	280	0	112	450	1	7	1270	0	1000	617	2346	0	3216	0	809	3483	5	68	11544	0	23	36	0	0	0	0	770	1622
106400480	FRENCH HOSPITAL MEDICAL CENTER - SAN LUIS OBISPO	20242	04/01/2024	06/30/2024	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	560	163	20	178	0	0	36	334	6	5	1302	0	2350	658	76	599	0	0	161	961	9	19	4833	0	17423	2916	320	3885	0	0	716	12514
106104047	FRESNO SURGICAL HOSPITAL	20242	04/01/2024	06/30/2024	Open	Fresno	09 - Central	605	Investor - Ptnr.	Comparable	None	559-431-8000	6125 NORTH FRESNO STREET	FRESNO	93710	DANIELLE HOLDRIDGE-ZEUNER	27	27	27	96	34	0	0	0	0	28	79	0	0	237	0	183	67	0	0	0	0	50	142	0	0	442	0	1251	733	32	521	0	0	82	983