Table: hqfur_2023_quarter_3_sum_of_four_quarters_01_16_2024 , 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_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
106370673	RADY CHILDREN'S HOSPITAL - SAN DIEGO	20233	10/01/2022	09/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	317	49	0	5274	5115	654	0	1353	6833	446	79	19803	39	327	0	37530	12924	3313	0	5953	39145	1977	650	101819	10379	569	0	68436	190109	23	0	19276	97055
106361308	REDLANDS COMMUNITY HOSPITAL	20233	10/01/2022	09/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	140	1448	3616	403	1813	0	0	59	2867	29	83	10318	0	7754	19256	3176	7700	0	0	218	10258	115	346	48823	0	27493	50147	6085	47652	0	0	862	41499
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20233	10/01/2022	09/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	3085	2796	546	2374	0	0	264	981	219	598	10863	0	18301	16486	4632	13218	0	0	1137	4861	1254	2105	61994	0	10896	11487	6916	43940	0	0	2695	11089
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20233	10/01/2022	09/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	235	61	471	0	0	0	0	958	31	57	1813	0	4274	922	6376	0	0	0	0	11538	394	942	24446	0	1350	475	0	0	0	0	0	13974
106454068	RESTPADD PSYCHIATRIC HEALTH FACILITY	20233	10/01/2022	09/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	370	0	0	0	0	0	370	0	0	0	0	0	5194	0	0	0	0	0	5194	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF PSYCHIATRIC HEALTH FACILITY	20233	10/01/2022	09/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	0	475	475	0	0	0	0	0	0	0	0	0	0	5173	5173	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20233	10/01/2022	09/30/2023	Open	Kern	09 - Central	621	Non Profit Corp.	Comparable	Rural	760-466-3551	1081 NORTH CHINA LAKE BOULEVARD	RIDGECREST	93555	JAMES SUVER	150	150	70	683	0	66	389	0	0	359	20	16	45	1578	0	3815	0	249	1210	0	0	1358	49	55	166	6902	0	70462	0	12890	53912	0	0	91029	2965
106200030	RIVER VISTA BEHAVIORAL HEALTH	20233	10/01/2022	09/30/2023	Open	Madera	09 - Central	601	Investor - Corp.	Comparable	None	559-603-6000 x0	40886 GOODWIN WAY	MADERA	93636	ROBERT DUTILE	128	128	128	1	0	0	0	24	0	1	1	0	0	27	0	19	0	0	0	303	0	9	17	0	0	348	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20233	10/01/2022	09/30/2023	Open	Riverside	12 - Inland Counties	1111	Investor - Ptnr.	Comparable	None	951-788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	ADAM RUDD	493	493	493	4218	6807	1785	8292	0	0	1171	4355	281	603	27512	0	28727	38873	14290	39085	0	0	4655	18023	927	1749	146329	0	7962	15333	6273	53394	0	0	2930	18147
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20233	10/01/2022	09/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	380	2657	2909	3123	7473	0	0	4002	818	358	314	21654	0	20019	19481	19667	35826	0	0	32925	3970	1915	1728	135531	0	10670	11481	18744	101541	0	0	18139	5603
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20233	10/01/2022	09/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	5832	2324	2285	3141	0	0	158	7870	10	695	22315	0	42744	19798	25481	28115	0	0	1186	55184	83	5663	178254	0	163745	61884	25756	46381	0	0	3119	297681