Table hqfur_2021_quarter_2_sum_of_four_quarters_10_13

Table: hqfur_2021_quarter_2_sum_of_four_quarters_10_13_2021 , fac_name like R*

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_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_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_thrd	vis_thrd_mc
106370673	RADY CHILDREN'S HOSPITAL - SAN DIEGO	20212	07/01/2020	06/30/2021	Open	San Diego	14 - San Diego/Imperial	1416	Non Profit Corp.	Comparable	Teaching	858-576-1700	3020 CHILDREN'S WAY	SAN DIEGO	92123	PATRICIO A. FRIAS, M. D.	511	436	309	73	0	4678	3189	622	1049	5059	304	104	15078	32	423	0	31829	9809	3502	6494	30680	1390	437	84564	10346	692	0	55574	124641	18	20626	78271
106361308	REDLANDS COMMUNITY HOSPITAL	20212	07/01/2020	06/30/2021	Open	San Bernardino	12 - Inland Counties	1209	Non Profit Corp.	Comparable	None	909-335-5501	350 TERRACINA BOULEVARD	REDLANDS	92373	JAMES R. HOLMES	229	197	126	1368	3595	680	1779	0	85	3111	96	106	10820	0	6617	17198	4127	6658	0	244	11481	397	442	47164	0	29182	47380	6181	36831	0	979	42509
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20212	07/01/2020	06/30/2021	Open	Santa Clara	07 - Santa Clara	431	Investor - Corp.	Comparable	None	408-259-5000	225 NORTH JACKSON AVENUE	SAN JOSE	95116	TOMI RYBA	258	258	258	3221	2453	1109	2214	0	325	1439	161	252	11174	0	20696	13730	7570	11224	0	1436	6416	773	1291	63136	0	11015	9217	7423	28728	0	2188	9868
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20212	07/01/2020	06/30/2021	Open	Los Angeles	11 - Los Angeles	927	Non Profit Other	Comparable	None	310-267-9315	150 Medical Plaza	LOS ANGELES	90095	JOHN MAZZIOTTA	74	74	74	275	85	150	1	0	0	1103	109	28	1751	0	4633	1382	2492	12	0	0	12390	1913	684	23506	0	1507	296	26	1	0	0	14178
106454068	RESTPADD PSYCHIATRIC HEALTH FACILITY	20212	07/01/2020	06/30/2021	Open	Shasta	01 - Northern California	209	Investor - Corp.	Psychiatric Health Facilities	None	530-262-6700	2750 EUREKA WAY	REDDING	96001	O. NWANGBURUKA	16	16	16	0	0	0	0	369	0	0	0	0	369	0	0	0	0	0	4823	0	0	0	0	4823	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF PSYCHIATRIC HEALTH FACILITY	20212	07/01/2020	06/30/2021	Open	Tehama	01 - Northern California	211	Investor - Corp.	Psychiatric Health Facilities	None	530-567-7300	925 WALNUT STREET	RED BLUFF	96080	CARL WOMACK	16	16	16	0	0	0	0	0	0	0	0	469	469	0	0	0	0	0	0	0	0	0	4356	4356	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20212	07/01/2020	06/30/2021	Open	Kern	09 - Central	621	Non Profit Corp.	Comparable	Rural	760-466-3551	1081 NORTH CHINA LAKE BLVD.	RIDGECREST	93555	JAMES SUVER	150	150	76	688	0	363	124	0	406	20	22	71	1694	0	3767	0	1239	418	0	1353	53	107	270	7207	0	34699	0	19968	4222	0	44187	1291
106331312	RIVERSIDE COMMUNITY HOSPITAL	20212	07/01/2020	06/30/2021	Open	Riverside	12 - Inland Counties	1111	Investor - Ptnr.	Comparable	None	951-788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	JACKIE D. VAN BLARICUM	478	478	478	3523	5145	2391	6865	0	728	4229	283	345	23509	0	24111	31347	15965	31120	0	3761	17469	1084	1323	126180	0	8784	14643	6881	38538	0	3470	16589
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20212	07/01/2020	06/30/2021	Open	Riverside	12 - Inland Counties	1109	City/County	Comparable	Teaching	951-486-4000	26520 CACTUS AVENUE	MORENO VALLEY	92555	ZAREH SARRAFIAN	439	372	308	2517	2493	3855	6068	128	3792	803	105	319	20080	0	16819	15858	20904	24436	459	30563	3983	616	1067	114705	0	8382	8504	27113	69894	1787	14722	4590
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20212	07/01/2020	06/30/2021	Open	Los Angeles	11 - Los Angeles	927	Non Profit Other	Comparable	Teaching	310-825-5041	757 WESTWOOD PLAZA	LOS ANGELES	90095	JOHNESE SPISSO	446	446	446	5653	1871	2538	1943	0	115	8014	21	518	20673	0	42665	15940	24941	16110	0	773	53689	148	3776	158042	0	163953	51088	30950	28057	0	2853	305812