Table: 2017_quarter_1_sum_of_four_quarters , 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	20171	04/01/2016	03/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	360	73	0	6,695	4,297	575	0	980	7,297	173	210	20,300	52	363	0	41,520	8,736	4,939	0	4,923	35,777	690	1,808	98,756	12,660	730	0	62,463	149,571	101	0	16,703	93,741	4,137	3,971	331,417	6,743,098	0	703,717,524	97,636,164	8,675,330	0	89,635,852	543,529,793	9,177,580	1,657,709	1,460,773,050	4,254,432	0	156,155,881	248,382,269	18,818	0	43,321,731	298,938,502	6,393,954	5,614,369	763,079,956	4,546,382	9,951,772	0	600,801,999	316,318,124	(10,746,772)	2,254,418	0	93,174,278	503,500,296	0	15,885,523	0	0	0	2,981,203	1,538,667,223	0	23,956,971	0	41,134,575	65,091,546	1,045,758	0	269,818,177	54,627,512	6,439,730	0	39,783,305	376,693,600	0	1,869,247	750,277,329	70,727,925	711,643,280	0	67,332,117	0	0	0	0	49,231,460	477,762,056	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	20171	04/01/2016	03/31/2017	Open	San Bernardino	12	1209	Non Profit Corp.	Comparable	None	(909) 335-5501	350 TERRACINA BOULEVARD	REDLANDS	92373	JAMES R. HOLMES	229	229	195	1,770	3,351	953	2,033	0	0	176	3,419	53	52	11,807	0	8,112	14,720	4,459	6,280	0	0	359	11,149	161	167	45,407	0	27,247	42,082	7,728	40,535	0	0	1,491	36,937	5,520	5,539	167,079	142,666,791	263,682,928	49,587,873	106,233,872	0	0	12,712,939	161,897,856	2,078,409	2,170,867	741,031,535	78,235,271	159,792,199	18,962,380	99,047,506	0	0	5,091,292	188,480,114	8,575,977	8,610,271	566,795,010	3,889,829	189,337,258	382,339,589	43,127,846	187,844,930	0	0	0	12,835,926	298,471,376	0	10,271,501	0	0	0	3,877,699	1,131,995,954	54,563,983	0	0	79,742,787	134,306,770	31,564,804	95,699,521	25,422,405	17,436,447	0	0	4,968,305	131,649,381	382,885	3,013,613	310,137,361	2,547,586	296,834,703	4,271,585	2,596,965	0	0	36,549,600	40,827,859	13,370,965	111,937,175	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	20171	04/01/2016	03/31/2017	Open	Humboldt	01	0107	Church	Comparable	Rural	(707) 445-8121	3300 RENNER DRIVE	FORTUNA	95540	DAVID O'BRIEN, MD	35	25	25	524	39	78	372	0	0	9	232	0	43	1,297	0	2,650	235	189	1,011	0	0	36	481	0	178	4,780	0	15,562	817	1,258	13,103	0	0	1,090	11,099	0	3,302	46,231	33,269,740	2,900,910	3,590,085	15,370,543	0	0	414,205	11,217,049	0	1,263,034	68,025,566	41,312,984	2,336,543	4,380,809	36,163,302	0	0	4,088,356	30,641,873	0	5,357,058	124,280,925	3,111,922	60,315,351	3,991,748	3,132,953	42,654,508	0	0	0	1,719,087	23,608,008	0	2,594,229	0	0	0	3,412,606	144,540,412	0	0	0	0	0	13,945,061	1,245,705	4,663,336	8,694,486	0	0	2,760,594	17,680,626	0	(1,223,729)	47,766,079	882,000	41,785,000	0	5,756,000	0	0	0	0	1,002,000	10,778,000	0	0	0	0	0	0	0	0	0	0	0	4,740,776	6,478
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20171	04/01/2016	03/31/2017	Open	Santa Clara	07	0431	Investor - Corp.	Comparable	None	(408) 259-5000	225 NORTH JACKSON AVENUE	SAN JOSE	95116	MICHAEL JOHNSON	264	264	264	5,519	2,889	1,418	3,042	0	0	109	2,200	127	256	15,560	0	30,630	14,774	8,129	15,085	0	0	466	9,477	492	1,300	80,353	0	18,337	9,661	13,226	48,609	0	0	1,373	17,816	1,291	10,331	120,644	991,937,799	501,725,576	291,983,334	500,826,441	0	0	20,538,984	423,661,118	19,656,188	56,937,577	2,807,267,017	177,340,417	104,330,623	93,571,435	300,360,257	0	0	11,856,911	162,896,901	11,474,416	72,609,816	934,440,776	25,705,194	1,047,953,623	554,837,754	351,164,415	781,085,799	0	0	0	14,258,166	394,317,048	0	34,468,138	0	0	0	106,704,651	3,310,494,788	0	0	0	0	0	121,324,593	51,218,445	34,390,354	20,100,899	0	0	18,137,729	192,240,971	0	(6,199,986)	431,213,005	1,359,458	427,181,726	13,895,786	863,444	0	0	0	0	10,494,173	313,938,869	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20171	04/01/2016	03/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	319	62	180	9	0	0	0	1,023	70	49	1,712	0	6,470	1,054	3,423	243	0	0	0	12,418	1,385	609	25,602	0	1,831	158	0	0	0	0	0	14,221	0	1,030	17,240	25,435,330	1,097,286	11,837,349	890,463	0	0	0	49,139,786	10,098,248	5,656,575	104,155,037	1,651,766	34,378	0	0	0	0	0	12,924,222	0	212,288	14,822,654	1,324,851	13,583,369	459,765	10,510,416	661,019	0	0	0	0	24,098,652	0	0	0	10,098,248	(10,098,248)	5,427,686	56,065,758	0	0	0	0	0	13,182,113	657,190	1,296,253	229,378	0	0	0	37,017,078	10,098,248	431,673	62,911,933	78,964	73,488,102	0	3,035,812	0	0	0	0	193,529	8,140,444	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	20171	04/01/2016	03/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	678	0	0	0	0	0	678	0	0	0	0	0	4,938	0	0	0	0	0	4,938	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4,222,120	0	0	0	0	0	4,222,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	4,222,120	0	0	0	0	0	4,222,120	0	4,014,736	0	0	0	0	0	0	11,714	134,062	0	0	0	0	0	0	0	0	0	0	0	0	0
106580996	RIDEOUT MEMORIAL HOSPITAL	20171	04/01/2016	03/31/2017	Open	Yuba	02	0227	Non Profit Corp.	Comparable	None	(530) 749-4663	726 FOURTH STREET	MARYSVILLE	95901	GINO PATRIZIO	219	219	150	5,020	70	903	3,056	0	0	1,929	0	32	123	11,133	0	27,085	411	4,892	12,555	0	0	7,335	0	150	590	53,018	0	49,108	661	5,467	31,791	0	0	29,174	0	0	4,277	120,478	362,601,356	5,964,538	54,593,045	170,675,097	0	0	101,732,851	0	2,660,576	10,482,808	708,710,271	226,777,879	3,039,774	25,203,106	146,568,470	0	0	134,727,928	0	0	19,733,814	556,050,971	10,837,481	468,393,933	7,417,854	41,437,486	251,787,703	(3,161,566)	0	0	124,861,028	0	0	2,660,576	0	0	0	0	904,234,495	0	0	0	0	0	120,985,301	1,586,457	41,520,231	65,455,864	0	0	100,341,824	0	2,660,576	27,976,494	360,526,747	6,372,653	396,564,188	46,729,667	10,518,839	0	0	0	0	37,340,197	360,652,269	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20171	04/01/2016	03/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	99	873	0	578	143	0	0	630	23	16	126	2,389	0	7,837	0	1,394	439	0	0	1,495	36	42	235	11,478	0	26,752	0	19,821	4,138	0	0	31,365	923	1,213	4,251	88,463	36,925,357	0	27,303,290	2,611,244	0	0	20,209,430	599,569	78,308	1,923,446	89,650,644	55,110,378	0	44,289,943	5,290,252	0	0	61,770,029	2,046,360	122,609	2,465,809	171,095,380	384,556	61,753,296	0	39,621,916	9,438,064	0	0	0	30,472,867	0	0	808,538	(15,393)	0	0	905,958	143,369,802	0	0	0	0	0	30,282,439	0	31,971,314	(1,536,568)	0	0	51,506,591	2,645,929	(592,227)	3,098,744	117,376,222	1,050,069	109,730,203	0	1,140,626	0	0	0	0	14,901,560	86,438,918	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20171	04/01/2016	03/31/2017	Open	Riverside	12	1111	Investor - Ptnr.	Comparable	None	(951) 788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	PATRICK BRILLIANT	373	373	373	4,279	5,071	3,111	7,727	12	0	352	4,864	104	494	26,014	0	26,202	24,951	15,954	24,751	36	0	1,249	15,899	721	1,489	111,252	0	17,733	19,599	13,387	63,863	49	0	2,696	25,534	606	12,169	155,636	590,054,984	695,666,903	274,829,005	556,174,073	1,657,716	0	38,200,809	437,611,330	19,489,841	38,785,733	2,652,470,394	158,516,870	246,594,301	74,061,837	408,730,726	1,780,669	0	26,029,613	263,978,188	8,578,586	79,202,153	1,267,472,943	22,273,486	642,119,260	835,616,834	332,862,295	909,589,647	0	2,182,523	0	52,040,466	506,491,635	0	21,973,681	0	0	0	114,302,719	3,439,452,546	0	0	0	0	0	106,452,594	106,644,370	16,028,547	55,315,152	1,255,862	0	12,189,955	195,097,883	6,094,747	(18,588,319)	480,490,791	2,241,139	412,912,443	16,936,824	37,340,963	0	0	0	0	420,592,217	354,231,493	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20171	04/01/2016	03/31/2017	Open	Riverside	12	1109	City/County	Comparable	Teaching	(951) 486-4000	26520 CACTUS AVENUE	MORENO VALLEY	92555	ZAREH SARRAFIAN	439	439	439	2,201	1,658	3,298	5,502	143	0	4,183	382	20	687	18,074	0	15,131	9,336	17,503	23,572	813	0	29,027	1,596	89	2,278	99,345	0	12,224	4,811	40,623	89,155	6,574	0	25,364	1,082	179	11,594	191,606	153,952,271	111,774,477	174,978,905	313,230,139	8,793,111	0	239,113,279	12,559,714	1,083,159	25,744,887	1,041,229,942	33,277,942	16,601,644	87,151,312	171,548,162	20,571,532	0	67,842,228	3,747,796	446,134	24,085,000	425,271,750	49,113,956	135,327,135	95,574,654	206,343,063	314,198,423	(52,054,839)	28,631,725	0	201,656,194	4,065,084	0	1,529,491	0	0	0	0	984,384,886	0	0	0	0	0	51,903,076	32,801,467	107,841,993	170,579,878	732,918	0	105,299,313	12,242,426	0	715,735	482,116,806	22,692,010	544,566,030	0	63,578,904	0	0	0	0	47,991,059	191,243,785	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20171	04/01/2016	03/31/2017	Open	Los Angeles	11	0927	Non Profit Other	Comparable	Teaching	(310) 825-5041	757 WESTWOOD PLAZA	LOS ANGELES	90095	DAVID FREINBERG	445	445	445	6,247	1,391	3,135	1,933	0	0	232	9,982	34	451	23,405	0	45,447	11,752	28,422	14,266	0	0	1,578	62,927	170	2,615	167,177	0	161,241	36,917	31,612	21,582	0	0	3,230	299,259	447	21,620	575,908	710,332,485	120,984,150	396,127,832	182,163,512	0	0	22,148,429	1,082,400,338	2,529,358	32,036,376	2,548,722,480	387,886,435	44,698,515	83,854,890	50,525,804	0	0	7,840,245	674,313,787	843,708	40,498,962	1,290,462,346	18,335,945	680,993,295	104,206,643	336,102,259	184,095,457	0	0	0	15,610,145	708,730,665	0	3,373,065	0	3,354,611	(3,354,611)	20,930,171	2,072,377,645	647,629	830,725	0	6,168,771	7,647,125	417,225,625	62,123,651	143,880,463	49,424,584	0	0	14,378,529	1,054,152,231	0	33,269,223	1,774,454,306	197,803,783	1,908,248,940	0	(17,228,353)	0	0	0	0	55,494,890	1,074,017,124	0	0	0	0	0	0	0	0	0	0	0	0	0