Table: 2020_quarter_2_complete_data_set_10_19_2020 , 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	20202	04/01/2020	06/30/2020	OPEN	Siskiyou	01 - Northern California	203	Non Profit Corp.	Comparable	Rural	530-842-4121	444 BRUCE STREET	YREKA	96097	JONATHON ANDRUS	25	25	25	115	0	112	0	0	0	79	0	0	2	308	0	439	0	332	0	0	0	141	0	0	5	917	0	6983	0	4175	0	0	0	4327	0
106301357	FOOTHILL REGIONAL MEDICAL CENTER	20202	04/01/2020	06/30/2020	OPEN	Orange	13 - Orange	1015	Investor - Corp.	Comparable	None	714-619-7700	14662 NEWPORT AVENUE	TUSTIN	92780	ARACELI LONERGAN	127	127	61	187	128	31	261	0	0	36	31	0	7	681	0	1103	543	125	3577	0	0	104	83	0	13	5548	0	48	212	112	414	0	0	90	173
106301175	FOUNTAIN VALLEY REGIONAL HOSPITAL AND MC - EUCLID	20202	04/01/2020	06/30/2020	OPEN	Orange	13 - Orange	1014	Investor - Corp.	Comparable	None	714-966-7200	17100 EUCLID STREET	FOUNTAIN VALLEY	92708	KENNETH MCFARLAND	400	344	184	549	496	232	1284	6	0	19	522	10	74	3192	0	3476	2645	1470	6089	29	0	64	2025	24	120	15942	0	944	1112	652	5027	2	0	403	1895
106014034	FREMONT HOSPITAL	20202	04/01/2020	06/30/2020	OPEN	Alameda	05 - East Bay	421	Investor - Corp.	Comparable	None	510-796-1100	39001 SUNDALE DRIVE	FREMONT	94538	PATRICIA WILLIAMS	148	148	148	86	63	183	0	0	0	241	506	1	2	1082	0	1683	1251	1439	0	0	0	2376	3821	4	45	10619	0	137	0	0	0	0	0	429	1159
106400480	FRENCH HOSPITAL MEDICAL CENTER - SAN LUIS OBISPO	20202	04/01/2020	06/30/2020	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	49	414	104	21	142	0	0	30	296	3	3	1013	0	1809	493	91	599	0	0	101	946	8	8	4055	0	7475	771	338	1812	0	0	464	5834
106104047	FRESNO SURGICAL HOSPITAL	20202	04/01/2020	06/30/2020	OPEN	Fresno	09 - Central	605	Investor - Ptnr.	Comparable	None	559-431-8000	6125 NORTH FRESNO STREET	FRESNO	93710	KRISTINE KASSAHN	27	27	27	182	36	0	8	0	0	23	141	0	1	391	0	386	63	0	15	0	0	52	275	0	2	793	0	1305	346	27	374	0	0	164	1638