Table: 2019_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
106121051	REDWOOD MEMORIAL HOSPITAL	20193	10/01/2018	09/30/2019	OPEN	Humboldt	01 - Northern California	107	Church	Comparable	Rural	707-445-8121	3300 RENNER DRIVE	FORTUNA	95540	ROBERTA LUSKIN-HAWK, M.D.	35	25	25	536	22	58	345	0	0	21	197	0	34	1213	0	2402	90	188	1163	0	0	88	500	0	95	4526	0	16765	735	1300	12579	0	0	1257	10975	0	2156	45767	39627100	2093108	3326528	18505802	0	0	2077888	12169468	0	1567170	79367064	59151539	2707286	4727939	43923672	0	0	5574335	35832398	0	4977033	156894202	1099665	78803095	4062233	1090838	55963800	0	0	0	3693332	29428917	0	5121601	0	0	0	917460	180180941	0	0	0	0	0	19249075	726301	6829671	6131781	0	0	3900835	17839666	0	1402996	56080325	786573	40309415	0	3069069	0	0	0	0	4343649	15785100	0	0	0	0	0	0	0	0	0	0	212777	5823294	19993
106150782	RIDGECREST REGIONAL HOSPITAL	20193	10/01/2018	09/30/2019	OPEN	Kern	09 - Central	621	Non Profit Corp.	Comparable	Rural	760-466-3551	1081 NORTH CHINA LAKE BLVD.	RIDGECREST	93555	JAMES SUVER	150	150	78	727	0	443	95	0	0	472	18	30	89	1874	0	3234	0	1405	262	0	0	1235	48	107	247	6538	0	25859	0	17289	3370	0	0	31129	979	1217	4216	84059	35533138	0	28057902	1586714	0	0	20122084	548730	40178	2907274	88796020	64524115	0	45501060	4952632	0	0	77336040	2107474	44039	3153156	197618516	3777437	69625385	0	40975888	9805954	0	0	0	39592388	0	0	230271	-18985	0	0	2245304	166233642	0	0	0	0	0	30431869	0	32583076	-3266610	0	0	57865734	2656202	-127068	37691	120180894	1084044	125184055	0	1173271	0	0	0	0	5679047	81574012	0	0	0	0	0	0	0	0	0	0	0	0	0
106190796	RONALD REAGAN UCLA MEDICAL CENTER	20193	10/01/2018	09/30/2019	OPEN	Los Angeles	11 - Los Angeles	927	Non Profit Other	Comparable	Teaching	310-825-5041	757 WESTWOOD PLAZA	LOS ANGELES	90095	JOHNESE SPISSO	445	445	451	6138	1609	2722	2051	0	0	211	9719	19	571	23040	0	44363	12860	25478	14601	0	0	1280	63021	133	3426	165162	0	169515	38335	28579	24302	0	0	3173	297539	561	27239	589243	923099253	294777253	494198459	269119263	0	0	25867141	1353682074	1170957	36985288	3398899688	547375429	107961506	89216911	78249908	0	0	11470779	897871272	1247649	68239077	1801632531	30412783	1014509122	225090029	426766557	248441081	0	0	0	21044308	1127684436	0	2418606	0	3359569	-3359569	37489537	3133856459	0	0	0	0	0	455965560	177648730	156648813	98928090	0	0	16293612	1123868910	0	37322045	2066675760	233172716	2135314202	0	31175843	0	0	0	0	58186056	978276751	0	0	0	0	0	0	0	0	0	0	0	0	0
106190930	RESNICK NEUROPSYCHIATRIC HOSPITAL AT UCLA	20193	10/01/2018	09/30/2019	OPEN	Los Angeles	11 - Los Angeles	927	Non Profit Other	Comparable	None	310-267-9315	150 Medical Plaza	LOS ANGELES	90095	JOHN MAZZIOTTA	74	74	74	336	50	187	0	0	0	0	1285	80	26	1964	0	5479	990	3344	0	0	0	0	13057	1339	440	24649	0	1406	206	0	0	0	0	0	16142	0	1848	19602	28785090	4426249	15742500	0	0	0	0	64748265	10106955	6378477	130187536	1726686	289910	0	0	0	0	0	16335575	0	485097	18837268	850494	17173075	2264149	12966497	0	0	0	0	0	33587074	0	4989889	0	10106955	-10106955	1602011	73433189	0	0	0	0	0	13153365	2438493	2769115	0	0	0	0	46849567	10106955	274120	75591615	249976	82613087	0	2963328	0	0	0	0	4053343	9731521	0	0	0	0	0	0	0	0	0	0	0	0	0
106331312	RIVERSIDE COMMUNITY HOSPITAL	20193	10/01/2018	09/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	4573	4958	2342	6942	26	0	573	3993	185	484	24076	0	29004	27658	15438	28368	105	0	2133	16457	919	1639	121721	0	16073	20489	9768	57676	109	0	4279	24962	977	12491	146824	815118124	997146986	352219348	847309427	7731194	0	100266029	563736551	30793230	49174088	3763494977	206651912	383177452	80493641	528521027	2555526	0	54144663	357609466	15020831	112126338	1740300856	0	865565065	1269289218	414380731	1335297889	0	10528533	0	121986172	703376180	0	45055022	0	0	0	158172629	4923651439	0	0	0	0	0	156204971	111035220	18332258	40532565	-241814	0	32424519	217969837	759038	3127800	580144394	2356960	425012672	23567505	51400103	0	0	0	0	41327599	417104706	0	0	0	0	0	0	0	0	0	0	0	0	0
106334487	RIVERSIDE UNIVERSITY HEALTH SYSTEM MEDICAL CENTER	20193	10/01/2018	09/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	335	2247	1774	3374	5686	128	0	4564	622	74	516	18985	0	18300	11891	18798	24468	484	0	32699	2596	356	1751	111343	0	13583	8904	47667	91871	3043	0	23571	4626	1701	10192	205158	179657574	144469094	213962796	320845028	7378663	0	235860137	46378625	4687824	19626020	1172865761	47523620	36261791	127324259	226401658	13503863	0	69037922	17291887	3448590	27784580	568578170	46254147	175098239	140748429	269253931	361952218	-58745988	20882526	0	212193821	33134104	0	8136413	0	0	0	0	1208907840	0	0	0	0	0	52082956	39982456	130779112	185294469	0	0	92704237	30536409	0	1156452	532536091	18236477	604321083	0	44450358	0	0	0	0	19250852	203622221	0	0	0	0	0	0	0	0	0	0	0	0	0
106361308	REDLANDS COMMUNITY HOSPITAL	20193	10/01/2018	09/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	146	1852	4008	903	1989	0	0	167	3646	58	63	12686	0	8697	17582	4967	6490	0	0	457	12387	186	206	50972	0	29564	50903	7854	38828	0	0	944	40124	6451	6032	180700	180973362	374158048	62204621	128981121	0	0	13329696	212146187	3722477	4131393	979646905	102029529	231314449	24505269	121142691	0	0	5481419	257307969	12613025	11793161	766187512	3276522	245654053	552668092	66032515	215648963	0	0	0	14481556	406265907	0	15845436	0	0	0	8487910	1528360954	68245665	0	0	79904443	148150108	37348838	121050070	20677375	34474849	0	0	4329559	143092692	490066	4160122	365623571	2725027	346022614	7291529	9988254	0	0	28496707	48474956	32567275	149495532	0	0	0	0	0	0	0	0	0	0	0	0	0
106370673	RADY CHILDREN'S HOSPITAL - SAN DIEGO	20193	10/01/2018	09/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, M. D.	524	444	344	69	0	6011	4813	594	0	1206	7178	39	309	20219	37	329	0	40491	11765	3130	0	5866	38187	174	520	100462	12368	490	0	57029	160998	2	0	20194	102263	502	6863	348341	6212119	0	763645950	170811392	20843264	0	96407525	628760335	6432363	7577407	1700690355	3579319	0	192575552	326248897	680	0	57367757	380243554	3405610	10402187	973823556	4062842	8248678	0	570399395	464820921	-11732328	14488535	0	107702326	619472711	0	9837971	0	0	0	8924801	1796225852	0	18742120	0	47951546	66693666	1542760	0	397554436	50981488	6355410	0	46072955	441990550	0	484126	944981725	81635820	776169922	0	-76874546	0	0	0	0	29416870	476568415	0	0	0	0	0	0	0	0	0	0	0	0	0
106430705	REGIONAL MEDICAL CENTER OF SAN JOSE	20193	10/01/2018	09/30/2019	OPEN	Santa Clara	07 - Santa Clara	431	Investor - Corp.	Comparable	None	408-259-5000	225 NORTH JACKSON AVENUE	SAN JOSE	95116	TOMI RYBA	264	264	264	5298	2745	1420	3397	0	0	282	2001	185	421	15749	0	30494	14095	8378	16785	0	0	1020	7708	825	1531	80836	0	16239	10166	10662	42757	0	0	2998	13402	832	12520	109576	1214540492	634579229	357185451	682468193	0	0	85129475	381059957	37380141	78769336	3471112274	221271945	163658991	105870044	369088266	0	0	43782264	172793839	15076366	118460285	1210002000	34747056	1321045725	733569749	430572717	1029833377	0	0	0	74233170	431338645	0	52456507	0	0	0	181145042	4288941988	0	0	0	0	0	114766712	64668471	32482778	21723082	0	0	54678569	122515151	0	-18662477	392172286	1448925	447912505	22498899	235156	0	0	0	0	17878850	289638745	0	0	0	0	0	0	0	0	0	0	0	0	0
106454068	RESTPADD PSYCHIATRIC HEALTH FACILITY	20193	10/01/2018	09/30/2019	OPEN	Shasta	01 - Northern California	209	Investor - Corp.	Psychiatric Health Facilities	None	530-262-6700	2750 EUREKA WAY	REDDING	96001	O. NWANGBURUKA	16	16	16	0	0	0	0	533	0	0	0	0	0	533	0	0	0	0	0	5113	0	0	0	0	0	5113	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4644260	0	0	0	0	0	4644260	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	4644260	0	0	0	0	0	4644260	0	4495771	0	0	0	0	0	0	6869	77935	0	0	0	0	0	0	0	0	0	0	0	0	0
106524017	RESTPADD RED BLUFF PSYCHIATRIC HEALTH FACILITY	20193	10/01/2018	09/30/2019	OPEN	Tehama	01 - Northern California	211	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	677	677	0	0	0	0	0	0	0	0	0	0	4745	4745	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4821340	4821340	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	4821340	4821340	0	4428682	0	0	0	0	0	0	0	86601	0	0	0	0	0	0	0	0	0	0	0	0	0