Table: 2017_quarter_3_complete_data_set_1_12_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	20173	07/01/2017	09/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	338	12	0	1,428	1,094	104	0	268	1,826	8	86	4,826	15	111	0	10,852	2,266	1,039	0	1,082	9,074	40	697	25,161	3,115	175	0	14,902	35,394	10	0	3,398	22,556	27	2,165	78,627	1,259,683	0	197,773,266	27,636,956	3,736,017	0	21,081,257	155,345,072	632,303	2,747,465	410,212,019	627,581	0	41,803,835	69,390,213	2,300	0	11,307,029	82,015,719	70,274	3,229,459	208,446,410	2,566,204	1,515,117	0	182,329,237	87,427,686	(2,043,686)	2,159,417	0	23,399,398	155,732,884	0	702,578	0	0	0	3,527,934	457,316,769	0	6,971,655	0	13,298,295	20,269,950	372,147	0	59,291,550	16,571,138	1,578,899	0	8,988,888	94,669,581	0	139,407	181,611,610	18,884,461	171,785,574	0	(1,302,631)	0	0	0	0	13,232,830	489,884,872	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	20173	07/01/2017	09/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	382	807	248	526	0	0	25	853	10	13	2,864	0	1,857	3,360	1,145	1,763	0	0	117	3,023	27	35	11,327	0	6,557	11,378	1,923	10,062	0	0	319	10,252	1,789	1,311	43,591	34,388,986	64,920,447	13,107,708	30,501,121	0	0	1,735,261	45,370,791	884,437	1,073,229	191,981,980	20,782,017	42,164,295	4,828,915	25,288,116	0	0	1,143,307	49,485,525	2,193,020	1,495,255	147,380,450	776,481	47,609,577	96,260,374	10,780,722	41,803,249	0	0	0	2,150,226	79,732,676	0	2,985,132	0	0	0	94,880	282,193,317	17,740,149	0	0	20,639,705	38,379,854	7,561,426	28,564,517	7,155,901	13,985,988	0	0	728,342	35,763,345	92,325	1,697,123	95,548,967	869,671	79,992,777	922,624	1,782,930	0	0	5,831,911	13,948,922	4,276,750	115,219,116	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	20173	07/01/2017	09/30/2017	Open	Humboldt	01	0107	Church	Comparable	Rural	(707) 445-8121	3300 RENNER DRIVE	FORTUNA	95540	DAVID O'BRIEN, MD	35	25	25	143	0	19	117	0	0	4	71	0	12	366	0	604	39	46	344	0	0	9	209	0	47	1,298	0	4,069	221	277	3,358	0	0	237	2,649	0	762	11,573	9,850,309	833,984	672,491	4,877,716	0	0	343,991	3,342,554	0	321,917	20,242,962	12,400,025	773,049	939,252	8,978,670	0	0	1,079,291	6,957,308	0	1,393,088	32,520,683	511,168	18,441,640	1,356,346	1,210,080	12,212,264	0	0	0	1,120,968	5,574,021	0	752,891	0	0	0	410,176	41,589,554	0	0	0	0	0	3,674,997	250,687	280,443	1,639,283	0	0	290,448	4,648,896	0	389,337	11,174,091	54,000	10,679,000	0	2,770,000	0	0	0	0	429,000	11,938,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20173	07/01/2017	09/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,342	571	371	699	0	0	29	524	43	109	3,688	0	7,946	2,913	2,131	3,631	0	0	137	2,332	170	460	19,720	0	4,400	2,331	3,025	11,695	0	0	391	4,173	295	2,960	29,270	258,849,183	107,459,946	77,061,785	140,288,112	0	0	5,742,742	112,418,151	6,289,030	14,658,999	722,767,948	48,709,231	28,142,679	23,325,933	80,028,392	0	0	2,603,278	42,462,111	4,538,218	21,340,971	251,150,813	5,237,212	278,909,832	124,940,535	92,263,577	214,665,520	0	0	0	5,034,242	108,607,010	0	10,827,248	0	0	0	33,447,320	873,932,496	0	0	0	0	0	28,648,582	10,662,090	8,124,141	5,650,984	0	0	3,311,778	46,273,252	0	(2,684,562)	99,986,265	313,170	106,851,514	3,390,879	86,454	0	0	0	0	493,545	308,935,571	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20173	07/01/2017	09/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	74	6	52	0	0	0	0	213	27	18	390	0	1,433	139	858	0	0	0	0	2,460	403	331	5,624	0	360	35	0	0	0	0	0	3,699	0	615	4,709	5,501,332	151,596	3,010,537	0	0	0	0	10,376,429	2,457,534	1,513,794	23,011,222	430,986	3,930	0	0	0	0	0	3,631,729	0	63,386	4,130,031	(93,994)	3,035,013	50,085	2,490,512	0	0	0	0	0	4,173,725	0	0	0	2,457,534	(2,457,534)	1,537,103	11,192,444	0	0	0	0	0	2,917,632	106,181	523,673	0	0	0	0	9,903,431	2,457,534	40,358	15,948,809	11,554	17,960,319	0	761,596	0	0	0	0	699,841	9,069,888	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	20173	07/01/2017	09/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	141	0	0	0	0	0	141	0	0	0	0	0	1,275	0	0	0	0	0	1,275	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,121,620	0	0	0	0	0	1,121,620	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,121,620	0	0	0	0	0	1,121,620	0	962,556	0	0	0	0	0	0	0	113,284	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD - RED BLUFF - PHF	20173	07/01/2017	09/30/2017	Open	Tehama	01	0211	Investor - Corp.	Psychiatric Health Facilities	None	(530) 567-7300	925 WALNUT STREET	RED BLUFF	96080	IFEANYI EZEANI	16	16	12	0	0	0	0	0	0	0	0	0	90	90	0	0	0	0	0	0	0	0	0	0	972	972	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	878,920	878,920	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	862,240	862,240	0	888,306	0	0	0	0	0	0	0	162,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106580996	RIDEOUT MEMORIAL HOSPITAL	20173	07/01/2017	09/30/2017	Open	Yuba	02	0227	Non Profit Corp.	Comparable	None	(530) 749-4663	726 FOURTH STREET	MARYSVILLE	95901	GINO PATRIZIO	219	219	143	1,277	31	233	726	0	0	473	0	10	25	2,775	0	6,860	155	1,172	3,019	0	0	1,653	0	61	148	13,068	0	13,790	223	1,710	7,858	0	0	7,290	1	0	1,055	31,927	95,614,434	2,248,147	13,021,463	39,240,671	0	0	25,338,633	0	984,793	2,372,802	178,820,943	64,654,206	1,047,387	8,019,005	36,842,325	0	0	34,177,054	4,114	0	4,946,791	149,690,882	5,083,762	126,717,146	2,710,537	14,307,204	59,987,603	586,009	0	0	28,785,672	0	0	984,794	0	0	0	0	239,162,727	0	0	0	0	0	33,551,494	584,997	6,147,255	16,095,393	0	0	25,646,252	4,114	984,794	6,334,799	89,349,098	1,500,276	96,208,931	10,556,811	1,031,137	0	0	0	0	643,778	353,396,129	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20173	07/01/2017	09/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	90	171	0	103	25	0	0	137	4	1	23	464	0	743	0	364	80	0	0	343	8	2	66	1,606	0	6,627	0	4,919	866	0	0	7,880	281	257	949	21,779	7,419,352	0	7,312,736	530,618	0	0	5,312,552	167,124	3,822	501,860	21,248,064	15,204,768	0	12,896,927	1,259,859	0	0	18,153,493	484,244	37,453	1,238,109	49,274,853	399,826	15,037,257	0	13,053,438	2,682,378	0	0	0	9,586,229	0	0	110,299	0	0	0	331,948	41,201,375	0	0	0	0	0	7,586,863	0	7,156,224	(891,901)	0	0	13,879,816	651,368	(69,024)	1,008,196	29,321,542	207,266	29,211,354	0	341,514	0	0	0	0	217,007	85,137,605	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20173	07/01/2017	09/30/2017	Open	Riverside	12	1111	Investor - Ptnr.	Comparable	None	(951) 788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	PATRICK BRILLIANT	373	373	373	1,036	1,158	253	829	6	0	56	632	48	99	4,117	0	5,899	5,035	3,198	4,486	22	0	288	2,959	306	322	22,515	0	4,650	4,907	2,877	16,102	18	0	720	6,059	328	2,860	38,521	154,691,333	159,718,585	72,978,963	152,329,254	777,981	0	10,886,607	102,544,042	6,309,888	9,012,568	669,249,221	47,353,304	69,706,103	19,382,495	116,597,211	247,828	0	7,406,719	71,782,442	5,163,905	21,725,869	359,365,876	10,770,617	173,293,836	204,969,067	87,490,852	252,608,649	0	805,668	0	15,317,759	133,407,332	0	9,785,913	0	0	0	25,203,566	913,653,259	0	0	0	0	0	28,750,801	24,455,621	4,870,606	16,317,816	220,141	0	2,975,567	40,919,152	1,687,880	(5,235,746)	114,961,838	416,932	113,131,382	5,484,898	9,136,218	0	0	0	0	23,155,351	388,979,861	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20173	07/01/2017	09/30/2017	Open	Riverside	12	1109	City/County	Comparable	Teaching	(951) 486-4000	26520 CACTUS AVENUE	MORENO VALLEY	92555	ZAREH SARRAFIAN	439	439	439	454	400	760	1,300	22	0	1,009	148	0	163	4,256	0	3,331	2,464	4,334	5,921	116	0	8,078	756	0	630	25,630	0	2,868	1,952	11,151	22,421	415	0	6,191	1,254	0	2,518	48,770	33,143,954	28,804,735	54,694,079	80,519,870	881,013	0	54,859,162	12,795,291	0	4,411,459	270,109,563	9,126,899	7,387,789	26,262,074	49,038,111	1,497,797	0	14,996,178	4,874,157	0	5,527,949	118,710,954	9,851,098	31,768,866	27,165,556	65,406,645	94,206,110	(13,145,039)	2,378,810	0	50,357,501	8,229,134	0	0	0	0	0	0	276,218,681	0	0	0	0	0	10,501,987	9,026,968	28,694,547	35,351,871	0	0	19,497,839	9,440,314	0	88,310	112,601,836	5,045,378	147,242,912	0	18,865,771	0	0	0	0	3,170,696	191,417,211	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20173	07/01/2017	09/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,579	340	722	527	0	0	53	2,457	7	132	5,817	0	10,934	2,790	7,060	3,852	0	0	395	15,291	41	754	41,117	0	41,473	8,004	7,435	5,759	0	0	690	70,449	411	6,290	140,511	167,344,607	24,404,908	103,616,133	47,020,130	0	0	5,661,121	266,320,714	430,762	7,795,732	622,594,107	102,968,408	4,872,114	18,766,335	13,756,934	0	0	1,990,398	176,144,638	658,607	10,072,728	329,230,162	7,241,961	179,622,404	14,295,470	89,879,571	46,554,457	0	0	0	3,763,174	167,285,568	0	1,089,369	0	819,177	(819,177)	5,497,201	515,229,175	0	0	0	0	0	90,690,611	14,981,552	32,502,897	14,222,607	0	0	3,888,345	275,179,784	0	5,129,298	436,595,094	42,381,573	457,533,935	0	8,946,452	0	0	0	0	10,596,197	1,051,775,596	0	0	0	0	0	0	0	0	0	0	0	0	0