Table 2023_quarter_1_complete_data_set_07_14

Table: 2023_quarter_1_complete_data_set_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	01/01/2023	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	16	0	1428	1233	190	368	1738	73	0	5046	4	174	0	9795	3251	865	1702	9556	358	0	25701	2704	139	0	17749	48011	23	5327	26371
106361308	REDLANDS COMMUNITY HOSPITAL	20231	01/01/2023	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	349	900	84	432	0	11	705	8	22	2511	0	1981	5347	730	1844	0	41	2584	25	74	12626	0	6516	12097	1224	11915	0	189	10350
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20231	01/01/2023	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	825	752	118	663	0	76	276	82	122	2914	0	5422	4631	1202	3827	0	347	1441	513	556	17939	0	3198	3139	1646	11009	0	715	3059
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20231	01/01/2023	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	54	15	121	0	0	0	241	11	15	457	0	878	378	1626	0	0	0	2880	85	243	6090	0	373	138	0	0	0	0	3436
106454068	RESTPADD PSYCHIATRIC HEALTH FACILITY	20231	01/01/2023	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	87	0	0	0	0	87	0	0	0	0	0	1307	0	0	0	0	1307	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF PSYCHIATRIC HEALTH FACILITY	20231	01/01/2023	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	113	113	0	0	0	0	0	0	0	0	0	1312	1312	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20231	01/01/2023	03/31/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	72	190	0	16	104	0	81	6	2	12	411	0	1129	0	91	333	0	317	17	7	51	1945	0	17859	0	3498	13347	0	23432	837
106331312	RIVERSIDE COMMUNITY HOSPITAL	20231	01/01/2023	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	1087	1695	420	1986	0	278	1086	103	56	6711	0	7165	10279	3462	9444	0	1203	4066	323	143	36085	0	1952	3672	1513	12723	0	692	4365
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20231	01/01/2023	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	675	816	582	1849	0	1135	198	60	173	5488	0	5280	5944	3670	8745	0	10164	917	344	1187	36251	0	2609	2703	4108	23908	0	4855	1326
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20231	01/01/2023	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	1443	584	573	743	0	42	1896	3	157	5441	0	11451	4967	6154	6562	0	391	13599	21	1086	44231	0	42777	15661	6678	11561	0	801	77134