Table hqfur_2023_quarter_2_sum_of_four_quarters_10_16

Table: hqfur_2023_quarter_2_sum_of_four_quarters_10_16_2023 , 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	20232	07/01/2022	06/30/2023	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.	507	432	322	47	0	5241	5138	655	1376	7061	421	69	20008	29	376	0	37927	13468	3433	6177	39717	1821	562	103481	10726	552	0	69541	190656	32	20081	98581
106361308	REDLANDS COMMUNITY HOSPITAL	20232	07/01/2022	06/30/2023	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	132	1337	3618	427	1740	0	52	2924	33	80	10211	0	7257	18674	3098	7048	0	151	10514	119	307	47168	0	27741	49023	6159	47719	0	918	41685
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20232	07/01/2022	06/30/2023	Open	Santa Clara	07 - Santa Clara	431	Investor - Corp.	Comparable	None	408-259-5000	225 NORTH JACKSON AVENUE	SAN JOSE	95116	PJ THRASHER	258	258	258	3176	2878	617	2487	0	263	1052	217	560	11250	0	19368	16960	5299	13877	0	1235	5322	1088	2221	65370	0	11321	11733	6677	43271	0	2673	11478
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20232	07/01/2022	06/30/2023	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	242	62	383	0	0	0	1009	55	57	1808	0	4326	1101	5234	0	0	0	12141	761	820	24383	0	1384	447	0	0	0	0	13475
106454068	RESTPADD PSYCHIATRIC HEALTH FACILITY	20232	07/01/2022	06/30/2023	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	402	0	0	0	0	402	0	0	0	0	0	5020	0	0	0	0	5020	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF PSYCHIATRIC HEALTH FACILITY	20232	07/01/2022	06/30/2023	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	478	478	0	0	0	0	0	0	0	0	0	5096	5096	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20232	07/01/2022	06/30/2023	Open	Kern	09 - Central	621	Non Profit Corp.	Comparable	Rural	760-466-3551	1081 NORTH CHINA LAKE BLVD.	RIDGECREST	93555	JAMES SUVER	150	150	67	661	0	63	413	0	386	22	19	55	1619	0	3854	0	253	1324	0	1447	58	83	182	7201	0	71225	0	13311	52848	0	93300	3189
106331312	RIVERSIDE COMMUNITY HOSPITAL	20232	07/01/2022	06/30/2023	Open	Riverside	12 - Inland Counties	1111	Investor - Ptnr.	Comparable	None	951-788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	JACKIE D. VAN BLARICUM	493	493	493	4267	6740	1748	8162	0	1158	4282	301	652	27310	0	28908	38869	14941	38325	0	4725	17336	774	1761	145639	0	8003	14916	6320	53014	0	2828	18076
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20232	07/01/2022	06/30/2023	Open	Riverside	12 - Inland Counties	1109	City/County	Comparable	Teaching	951-486-4000	26520 CACTUS AVENUE	MORENO VALLEY	92555	ZAREH SARRAFIAN	439	439	393	2619	2894	2492	7804	0	4175	821	263	449	21517	0	20743	20487	15149	39933	0	34495	3932	1413	2438	138590	0	11469	11726	17057	101957	0	18669	5791
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20232	07/01/2022	06/30/2023	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	5939	2321	2342	2950	0	166	7844	15	692	22269	0	43209	19516	25088	26344	0	1213	55768	124	5562	176824	0	168766	63159	26913	43963	0	3155	307909