Table: 2017_quarter_2_complete_data_set_11_02_17 , 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	20172	04/01/2017	06/30/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	333	13	0	1,435	1,127	177	0	261	1,931	29	58	5,031	14	52	0	9,695	2,387	1,266	0	1,152	9,368	140	479	24,539	3,032	182	0	15,442	40,317	8	0	3,996	24,375	20	2,263	86,603	619,645	0	165,338,020	27,329,362	2,874,519	0	22,133,000	159,014,299	2,128,871	1,365,088	380,802,804	882,172	0	41,493,251	71,930,646	1,050	0	10,811,586	83,575,362	48,383	2,830,223	211,572,673	4,244,885	1,153,799	0	170,244,490	85,669,297	(2,195,738)	1,180,221	0	23,278,545	158,379,580	0	2,177,254	0	0	0	871,923	445,004,256	0	4,098,077	0	3,744,193	7,842,270	348,018	0	38,782,519	17,688,788	1,695,348	0	9,666,041	87,529,785	0	(497,008)	155,213,491	21,007,297	157,232,043	0	35,732,049	0	0	0	0	13,748,339	483,202,895	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	20172	04/01/2017	06/30/2017	Open	San Bernardino	12	1209	Non Profit Corp.	Comparable	None	(909) 335-5501	350 TERRACINA BOULEVARD	REDLANDS	92373	JAMES R. HOLMES	229	229	195	422	981	239	477	0	0	48	835	9	10	3,021	0	1,954	4,222	1,027	1,654	0	0	138	3,030	47	51	12,123	0	6,704	11,392	2,190	10,755	0	0	261	10,125	1,340	1,371	44,138	38,610,695	80,945,756	12,412,604	29,106,915	0	0	3,862,728	44,847,625	900,629	956,202	211,643,154	21,688,833	44,353,694	5,546,495	27,375,864	0	0	976,214	52,128,325	2,015,864	2,063,351	156,148,640	1,068,561	52,929,459	113,079,828	15,401,646	52,372,681	0	0	0	3,219,752	82,950,701	0	2,828,999	0	0	0	836,479	324,688,106	13,496,053	0	0	20,012,500	33,508,553	7,370,069	25,715,675	2,557,452	4,110,098	0	0	1,619,190	34,037,749	87,494	1,114,514	76,612,241	520,792	75,602,002	1,261,614	1,298,502	0	0	8,500,218	11,338,118	3,617,718	113,267,486	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	20172	04/01/2017	06/30/2017	Open	Humboldt	01	0107	Church	Comparable	Rural	(707) 445-8121	3300 RENNER DRIVE	FORTUNA	95540	DAVID O'BRIEN, MD	35	25	25	145	4	19	93	0	0	0	74	0	9	344	0	646	18	60	260	0	0	0	201	0	28	1,213	0	4,061	189	307	3,530	0	0	201	2,933	0	766	11,987	8,014,753	362,148	766,106	3,649,745	0	0	0	3,832,586	0	548,411	17,173,749	12,129,541	690,990	1,165,683	8,475,206	0	0	955,706	8,010,969	0	795,290	32,223,385	131,000	14,133,794	893,719	1,505,189	8,876,584	0	0	0	455,030	7,681,338	0	643,603	0	0	0	423,174	34,743,431	0	0	0	0	0	5,926,944	159,419	335,929	3,178,467	0	0	492,400	4,067,353	0	493,191	14,653,703	388,000	11,385,000	0	1,403,000	0	0	0	0	1,325,000	11,812,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20172	04/01/2017	06/30/2017	Open	Santa Clara	07	0431	Investor - Corp.	Comparable	None	(408) 259-5000	225 NORTH JACKSON AVENUE	SAN JOSE	95116	MICHAEL JOHNSON	264	264	264	1,453	686	393	695	0	0	32	511	30	97	3,897	0	8,210	3,351	2,375	3,437	0	0	97	2,194	127	467	20,258	0	4,933	2,481	3,299	13,469	0	0	397	4,437	306	2,777	32,099	271,299,628	121,491,441	87,379,389	128,220,951	0	0	6,120,568	106,192,163	6,858,960	24,163,734	751,726,834	48,262,944	26,495,429	23,661,469	83,639,006	0	0	3,413,513	41,877,042	2,110,082	20,355,048	249,814,533	14,569,643	288,778,003	135,869,964	102,422,953	204,919,166	0	0	0	6,293,806	96,893,108	0	8,969,042	0	0	0	32,509,577	891,225,262	0	0	0	0	0	30,784,569	12,116,906	8,617,905	6,940,791	0	0	3,240,275	51,176,097	0	(2,560,438)	110,316,105	312,006	110,238,990	3,293,620	61,363	0	0	0	0	6,818,280	311,393,083	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20172	04/01/2017	06/30/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	78	9	55	3	0	0	0	271	14	19	449	0	1,319	111	709	63	0	0	0	3,064	361	179	5,806	0	387	50	0	0	0	0	0	4,031	0	360	4,828	5,077,320	109,731	2,532,553	215,881	0	0	0	11,938,047	5,329,458	1,292,356	26,495,346	406,980	3,629	0	0	0	0	0	3,734,265	0	80,412	4,225,286	73,024	2,712,138	39,425	2,238,318	168,820	0	0	0	0	5,064,341	0	0	0	5,329,458	(5,329,458)	1,295,428	11,591,494	0	0	0	0	0	2,757,570	69,936	292,686	46,813	0	0	0	10,555,742	5,329,458	76,933	19,129,138	66,289	18,218,408	0	859,411	0	0	0	0	919,238	8,783,876	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	20172	04/01/2017	06/30/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	122	0	0	0	0	0	122	0	0	0	0	0	1,325	0	0	0	0	0	1,325	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,142,080	0	0	0	0	0	1,142,080	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,142,080	0	0	0	0	0	1,142,080	0	984,132	0	0	0	0	0	0	3,900	121,141	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF - PHF	20172	04/01/2017	06/30/2017	Open	Tehama	01	0211	Investor - Corp.	Comparable	None	(530) 567-7300	925 WALNUT STREET	RED BLUFF	96080	IFEANYI EZEANI	16	7	7	0	0	0	0	0	0	0	0	0	17	17	0	0	0	0	0	0	0	0	0	0	180	180	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	154,800	154,800	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	154,800	154,800	0	83,473	0	0	0	0	0	0	180,000	171,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106580996	RIDEOUT MEMORIAL HOSPITAL	20172	04/01/2017	06/30/2017	Open	Yuba	02	0227	Non Profit Corp.	Comparable	None	(530) 749-4663	726 FOURTH STREET	MARYSVILLE	95901	GINO PATRIZIO	219	219	152	1,287	25	233	683	1	0	481	0	12	25	2,747	0	7,123	121	1,163	3,337	9	0	1,826	0	64	150	13,793	0	11,908	259	1,541	7,016	3	0	6,917	0	0	934	28,578	94,298,937	1,542,765	12,983,234	42,480,126	88,966	0	23,374,299	0	1,536,504	3,930,454	180,235,285	58,143,865	1,242,091	7,450,185	34,413,649	11,982	0	33,796,338	0	0	4,596,477	139,654,587	1,941,519	122,978,920	2,370,223	12,018,477	62,564,568	0	86,024	0	27,141,110	0	0	1,536,504	0	0	0	0	230,637,345	0	0	0	0	0	29,463,882	414,633	8,414,940	14,329,207	14,924	0	28,088,009	0	1,536,504	6,990,428	89,252,527	1,465,416	100,516,659	11,612,028	1,214,711	0	0	0	0	1,173,783	357,844,989	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20172	04/01/2017	06/30/2017	Open	Kern	09	0621	Non Profit Corp.	Comparable	Rural	(760) 466-3551	1081 NORTH CHINA LAKE BOULEVARD.	RIDGECREST	93555	JAMES SUVER	150	150	92	176	0	95	26	0	0	119	6	2	25	449	0	812	0	306	81	0	0	339	20	3	73	1,634	0	6,845	0	4,818	868	0	0	8,061	294	302	1,044	22,232	8,538,498	0	6,948,862	547,244	0	0	6,257,786	200,870	25,947	425,109	22,944,316	14,432,175	0	11,849,999	1,204,121	0	0	17,533,672	561,184	64,016	810,029	46,455,196	316,194	16,887,597	0	11,998,958	2,081,542	0	0	0	8,934,700	0	0	187,022	(3,626)	0	0	261,375	40,663,762	0	0	0	0	0	6,083,076	0	6,799,903	(330,177)	0	0	14,856,758	762,053	(93,434)	657,571	28,735,750	144,257	29,043,306	0	315,470	0	0	0	0	1,149,380	85,249,656	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20172	04/01/2017	06/30/2017	Open	Riverside	12	1111	Investor - Ptnr.	Comparable	None	(951) 788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	PATRICK BRILLIANT	373	373	373	1,141	1,260	679	2,045	8	0	87	1,248	21	84	6,573	0	6,937	5,866	3,104	6,906	25	0	312	4,134	78	324	27,686	0	4,616	5,084	3,068	16,892	11	0	617	6,399	95	2,755	39,537	168,097,073	178,766,023	63,788,631	160,563,460	796,201	0	9,625,466	122,851,756	4,112,790	2,870,641	711,472,041	47,741,126	69,713,703	18,653,203	116,097,572	90,549	0	7,732,035	72,302,718	864,803	23,150,900	356,346,609	2,579,525	182,397,699	222,609,255	78,218,575	263,952,070	0	506,592	0	14,022,027	140,731,400	0	10,492,549	0	0	0	23,427,522	938,937,214	0	0	0	0	0	33,440,500	25,870,471	4,223,259	12,708,962	380,158	0	3,335,474	54,423,074	(5,514,956)	14,494	128,881,436	528,236	113,650,890	4,748,009	8,732,296	0	0	0	0	18,098,668	372,330,160	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20172	04/01/2017	06/30/2017	Open	Riverside	12	1109	City/County	Comparable	Teaching	(951) 486-4000	26520 CACTUS AVENUE	MORENO VALLEY	92555	ZAREH SARRAFIAN	439	439	439	482	359	631	1,347	28	0	1,000	140	0	273	4,260	0	2,996	1,889	2,944	5,837	92	0	6,379	581	0	1,398	22,116	0	2,965	1,666	10,089	22,291	512	0	5,643	1,224	0	2,786	47,176	33,072,572	24,894,447	39,007,035	75,408,903	1,412,114	0	45,066,246	9,647,636	0	14,782,996	243,291,949	10,217,101	6,993,462	27,381,565	48,265,512	1,434,962	0	17,134,624	4,367,437	0	7,453,103	123,247,766	21,718,036	32,034,932	23,934,939	52,138,574	80,724,730	(13,625,985)	2,847,076	0	45,442,265	5,362,171	0	0	0	0	0	0	250,576,738	0	0	0	0	0	11,254,741	7,952,970	27,876,011	42,949,685	0	0	16,758,605	8,652,902	0	518,063	115,962,977	5,847,146	120,130,816	0	16,030,608	0	0	0	0	14,577,204	203,021,949	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20172	04/01/2017	06/30/2017	Open	Los Angeles	11	0927	Non Profit Other	Comparable	Teaching	(310) 825-5041	757 WESTWOOD PLAZA	LOS ANGELES	90095	JOHNESE SPISSO	445	445	445	1,470	329	744	538	0	0	54	2,438	4	146	5,723	0	10,658	2,642	7,116	4,217	0	0	357	15,097	21	786	40,894	0	42,334	8,639	8,022	5,970	0	0	917	73,692	114	5,718	145,406	161,898,384	22,170,671	102,853,778	59,438,031	0	0	4,995,541	272,543,310	177,200	6,644,758	630,721,673	104,335,193	4,244,464	19,506,287	12,816,081	0	0	2,472,376	178,801,741	217,700	10,877,586	333,271,428	434,913	173,948,562	13,936,028	87,093,259	57,175,282	0	0	0	3,917,537	196,319,416	0	394,900	0	637,069	(637,069)	5,394,528	538,614,425	0	0	0	0	0	92,285,015	12,479,107	35,266,806	15,078,830	0	0	3,550,380	255,025,635	0	11,692,903	425,378,676	45,379,427	413,020,988	0	3,967,201	0	0	0	0	21,282,377	1,069,173,430	0	0	0	0	0	0	0	0	0	0	0	0	0