Table: 2018_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	2018R1	04/01/2017	03/31/2018	Open	San Diego	14	1416	Non Profit Corp.	Comparable	Rural	858-576-1700	3020 CHILDREN'S WAY	SAN DIEGO	92123	DONALD KEARNS, MD	524	444	369	62	0	6,103	4,859	489	0	1,076	7,573	61	256	20,479	55	302	0	43,634	10,157	4,975	0	4,899	35,807	303	2,066	102,143	12,231	729	0	59,626	157,051	30	0	14,979	94,800	94	9,424	336,733	4,757,896	0	761,699,462	127,476,454	16,547,079	0	87,094,400	595,822,269	4,620,134	5,400,449	1,603,418,143	3,305,136	0	175,110,859	290,379,546	7,495	0	44,650,232	331,230,003	232,309	11,861,194	856,776,774	11,919,106	6,730,840	0	633,697,517	378,920,296	(8,334,421)	10,171,087	0	92,312,400	585,025,941	0	4,852,444	0	0	0	8,639,722	1,723,934,932	0	21,951,277	0	57,034,733	78,986,010	1,332,192	0	311,447,224	60,886,980	6,383,486	0	39,432,233	397,869,151	0	(2,105,271)	815,245,995	77,225,972	716,905,841	0	47,028,667	0	0	0	0	62,697,730	496,699,845	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	2018R1	04/01/2017	03/31/2018	Open	San Bernardino	12	1209	Non Profit Corp.	Comparable	None	909-335-5501	350 TERRACINA BOULEVARD	REDLANDS	92373	JAMES R. HOLMES	229	197	142	1,712	3,722	980	1,985	0	0	143	3,391	40	46	12,019	0	8,161	16,173	4,512	6,803	0	0	402	12,019	124	141	48,335	0	28,447	46,431	7,938	40,803	0	0	1,102	40,264	6,284	5,631	176,900	159,059,104	315,361,189	54,113,117	122,199,763	0	0	10,979,246	185,048,774	2,355,310	2,662,319	851,778,822	91,615,738	180,313,152	20,212,005	104,063,496	0	0	4,870,759	206,450,805	9,333,084	8,349,727	625,208,766	3,165,952	218,181,357	447,167,330	59,306,884	200,490,961	0	0	0	11,450,845	334,784,801	0	11,337,742	0	0	0	3,568,943	1,289,454,815	61,291,460	0	0	83,118,663	144,410,123	32,493,485	109,798,471	15,018,237	25,772,298	0	0	4,399,160	139,833,441	350,652	4,277,152	331,942,896	2,680,868	319,229,535	4,880,736	8,543,709	0	0	30,759,366	57,552,379	15,917,407	119,699,283	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	2018R1	04/01/2017	03/31/2018	Open	Humboldt	01	0107	Church	Comparable	Teaching	707-445-8121	3300 RENNER DRIVE	FORTUNA	95540	ROBERTA LUSKIN-HAWK, MD	35	25	25	562	27	81	393	0	0	9	251	0	46	1,369	0	2,811	202	215	1,109	0	0	24	785	0	162	5,308	0	16,326	798	1,055	13,662	0	0	865	11,054	0	2,924	46,684	38,757,202	2,794,440	3,199,235	16,721,183	0	0	1,089,426	11,996,146	0	1,835,449	76,393,081	49,342,506	2,676,373	3,614,624	35,994,019	0	0	4,196,744	29,050,550	0	4,981,853	129,856,669	1,426,708	67,983,504	4,300,702	424,601	43,852,162	0	0	0	3,074,644	24,054,309	0	3,588,399	0	0	0	2,107,821	150,812,850	0	0	0	0	0	19,634,277	1,170,111	6,167,922	8,522,262	0	0	2,157,928	16,583,960	0	1,200,440	55,436,900	609,000	44,657,000	0	6,750,000	0	0	0	0	2,661,000	12,260,000	0	0	0	0	0	0	0	0	0	0	27,787	5,699,088	23
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	2018R1	04/01/2017	03/31/2018	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,491	2,672	1,503	2,814	0	0	205	1,942	103	382	15,112	0	32,579	14,572	9,262	15,272	0	0	997	8,053	440	1,625	82,800	0	18,371	9,562	12,433	50,602	0	0	2,008	16,260	1,163	11,508	121,907	1,115,525,242	558,989,881	352,342,551	588,094,337	0	0	45,143,231	401,261,662	19,704,003	67,535,589	3,148,596,496	200,996,176	114,536,832	93,653,243	332,660,582	0	0	19,272,791	163,397,072	12,155,780	84,051,480	1,020,723,956	11,621,310	1,191,318,147	620,500,950	409,836,171	895,165,350	0	0	0	40,079,819	414,441,782	0	31,859,783	0	0	0	149,007,801	3,763,831,113	0	0	0	0	0	125,203,271	53,025,763	36,159,623	25,589,569	0	0	24,336,203	150,216,952	0	(9,042,042)	405,489,339	1,261,754	436,343,452	13,488,614	491,000	0	0	0	0	9,105,159	298,916,262	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	2018R1	04/01/2017	03/31/2018	Open	Los Angeles	11	0927	Non Profit Other	Comparable	None	310-267-9315	150 MEDICAL PLAZA	LOS ANGELES	90095	JOHN MAZZIOTTA	74	74	74	290	42	198	3	0	0	0	1,049	82	78	1,742	0	5,650	722	2,999	63	0	0	0	11,729	1,692	1,210	24,065	0	1,385	202	0	0	0	0	0	15,100	0	2,687	19,374	21,766,959	822,225	10,562,165	215,881	0	0	0	48,525,293	12,648,635	6,188,615	100,729,773	1,495,558	42,588	0	0	0	0	0	14,652,180	0	221,891	16,412,217	1,072,252	11,664,661	331,116	8,939,761	168,820	0	0	0	0	21,565,942	0	4,455,588	0	12,648,635	(12,648,635)	1,725,845	49,923,985	0	0	0	0	0	11,380,535	512,463	1,592,583	46,813	0	0	0	40,810,593	12,648,635	226,383	67,218,005	183,857	72,564,389	0	3,286,088	0	0	0	0	2,879,320	9,264,753	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	2018R1	04/01/2017	03/31/2018	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	513	0	0	0	0	0	513	0	0	0	0	0	5,069	0	0	0	0	0	5,069	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4,436,420	0	0	0	0	0	4,436,420	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,436,420	0	0	0	0	0	4,436,420	0	4,004,509	0	0	0	0	0	0	6,360	79,806	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF - PHF	2018R1	04/01/2017	03/31/2018	Open	Tehama	01	0211	Investor - Corp.	Comparable	None	530-567-7300	925 WALNUT STREET	RED BLUFF	96080	CARL WOMACK	16	16	16	0	0	0	0	0	0	0	0	0	435	435	0	0	0	0	0	0	0	0	0	0	3,315	3,315	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3,290,440	3,290,440	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	3,273,760	3,273,760	0	3,703,273	0	0	0	0	0	0	180,000	129,431	0	0	0	0	0	0	0	0	0	0	0	0	0
106580996	RIDEOUT MEMORIAL HOSPITAL	2018R1	04/01/2017	03/31/2018	Open	Yuba	02	0227	Non Profit Corp.	Comparable	None	530-749-4663	726 FOURTH ST	MARYSVILLE	95901	RICK RAWSON	221	221	164	5,143	122	933	2,856	2	0	1,912	0	68	62	11,098	0	29,089	685	4,559	12,419	11	0	7,226	0	413	379	54,781	0	49,289	990	6,251	29,352	6	0	26,890	1	0	3,959	116,738	403,183,582	10,086,041	51,418,454	165,783,806	117,553	0	105,516,267	0	8,280,555	8,371,526	752,757,784	237,138,167	4,744,032	30,005,227	141,364,944	24,567	0	129,432,705	4,114	0	19,079,794	561,793,550	10,823,932	510,435,352	12,508,183	17,735,461	248,355,021	586,009	111,837	0	117,339,547	0	0	8,280,557	0	0	0	0	926,175,899	0	0	0	0	0	129,886,397	2,321,889	63,102,207	58,793,729	30,283	0	106,785,495	4,114	8,280,557	19,170,764	388,375,435	6,235,193	403,924,820	45,878,924	6,194,022	0	0	0	0	1,817,561	344,604,769	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	2018R1	04/01/2017	03/31/2018	Open	Kern	09	0621	Non Profit Corp.	Comparable	Teaching	760-466-3551	1081 NORTH CHINA LAKE BOULEVARD.	RIDGECREST	93555	JAMES SUVER	150	150	84	727	0	388	105	0	0	503	24	10	100	1,857	0	3,194	0	1,228	314	0	0	1,380	72	24	383	6,595	0	26,758	0	19,462	3,528	0	0	32,364	1,156	1,421	4,028	88,717	31,183,530	0	26,929,273	2,035,548	0	0	23,386,789	778,883	77,300	2,071,130	86,462,453	61,823,068	0	49,648,839	5,031,991	0	0	72,005,821	2,284,652	158,707	3,550,117	194,503,195	2,309,777	65,002,488	0	46,268,845	9,191,300	0	0	0	36,767,515	0	0	582,512	(11,220)	0	0	1,462,856	161,574,073	0	0	0	0	0	28,004,110	0	30,309,266	(2,123,761)	0	0	58,625,095	3,063,532	(335,284)	1,848,617	119,391,575	705,243	118,217,676	0	1,214,078	0	0	0	0	3,759,083	83,842,577	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	2018R1	04/01/2017	03/31/2018	Open	Riverside	12	1111	Investor - Ptnr.	Comparable	None	951-788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	PATRICK BRILLIANT	456	456	456	4,352	4,881	2,090	6,145	26	0	318	3,833	129	325	22,099	0	25,411	23,720	13,148	23,379	111	0	1,436	14,976	657	1,121	103,959	0	18,049	20,267	11,687	65,669	78	0	2,935	25,128	988	12,097	156,898	669,300,806	762,035,335	283,448,589	660,746,020	3,362,876	0	53,764,279	483,575,680	19,629,304	25,429,330	2,961,292,219	196,552,881	292,401,857	76,258,178	468,536,470	1,573,089	0	33,073,055	297,411,021	11,127,733	99,821,640	1,476,755,924	14,719,214	739,632,315	946,692,836	341,264,647	1,070,222,519	0	3,900,128	0	68,364,051	582,811,478	0	25,694,155	0	0	0	119,072,773	3,912,374,116	0	0	0	0	0	126,221,372	107,744,356	18,442,120	59,059,971	1,035,837	0	18,473,282	198,175,223	8,382,596	(11,860,730)	525,674,027	1,865,979	459,097,175	21,645,985	36,815,840	0	0	0	0	69,483,735	399,473,302	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	2018R1	04/01/2017	03/31/2018	Open	Riverside	12	1109	City/County	Comparable	Rural	951-486-4000	26520 CACTUS AVENUE	MORENO VALLEY	92555	ZAREH SARRAFIAN	439	439	439	1,961	1,648	3,175	5,470	114	0	4,030	621	22	647	17,688	0	14,775	9,853	17,956	24,048	509	0	29,041	2,616	112	3,045	101,955	0	11,693	7,222	43,063	89,523	1,595	0	23,286	4,964	2,487	9,778	193,611	147,155,818	119,706,648	205,885,095	307,751,725	6,375,036	0	200,897,387	43,714,527	1,120,596	30,049,138	1,062,655,970	38,305,613	27,936,513	107,148,561	193,436,574	5,121,834	0	61,797,720	17,090,109	5,516,392	22,753,482	479,106,798	52,009,908	140,415,320	110,897,378	245,896,023	342,932,159	(56,159,671)	11,496,870	0	188,673,970	26,914,105	0	6,636,988	0	0	0	0	1,069,713,050	0	0	0	0	0	45,046,110	36,745,783	123,297,304	158,256,141	0	0	74,021,137	33,890,531	0	792,712	472,049,718	24,049,669	552,224,223	0	64,741,000	0	0	0	0	29,326,040	194,163,536	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	2018R1	04/01/2017	03/31/2018	Open	Los Angeles	11	0927	Non Profit Other	Comparable	Rural	310-825-5041	757 WESTWOOD PLAZA	LOS ANGELES	90095	JOHNESE SPISSO	445	468	468	6,214	1,337	2,924	2,143	0	0	207	9,667	29	508	23,029	0	45,495	10,641	28,444	16,549	0	0	1,552	59,835	147	2,591	165,254	0	166,207	32,393	30,174	22,958	0	0	3,153	286,820	818	23,843	566,366	708,842,894	87,740,450	405,412,443	216,945,020	0	0	23,274,243	1,070,943,211	1,546,991	26,690,691	2,541,395,943	416,907,579	17,333,081	74,071,460	53,742,478	0	0	8,517,789	706,791,314	1,434,871	43,624,807	1,322,423,379	24,124,899	750,451,853	53,526,805	347,041,922	212,905,306	0	0	0	16,256,945	688,053,432	0	2,981,862	0	3,076,792	(3,076,792)	23,031,072	2,118,374,096	0	0	0	0	0	375,298,620	51,546,726	132,441,981	57,782,192	0	0	15,535,087	1,089,681,093	0	23,159,527	1,745,445,226	179,408,629	1,818,540,008	0	22,767,347	0	0	0	0	80,240,798	1,037,485,885	0	0	0	0	0	0	0	0	0	0	0	0	0