Table: 2018_quarter_2_complete_data_set_10_10_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	20182	04/01/2018	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	7	0	1,438	1,104	106	0	328	1,804	16	62	4,865	13	2	0	10,516	2,013	1,572	0	1,623	9,636	82	485	25,929	2,942	142	0	13,999	38,153	0	0	4,089	25,007	16	1,895	83,301	242,953	0	183,187,025	31,259,550	4,863,657	0	30,536,640	163,029,781	1,281,391	3,448,449	417,849,446	1,011,827	0	43,969,263	71,361,368	0	0	11,786,439	83,843,432	39,172	1,902,031	213,913,532	6,358,714	922,107	0	166,056,341	94,746,917	(3,282,617)	3,312,229	0	30,196,360	138,490,465	0	1,320,563	0	0	0	4,273,899	442,394,978	0	4,843,947	0	14,661,202	19,505,149	332,673	0	64,382,563	12,717,948	1,551,428	0	12,126,719	122,408,078	0	(4,646,260)	208,873,149	18,772,182	199,482,367	0	(11,059,257)	0	0	0	0	13,437,347	492,765,456	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	20182	04/01/2018	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	513	950	196	485	0	0	40	867	14	14	3,079	0	2,242	4,061	1,021	1,484	0	0	96	2,968	38	42	11,952	0	8,138	11,944	1,987	9,027	0	0	278	9,651	1,271	1,190	43,486	44,350,574	81,212,237	13,074,823	28,515,723	0	0	3,613,230	47,712,037	280,739	311,577	219,070,940	21,604,722	47,239,031	5,387,064	24,589,486	0	0	1,537,032	55,835,211	2,039,190	1,906,640	160,138,376	707,650	56,535,750	115,824,798	16,013,164	49,546,652	0	0	0	3,710,613	89,500,472	0	2,250,330	0	0	0	860,503	334,949,932	15,568,688	0	0	21,767,945	37,336,633	9,419,546	28,195,158	2,448,723	3,558,557	0	0	1,439,649	35,814,721	69,599	650,064	81,596,017	56,918	82,420,197	1,399,665	6,674,365	0	0	7,434,143	16,833,451	5,783,913	121,638,716	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	20182	04/01/2018	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	142	3	27	107	0	0	2	55	0	10	346	0	797	15	58	313	0	0	6	143	0	26	1,358	0	4,275	232	222	3,323	0	0	235	2,815	0	750	11,852	11,304,533	272,859	1,036,196	5,891,245	0	0	336,437	2,514,096	0	550,149	21,905,515	14,442,803	579,621	938,243	10,614,216	0	0	1,238,845	9,119,380	0	1,259,172	38,192,280	286,759	19,864,910	676,699	261,006	14,311,527	0	0	0	733,068	7,200,168	0	1,147,836	0	0	0	758,074	45,240,047	0	0	0	0	0	5,735,682	175,781	1,713,433	2,175,815	0	0	842,214	4,309,131	0	(94,308)	14,857,748	157,000	11,139,896	0	1,080,000	0	0	0	0	463,000	12,436,000	0	0	0	0	0	0	0	0	0	0	72,896	1,219,907	0
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20182	04/01/2018	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	1,242	650	338	662	0	0	132	434	38	89	3,585	0	7,463	3,680	1,968	3,362	0	0	753	1,595	175	399	19,395	0	4,346	2,271	2,846	10,810	0	0	726	3,395	201	2,808	27,403	283,201,164	145,109,867	71,320,648	130,526,160	0	0	28,240,927	94,881,852	7,660,280	18,259,065	779,199,963	54,919,116	32,137,905	23,896,664	83,565,183	0	0	9,315,364	38,000,447	3,001,721	22,100,501	266,936,901	6,834,106	311,442,109	163,932,742	88,595,585	212,806,908	0	0	0	24,577,529	95,751,917	0	10,662,001	0	0	0	34,873,724	949,476,621	0	0	0	0	0	26,678,171	13,315,030	6,621,727	1,284,435	0	0	12,978,762	37,130,382	0	(1,348,264)	96,660,243	485,153	111,292,896	4,052,864	60,521	0	0	0	0	1,031,425	294,068,745	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20182	04/01/2018	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	89	7	47	0	0	0	0	321	21	14	499	0	1,400	262	811	0	0	0	0	3,202	175	121	5,971	0	338	111	0	0	0	0	0	4,633	0	340	5,422	5,237,469	202,998	2,736,980	0	0	0	0	12,832,335	2,787,778	831,105	24,628,665	453,187	12,321	0	0	0	0	0	4,129,847	0	40,600	4,635,955	436,230	3,016,102	87,002	2,389,009	0	0	0	0	0	6,164,041	0	1,233,986	0	2,787,778	(2,787,778)	(505,097)	12,821,273	0	0	0	0	0	2,591,760	114,775	337,199	0	0	0	0	10,473,441	2,787,778	138,394	16,443,347	11,528	17,686,547	0	771,021	0	0	0	0	1,111,480	10,050,472	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	20182	04/01/2018	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	113	0	0	0	0	0	113	0	0	0	0	0	1,261	0	0	0	0	0	1,261	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,130,800	0	0	0	0	0	1,130,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	1,130,800	0	0	0	0	0	1,130,800	0	1,061,184	0	0	0	0	0	0	13,566	75,891	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF - PHF	20182	04/01/2018	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	162	162	0	0	0	0	0	0	0	0	0	0	1,263	1,263	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,252,040	1,252,040	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,252,040	1,252,040	0	1,116,804	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	20182	04/01/2018	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	1,346	29	291	699	1	0	514	0	1	9	2,890	0	7,231	113	1,365	2,731	25	0	1,876	0	95	117	13,553	0	13,347	300	1,499	8,250	1	0	7,074	0	0	857	31,328	103,970,828	2,042,960	18,186,034	39,150,077	273,387	0	29,833,511	0	788,565	1,431,225	195,676,587	59,760,447	1,344,114	6,697,057	36,965,895	1,070	0	31,667,699	0	0	3,820,462	140,256,744	3,392,955	89,272,241	2,491,809	29,715,680	57,842,257	(7,398)	10,222	0	21,090,001	0	0	788,565	0	0	0	0	204,596,332	0	0	0	0	0	74,459,034	895,264	(4,825,191)	18,273,716	(9,152)	0	37,018,230	24	788,565	4,736,509	131,336,999	817,389	95,990,949	12,192,408	233,885	0	0	0	0	17,410,011	357,248,586	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20182	04/01/2018	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	170	0	90	23	0	0	109	2	5	25	424	0	690	0	268	71	0	0	274	4	19	120	1,446	0	6,290	0	4,391	943	0	0	7,749	262	186	1,003	20,824	7,353,368	0	6,480,354	567,818	0	0	5,839,612	133,355	14,592	826,858	21,215,957	17,209,323	0	12,087,369	1,429,386	0	0	17,369,013	598,603	6,150	558,641	49,258,485	761,183	17,080,185	0	11,310,625	2,726,218	0	0	0	9,642,640	0	0	53,559	(3,853)	0	0	416,459	41,987,016	0	0	0	0	0	7,482,505	0	7,257,098	(729,014)	0	0	13,565,985	731,958	(28,963)	207,857	28,487,426	467,037	29,244,928	0	263,812	0	0	0	0	131,874	83,395,804	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20182	04/01/2018	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	1,160	1,343	568	1,689	12	0	128	1,031	5	133	6,069	0	6,670	6,881	3,304	6,382	45	0	480	4,123	79	245	28,209	0	4,552	5,051	2,905	14,861	27	0	1,069	6,463	55	2,971	37,954	182,339,699	224,702,318	75,696,951	188,443,148	1,790,479	0	23,507,525	132,476,068	1,387,331	7,201,211	837,544,730	48,913,801	81,694,594	22,256,043	113,779,510	428,418	0	15,937,039	81,544,655	2,143,828	24,084,000	390,781,888	0	194,032,811	277,309,602	90,503,636	293,618,916	0	1,696,950	0	31,063,294	161,138,930	0	5,458,920	0	0	0	31,348,003	1,086,171,062	0	0	0	0	0	37,220,689	29,087,310	7,449,358	8,603,742	521,948	0	8,381,269	52,881,793	(1,927,761)	(62,792)	142,155,556	470,493	91,979,848	5,729,063	10,273,264	0	0	0	0	16,063,656	401,616,882	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20182	04/01/2018	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	519	444	906	1,400	39	0	1,057	160	2	118	4,645	0	3,900	2,627	4,964	5,716	185	0	7,305	653	20	329	25,699	0	3,113	1,861	11,984	22,969	563	0	6,134	1,247	227	2,316	50,414	37,267,828	30,892,659	54,529,297	74,096,573	2,594,438	0	51,797,413	11,682,433	186,354	3,276,258	266,323,253	10,435,275	7,294,847	30,683,881	52,116,283	2,219,344	0	16,243,524	4,550,850	227,344	5,578,797	129,350,145	5,944,184	23,124,287	18,364,948	40,313,368	51,453,035	(14,938,677)	4,813,782	0	30,704,680	4,861,813	0	413,698	0	0	0	0	165,055,118	0	0	0	0	0	24,578,816	19,822,558	59,838,487	74,759,821	0	0	37,336,257	11,371,470	0	2,910,871	230,618,280	1,851,365	149,976,940	0	12,795,842	0	0	0	0	6,835,435	196,155,144	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20182	04/01/2018	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	1,659	462	750	525	0	0	54	2,364	7	70	5,891	0	11,996	3,580	6,231	4,391	0	0	319	14,177	51	505	41,250	0	42,755	8,480	7,277	6,001	0	0	840	75,491	204	6,600	147,648	191,014,603	20,603,517	87,245,124	58,558,532	0	0	5,861,344	269,026,295	676,811	6,661,685	639,647,911	110,361,341	4,547,743	20,372,795	13,880,965	0	0	2,469,272	192,585,489	360,971	11,686,046	356,264,622	1,145,763	194,893,900	17,104,822	44,947,738	56,631,177	0	0	0	5,477,011	199,815,194	0	1,037,782	0	919,846	(919,846)	6,239,815	527,293,202	0	0	0	0	0	106,482,044	8,046,438	62,670,181	15,808,320	0	0	2,853,605	261,796,590	0	10,962,153	468,619,331	53,903,209	487,348,867	0	5,225,239	0	0	0	0	18,349,985	1,030,835,418	0	0	0	0	0	0	0	0	0	0	0	0	0