Table hqfur_2023_quarter_1_sum_of_four_quarters_07_14

Table: hqfur_2023_quarter_1_sum_of_four_quarters_07_14_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	20231	04/01/2022	03/31/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.	511	436	347	57	0	5207	5079	651	1357	6983	383	96	19813	21	446	0	38044	13930	3559	6434	39365	1967	729	104474	10768	552	0	70615	189760	36	20361	98821
106361308	REDLANDS COMMUNITY HOSPITAL	20231	04/01/2022	03/31/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	142	1272	3556	472	1692	0	53	2937	41	74	10097	0	6926	17771	3078	6711	0	191	10309	129	267	45382	0	26616	47819	6131	46720	0	1066	42572
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20231	04/01/2022	03/31/2023	Open	Santa Clara	07 - Santa Clara	431	Investor - Corp.	Comparable	None	408-259-5000	225 NORTH JACKSON AVENUE	SAN JOSE	95116	KENNETH WEST	258	258	258	3343	2881	672	2562	0	272	1111	219	566	11626	0	19893	16595	5300	14096	0	1175	5554	1190	2371	66174	0	11167	11431	6984	42437	0	2714	11450
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20231	04/01/2022	03/31/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	231	65	301	2	0	0	1017	85	53	1754	0	4307	1119	4491	35	0	0	12423	1162	812	24349	0	1348	461	0	0	0	0	12796
106454068	RESTPADD PSYCHIATRIC HEALTH FACILITY	20231	04/01/2022	03/31/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	413	0	0	0	0	413	0	0	0	0	0	4894	0	0	0	0	4894	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF PSYCHIATRIC HEALTH FACILITY	20231	04/01/2022	03/31/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	505	505	0	0	0	0	0	0	0	0	0	4979	4979	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20231	04/01/2022	03/31/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	72	650	0	74	420	0	391	21	18	60	1634	0	4075	0	312	1420	0	1405	57	69	186	7524	0	70621	0	13676	50409	0	94405	3279
106331312	RIVERSIDE COMMUNITY HOSPITAL	20231	04/01/2022	03/31/2023	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	4254	6502	1923	8013	0	1142	4216	316	598	26964	0	29369	38168	16298	37155	0	4497	17057	811	1195	144550	0	7869	14824	6456	51923	0	2747	17989
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20231	04/01/2022	03/31/2023	Open	Riverside	12 - Inland Counties	1109	City/County	Comparable	Teaching	951-486-4000	26520 CACTUS AVENUE	MORENO VALLEY	92555	ZAREH SARRAFIAN	439	439	439	2504	2787	2751	8043	0	3554	835	204	497	21175	0	20315	20016	17157	42707	0	29118	4178	1144	2673	137308	0	11369	11214	18752	97988	0	17541	5684
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20231	04/01/2022	03/31/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	5951	2278	2384	2689	0	153	7817	17	705	21994	0	43622	19175	24457	24558	0	1184	55432	139	5860	174427	0	172153	63720	28351	41534	0	3130	316795