Table 2023_quarter_2_complete_data_set_10_16

Table: 2023_quarter_2_complete_data_set_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_thrd	vis_thrd_mc
106370673	RADY CHILDREN'S HOSPITAL - SAN DIEGO	20232	04/01/2023	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	7	0	1236	1170	153	331	1676	72	0	4645	14	21	0	9049	2687	800	1233	9804	464	0	24058	2618	139	0	17271	49049	5135	25306
106361308	REDLANDS COMMUNITY HOSPITAL	20232	04/01/2023	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	361	944	102	433	0	16	711	7	21	2595	0	1848	4633	800	1674	0	32	2707	29	83	11806	0	6991	12514	1768	12007	213	10263
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20232	04/01/2023	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	750	688	151	556	0	55	251	43	167	2661	0	4356	4059	1352	3139	0	292	1172	125	562	15057	0	3223	3304	1702	10961	665	3041
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20232	04/01/2023	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	66	12	121	0	0	0	253	6	15	473	0	1174	204	1631	0	0	0	2966	56	235	6266	0	327	63	0	0	0	3839
106454068	RESTPADD PSYCHIATRIC HEALTH FACILITY	20232	04/01/2023	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	88	0	0	0	0	88	0	0	0	0	0	1345	0	0	0	0	1345	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF PSYCHIATRIC HEALTH FACILITY	20232	04/01/2023	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	111	111	0	0	0	0	0	0	0	0	0	1293	1293	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20232	04/01/2023	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	162	0	14	78	0	89	5	3	12	363	0	927	0	50	217	0	312	10	23	45	1584	0	17694	0	3175	13549	22484	711
106331312	RIVERSIDE COMMUNITY HOSPITAL	20232	04/01/2023	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	989	1745	380	2084	0	299	1028	50	224	6799	0	6731	9395	3074	10098	0	1146	4245	163	891	35743	0	1949	3845	1406	13334	741	4435
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20232	04/01/2023	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	651	689	554	1712	0	1217	191	92	61	5167	0	4803	4354	3312	8472	0	9809	866	402	130	32148	0	2609	2998	4197	26120	4684	1412
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20232	04/01/2023	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	1497	575	553	846	0	38	1975	4	171	5659	0	10224	4884	6261	7422	0	294	13834	39	1503	44461	0	40949	15543	6091	11965	752	73604