Table: 2018_quarter_1_complete_data_set_7_13_18 , 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	20181	01/01/2018	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	22	0	1,651	1,334	99	0	309	1,941	23	48	5,427	12	54	0	12,084	2,782	1,505	0	1,582	8,562	115	472	27,156	3,035	140	0	14,983	42,357	12	0	4,102	24,932	26	2,708	89,260	1,279,724	0	205,715,569	37,497,040	4,847,581	0	25,454,086	138,185,544	1,749,923	921,037	415,650,504	845,694	0	48,566,432	78,048,444	4,145	0	11,299,969	84,916,468	62,985	3,236,370	226,980,507	3,284,286	2,355,622	0	177,554,913	106,171,603	(2,047,500)	3,228,828	0	24,997,703	128,551,657	0	1,812,908	0	0	0	2,830,311	448,740,331	0	5,155,365	0	16,475,098	21,630,463	(230,204)	0	78,774,588	14,529,246	1,622,898	0	11,756,353	110,697,022	0	(1,628,760)	215,521,143	18,842,480	181,780,260	0	29,684,936	0	0	0	0	14,713,343	496,699,845	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	20181	01/01/2018	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	506	992	249	456	0	0	35	834	8	10	3,090	0	2,441	4,500	1,319	1,477	0	0	78	2,908	18	20	12,761	0	7,879	11,951	2,222	10,053	0	0	255	9,771	1,601	1,496	45,228	48,350,877	88,198,581	16,238,429	28,812,573	0	0	3,178,823	46,634,913	29,322	32,546	231,476,064	25,019,095	47,229,494	5,664,841	25,549,164	0	0	1,444,694	51,611,031	2,408,546	2,251,988	161,178,853	824,378	63,918,087	122,620,177	18,961,558	51,104,030	0	0	0	3,460,566	84,503,687	0	2,364,732	0	0	0	898,997	348,656,212	15,623,863	0	0	21,827,663	37,451,526	9,451,885	28,431,761	2,941,712	3,257,707	0	0	1,162,951	35,569,920	73,136	561,159	81,450,231	860,631	82,452,026	1,343,003	3,001,891	0	0	8,230,416	15,974,645	4,272,177	119,699,283	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	20181	01/01/2018	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	158	10	18	95	0	0	2	49	0	12	344	0	847	61	54	257	0	0	7	247	0	37	1,510	0	4,140	223	211	3,382	0	0	218	2,795	0	717	11,686	11,411,632	656,814	929,892	4,010,333	0	0	376,754	2,411,699	0	329,888	20,127,012	13,152,213	712,721	669,255	9,187,210	0	0	1,083,355	7,464,710	0	1,345,104	33,614,568	(38,995)	19,959,341	967,385	1,519,785	11,223,763	0	0	0	767,650	5,823,214	0	1,240,341	0	0	0	403,619	41,866,103	0	0	0	0	0	4,424,214	402,150	79,362	1,716,079	0	0	686,264	3,962,571	0	604,837	11,875,477	92,000	10,859,000	0	93,000	0	0	0	0	187,000	12,260,000	0	0	0	0	0	0	0	0	0	0	27,787	538,019	0
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20181	01/01/2018	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	1,374	744	363	716	0	0	115	393	17	74	3,796	0	8,389	4,419	2,440	4,260	0	0	606	1,454	94	213	21,875	0	4,660	2,406	3,182	12,821	0	0	794	3,683	286	2,900	30,732	295,703,403	177,613,634	96,363,037	167,140,053	0	0	26,121,560	73,147,760	4,377,861	10,372,139	850,839,447	54,435,753	29,930,936	24,613,094	80,753,623	0	0	9,583,580	36,263,042	1,836,824	21,243,584	258,660,436	(7,562,519)	315,130,167	188,773,308	109,667,088	239,882,739	0	0	0	23,973,423	87,831,698	0	6,214,685	0	0	0	41,276,705	1,005,187,294	0	0	0	0	0	35,008,989	18,771,262	11,309,043	8,010,937	0	0	11,731,717	21,579,104	0	(2,098,463)	104,312,589	324,222	112,620,488	3,390,178	153,406	0	0	0	0	1,676,359	298,916,262	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20181	01/01/2018	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	79	18	40	0	0	0	0	289	25	15	466	0	1,491	333	728	0	0	0	0	2,893	541	339	6,325	0	309	77	0	0	0	0	0	4,006	0	775	5,167	5,924,317	183,563	2,525,963	0	0	0	0	12,608,241	2,404,109	1,939,734	25,585,927	321,819	1,840	0	0	0	0	0	3,695,596	0	46,482	4,065,737	75,162	3,180,435	71,463	2,130,629	0	0	0	0	0	5,673,426	0	1,735,076	0	2,404,109	(2,404,109)	168,981	13,035,172	0	0	0	0	0	3,049,573	113,341	393,254	0	0	0	0	10,574,488	2,404,109	81,727	16,616,492	15,790	18,083,768	0	882,462	0	0	0	0	912,255	9,264,753	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	20181	01/01/2018	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	121	0	0	0	0	0	121	0	0	0	0	0	1,187	0	0	0	0	0	1,187	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,044,560	0	0	0	0	0	1,044,560	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	1,044,560	0	0	0	0	0	1,044,560	0	990,998	0	0	0	0	0	0	2,460	79,806	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF - PHF	20181	01/01/2018	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	158	158	0	0	0	0	0	0	0	0	0	0	965	965	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,089,600	1,089,600	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	1,089,600	1,089,600	0	1,038,271	0	0	0	0	0	0	0	129,431	0	0	0	0	0	0	0	0	0	0	0	0	0
106580996	RIDEOUT MEMORIAL HOSPITAL	20181	01/01/2018	03/31/2018	Open	Yuba	02	0227	Non Profit Corp.	Comparable	None	530-749-4663	726 FOURTH STREET	MARYSVILLE	95901	RICK RAWSON	221	221	164	1,380	35	242	699	0	0	503	0	16	9	2,884	0	8,240	222	1,035	3,039	0	0	1,990	0	104	57	14,687	0	10,984	191	1,434	6,711	2	0	5,741	0	0	903	25,966	115,774,099	2,795,099	12,287,228	42,689,107	0	0	30,536,879	0	1,743,642	927,799	206,753,853	56,847,833	1,001,313	7,393,376	34,651,776	8,339	0	29,781,503	0	0	4,663,995	134,348,135	2,490,498	137,030,139	3,090,228	(12,988,805)	62,884,463	0	0	0	30,758,558	0	0	1,743,642	0	0	0	0	225,008,723	0	0	0	0	0	35,591,794	706,183	32,669,408	14,456,420	8,339	0	27,069,327	0	1,743,642	3,848,152	116,093,265	1,485,311	108,546,685	12,387,933	238,878	0	0	0	0	0	344,604,769	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20181	01/01/2018	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	203	0	98	30	0	0	117	7	3	31	489	0	955	0	294	75	0	0	356	23	10	143	1,856	0	6,777	0	4,955	909	0	0	8,483	283	658	1,048	23,113	8,885,427	0	6,372,786	417,922	0	0	6,391,011	222,020	39,486	498,021	22,826,673	17,102,494	0	12,571,454	1,370,155	0	0	18,778,957	616,455	17,104	1,000,855	51,457,474	430,272	17,933,323	0	12,331,539	2,054,953	0	0	0	9,620,708	0	0	87,958	(7,594)	0	0	456,848	42,908,007	0	0	0	0	0	8,054,598	0	6,612,701	(266,876)	0	0	15,549,260	838,475	(23,774)	611,756	31,376,140	250,218	30,097,935	0	342,762	0	0	0	0	973,308	83,842,577	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20181	01/01/2018	03/31/2018	Open	Riverside	12	1111	Investor - Ptnr.	Comparable	None	951-788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	PATRICK BRILLIANT	456	456	456	1,063	1,306	583	1,655	8	0	120	940	27	78	5,780	0	6,181	7,020	3,220	6,142	52	0	506	3,790	96	405	27,412	0	4,390	5,253	2,913	16,506	24	0	917	6,093	177	3,371	39,644	177,400,358	233,313,056	69,786,583	179,531,563	1,355,545	0	24,334,857	121,782,009	4,575,397	10,509,399	822,588,767	51,742,590	80,196,787	19,977,962	119,339,915	891,825	0	11,141,306	73,717,321	3,254,211	26,522,673	386,784,590	0	195,080,466	282,291,623	86,844,189	284,609,048	0	2,185,889	0	28,338,453	143,848,369	0	4,775,114	0	0	0	42,149,113	1,070,122,264	0	0	0	0	0	34,062,482	31,218,220	2,920,356	14,262,430	61,481	0	7,137,709	51,650,961	3,054,494	(5,117,040)	139,251,093	447,279	116,651,504	5,566,570	9,661,233	0	0	0	0	5,798,007	399,473,302	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20181	01/01/2018	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	567	479	899	1,436	28	0	983	170	5	70	4,637	0	5,021	3,059	5,028	6,152	115	0	7,651	701	9	454	28,190	0	3,067	1,811	12,228	23,117	363	0	5,944	1,264	550	2,251	50,595	45,446,401	36,825,574	57,316,258	75,892,313	1,550,249	0	55,714,130	10,035,336	101,233	5,118,843	288,000,337	9,452,133	6,668,614	29,299,779	49,416,236	1,223,635	0	15,464,072	3,961,257	1,622,637	4,592,984	121,701,347	9,627,861	40,885,279	33,001,899	67,848,650	83,417,423	(15,975,854)	2,773,884	0	51,183,677	6,564,147	0	1,723,870	0	0	0	0	281,050,836	0	0	0	0	0	14,013,255	10,492,289	34,743,241	41,891,126	0	0	19,994,525	7,432,446	0	83,966	128,650,848	6,597,112	147,834,530	0	14,314,074	0	0	0	0	7,510,485	194,163,536	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20181	01/01/2018	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	1,660	338	737	531	0	0	46	2,429	12	120	5,873	0	12,183	2,405	7,234	4,419	0	0	282	14,893	62	631	42,109	0	42,069	8,043	7,391	5,873	0	0	762	72,127	134	5,945	142,344	196,334,429	18,054,233	103,042,767	57,594,435	0	0	4,380,896	273,334,126	591,708	6,035,306	659,367,900	109,040,599	4,153,313	18,538,526	13,896,887	0	0	1,935,061	176,836,275	273,002	12,120,387	336,794,050	10,625,131	204,731,192	11,189,433	85,907,659	58,113,401	0	0	0	3,199,008	159,817,903	0	864,710	0	801,369	(801,369)	6,380,231	540,828,668	0	0	0	0	0	100,643,836	11,018,113	35,673,634	13,377,921	0	0	3,116,949	290,352,498	0	1,150,331	455,333,282	47,633,896	475,740,155	0	542,358	0	0	0	0	20,430,751	1,037,485,885	0	0	0	0	0	0	0	0	0	0	0	0	0