Table: 2018_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	2018R2	07/01/2017	06/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	349	56	0	6,106	4,836	418	0	1,143	7,446	48	260	20,313	54	252	0	44,455	9,783	5,281	0	5,370	36,075	245	2,072	103,533	12,141	689	0	58,183	154,887	22	0	15,072	95,432	90	9,056	333,431	4,381,204	0	779,548,467	131,406,642	18,536,217	0	95,498,040	599,837,751	3,772,654	7,483,810	1,640,464,785	3,434,791	0	177,586,871	289,810,268	6,445	0	45,625,085	332,330,267	223,098	10,933,002	859,949,827	14,037,333	6,499,148	0	629,509,368	387,997,916	(9,421,300)	12,303,095	0	99,230,215	565,136,826	0	3,995,753	0	0	0	12,041,698	1,721,330,052	0	20,076,216	0	58,336,127	78,412,343	1,316,847	0	337,047,268	53,295,210	6,239,566	0	41,892,911	423,963,583	0	(6,258,482)	857,496,903	76,582,527	757,567,367	0	42,003,456	0	0	0	0	62,386,738	492,765,456	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	2018R2	07/01/2017	06/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	140	1,803	3,691	937	1,993	0	0	135	3,423	45	50	12,077	0	8,449	16,012	4,506	6,633	0	0	360	11,957	115	132	48,164	0	29,881	46,983	7,735	39,075	0	0	1,119	39,790	6,215	5,450	176,248	164,798,983	315,627,670	54,775,336	121,608,571	0	0	10,729,748	187,913,186	1,735,420	2,017,694	859,206,608	91,531,627	183,198,489	20,052,574	101,277,118	0	0	5,431,577	210,157,691	9,356,410	8,193,016	629,198,502	2,805,041	221,787,648	449,912,300	59,918,402	197,664,932	0	0	0	11,941,706	341,334,572	0	10,759,073	0	0	0	3,592,967	1,299,716,641	63,364,095	0	0	84,874,108	148,238,203	34,542,962	112,277,954	14,909,508	25,220,757	0	0	4,219,619	141,610,413	332,757	3,812,702	336,926,672	2,216,994	326,047,730	5,018,787	13,919,572	0	0	29,693,291	63,047,712	18,083,602	121,638,716	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	2018R2	07/01/2017	06/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	559	26	89	407	0	0	11	232	0	47	1,371	0	2,962	199	213	1,162	0	0	30	727	0	160	5,453	0	16,540	841	970	13,455	0	0	899	10,936	0	2,908	46,549	42,046,982	2,705,151	3,469,325	18,962,683	0	0	1,425,863	10,677,656	0	1,837,187	81,124,847	51,655,768	2,565,004	3,387,184	38,133,029	0	0	4,479,883	30,158,961	0	5,445,735	135,825,564	1,582,467	73,714,620	4,083,682	(819,582)	49,287,105	0	0	0	3,352,682	23,573,139	0	4,092,632	0	0	0	2,442,721	161,309,466	0	0	0	0	0	19,443,015	1,186,473	7,545,426	7,519,610	0	0	2,507,742	16,825,738	0	612,941	55,640,945	378,000	44,411,896	0	6,427,000	0	0	0	0	1,799,000	12,436,000	0	0	0	0	0	0	0	0	0	0	100,683	6,918,995	23
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	2018R2	07/01/2017	06/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,280	2,636	1,448	2,781	0	0	305	1,865	111	374	14,800	0	31,832	14,901	8,855	15,197	0	0	1,653	7,454	488	1,557	81,937	0	17,784	9,352	11,980	47,943	0	0	2,337	15,218	1,058	11,539	117,211	1,127,426,778	582,608,307	336,283,810	590,399,546	0	0	67,263,590	389,951,351	20,505,323	61,630,920	3,176,069,625	207,652,348	120,179,308	93,888,438	332,586,759	0	0	25,174,642	159,520,477	13,047,419	85,796,933	1,037,846,324	3,885,773	1,213,982,253	648,563,728	396,008,803	903,053,092	0	0	0	58,363,542	413,300,591	0	33,552,742	0	0	0	151,371,948	3,822,082,472	0	0	0	0	0	121,096,873	54,223,887	34,163,445	19,933,213	0	0	34,074,690	136,171,237	0	(7,829,868)	391,833,477	1,434,901	437,397,358	14,247,858	490,158	0	0	0	0	3,318,304	294,068,745	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	2018R2	07/01/2017	06/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	301	40	190	0	0	0	0	1,099	89	73	1,792	0	5,731	873	3,101	0	0	0	0	11,867	1,506	1,152	24,230	0	1,336	263	0	0	0	0	0	15,702	0	2,667	19,968	21,927,108	915,492	10,766,592	0	0	0	0	49,419,581	10,106,955	5,727,364	98,863,092	1,541,765	51,280	0	0	0	0	0	15,047,762	0	182,079	16,822,886	1,435,458	11,968,625	378,693	9,090,452	0	0	0	0	0	22,665,642	0	5,689,574	0	10,106,955	(10,106,955)	(74,680)	51,153,764	0	0	0	0	0	11,214,725	557,302	1,637,096	0	0	0	0	40,728,292	10,106,955	287,844	64,532,214	129,096	72,032,528	0	3,197,698	0	0	0	0	3,071,562	10,050,472	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	2018R2	07/01/2017	06/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	504	0	0	0	0	0	504	0	0	0	0	0	5,005	0	0	0	0	0	5,005	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4,425,140	0	0	0	0	0	4,425,140	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,425,140	0	0	0	0	0	4,425,140	0	4,081,561	0	0	0	0	0	0	16,026	75,891	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF - PHF	2018R2	07/01/2017	06/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	580	580	0	0	0	0	0	0	0	0	0	0	4,398	4,398	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4,387,680	4,387,680	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	4,371,000	4,371,000	0	4,736,604	0	0	0	0	0	0	3,382	125,618	0	0	0	0	0	0	0	0	0	0	0	0	0
106580996	RIDEOUT MEMORIAL HOSPITAL	2018R2	07/01/2017	06/30/2018	Open	Yuba	02 - Golden Empire	0227	Non Profit Corp.	Comparable	None	530-749-4663	726 FOURTH STREET	MARYSVILLE	95901	RICK RAWSON	221	221	149	5,202	126	991	2,872	2	0	1,945	0	57	46	11,241	0	29,197	677	4,761	11,813	27	0	7,276	0	444	346	54,541	0	50,728	1,031	6,209	30,586	4	0	27,047	1	0	3,882	119,488	412,855,473	10,586,236	56,621,254	162,453,757	301,974	0	111,975,479	0	7,532,616	5,872,297	768,199,086	238,754,749	4,846,055	29,252,099	143,917,190	13,655	0	127,304,066	4,114	0	18,303,779	562,395,707	12,275,368	476,728,673	12,629,769	35,432,664	243,632,710	578,611	36,035	0	111,288,438	0	0	7,532,618	0	0	0	0	900,134,886	0	0	0	0	0	174,881,549	2,802,520	49,862,076	62,738,238	6,207	0	115,715,716	4,138	7,532,618	16,916,845	430,459,907	5,587,166	399,399,110	46,459,304	5,213,196	0	0	0	0	18,053,789	357,248,586	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	2018R2	07/01/2017	06/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	81	721	0	383	102	0	0	493	20	13	100	1,832	0	3,072	0	1,190	304	0	0	1,315	56	40	430	6,407	0	26,203	0	19,035	3,603	0	0	32,052	1,124	1,305	3,987	87,309	29,998,400	0	26,460,765	2,056,122	0	0	22,968,615	711,368	65,945	2,472,879	84,734,094	64,600,216	0	49,886,209	5,257,256	0	0	71,841,162	2,322,071	100,841	3,298,729	197,306,484	2,754,766	65,195,076	0	45,580,512	9,835,976	0	0	0	37,475,455	0	0	449,049	(11,447)	0	0	1,617,940	162,897,327	0	0	0	0	0	29,403,539	0	30,766,461	(2,522,598)	0	0	57,334,322	3,033,437	(270,813)	1,398,903	119,143,251	1,028,023	118,419,298	0	1,162,420	0	0	0	0	2,741,577	83,395,804	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	2018R2	07/01/2017	06/30/2018	Open	Riverside	12 - Inland Counties	1111	Investor - Ptnr.	Comparable	None	951-788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	PATRICK BRILLIANT	456	456	456	4,371	4,964	1,979	5,789	30	0	359	3,616	113	374	21,595	0	25,144	24,735	13,348	22,855	131	0	1,604	14,965	658	1,042	104,482	0	17,985	20,234	11,524	63,638	94	0	3,387	25,192	948	12,313	155,315	683,543,432	807,971,630	295,356,909	688,625,708	4,357,154	0	67,646,338	493,199,992	16,903,845	29,759,900	3,087,364,908	197,725,556	304,382,748	79,861,018	466,218,408	1,910,958	0	41,278,059	306,652,958	12,406,758	100,754,740	1,511,191,203	12,139,689	751,267,427	1,001,393,183	353,549,708	1,099,889,365	0	5,090,486	0	85,405,318	603,219,008	0	20,660,526	0	0	0	126,993,254	4,059,607,964	0	0	0	0	0	130,001,561	110,961,195	21,668,219	54,954,751	1,177,627	0	23,519,077	196,633,942	11,969,791	(11,938,016)	538,948,147	1,808,236	437,426,133	22,627,039	38,356,808	0	0	0	0	60,241,388	401,616,882	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	2018R2	07/01/2017	06/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,998	1,733	3,450	5,523	125	0	4,087	641	24	492	18,073	0	15,679	10,591	19,976	23,927	602	0	29,967	2,688	132	1,976	105,538	0	11,841	7,417	44,958	90,201	1,646	0	23,777	4,987	2,714	9,308	196,849	151,351,074	125,704,860	221,407,357	306,439,395	7,557,360	0	207,628,554	45,749,324	1,306,950	18,542,400	1,085,687,274	38,523,787	28,237,898	110,450,877	197,287,345	5,906,216	0	60,906,620	17,273,522	5,743,736	20,879,176	485,209,177	36,236,056	131,504,675	105,327,387	234,070,817	313,660,464	(57,472,363)	13,463,576	0	173,936,385	26,413,747	0	7,050,686	0	0	0	0	984,191,430	0	0	0	0	0	58,370,185	48,615,371	155,259,780	190,066,277	0	0	94,598,789	36,609,099	0	3,185,520	586,705,021	20,053,888	582,070,347	0	61,506,234	0	0	0	0	21,584,271	196,155,144	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	2018R2	07/01/2017	06/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	454	454	6,403	1,470	2,930	2,130	0	0	207	9,593	32	432	23,197	0	46,833	11,579	27,559	16,723	0	0	1,514	58,915	177	2,310	165,610	0	166,628	32,234	29,429	22,989	0	0	3,076	288,619	908	24,725	568,608	737,959,113	86,173,296	389,803,789	216,065,521	0	0	24,140,046	1,067,426,196	2,046,602	26,707,618	2,550,322,181	422,933,727	17,636,360	74,937,968	54,807,362	0	0	8,514,685	720,575,062	1,578,142	44,433,267	1,345,416,573	24,835,749	771,397,191	56,695,599	304,896,401	212,361,201	0	0	0	17,816,419	691,549,210	0	3,624,744	0	3,359,569	(3,359,569)	23,876,359	2,107,052,873	0	0	0	0	0	389,495,649	47,114,057	159,845,356	58,511,682	0	0	14,838,312	1,096,452,048	0	22,428,777	1,788,685,881	187,932,411	1,892,867,887	0	24,025,385	0	0	0	0	77,308,406	1,030,835,418	0	0	0	0	0	0	0	0	0	0	0	0	0