Table: 2019_quarter_2_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	20192	07/01/2018	06/30/2019	Open	San Diego	14 - San Diego/Imperial	1416	Non Profit Corp.	Comparable	Teaching	858-576-1700	3020 CHILDREN'S WAY	SAN DIEGO	92123	PATRICIO A. FRIAS, MD	524	444	326	70	0	5,875	4,939	572	0	1,175	7,365	40	238	20,274	38	355	0	40,279	11,537	3,615	0	6,155	37,331	189	349	99,810	12,515	533	0	55,254	156,782	11	0	18,900	99,821	505	6,467	338,273	5,954,665	0	742,295,688	162,563,639	19,864,739	0	100,279,757	607,390,410	6,086,467	6,250,523	1,650,685,888	3,305,859	0	181,768,315	313,997,940	3,380	0	53,493,659	364,888,651	3,398,982	9,015,469	929,872,255	2,958,568	7,735,259	0	534,895,978	443,943,491	(11,461,831)	13,655,209	0	106,431,756	597,519,229	0	9,485,448	0	0	0	6,809,484	1,711,972,591	0	18,792,871	0	49,132,154	67,925,025	1,525,265	0	400,629,855	51,410,961	6,212,911	0	47,341,658	428,510,239	0	879,688	936,510,577	78,803,580	767,374,649	0	(39,298,009)	0	0	0	0	35,711,031	479,263,609	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	20192	07/01/2018	06/30/2019	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	149	1,853	4,000	923	1,962	0	0	162	3,665	53	58	12,676	0	8,638	17,403	4,989	6,369	0	0	452	12,619	147	163	50,780	0	30,367	50,107	7,748	38,029	0	0	1,019	39,659	6,167	5,766	178,862	178,864,986	363,797,563	59,300,422	125,347,999	0	0	12,795,468	212,800,862	2,799,980	3,107,560	958,814,840	97,389,845	216,710,575	28,387,884	107,126,797	0	0	6,196,645	243,691,425	11,628,208	10,872,359	722,003,738	4,048,053	240,212,533	528,809,823	72,770,706	199,579,763	0	0	0	14,553,405	392,554,790	0	13,995,343	0	0	0	6,462,290	1,472,986,706	67,976,301	0	0	76,685,987	144,662,288	36,042,298	119,674,616	14,917,600	32,895,033	0	0	4,438,708	140,623,484	432,845	3,469,576	352,494,160	2,596,926	343,091,209	6,511,893	17,877,954	0	0	30,623,021	44,960,679	31,830,405	143,897,757	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	20192	07/01/2018	06/30/2019	Open	Humboldt	01 - Northern California	0107	Church	Comparable	Rural	707-445-8121	3300 RENNER DRIVE	FORTUNA	95540	ROBERTA LUSKIN-HAWK, MD	35	25	25	511	20	60	354	0	0	15	213	0	39	1,212	0	2,500	86	183	1,133	0	0	67	530	0	113	4,612	0	17,031	806	1,109	12,506	0	0	1,097	11,090	0	2,532	46,171	39,782,407	2,066,389	3,315,898	17,639,077	0	0	1,890,474	12,670,695	0	1,962,627	79,327,567	59,129,150	2,834,201	4,265,816	42,906,965	0	0	5,410,310	34,898,541	0	5,007,368	154,452,351	1,610,292	78,868,892	4,156,332	1,113,372	53,961,510	0	0	0	3,791,217	28,391,021	0	4,805,560	0	0	0	1,187,802	177,885,998	0	0	0	0	0	19,584,351	744,258	6,338,662	6,476,971	0	0	3,477,936	18,583,415	0	688,327	55,893,920	611,734	40,815,107	0	4,176,145	0	0	0	0	3,644,301	14,975,377	0	0	0	0	0	0	0	0	0	0	212,777	7,008,786	19,993
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20192	07/01/2018	06/30/2019	Open	Santa Clara	07 - Santa Clara	0431	Investor - Corp.	Comparable	None	408-259-5000	225 NORTH JACKSON AVENUE	SAN JOSE	95116	TOMI RYBA	264	264	264	5,247	2,756	1,477	3,151	0	0	274	2,005	146	427	15,483	0	30,185	14,402	8,207	15,921	0	0	1,006	7,949	613	1,195	79,478	0	16,190	9,828	10,660	43,255	0	0	3,006	13,674	809	12,071	109,493	1,190,428,522	644,011,464	350,185,145	647,643,245	0	0	84,943,685	397,570,465	29,315,811	62,712,179	3,406,810,516	218,019,928	149,815,511	101,870,517	358,723,378	0	0	43,511,158	173,206,739	11,820,211	111,791,486	1,168,758,928	28,369,797	1,303,144,062	730,153,981	416,911,779	976,626,416	0	0	0	76,032,538	440,475,499	0	41,136,022	0	0	0	168,496,448	4,181,346,542	0	0	0	0	0	105,304,388	63,672,994	35,143,883	29,740,207	0	0	52,422,305	130,301,705	0	(22,362,580)	394,222,902	1,448,132	445,460,070	22,147,725	229,869	0	0	0	0	10,735,173	283,562,730	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20192	07/01/2018	06/30/2019	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	318	41	194	0	0	0	0	1,265	87	22	1,927	0	5,416	941	3,497	0	0	0	0	13,298	1,335	291	24,778	0	1,440	166	0	0	0	0	0	16,041	0	1,904	19,551	27,692,780	2,995,421	16,219,034	0	0	0	0	65,026,627	10,106,955	6,256,384	128,297,201	1,645,901	196,298	0	0	0	0	0	16,626,416	0	565,941	19,034,556	965,121	17,294,262	1,607,714	13,003,985	0	0	0	0	0	34,335,791	0	5,443,950	0	10,106,955	(10,106,955)	1,043,620	73,694,443	0	0	0	0	0	11,888,293	1,612,799	3,175,440	0	0	0	0	46,521,452	10,106,955	332,375	73,637,314	274,547	78,312,483	0	3,095,296	0	0	0	0	3,773,778	9,873,146	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	20192	07/01/2018	06/30/2019	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	527	0	0	0	0	0	527	0	0	0	0	0	4,977	0	0	0	0	0	4,977	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4,469,020	0	0	0	0	0	4,469,020	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,469,020	0	0	0	0	0	4,469,020	0	4,273,413	0	0	0	0	0	0	31,645	86,646	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF - PHF	20192	07/01/2018	06/30/2019	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	697	697	0	0	0	0	0	0	0	0	0	0	4,705	4,705	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4,803,980	4,803,980	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	4,803,980	4,803,980	0	4,469,757	0	0	0	0	0	0	3,990	94,289	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20192	07/01/2018	06/30/2019	Open	Kern	09 - Central	0621	Non Profit Corp.	Comparable	Rural	760-466-3551	1081 NORTH CHINA LAKE BOULEVARD.	RIDGECREST	93555	JAMES SUVER	150	150	83	713	0	438	99	0	0	483	22	25	85	1,865	0	3,184	0	1,390	296	0	0	1,243	61	101	227	6,502	0	25,444	0	17,606	3,437	0	0	31,279	983	1,067	4,159	83,975	33,408,638	0	28,303,279	2,116,736	0	0	20,272,372	701,902	39,706	3,135,408	87,978,041	65,369,115	0	45,862,126	5,075,676	0	0	75,841,634	2,004,436	41,836	2,922,508	197,117,331	3,607,019	69,549,767	0	40,634,568	9,689,733	0	0	0	37,864,420	0	0	216,808	(18,601)	0	0	2,062,738	163,606,452	0	0	0	0	0	29,227,987	0	33,530,839	(2,497,323)	0	0	58,249,584	2,706,337	(116,665)	388,161	121,488,920	1,032,179	123,000,318	0	1,238,049	0	0	0	0	1,956,275	82,887,169	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20192	07/01/2018	06/30/2019	Open	Riverside	12 - Inland Counties	1111	Investor - Ptnr.	Comparable	None	951-788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	JACKIE D. VAN BLARICUM	478	478	478	4,677	4,876	2,349	6,956	26	0	583	4,046	150	500	24,163	0	28,805	26,750	15,669	26,857	118	0	2,245	16,232	681	1,816	119,173	0	16,507	20,078	9,840	59,383	105	0	4,192	25,587	788	12,435	148,915	788,355,362	946,551,145	346,196,978	815,231,744	6,248,600	0	100,368,679	541,047,848	23,904,064	53,601,620	3,621,506,040	205,379,079	361,090,762	80,190,164	524,240,060	2,671,195	0	53,276,585	354,077,761	11,640,302	114,545,446	1,707,111,354	0	844,463,722	1,196,348,498	408,285,326	1,296,505,149	0	11,686,235	0	125,159,809	686,153,190	0	34,920,951	0	0	0	165,459,949	4,768,982,829	0	0	0	0	0	149,270,719	111,293,409	18,101,816	42,966,655	(2,766,441)	0	28,485,453	208,972,419	623,414	2,687,121	559,634,565	2,129,235	418,415,025	22,314,806	48,782,128	0	0	0	0	46,833,187	416,556,549	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20192	07/01/2018	06/30/2019	Open	Riverside	12 - Inland Counties	1109	City/County	Comparable	Teaching	951-486-4000	26520 CACTUS AVENUE	MORENO VALLEY	92555	ZAREH SARRAFIAN	439	439	439	2,144	1,767	3,363	5,641	126	0	4,337	600	8	490	18,476	0	18,079	12,226	19,157	23,929	545	0	32,913	2,649	41	1,850	111,389	0	13,386	8,611	46,817	89,478	2,862	0	23,323	4,448	1,330	9,961	200,216	177,669,438	145,519,780	212,028,526	310,915,474	7,189,959	0	239,468,293	44,923,763	1,055,182	20,976,069	1,159,746,484	45,325,215	34,022,926	126,456,594	220,604,981	12,717,630	0	67,298,605	16,180,422	1,572,287	25,154,746	549,333,406	45,112,692	172,651,020	139,998,789	265,474,075	351,749,818	(62,472,685)	19,907,589	0	217,529,542	31,130,710	0	2,627,468	0	0	0	0	1,183,709,018	0	0	0	0	0	50,343,634	39,543,916	135,483,730	179,770,638	0	0	89,237,356	29,973,475	0	1,018,123	525,370,872	20,999,621	595,279,424	0	45,609,534	0	0	0	0	20,465,750	191,998,098	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20192	07/01/2018	06/30/2019	Open	Los Angeles	11 - Los Angeles	0927	Non Profit Other	Comparable	Teaching	310-825-5041	757 WESTWOOD PLAZA	LOS ANGELES	90095	JOHNESE SPISSO	445	445	459	6,280	1,595	2,757	2,081	0	0	215	9,566	16	475	22,985	0	44,888	12,925	26,048	14,874	0	0	1,296	62,110	111	2,725	164,977	0	168,284	36,886	28,790	23,861	0	0	3,130	294,248	616	29,207	585,022	926,478,924	238,177,599	508,896,584	265,647,687	0	0	25,180,566	1,374,553,319	1,317,875	35,845,566	3,376,098,120	537,479,300	80,425,994	89,731,441	75,728,989	0	0	11,082,822	901,139,692	1,283,065	67,565,567	1,764,436,870	31,760,902	1,021,763,884	175,001,308	423,234,335	255,943,553	0	0	0	20,603,355	1,146,050,788	0	2,600,940	0	3,359,569	(3,359,569)	35,023,628	3,111,982,693	0	0	0	0	0	442,194,340	143,602,285	175,393,690	85,433,123	0	0	15,660,033	1,129,642,223	0	36,626,603	2,028,552,297	226,232,794	2,028,651,512	0	36,524,333	0	0	0	0	59,070,499	990,510,520	0	0	0	0	0	0	0	0	0	0	0	0	0