Table: 2017_quarter_2_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	20172	07/01/2016	06/30/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	333	75	0	6,441	4,505	637	0	1,014	7,549	114	268	20,603	55	342	0	41,190	9,027	5,109	0	4,695	37,157	549	1,625	99,694	12,314	678	0	61,419	152,885	109	0	16,032	94,216	2,177	6,234	333,750	5,931,715	0	698,996,317	101,935,968	9,222,836	0	87,129,291	586,753,129	8,093,301	3,022,796	1,501,085,353	4,081,636	0	158,668,846	261,469,087	19,868	0	42,946,982	306,831,356	3,607,287	8,444,593	786,069,655	10,598,016	8,826,473	0	626,073,022	327,746,523	(9,586,853)	2,727,687	0	90,754,049	554,688,628	0	8,404,400	0	0	0	3,853,126	1,624,085,071	0	27,317,033	0	50,637,171	77,954,204	1,186,878	0	241,178,993	62,975,565	6,515,017	0	39,322,223	388,473,225	0	1,372,240	741,024,141	70,447,058	693,356,517	0	67,176,017	0	0	0	0	48,320,464	483,202,895	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	20172	07/01/2016	06/30/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,763	3,515	949	2,064	0	0	186	3,457	47	59	12,040	0	7,929	15,357	4,443	6,680	0	0	391	11,793	167	203	46,963	0	27,580	43,062	7,591	42,320	0	0	1,382	37,938	5,688	5,532	171,093	148,250,527	284,581,919	49,721,775	114,685,877	0	0	13,125,799	173,570,206	2,408,744	2,940,385	789,285,232	80,945,817	166,789,516	18,728,074	104,113,067	0	0	4,801,347	196,462,819	8,866,683	8,640,906	589,348,229	3,896,291	198,524,138	407,745,972	54,869,105	202,492,692	0	0	0	12,536,756	315,312,596	0	10,992,291	0	0	0	3,948,836	1,210,318,677	55,570,495	0	0	80,157,418	135,727,913	30,672,206	99,195,958	13,580,742	16,306,251	0	0	5,390,390	134,877,847	283,136	3,736,167	304,042,697	1,705,470	295,985,538	4,859,540	4,963,252	0	0	35,828,803	41,801,352	14,152,586	113,267,486	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	20172	07/01/2016	06/30/2017	Open	Humboldt	01	0107	Church	Comparable	Rural	(707) 445-8121	3300 RENNER DRIVE	FORTUNA	95540	DAVID O'BRIEN, MD	35	25	25	528	35	67	359	0	0	8	237	0	44	1,278	0	2,677	206	188	1,023	0	0	30	561	0	166	4,851	0	15,758	814	1,266	13,375	0	0	1,046	11,161	0	3,259	46,679	33,077,002	2,711,552	3,336,042	15,872,292	0	0	366,133	12,672,275	0	1,277,135	69,312,431	43,071,682	2,469,092	4,632,187	35,508,352	0	0	4,145,553	30,946,431	0	4,931,262	125,704,559	2,507,709	59,393,813	4,090,428	3,417,459	42,562,293	0	0	0	1,510,459	25,648,391	0	2,667,494	0	0	0	2,785,103	144,583,149	0	0	0	0	0	16,415,463	1,090,216	4,335,814	8,612,732	0	0	2,970,071	17,495,870	0	(486,325)	50,433,841	727,000	42,506,000	0	5,729,000	0	0	0	0	2,106,000	11,812,000	0	0	0	0	0	0	0	0	0	0	0	3,231,014	6,478
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20172	07/01/2016	06/30/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,599	2,821	1,447	2,994	0	0	115	2,183	126	318	15,603	0	31,335	14,297	8,059	14,832	0	0	396	9,483	538	1,661	80,601	0	18,752	9,650	12,749	50,434	0	0	1,373	17,999	1,086	10,780	122,823	1,032,034,097	499,444,799	301,967,667	513,092,538	0	0	21,723,316	432,845,465	21,423,069	77,230,999	2,899,761,950	184,690,663	104,751,742	92,696,402	314,965,221	0	0	11,985,109	164,969,768	8,768,996	75,704,379	958,532,280	38,963,560	1,096,155,934	553,879,981	362,505,931	804,923,108	0	0	0	16,450,597	408,242,960	0	33,529,599	0	0	0	118,500,529	3,433,152,199	0	0	0	0	0	120,568,826	50,316,560	32,158,138	23,134,651	0	0	17,257,828	189,572,273	0	(7,866,245)	425,142,031	1,363,267	434,799,343	13,393,289	547,808	0	0	0	0	13,113,498	311,393,083	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20172	07/01/2016	06/30/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	314	53	195	9	0	0	0	1,055	68	57	1,751	0	6,167	899	3,236	236	0	0	0	12,328	1,357	631	24,854	0	1,826	186	0	0	0	0	0	14,594	0	1,220	17,826	24,190,624	994,685	11,317,808	819,342	0	0	0	48,584,709	10,106,955	5,238,982	101,253,105	1,709,166	27,654	0	0	0	0	0	13,512,282	0	287,686	15,536,788	1,163,218	12,958,145	389,060	10,068,480	616,078	0	0	0	0	22,070,861	0	0	0	10,106,955	(10,106,955)	5,273,924	52,539,766	0	0	0	0	0	12,667,022	616,650	1,223,967	204,303	0	0	0	39,183,488	10,106,955	247,742	64,250,127	120,568	73,287,617	0	3,022,036	0	0	0	0	1,030,585	8,783,876	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	20172	07/01/2016	06/30/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	630	0	0	0	0	0	630	0	0	0	0	0	5,062	0	0	0	0	0	5,062	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4,357,840	0	0	0	0	0	4,357,840	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,357,840	0	0	0	0	0	4,357,840	0	3,999,495	0	0	0	0	0	0	10,898	121,141	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF - PHF	20172	07/01/2016	06/30/2017	Open	Tehama	01	0211	Investor - Corp.	Psychiatric Health Facilities	None	(530) 567-7300	925 WALNUT STREET	RED BLUFF	96080	IFEANYI EZEANI	16	7	7	0	0	0	0	0	0	0	0	0	17	17	0	0	0	0	0	0	0	0	0	0	180	180	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	154,800	154,800	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	154,800	154,800	0	83,473	0	0	0	0	0	0	180,000	171,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106580996	RIDEOUT MEMORIAL HOSPITAL	20172	07/01/2016	06/30/2017	Open	Yuba	02	0227	Non Profit Corp.	Comparable	None	(530) 749-4663	726 FOURTH STREET	MARYSVILLE	95901	GINO PATRIZIO	219	219	152	5,103	85	888	2,961	1	0	1,931	0	35	117	11,121	0	27,426	495	4,702	12,788	9	0	7,341	0	169	588	53,518	0	49,495	778	5,420	31,265	3	0	29,049	0	0	4,378	120,388	368,224,469	7,003,545	52,418,523	172,071,037	88,966	0	100,851,858	0	3,572,666	12,358,120	716,589,184	229,932,843	3,612,259	25,181,018	145,246,006	11,982	0	134,953,379	0	0	20,334,135	559,271,622	13,199,447	476,197,515	9,192,261	44,897,369	253,954,959	(1,393,656)	86,024	0	120,136,630	0	0	3,572,666	0	0	0	0	919,843,215	0	0	0	0	0	121,959,796	1,423,542	34,095,826	63,362,084	14,924	0	102,469,162	0	3,572,666	29,119,591	356,017,591	6,346,375	391,196,785	46,038,672	10,916,338	0	0	0	0	23,611,112	357,844,989	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20172	07/01/2016	06/30/2017	Open	Kern	09	0621	Non Profit Corp.	Comparable	Rural	(760) 466-3551	1081 NORTH CHINA LAKE BOULEVARD.	RIDGECREST	93555	JAMES SUVER	150	150	92	822	0	522	130	0	0	577	24	13	99	2,187	0	6,944	0	1,300	391	0	0	1,497	51	40	214	10,437	0	26,885	0	19,577	3,918	0	0	31,477	1,141	1,278	4,173	88,449	36,833,053	0	27,221,652	2,452,805	0	0	21,662,948	687,703	75,797	2,046,496	90,980,454	55,659,234	0	44,516,139	5,014,850	0	0	63,155,658	2,049,665	172,092	2,707,131	173,274,769	459,723	62,933,015	0	41,343,680	9,134,461	0	0	0	31,304,869	0	0	795,592	(19,019)	0	0	940,332	146,892,653	0	0	0	0	0	29,559,272	0	30,394,108	(1,666,806)	0	0	53,513,736	2,737,367	(528,684)	3,353,577	117,362,570	89,870	112,562,190	0	1,329,986	0	0	0	0	6,000,305	85,249,656	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20172	07/01/2016	06/30/2017	Open	Riverside	12	1111	Investor - Ptnr.	Comparable	None	(951) 788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	PATRICK BRILLIANT	373	373	373	4,409	5,039	2,937	8,165	14	0	348	4,822	119	397	26,250	0	26,800	24,400	14,819	26,156	47	0	1,302	15,926	785	1,185	111,420	0	18,229	19,919	12,425	66,434	55	0	2,565	25,575	691	11,973	157,866	628,506,729	707,768,679	270,026,976	594,500,335	2,039,802	0	40,247,928	449,867,052	23,042,335	29,779,050	2,745,778,886	172,140,581	261,520,602	72,014,694	438,888,895	1,455,060	0	27,554,911	275,059,837	9,356,372	81,486,501	1,339,477,453	22,707,393	685,729,098	863,671,259	325,888,801	975,744,198	0	2,031,842	0	54,165,985	528,683,879	0	31,948,803	0	0	0	100,856,358	3,591,427,616	0	0	0	0	0	114,918,212	105,618,022	16,152,869	57,645,032	1,463,020	0	13,636,853	196,243,010	449,905	(12,298,200)	493,828,723	2,242,124	428,738,091	17,604,755	36,149,473	0	0	0	0	443,300,086	372,330,160	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20172	07/01/2016	06/30/2017	Open	Riverside	12	1109	City/County	Comparable	Teaching	(951) 486-4000	26520 CACTUS AVENUE	MORENO VALLEY	92555	ZAREH SARRAFIAN	439	439	439	1,896	1,502	2,685	5,258	130	0	4,401	475	10	537	16,894	0	14,862	9,538	14,505	23,575	647	0	29,940	2,113	65	2,334	97,579	0	11,350	5,321	39,068	86,450	4,887	0	24,041	3,643	55	9,763	184,578	156,287,813	123,361,218	183,404,312	306,975,849	7,246,833	0	221,701,160	38,244,497	786,730	25,055,183	1,063,063,595	35,101,005	22,228,876	96,061,807	174,992,239	13,153,571	0	64,183,991	12,376,687	230,781	21,788,885	440,117,842	45,752,680	141,630,265	109,279,351	219,479,926	314,590,076	(57,359,263)	19,852,483	0	208,129,627	19,367,681	0	1,017,511	0	0	0	0	1,021,740,337	0	0	0	0	0	49,758,553	36,310,743	117,345,456	167,378,012	547,921	0	77,755,524	31,253,503	0	1,091,388	481,441,100	21,053,142	548,775,905	0	65,364,079	0	0	0	0	41,125,493	203,021,949	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20172	07/01/2016	06/30/2017	Open	Los Angeles	11	0927	Non Profit Other	Comparable	Teaching	(310) 825-5041	757 WESTWOOD PLAZA	LOS ANGELES	90095	JOHNESE SPISSO	445	445	445	6,104	1,347	3,072	2,016	0	0	219	9,885	15	514	23,172	0	44,454	11,348	28,643	14,943	0	0	1,419	62,282	81	3,011	166,181	0	163,036	35,713	31,257	22,574	0	0	3,378	295,702	441	22,406	574,507	690,972,311	110,942,568	401,802,845	195,149,824	0	0	20,284,671	1,086,500,532	911,949	32,300,378	2,538,865,078	392,978,589	35,223,090	81,354,181	51,041,243	0	0	8,225,574	677,972,703	763,830	39,196,217	1,286,755,427	13,124,258	686,430,758	85,878,002	330,124,964	195,063,901	0	0	0	14,626,286	719,795,461	0	1,675,778	0	3,359,569	(3,359,569)	21,438,020	2,068,157,428	386,561	496,789	0	3,647,525	4,530,875	397,520,142	60,674,217	153,032,062	51,623,955	0	0	13,883,959	1,048,325,299	0	36,934,318	1,761,993,952	197,771,152	1,869,159,631	0	(17,320,576)	0	0	0	0	61,569,654	1,069,173,430	0	0	0	0	0	0	0	0	0	0	0	0	0