Table: 2017_quarter_4_complete_data_set_4_13_18 , 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	vis_indgnt	vis_oth	vis_tot	grip_mcar	grip_mcar_mc	grip_mcal	grip_mcal_mc	grip_cnty	grip_cnty_mc	grip_thrd	grip_thrd_mc	grip_indgnt	grip_oth	grip_tot	grop_mcar	grop_mcar_mc	grop_mcal	grop_mcal_mc	grop_cnty	grop_cnty_mc	grop_thrd	grop_thrd_mc	grop_indgnt	grop_oth	grop_tot	bad_debt	cadj_mcar	cadj_mcar_mc	cadj_mcal	cadj_mcal_mc	disp_855	cadj_cnty	cadj_cnty_mc	cadj_thrd	cadj_thrd_mc	char_hb	char_oth	sub_indgnt	tch_allow	tch_supp	ded_oth	ded_tot	cap_mcar	cap_mcal	cap_cnty	cap_thrd	cap_tot	net_mcar	net_mcar_mc	net_mcal	net_mcal_mc	net_cnty	net_cnty_mc	net_thrd	net_thrd_mc	net_indgnt	net_oth	net_tot	oth_op_rev	tot_op_exp	phy_comp	nonop_rev	dis_pips	day_pips	exp_pips	exp_pops	cap_exp	fix_assets	disp_trnfr	dis_tot_cc	pat_day_tot_cc	tot_out_vis_cc	gros_inpat_rev_cc	gros_outpat_rev_cc	contr_adj_cc	othr_deduct_cc	cap_prem_rev_cc	net_pat_rev_cc	qa_fees	qa_suppl_pay	mngd_care_qa_pay
106370673	RADY CHILDREN'S HOSPITAL - SAN DIEGO	20174	10/01/2017	12/31/2017	Open	San Diego	14	1416	Non Profit Corp.	Comparable	Teaching	858-576-1700	3020 CHILDREN'S WAY	SAN DIEGO	92123	DONALD KEARNS, MD	524	444	339	15	0	1,589	1,304	109	0	238	1,875	1	64	5,195	14	85	0	11,003	2,722	1,165	0	1,083	8,803	8	418	25,287	3,049	232	0	14,299	38,983	0	0	3,483	22,937	21	2,288	82,243	1,598,844	0	192,872,607	35,013,096	5,088,962	0	18,426,057	143,277,354	109,037	366,859	396,752,816	949,689	0	43,247,341	71,010,243	0	0	11,231,648	81,554,648	50,667	2,565,142	210,609,378	1,828,129	1,706,302	0	103,568,877	99,651,710	(2,047,497)	3,602,621	0	20,636,754	142,361,820	0	159,704	0	0	0	1,409,554	372,877,974	0	3,105,249	0	13,901,532	17,006,781	842,231	0	134,598,567	9,476,878	1,486,341	0	9,020,951	96,188,902	0	(122,869)	251,491,001	20,083,404	204,519,166	0	24,680,408	0	0	0	0	21,003,218	495,055,554	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	20174	10/01/2017	12/31/2017	Open	San Bernardino	12	1209	Non Profit Corp.	Comparable	None	909-335-5501	350 TERRACINA BOULEVARD	REDLANDS	92373	JAMES R. HOLMES	229	197	136	402	942	244	526	0	0	35	869	13	13	3,044	0	1,909	4,091	1,021	1,909	0	0	69	3,058	32	35	12,124	0	7,307	11,710	1,603	9,933	0	0	267	10,116	1,554	1,453	43,943	37,708,546	81,296,405	12,354,376	33,779,154	0	0	2,202,434	48,195,445	540,922	600,342	216,677,624	24,125,793	46,565,669	4,171,754	25,850,352	0	0	1,306,544	53,225,924	2,715,654	2,539,133	160,500,823	496,532	53,724,234	115,206,951	14,162,958	55,211,001	0	0	0	2,620,301	87,597,737	0	3,158,879	0	0	0	1,738,587	333,917,180	14,431,395	0	0	20,638,795	35,070,190	8,110,105	27,086,518	2,363,172	4,418,505	0	0	888,677	34,462,427	97,697	904,356	78,331,457	429,774	81,182,730	1,353,495	2,460,386	0	0	8,196,821	16,290,694	3,750,762	116,639,348	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	20174	10/01/2017	12/31/2017	Open	Humboldt	01	0107	Church	Comparable	Rural	707-445-8121	3300 RENNER DRIVE	FORTUNA	95540	DAVID O'BRIEN, MD	35	25	25	116	13	25	88	0	0	3	57	0	13	315	0	714	84	55	248	0	0	8	128	0	50	1,287	0	4,056	165	260	3,392	0	0	209	2,677	0	679	11,438	9,480,508	941,494	830,746	4,183,389	0	0	368,681	2,409,307	0	635,233	18,849,358	11,660,727	499,613	840,434	9,352,933	0	0	1,078,392	6,617,563	0	1,448,371	31,498,033	823,535	15,448,729	1,083,252	(3,810,453)	11,539,551	0	0	0	730,996	4,975,736	0	951,564	0	0	0	870,852	32,613,762	0	0	0	0	0	5,608,122	357,855	5,472,188	1,988,433	0	0	688,816	3,905,140	0	(286,925)	17,733,629	75,000	11,734,000	0	2,484,000	0	0	0	0	720,000	12,362,000	0	0	0	0	0	0	0	0	0	0	0	5,161,069	23
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20174	10/01/2017	12/31/2017	Open	Santa Clara	07	0431	Investor - Corp.	Comparable	None	408-259-5000	225 NORTH JACKSON AVENUE	SAN JOSE	95116	MICHAEL CARTER	264	264	264	1,322	671	376	704	0	0	29	514	13	102	3,731	0	8,034	3,889	2,316	3,944	0	0	157	2,073	49	485	20,947	0	4,378	2,344	2,927	12,617	0	0	426	3,967	276	2,871	29,806	289,673,028	152,424,860	91,538,340	152,445,221	0	0	7,158,361	109,503,588	2,178,152	18,340,717	823,262,267	49,588,248	29,967,788	22,052,747	88,239,561	0	0	3,672,420	42,794,877	3,670,656	21,111,877	261,098,174	(623,026)	308,500,145	170,917,143	105,482,553	235,697,925	0	0	0	4,778,348	121,109,966	0	5,848,808	0	0	0	41,774,199	993,486,061	0	0	0	0	0	30,761,131	11,475,505	8,108,534	4,986,857	0	0	6,052,433	31,188,499	0	(1,698,579)	90,874,380	312,356	106,632,460	3,413,937	189,777	0	0	0	0	116,975	303,250,545	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20174	10/01/2017	12/31/2017	Open	Los Angeles	11	0927	Non Profit Other	Comparable	None	310-267-9315	150 MEDICAL PLAZA	LOS ANGELES	90095	JOHN MAZZIOTTA	74	74	74	59	9	51	0	0	0	0	276	16	26	437	0	1,407	139	704	0	0	0	0	3,312	387	361	6,310	0	329	40	0	0	0	0	0	3,364	0	937	4,670	5,263,990	377,335	2,493,112	0	0	0	0	13,602,576	2,457,534	1,442,731	25,637,278	335,773	33,189	0	0	0	0	0	3,590,590	0	31,611	3,991,163	1,018,060	2,737,075	170,143	2,080,302	0	0	0	0	0	6,654,450	0	0	0	2,457,534	(2,457,534)	1,444,845	14,104,875	0	0	0	0	0	2,655,760	223,005	382,970	0	0	0	0	9,776,932	2,457,534	27,365	15,523,566	90,224	18,301,894	0	782,619	0	0	0	0	347,986	9,222,475	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	20174	10/01/2017	12/31/2017	Open	Shasta	01	0209	Investor - Corp.	Psychiatric Health Facilities	None	530-262-6700	2750 EUREKA WAY	REDDING	96001	O. NWANGBURUKA	16	16	16	0	0	0	0	129	0	0	0	0	0	129	0	0	0	0	0	1,282	0	0	0	0	0	1,282	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,128,160	0	0	0	0	0	1,128,160	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,128,160	0	0	0	0	0	1,128,160	0	1,066,823	0	0	0	0	0	0	0	94,827	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF - PHF	20174	10/01/2017	12/31/2017	Open	Tehama	01	0211	Investor - Corp.	Comparable	None	530-567-7300	925 WALNUT STREET	RED BLUFF	96080	CARL WOMACK	16	16	20	0	0	0	0	0	0	0	0	0	170	170	0	0	0	0	0	0	0	0	0	0	1,198	1,198	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,167,120	1,167,120	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,167,120	1,167,120	0	1,693,223	0	0	0	0	0	0	0	144,442	0	0	0	0	0	0	0	0	0	0	0	0	0
106580996	RIDEOUT MEMORIAL HOSPITAL	20174	10/01/2017	12/31/2017	Open	Yuba	02	0227	Non Profit Corp.	Comparable	None	530-749-4663	726 FOURTH STREET	MARYSVILLE	95901	GINO PATRIZIO	221	221	144	1,199	31	225	748	1	0	455	0	30	3	2,692	0	6,866	187	1,189	3,024	2	0	1,757	0	184	24	13,233	0	12,607	317	1,566	7,767	1	0	6,942	0	0	1,067	30,267	97,496,112	3,500,030	13,126,529	41,373,902	28,587	0	26,266,456	0	4,015,616	1,140,471	186,947,703	57,492,263	1,453,241	7,142,661	35,457,194	4,246	0	31,677,810	0	0	4,872,531	138,099,946	1,308,153	123,709,147	4,337,195	4,398,585	62,918,387	0	25,813	0	30,654,207	0	0	4,015,617	0	0	0	0	231,367,104	0	0	0	0	0	31,279,227	616,076	15,870,604	13,912,709	7,020	0	25,981,907	0	4,015,617	1,997,385	93,680,545	1,784,190	98,652,545	11,322,152	3,709,296	0	0	0	0	0	349,100,229	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20174	10/01/2017	12/31/2017	Open	Kern	09	0621	Non Profit Corp.	Comparable	Rural	760-466-3551	1081 NORTH CHINA LAKE BOULEVARD	RIDGECREST	93555	JAMES SUVER	150	150	88	177	0	92	24	0	0	130	7	4	21	455	0	684	0	264	78	0	0	342	21	9	101	1,499	0	6,509	0	4,770	885	0	0	7,940	298	204	987	21,593	6,340,253	0	6,294,889	539,764	0	0	5,425,440	188,869	8,045	646,140	19,443,400	15,083,631	0	12,330,459	1,197,856	0	0	17,539,699	622,769	40,134	501,124	47,315,672	1,163,485	15,144,311	0	8,884,910	2,372,427	0	0	0	8,625,878	0	0	197,233	0	0	0	412,685	36,800,929	0	0	0	0	0	6,279,573	0	9,740,438	(634,807)	0	0	14,339,261	811,636	(149,052)	(428,906)	29,958,143	103,502	29,865,081	0	214,332	0	0	0	0	1,419,388	84,876,778	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20174	10/01/2017	12/31/2017	Open	Riverside	12	1111	Investor - Ptnr.	Comparable	None	951-788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	PATRICK BRILLIANT	456	456	456	1,112	1,157	575	1,616	4	0	55	1,013	33	64	5,629	0	6,394	5,799	3,626	5,845	12	0	330	4,093	177	70	26,346	0	4,393	5,023	2,829	16,169	25	0	681	6,577	388	3,111	39,196	169,112,042	190,237,671	76,894,412	168,321,743	433,149	0	8,917,349	136,397,873	4,631,229	3,036,722	757,982,190	49,715,861	72,785,264	18,244,518	116,501,772	342,887	0	6,792,995	79,608,540	1,844,814	28,422,198	374,258,849	1,369,072	188,860,314	236,822,891	88,711,031	269,052,752	0	401,979	0	10,685,812	164,824,377	0	640,579	0	0	0	28,292,572	989,661,379	0	0	0	0	0	29,967,589	26,200,044	6,427,899	15,770,763	374,057	0	5,024,532	51,182,036	9,155,178	(1,522,438)	142,579,660	473,532	115,663,399	5,846,508	9,286,093	0	0	0	0	15,224,374	397,412,261	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20174	10/01/2017	12/31/2017	Open	Riverside	12	1109	City/County	Comparable	Teaching	951-486-4000	26520 CACTUS AVENUE	MORENO VALLEY	92555	ZAREH SARRAFIAN	439	439	439	458	410	885	1,387	48	0	1,038	163	0	146	4,535	0	3,427	2,441	5,650	6,138	233	0	6,933	878	0	619	26,319	0	2,793	1,793	11,026	21,694	610	0	5,509	1,222	0	2,423	47,070	35,492,890	29,181,892	54,867,723	75,930,639	3,050,119	0	45,257,849	11,236,264	0	6,236,745	261,254,121	9,509,481	6,886,648	26,741,078	46,716,715	2,097,664	0	14,204,030	3,887,258	0	5,403,858	115,446,732	11,538,231	35,726,243	26,794,984	63,038,089	84,583,895	(13,412,793)	5,147,783	0	41,691,491	6,758,872	0	0	0	0	0	0	261,866,795	0	0	0	0	0	9,276,128	9,273,556	31,983,505	38,063,459	0	0	17,770,388	8,364,650	0	102,372	114,834,058	4,716,125	137,015,965	0	15,530,547	0	0	0	0	4,067,655	198,910,569	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20174	10/01/2017	12/31/2017	Open	Los Angeles	11	0927	Non Profit Other	Comparable	Teaching	310-825-5041	757 WESTWOOD PLAZA	LOS ANGELES	90095	JOHNESE SPISSO	445	445	448	1,505	330	721	547	0	0	54	2,343	6	110	5,616	0	11,720	2,804	7,034	4,061	0	0	518	14,554	23	420	41,134	0	40,331	7,707	7,326	5,356	0	0	784	70,552	159	5,890	138,105	183,265,474	23,110,638	95,899,765	52,892,424	0	0	8,236,685	258,745,061	347,321	6,214,895	628,712,263	100,563,379	4,063,190	17,260,312	13,272,576	0	0	2,119,954	175,008,660	285,562	10,554,106	323,127,739	5,822,894	192,149,695	14,105,874	84,161,433	51,062,166	0	0	0	5,377,226	164,630,545	0	632,883	0	819,177	(819,177)	5,759,112	523,701,828	0	0	0	0	0	91,679,158	13,067,954	28,998,644	15,102,834	0	0	4,979,413	269,123,176	0	5,186,995	428,138,174	44,013,733	472,244,930	0	9,311,336	0	0	0	0	27,931,473	1,058,521,596	0	0	0	0	0	0	0	0	0	0	0	0	0