Table: 2017_quarter_4_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	20174	01/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	62	0	6,210	4,789	534	0	1,056	7,575	55	288	20,569	50	334	0	42,820	10,129	4,877	0	4,507	36,476	267	2,033	101,443	12,164	723	0	60,499	155,430	45	0	15,001	93,765	131	9,044	334,638	5,021,436	0	740,400,829	121,216,724	13,620,604	0	85,335,018	597,275,628	3,949,929	5,749,007	1,572,569,175	3,357,478	0	168,228,740	281,802,028	8,173	0	44,424,119	324,171,967	311,390	11,396,229	833,700,124	9,695,841	6,572,145	0	618,747,463	365,085,295	(9,000,172)	7,332,636	0	90,585,470	588,804,276	0	4,261,319	0	0	0	7,674,812	1,689,759,085	0	23,535,785	0	53,553,581	77,089,366	1,806,769	0	298,882,277	61,469,242	6,296,140	0	39,173,666	385,227,315	0	744,171	793,599,580	76,299,537	713,056,117	0	51,862,852	0	0	0	0	58,882,022	495,055,554	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	20174	01/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	1,664	3,669	963	2,015	0	0	163	3,409	43	48	11,974	0	7,688	15,764	4,118	7,117	0	0	425	11,953	132	149	47,346	0	27,734	45,255	7,660	41,687	0	0	1,203	40,059	6,032	5,517	175,147	147,526,813	305,949,684	49,387,122	125,090,133	0	0	11,943,455	182,568,949	2,628,844	2,951,316	828,046,316	88,236,943	175,005,903	19,327,075	105,442,217	0	0	4,866,304	205,171,380	8,842,775	8,061,163	614,953,760	2,923,094	204,955,815	433,814,884	54,395,702	203,715,078	0	0	0	12,139,774	331,709,841	0	11,127,470	0	0	0	3,715,710	1,258,497,368	59,353,763	0	0	81,918,660	141,272,423	30,807,941	106,494,466	14,318,493	26,817,272	0	0	4,669,985	137,949,148	344,149	4,373,677	325,775,131	2,225,238	310,264,490	4,689,507	6,065,135	0	0	30,753,018	51,929,239	15,860,663	116,639,348	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	20174	01/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	546	31	72	389	0	0	7	272	0	43	1,360	0	2,818	223	199	1,092	0	0	17	661	0	154	5,164	0	16,186	792	1,134	13,746	0	0	894	10,933	0	2,940	46,625	37,580,675	3,145,100	3,155,508	17,644,846	0	0	712,672	12,865,465	0	1,722,609	76,826,875	47,576,716	2,545,807	4,055,335	36,355,908	0	0	4,057,860	29,186,656	0	4,726,102	128,504,384	1,806,957	66,642,984	4,677,526	546,524	45,131,518	0	0	0	2,319,731	24,746,036	0	3,041,549	0	0	0	2,516,636	151,429,461	0	0	0	0	0	18,116,489	1,013,381	6,416,602	8,756,389	0	0	2,398,777	16,865,491	0	334,669	53,901,798	579,000	44,310,000	0	8,863,000	0	0	0	0	2,611,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	01/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	5,703	2,690	1,519	2,863	0	0	103	2,111	124	382	15,495	0	33,035	13,993	9,205	14,659	0	0	461	9,107	483	1,794	82,737	0	18,767	9,666	12,549	50,909	0	0	1,547	16,933	1,077	11,142	122,590	1,112,791,091	517,166,793	342,523,542	548,132,012	0	0	22,987,654	438,807,165	20,446,147	75,666,801	3,078,521,205	193,295,605	111,457,217	91,893,612	330,085,162	0	0	12,618,187	164,516,600	12,219,056	78,361,863	994,447,302	26,908,637	1,181,710,465	581,589,265	400,303,470	854,621,856	0	0	0	19,489,744	434,685,206	0	32,665,203	0	0	0	138,464,489	3,670,438,335	0	0	0	0	0	124,376,231	47,034,745	34,113,684	23,595,318	0	0	16,116,097	168,638,559	0	(11,344,462)	402,530,172	1,384,867	436,009,105	13,227,360	444,289	0	0	0	0	9,943,065	303,250,545	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20174	01/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	276	38	201	6	0	0	0	1,053	73	73	1,720	0	5,544	643	3,153	169	0	0	0	12,262	1,430	995	24,196	0	1,479	183	0	0	0	0	0	14,774	0	2,275	18,711	20,586,393	1,056,022	11,111,269	588,519	0	0	0	48,995,826	11,837,025	5,292,358	99,467,412	1,571,592	44,508	0	0	0	0	0	14,327,844	0	286,809	16,230,753	1,302,581	10,799,176	429,243	9,611,781	462,276	0	0	0	0	21,954,878	0	0	0	11,837,025	(11,837,025)	5,349,143	49,909,078	0	0	0	0	0	11,095,495	645,124	1,465,760	124,255	0	0	0	40,395,488	11,837,025	225,940	65,789,087	183,540	73,014,271	0	3,321,143	0	0	0	0	2,055,567	9,222,475	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	20174	01/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	557	0	0	0	0	0	557	0	0	0	0	0	5,148	0	0	0	0	0	5,148	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4,478,440	0	0	0	0	0	4,478,440	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,478,440	0	0	0	0	0	4,478,440	0	4,019,856	0	0	0	0	0	0	3,900	94,827	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF - PHF	20174	01/01/2017	12/31/2017	Open	Tehama	01	0211	Investor - Corp.	Psychiatric Health Facilities	None	530-567-7300	925 WALNUT STREET	RED BLUFF	96080	CARL WOMACK	16	16	20	0	0	0	0	0	0	0	0	0	277	277	0	0	0	0	0	0	0	0	0	0	2,350	2,350	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2,200,840	2,200,840	0	0	0	0	0	0	0	0	0	0	0	16,680	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	16,680	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2,184,160	2,184,160	0	2,665,002	0	0	0	0	0	0	180,000	144,442	0	0	0	0	0	0	0	0	0	0	0	0	0
106580996	RIDEOUT MEMORIAL HOSPITAL	20174	01/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	5,037	112	911	2,885	2	0	1,848	0	63	73	10,931	0	27,662	582	5,000	12,424	11	0	7,013	0	366	465	53,523	0	50,149	984	5,977	29,924	4	0	28,065	1	0	4,156	119,260	376,779,632	8,772,686	53,487,996	164,363,571	117,553	0	98,909,989	0	7,603,719	9,937,389	719,972,535	236,681,212	4,618,008	28,154,806	141,489,872	16,228	0	132,599,592	4,114	0	19,646,941	563,210,773	10,585,431	490,921,911	11,569,696	43,819,883	243,687,141	586,009	111,837	0	116,688,879	0	0	7,603,721	0	0	0	0	925,574,508	0	0	0	0	0	122,538,931	1,820,998	37,236,907	62,166,302	21,944	0	104,235,272	4,114	7,603,721	21,980,611	357,608,800	6,537,501	393,878,084	45,664,748	12,567,425	0	0	0	0	7,973,396	349,100,229	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20174	01/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	729	0	381	100	0	0	527	19	10	83	1,849	0	3,608	0	1,245	320	0	0	1,481	53	29	272	7,008	0	27,088	0	19,502	3,620	0	0	31,862	1,143	1,229	3,998	88,442	32,199,366	0	26,754,883	2,205,940	0	0	22,767,382	668,428	82,613	2,043,708	86,722,320	59,629,354	0	48,210,797	5,088,533	0	0	68,879,525	2,137,696	204,345	3,207,940	187,358,190	2,696,490	63,345,339	0	43,434,966	9,698,654	0	0	0	35,180,526	0	0	697,883	(14,087)	0	0	1,234,461	156,274,232	0	0	0	0	0	28,483,381	0	31,530,713	(2,404,181)	0	0	56,466,380	2,806,121	(396,837)	1,320,701	117,806,278	306,864	116,380,633	0	1,400,181	0	0	0	0	3,856,312	84,876,778	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20174	01/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	4,470	4,874	2,265	6,433	21	0	289	4,044	135	276	22,807	0	26,885	23,341	13,619	23,341	75	0	1,290	15,218	744	761	105,274	0	18,444	20,100	11,901	66,310	73	0	2,690	25,631	913	11,649	157,711	673,975,950	729,692,106	281,323,783	631,155,988	2,578,235	0	41,109,950	478,367,500	20,627,429	16,077,379	2,874,908,320	190,146,987	279,628,249	74,905,064	461,348,470	943,117	0	28,735,266	294,816,894	9,486,774	91,243,446	1,431,254,267	17,757,670	740,589,087	904,995,196	335,859,204	1,034,441,913	0	2,323,174	0	54,587,207	578,285,952	0	27,280,985	0	0	0	96,145,714	3,792,266,102	0	0	0	0	0	123,533,850	104,325,159	20,369,643	58,062,545	1,198,178	0	15,258,009	194,898,442	6,152,932	(9,902,273)	513,896,485	1,976,131	452,219,750	20,140,936	35,438,010	0	0	0	0	75,625,163	397,412,261	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20174	01/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	1,854	1,599	2,961	5,293	130	0	4,295	627	0	681	17,440	0	13,171	9,471	16,348	23,492	534	0	30,051	2,980	0	2,976	99,023	0	11,594	6,902	42,236	88,486	2,954	0	23,186	4,898	0	10,086	190,342	140,772,828	117,709,961	191,290,561	302,423,384	6,607,307	0	202,192,006	49,002,902	0	29,124,961	1,039,123,910	38,070,892	27,109,750	104,384,848	186,237,435	9,031,565	0	62,172,350	16,665,683	0	23,185,066	466,857,589	51,403,388	135,258,491	108,422,775	232,983,606	333,129,163	(53,878,201)	15,638,872	0	190,486,800	27,566,226	0	0	0	0	0	0	1,041,011,120	0	0	0	0	0	43,585,229	36,396,936	116,570,004	155,531,656	0	0	73,877,556	38,102,359	0	906,639	464,970,379	20,906,118	550,806,679	0	68,068,898	0	0	0	0	26,840,427	198,910,569	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20174	01/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	6,101	1,339	2,968	2,113	0	0	213	9,675	18	516	22,943	0	43,939	10,942	29,258	15,376	0	0	1,582	60,179	94	2,774	164,144	0	164,795	32,365	30,642	22,798	0	0	3,258	286,938	816	23,595	565,207	681,993,432	91,838,098	415,414,769	200,472,301	0	0	23,192,336	1,071,337,101	1,043,026	28,333,684	2,513,624,747	408,449,297	18,523,614	75,226,715	54,132,193	0	0	8,450,969	700,259,620	1,385,299	41,118,628	1,307,546,335	16,590,106	715,695,170	57,456,952	346,340,206	197,104,425	0	0	0	16,322,056	711,730,691	0	2,428,325	0	3,182,923	(3,182,923)	22,649,286	2,086,317,217	0	0	0	0	0	374,747,559	52,904,760	144,301,278	57,500,069	0	0	15,321,249	1,059,866,030	0	30,212,920	1,734,853,865	188,358,536	1,836,384,934	0	32,124,027	0	0	0	0	71,156,772	1,058,521,596	0	0	0	0	0	0	0	0	0	0	0	0	0