Table: 2021_quarter_2_complete_data_set_10_13_2021 , 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	20212	04/01/2021	06/30/2021	Open	Siskiyou	01 - Northern California	203	Non Profit Corp.	Comparable	Rural	530-842-4121	444 BRUCE STREET	YREKA	96097	JONATHON ANDRUS	25	25	25	104	0	102	0	0	0	77	0	0	9	292	0	519	0	299	0	0	0	192	0	0	89	1099	0	7719	0	5626	0	0	0	4888	0
106301357	FOOTHILL REGIONAL MEDICAL CENTER	20212	04/01/2021	06/30/2021	Open	Orange	13 - Orange	1015	Investor - Corp.	Comparable	None	714-619-7700	14662 NEWPORT AVENUE	TUSTIN	92780	ARACELI LONERGAN	127	127	62	205	184	40	370	0	0	49	82	0	25	955	0	890	736	195	3408	0	0	186	163	0	45	5623	0	91	277	126	658	0	0	100	243
106301175	FOUNTAIN VALLEY REGIONAL HOSPITAL AND MC - EUCLID	20212	04/01/2021	06/30/2021	Open	Orange	13 - Orange	1014	Investor - Corp.	Comparable	None	714-966-7200	17100 EUCLID STREET	FOUNTAIN VALLEY	92708	CLAY FARELL	400	344	210	667	656	272	1695	1	0	16	529	19	53	3908	0	3684	3279	1573	7520	2	0	99	2030	57	107	18351	0	1104	1615	693	7823	2	0	465	5528
106014034	FREMONT HOSPITAL	20212	04/01/2021	06/30/2021	Open	Alameda	05 - East Bay	421	Investor - Corp.	Comparable	None	510-796-1100	39001 SUNDALE DRIVE	FREMONT	94538	PATRICIA WILLIAMS	148	148	148	93	57	187	0	0	0	297	660	0	4	1298	0	1248	692	1300	0	0	0	2519	4438	0	22	10219	0	34	41	0	0	0	0	613	1202
106400480	FRENCH HOSPITAL MEDICAL CENTER - SAN LUIS OBISPO	20212	04/01/2021	06/30/2021	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	59	540	144	21	154	0	0	54	345	5	1	1264	0	2345	535	132	629	0	0	205	1046	27	3	4922	0	13057	1505	399	2919	0	0	730	9492
106104047	FRESNO SURGICAL HOSPITAL	20212	04/01/2021	06/30/2021	Open	Fresno	09 - Central	605	Investor - Ptnr.	Comparable	None	559-431-8000	6125 NORTH FRESNO STREET	FRESNO	93710	KRISTINE KASSAHN	27	27	27	106	29	0	21	0	0	19	97	0	0	272	0	232	56	0	28	0	0	38	170	0	0	524	0	1660	565	28	470	0	0	219	1673