Table: 2017_quarter_3_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	20173	10/01/2016	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, M. D.	524	444	338	70	0	6263	4578	599	0	1063	7534	65	354	20526	53	360	0	42343	9445	5062	0	4577	36434	308	2322	100851	12262	627	0	61009	153782	71	0	15444	93745	160	8399	333237	4695200	0	728740515	107535821	10895453	0	86559291	595925662	4518192	5770261	1544640395	3150316	0	161661082	272090263	12898	0	43094941	316529248	375486	11674052	808588286	10414797	6660773	0	656761939	340745606	-9718039	4409874	0	90727591	584513009	0	4893679	0	0	0	6981953	1696391182	0	27401364	0	51953785	79355149	1184743	0	243357696	67252663	6498476	0	38926640	377883383	0	1089047	736192648	72892188	688068143	0	54920517	0	0	0	0	49571775	489884872	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	20173	10/01/2016	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	1689	3516	945	2005	0	0	166	3404	47	52	11824	0	7785	15333	4419	6811	0	0	423	11660	146	162	46739	0	27348	44019	7725	42087	0	0	1307	39164	5874	5492	173016	146295479	291176974	51214283	119173619	0	0	12388923	175694635	2787745	3093979	801825637	83303421	168583638	19141937	104295004	0	0	4837336	200901405	8462543	7912466	597437750	3366775	199431870	415365883	55325119	197340302	0	0	0	12294402	321444516	0	10912779	0	0	0	3247477	1218729123	57857453	0	0	81215713	139073166	30167030	102252182	15031099	26128321	0	0	4931857	136367237	337509	4392195	319607430	2104928	301535339	4339125	5090672	0	0	31837510	45786469	14588850	115219116	0	0	0	0	0	0	0	0	0	0	0	0	0
106121051	REDWOOD MEMORIAL HOSPITAL	20173	10/01/2016	09/30/2017	Open	Humboldt	01	0107	Church	Comparable	Rural	(707) 445-8121	3300 RENNER DRIVE	FORTUNA	95540	DAVID O'BRIEN, M.D.	35	25	25	539	25	65	378	0	0	12	280	0	35	1334	0	2734	191	191	1054	0	0	39	679	0	126	5014	0	16035	809	1205	13499	0	0	1015	10896	0	3163	46622	36398515	2785529	3105896	16795140	0	0	710124	13383962	0	1192363	74371529	45923331	2750218	4611929	36088382	0	0	4221861	30118589	0	4677436	128391746	1940483	64637178	4491403	4530685	44467621	0	0	0	2235958	25526500	0	2726956	0	0	0	2293734	152850518	0	0	0	0	0	17301020	1044344	2921606	8274188	0	0	2664597	17553296	0	153706	49912757	557000	42748000	0	6370000	0	0	0	0	2322000	11938000	0	0	0	0	0	0	0	0	0	0	0	1615507	6478
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20173	10/01/2016	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	5732	2727	1483	2949	0	0	108	2141	127	381	15648	0	32620	13822	8521	14902	0	0	408	9416	506	1773	81968	0	18863	9680	12534	50530	0	0	1471	17548	943	11164	122733	1085217814	497287075	316226240	545967983	0	0	20360909	443071010	21383280	78243035	3007757346	191420934	106805321	91078328	322302413	0	0	11881622	165061330	10175710	77131078	975856736	40122508	1153214845	555153291	375828089	843395122	0	0	0	17603682	422924055	0	34896524	0	0	0	122818070	3565956186	0	0	0	0	0	123423903	48939105	31476479	24875274	0	0	14638849	185208285	0	-10903999	417657896	1369084	437854134	13019421	377517	0	0	0	0	10047974	308935571	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20173	10/01/2016	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	291	46	200	6	0	0	0	1049	76	62	1730	0	5953	846	3324	180	0	0	0	11665	1441	788	24197	0	1645	165	0	0	0	0	0	14870	0	1600	18280	22611740	956136	11663722	622981	0	0	0	46685908	10971990	5416427	98928904	1712880	13365	0	0	0	0	0	13911373	0	291400	15929018	223751	12017421	360540	10213919	493553	0	0	0	0	20527738	0	0	0	10971990	-10971990	5464439	49301361	0	0	0	0	0	12267795	600967	1447533	134960	0	0	0	39891641	10971990	241675	65556561	121929	73980853	0	3233178	0	0	0	0	1707581	9069888	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD - PHF	20173	10/01/2016	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	615	0	0	0	0	0	615	0	0	0	0	0	5069	0	0	0	0	0	5069	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4383980	0	0	0	0	0	4383980	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	4383980	0	0	0	0	0	4383980	0	3948782	0	0	0	0	0	0	4541	113284	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF - PHF	20173	10/01/2016	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	107	107	0	0	0	0	0	0	0	0	0	0	1152	1152	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1033720	1033720	0	0	0	0	0	0	0	0	0	0	0	16680	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	16680	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1017040	1017040	0	971779	0	0	0	0	0	0	180000	162000	0	0	0	0	0	0	0	0	0	0	0	0	0
106580996	RIDEOUT MEMORIAL HOSPITAL	20173	10/01/2016	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	5120	94	874	2900	1	0	1895	0	39	118	11041	0	27658	495	4711	12575	9	0	7092	0	210	653	53403	0	50597	884	5679	30662	3	0	28602	1	0	4231	120659	372252506	6483547	52318904	166063788	88966	0	100339198	0	4068442	12733674	714349025	236596407	4123765	26566757	143417241	11982	0	133767722	4114	0	19788936	564276924	15393995	484557743	9065574	47844245	244474869	586009	86024	0	119862303	0	0	4068443	0	0	0	0	925939205	0	0	0	0	0	124291169	1541737	30455405	65006160	14924	0	98850623	4114	4068443	28454169	352686744	6068319	391799368	46428895	10709851	0	0	0	0	14952232	353396129	0	0	0	0	0	0	0	0	0	0	0	0	0
106150782	RIDGECREST REGIONAL HOSPITAL	20173	10/01/2016	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	776	0	456	104	0	0	508	17	12	95	1968	0	6012	0	1304	377	0	0	1463	42	40	241	9479	0	27042	0	19529	3687	0	0	31778	1140	1317	4058	88551	35840185	0	27505086	2475459	0	0	22073296	690700	75526	2133606	90793858	58014982	0	46528301	4910190	0	0	66548338	2013163	183184	3373999	181572157	2487421	66651005	0	44430404	9316546	0	0	0	33069713	0	0	752911	-14087	0	0	1091903	157785816	0	0	0	0	0	27204162	0	29602981	-1930897	0	0	55551920	2703862	-480115	1928286	114580199	187173	114511180	0	1481448	0	0	0	0	5470289	85137605	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20173	10/01/2016	09/30/2017	Open	Riverside	12	1111	Investor - Ptnr.	Comparable	None	(951) 788-3000	4445 MAGNOLIA AVENUE	RIVERSIDE	92501	PATRICK BRILLIANT	373	373	373	4470	4970	2330	6839	17	0	332	4234	140	387	23719	0	27069	23331	13690	23971	63	0	1371	14960	781	1235	106471	0	18592	19940	11921	66358	60	0	2667	25223	630	11879	157270	661771129	707759279	272781369	605697091	2145086	0	43652883	451038583	21136413	28963048	2794944881	180750589	271537597	72433520	453433648	967165	0	28972350	284435884	9298543	84748066	1386577362	26544950	721154159	874247321	329218663	1000193702	0	1959510	0	59041974	547650133	0	32790677	0	0	0	98902332	3691703421	0	0	0	0	0	121367559	105049555	15996226	58937037	1152741	0	13583258	187824334	-2355720	-11736168	489818822	2005917	438471858	18608987	35039394	0	0	0	0	288070036	388979861	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20173	10/01/2016	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	1873	1589	2748	5222	116	0	4174	598	0	635	16955	0	13612	9478	14185	22776	465	0	27067	2692	0	2712	92987	0	11291	6513	38714	85746	4589	0	22770	4624	0	9977	184224	143724902	121301113	180350052	297807815	5811804	0	207376472	48554868	0	26154305	1031081331	36172865	26165769	97280119	179288314	13159719	0	61534657	16173484	0	22158017	451932944	47329988	133614609	110687651	219865436	321051113	-53511566	18941942	0	195273446	26233885	0	0	0	0	0	0	1019486504	0	0	0	0	0	46283158	36779231	111276301	156045016	29581	0	73637683	38494467	0	982334	463527771	21077799	560771734	0	68476859	0	0	0	0	39857100	191417211	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20173	10/01/2016	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	6123	1362	3025	2066	0	0	224	9780	14	517	23111	0	43843	11256	29183	15076	0	0	1472	61067	82	3075	165054	0	163096	34307	30556	22839	0	0	3285	290400	724	22649	567856	677372101	103042222	412500631	195879014	0	0	21303464	1074963634	840987	31475574	2517377627	399448901	26787428	78189031	52122196	0	0	8223128	686572319	1230733	40244226	1292817962	15363877	688561763	73780442	334703914	193576916	0	0	0	15198634	709900160	0	2071720	0	3271246	-3271246	21797247	2054954673	186797	238541	0	1696864	2122202	388259239	56236005	155985748	54662835	0	0	14327958	1053332657	0	34558676	1757363118	195159984	1855932505	0	-13969459	0	0	0	0	54956026	1051775596	0	0	0	0	0	0	0	0	0	0	0	0	0