Table: 2018_quarter_3_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	20183	10/01/2017	09/30/2018	Open	San Diego	14 - San Diego/Imperial	1416	Non Profit Corp.	Comparable	Teaching	858-576-1700	3020 CHILDREN'S WAY	SAN DIEGO	92123	DONALD KEARNS, MD	524	444	338	55	0	5,999	4,932	442	0	1,187	7,481	52	174	20,322	57	228	0	44,637	10,058	5,607	0	6,060	35,227	269	1,375	103,461	12,215	680	0	57,062	155,347	21	0	15,621	96,384	76	8,715	333,906	4,610,460	0	782,890,708	140,393,435	19,753,635	0	105,376,457	584,689,475	4,164,955	4,736,345	1,646,615,470	3,658,537	0	178,563,575	293,194,413	6,845	0	45,872,773	338,110,223	188,186	10,086,869	869,681,421	14,612,212	6,902,669	0	617,601,151	401,441,379	(9,707,117)	13,677,341	0	105,568,930	550,951,362	0	4,353,141	0	0	0	9,039,817	1,714,440,885	0	17,757,209	0	58,733,777	76,490,986	1,366,328	0	353,560,246	49,903,679	6,083,139	0	45,680,300	429,120,890	0	(7,367,590)	878,346,992	76,834,384	772,806,232	0	39,957,968	0	0	0	0	61,929,635	493,726,461	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	20183	10/01/2017	09/30/2018	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	139	1,844	3,864	942	1,955	0	0	147	3,515	50	54	12,371	0	8,504	16,562	4,567	6,421	0	0	334	12,195	135	149	48,867	0	31,233	47,681	7,831	38,722	0	0	1,097	39,113	5,838	5,459	176,974	167,494,908	329,113,291	55,184,514	119,372,685	0	0	11,893,739	194,990,995	1,869,469	2,074,833	881,994,434	93,297,144	189,043,308	20,488,039	101,308,115	0	0	6,218,010	215,395,005	9,559,963	8,938,553	644,248,137	3,549,375	225,707,052	467,292,597	61,371,632	187,211,329	0	0	0	13,478,323	352,149,282	0	11,086,549	0	0	0	4,356,132	1,326,202,271	64,269,880	0	0	82,127,137	146,397,017	35,085,000	115,133,882	14,300,921	33,469,471	0	0	4,633,426	140,363,855	342,883	3,107,879	346,437,317	2,294,838	319,022,927	5,533,843	17,973,880	0	0	31,983,696	37,632,650	22,192,024	126,881,655	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	20183	10/01/2017	09/30/2018	Open	Humboldt	01 - Northern California	0107	Church	Comparable	Rural	707-445-8121	3300 RENNER DRIVE	FORTUNA	95540	ROBERTA LUSKIN-HAWK, MD	35	25	25	538	30	84	367	0	0	8	219	0	43	1,289	0	3,016	179	207	1,049	0	0	25	710	0	141	5,327	0	16,881	875	896	13,153	0	0	907	10,988	0	2,862	46,562	41,683,205	2,229,517	3,532,905	17,563,927	0	0	1,314,726	10,532,325	0	2,071,563	78,928,168	54,131,015	2,579,379	3,400,902	39,384,875	0	0	4,691,324	31,564,240	0	5,306,330	141,058,065	2,242,951	75,026,223	3,695,083	(469,756)	49,095,584	0	0	0	2,973,493	24,422,928	0	4,504,700	0	0	0	2,573,029	164,064,235	0	0	0	0	0	20,227,646	1,113,813	7,339,941	7,550,668	0	0	2,999,101	17,186,813	0	(495,984)	55,921,998	440,000	44,361,896	0	5,196,000	0	0	0	0	1,757,000	12,546,000	0	0	0	0	0	0	0	0	0	0	100,683	8,104,487	23
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20183	10/01/2017	09/30/2018	Open	Santa Clara	07 - Santa Clara	0431	Investor - Corp.	Comparable	None	408-259-5000	225 NORTH JACKSON AVENUE	SAN JOSE	95116	MICHAEL CARTER	264	264	264	5,135	2,724	1,483	2,777	0	0	342	1,869	99	383	14,812	0	30,477	15,391	8,736	15,036	0	0	1,796	7,308	456	1,309	80,509	0	17,387	9,444	11,560	46,780	0	0	2,666	14,583	1,032	11,429	114,881	1,123,094,573	621,189,012	340,683,343	593,898,991	0	0	84,607,541	383,472,102	18,796,253	59,350,111	3,225,091,926	214,377,895	127,114,846	93,885,188	338,781,423	0	0	31,783,470	158,630,493	11,907,479	88,866,428	1,065,347,222	3,244,660	1,223,685,202	691,504,102	398,718,160	905,794,092	0	0	0	75,154,887	415,510,950	0	30,703,732	0	0	0	158,511,180	3,902,826,965	0	0	0	0	0	113,787,266	56,799,756	35,850,371	26,886,322	0	0	41,236,124	126,591,645	0	(13,539,301)	387,612,183	1,446,100	441,744,209	15,892,942	479,902	0	0	0	0	4,603,812	291,211,259	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20183	10/01/2017	09/30/2018	Open	Los Angeles	11 - Los Angeles	0927	Non Profit Other	Comparable	None	310-267-9315	150 MEDICAL PLAZA	LOS ANGELES	90095	JOHN MAZZIOTTA	74	74	74	307	41	185	0	0	0	0	1,169	86	58	1,846	0	5,748	927	3,000	0	0	0	0	12,783	1,442	871	24,771	0	1,373	273	0	0	0	0	0	16,011	0	2,499	20,156	23,940,500	926,411	11,307,529	0	0	0	0	55,821,717	10,086,921	5,877,158	107,960,236	1,645,662	52,345	0	0	0	0	0	15,715,334	0	284,904	17,698,245	2,587,243	14,004,875	433,259	9,549,274	0	0	0	0	0	28,038,638	0	5,648,195	0	10,086,921	(10,086,921)	164,107	60,425,591	0	0	0	0	0	11,069,117	504,977	1,673,851	0	0	0	0	41,561,851	10,086,921	336,173	65,232,890	154,869	73,045,810	0	3,206,569	0	0	0	0	2,425,212	9,909,439	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	20183	10/01/2017	09/30/2018	Open	Shasta	01 - Northern California	0209	Investor - Corp.	Psychiatric Health Facilities	None	530-262-6700	2750 EUREKA WAY	REDDING	96001	O. NWANGBURUKA	16	16	16	0	0	0	0	494	0	0	0	0	0	494	0	0	0	0	0	4,884	0	0	0	0	0	4,884	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4,342,120	0	0	0	0	0	4,342,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,342,120	0	0	0	0	0	4,342,120	0	4,106,125	0	0	0	0	0	0	40,802	83,186	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF - PHF	20183	10/01/2017	09/30/2018	Open	Tehama	01 - Northern California	0211	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	0	663	663	0	0	0	0	0	0	0	0	0	0	4,649	4,649	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4,759,920	4,759,920	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	4,759,920	4,759,920	0	4,894,032	0	0	0	0	0	0	7,372	117,546	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20183	10/01/2017	09/30/2018	Open	Kern	09 - Central	0621	Non Profit Corp.	Comparable	Rural	760-466-3551	1081 NORTH CHINA LAKE BOULEVARD	RIDGECREST	93555	JAMES SUVER	150	150	83	726	0	373	100	0	0	480	22	16	98	1,815	0	2,999	0	1,140	300	0	0	1,277	64	58	431	6,269	0	25,821	0	18,486	3,654	0	0	31,571	1,094	1,241	4,050	85,917	28,749,115	0	26,184,972	2,241,914	0	0	22,788,402	774,891	63,178	2,870,099	83,672,571	65,515,437	0	48,693,078	5,279,447	0	0	70,719,597	2,271,271	72,102	2,812,792	195,363,724	3,130,007	65,656,727	0	42,518,606	9,684,071	0	0	0	36,489,039	0	0	363,099	(15,729)	0	0	1,663,015	159,488,835	0	0	0	0	0	28,607,824	0	32,359,444	(2,162,711)	0	0	57,018,960	3,046,160	(212,087)	889,870	119,547,460	933,548	118,626,033	0	1,192,068	0	0	0	0	2,610,452	83,346,360	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20183	10/01/2017	09/30/2018	Open	Riverside	12 - Inland Counties	1111	Investor - Ptnr.	Comparable	None	951-788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	PATRICK BRILLIANT	478	478	478	4,554	5,019	2,344	6,747	33	0	444	4,095	103	388	23,727	0	26,419	26,237	14,102	24,119	158	0	1,881	16,142	498	1,165	110,721	0	17,739	20,267	11,155	62,876	109	0	3,614	25,667	893	12,559	154,879	716,613,711	867,795,364	306,407,765	711,813,191	5,377,207	0	79,900,128	519,466,072	15,804,343	30,660,739	3,253,838,520	199,165,371	313,088,104	79,489,348	473,500,626	2,260,025	0	45,966,395	314,896,991	10,798,883	106,643,344	1,545,809,087	1,369,072	775,772,445	1,065,417,823	364,195,938	1,135,943,955	0	9,078,157	0	100,371,823	627,988,010	0	17,548,084	0	0	0	139,628,555	4,237,313,862	0	0	0	0	0	140,006,637	115,465,645	21,701,175	49,369,862	(1,440,924)	0	25,494,697	206,375,053	12,374,856	(7,013,256)	562,333,745	1,923,733	430,701,160	23,034,859	40,173,516	0	0	0	0	69,503,087	410,272,412	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20183	10/01/2017	09/30/2018	Open	Riverside	12 - Inland Counties	1109	City/County	Comparable	Teaching	951-486-4000	26520 CACTUS AVENUE	MORENO VALLEY	92555	ZAREH SARRAFIAN	439	439	439	1,978	1,731	3,553	5,602	147	0	4,001	629	17	402	18,060	0	16,515	10,897	20,869	23,557	644	0	30,536	2,561	96	1,667	107,342	0	12,270	7,459	45,835	89,481	1,997	0	23,368	4,712	2,096	9,575	196,793	158,448,896	128,591,735	221,789,897	294,003,308	7,989,213	0	217,398,344	43,541,632	1,039,840	19,563,752	1,092,366,617	39,585,436	28,313,024	117,512,289	202,000,559	7,856,727	0	61,660,840	15,850,320	4,208,832	20,971,984	497,960,011	37,336,786	139,945,253	108,556,263	235,204,079	301,427,511	(60,686,478)	15,845,940	0	182,020,868	24,548,176	0	5,248,672	0	0	0	0	989,447,070	0	0	0	0	0	58,089,078	48,348,496	164,784,585	194,576,357	0	0	97,038,316	34,843,776	0	3,198,950	600,879,558	21,370,147	579,314,101	0	56,622,239	0	0	0	0	21,711,371	208,124,808	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20183	10/01/2017	09/30/2018	Open	Los Angeles	11 - Los Angeles	0927	Non Profit Other	Comparable	Teaching	310-825-5041	757 WESTWOOD PLAZA	LOS ANGELES	90095	JOHNESE SPISSO	445	445	450	6,455	1,514	2,915	2,150	0	0	212	9,556	32	391	23,225	0	47,089	11,965	27,072	16,786	0	0	1,477	58,880	191	2,264	165,724	0	166,879	32,986	29,503	22,974	0	0	3,145	290,411	646	25,478	572,022	806,088,161	85,409,989	412,766,938	234,139,919	0	0	24,799,206	1,171,266,849	2,330,425	28,181,613	2,764,983,100	450,756,860	18,693,914	81,271,629	57,951,083	0	0	8,701,606	776,591,709	1,295,592	52,089,336	1,447,351,729	24,326,563	857,889,387	60,949,094	339,988,930	236,077,097	0	0	0	19,384,851	835,631,942	0	3,626,017	0	3,352,891	(3,352,891)	27,930,414	2,405,804,295	0	0	0	0	0	398,955,634	43,154,809	154,049,637	56,013,905	0	0	14,115,961	1,112,226,616	0	28,013,972	1,806,530,534	191,626,193	1,914,900,743	0	23,178,199	0	0	0	0	84,896,671	1,022,443,360	0	0	0	0	0	0	0	0	0	0	0	0	0