Table: 1997_quarter_4_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_	year	qtr	fac_name	city	hsa	hfpa	toc	bg_date	ed_date	lic_beds	avl_beds	stf_beds	dis_mcar	dis_mcal	dis_cnty	dis_thrd	dis_oth	dis_tot	dis_ltc	day_mcar	day_mcal	day_cnty	day_thrd	day_oth	day_tot	day_ltc	vis_mcar	vis_mcal	vis_cnty	vis_thrd	vis_oth	vis_tot	tot_exp	inp_exp	out_exp	phy_comp	gri_mcar	gri_mcal	gri_cnty	gri_thrd	gri_oth	gri_tot	gro_mcar	gro_mcal	gro_cnty	gro_thrd	gro_oth	gro_tot	ded_mcar	ded_mcal	ded_disp	ded_cnty	ded_thrd	ded_bd	ded_hb	ded_char	ded_rest	ded_tch	ded_clin	ded_cap	ded_oth	ded_tot	net_mcar	net_mcal	net_cnty	net_thrd	net_oth	net_tot	othoprev	nonoprex	capital	assets	disp_tfr	puripdis	puripday	puripexp	puriprev
106171049	1997	4	REDBUD COMMUNITY HOSPITAL	CLEARLAKE	01	0115	1	010197	"123197"	40	28	28	788	276	32	227	61	1384	0	3460	960	108	631	164	5323	0	31573	10295	1558	8039	2213	53678	19481932	8660171	10821761	0	12860832	3148588	419054	2808999	686606	19924079	10930123	6068103	981412	5191970	1630804	24802412	13576021	7351667	0	897771	2928088	1287184	0	420005	0	0	0	0	0	26460736	10214934	1865025	502695	5072881	610220	18265755	183843	371730	706478	4386467	0	0	0	0	0
106450940	1997	4	REDDING MEDICAL CENTER	REDDING	01	0209	2	010197	"123197"	198	198	113	4379	921	255	2547	68	8170	0	25297	3606	1199	10690	173	40965	0	18938	15586	2665	26069	5882	69140	104305888	85552903	18752985	0	232751204	29345898	11783661	107591739	1589017	383061519	27431535	15344578	3933117	32904192	4665381	84278803	187101483	36851425	0	18269234	87819973	4051805	0	826605	0	0	0	-2822959	154143	332251709	73081256	7839051	-2552456	49744931	6975831	135088613	476956	-278328	18916994	65450960	0	0	0	0	0
106121051	1997	4	REDWOOD MEMORIAL HOSPITAL	FORTUNA	01	0107	1	010197	"123197"	47	35	35	768	327	54	504	129	1782	127	3678	912	206	1364	294	6454	984	8024	6422	789	13210	2937	31382	15650003	8378994	7271009	0	9897577	2355504	748119	4280467	686386	17968053	3806275	2395475	559458	7606959	1211770	15579937	7914173	3862083	0	478436	4689494	591884	0	260911	-6719	0	0	0	37409	17827671	5789679	888896	829141	7189661	1022942	15720319	140279	487117	657372	6613010	0	0	0	0	0
106580996	1997	4	RIDEOUT MEMORIAL HOSPITAL	MARYSVILLE	02	0227	1	010197	"123197"	164	164	164	2619	985	245	1047	342	5238	248	16531	4378	923	3285	740	25857	4253	28571	20391	4852	26952	11656	92422	51082233	32993291	18088942	2367410	30777769	9705354	5014477	15359343	2706491	63563434	11635858	7143476	2127611	9870406	4051768	34829119	23250086	11527968	0	5758728	3720041	1526494	0	505519	0	0	0	0	595186	46884022	19163541	5320862	1383360	19388028	6252740	51508531	541436	3800808	1841676	37088566	0	0	0	0	0
106414018	1997	4	RECOVERY INN OF MENLO PARK	MENLO PARK	04	0428	2	010197	"123197"	16	16	16	58	6	0	493	94	651	0	110	9	0	906	206	1231	0	62	7	0	1400	133	1602	6167767	2504730	3663037	0	445571	38612	0	3801174	427010	4712367	271760	34166	0	6452563	235009	6993498	392454	65381	0	0	4895084	341709	0	0	0	0	0	0	0	5694628	324877	7397	0	5358652	320311	6011237	0	0	0	3026641	0	0	0	0	0
106214005	1997	4	ROSS HOSPITAL	KENTFIELD	04	0405	2	010197	"123197"	87	41	41	152	139	120	710	63	1184	0	1689	914	617	5273	502	8995	0	3076	0	0	6319	1649	11044	5816156	4147865	1668291	254171	2093047	1110462	753114	5716432	415114	10088169	1596259	0	0	2217022	260703	4073984	2374099	469513	0	609309	3848023	671331	0	260265	0	0	0	0	0	8232540	1256812	640949	143805	3465489	422558	5929613	22406	0	366867	2877259	0	0	0	0	0
106150782	1997	4	RIDGECREST COMMUNITY HOSPITAL	RIDGECREST	09	0621	1	010197	"123197"	80	80	80	1104	331	7	1039	66	2547	0	4221	1126	7	2882	218	8454	0	16298	5140	111	19036	1548	42133	22716686	13581173	9135513	0	12192967	2925054	18785	8765503	766733	24669042	5325681	2114166	60989	8534359	549328	16584523	10037708	2121468	0	44247	3792289	746226	0	61537	-19068	0	0	0	188811	16973218	7480940	2917752	35527	12780974	1065154	24280347	497140	328338	1827256	12495197	0	0	0	0	0
106421167	1997	4	REHABILITATION INSTITUTE AT SNTA BARBARA	SANTA BARBARA	10	0807	1	010197	"123197"	49	45	31	321	13	7	144	4	489	101	7383	341	143	3054	29	10950	2028	4549	171	39	8231	502	13492	13364205	11826021	1538184	0	11439790	603688	220584	4978365	43021	17285448	884546	22400	6296	1202836	48344	2164422	6054143	352745	0	49518	2185651	14125	0	0	-25214	0	0	0	72739	8703707	6240647	268301	177362	3984241	75612	10746163	384485	864581	879457	4371339	0	0	0	0	0
106190366	1997	4	ROBERT F. KENNEDY MEDICAL CENTER	HAWTHORNE	11	0929	1	010197	"123197"	274	195	195	2069	1747	0	1419	181	5416	0	18304	13448	0	6396	1021	39169	0	6339	10691	0	12015	5765	34810	47860597	34874076	12986521	0	31892739	23483488	0	15785601	2507535	73669363	7508626	5900557	0	10849721	3089844	27348748	21772830	18944348	-6716979	0	12155676	4873436	0	1158121	0	0	0	0	2625413	54812845	17628535	17156676	0	14479646	-3059591	46205266	174624	189259	3454183	18632387	0	0	0	0	0
106361308	1997	4	REDLANDS COMMUNITY HOSPITAL	REDLANDS	12	1209	1	010197	"123197"	177	177	177	1324	1085	22	7809	87	10327	0	5598	4208	84	25358	361	35609	0	16557	14281	30	89202	8066	128136	62488933	48052755	14436178	0	21780071	11034404	303709	99225133	2059638	134402955	7509853	3344400	23444	26752255	2717312	40347264	15992201	10516860	0	327153	102471910	1549000	0	231730	0	0	0	-24888092	4234975	110435737	13297723	3861944	0	46612841	541974	64314482	554254	3044549	3454092	31241580	0	0	0	0	0
106331312	1997	4	RIVERSIDE COMMUNITY HOSPITAL	RIVERSIDE	12	1111	2	010197	"123197"	369	276	276	2350	529	130	7571	893	11473	312	13515	2998	625	30845	2956	50939	2463	16076	3555	318	53080	7246	80275	96115374	79551110	16564264	1311859	41157298	12445904	3542236	113740730	12294438	183180606	5554830	1654220	281949	26180957	4519156	38191112	26963361	8395588	0	2871955	109649383	3683885	0	350045	0	0	0	-28460853	6012257	129465621	19748767	5704536	952229	57722507	7778058	91906097	473485	817931	5185642	46499765	0	0	0	0	0
106331314	1997	4	RIVERSIDE GENERAL HOSP-MENTAL HEALTH FAC	RIVERSIDE	12	1111	4	010197	"123197"	77	77	77	317	1076	1120	394	0	2907	0	2981	8464	7880	2226	0	21551	0	621	1830	1836	928	0	5215	14682187	13030913	1651274	0	2271894	6892550	6429321	1880232	0	17473997	263753	697010	804090	452590	0	2217443	1306194	2703753	-5313101	5022210	1889587	196914	0	0	0	0	0	0	0	5805557	1229453	10198908	2211200	246322	0	13885883	0	5877662	0	5714395	0	0	0	0	0
106331313	1997	4	RIVERSIDE GENERAL HOSP-UNIV MED CTR	RIVERSIDE	12	1111	4	010197	"123197"	345	239	239	423	2322	3987	1813	866	9411	0	2046	10998	18282	9233	4097	44656	0	5000	44312	66806	22462	14361	152941	109306191	69822698	39483493	0	5466909	32119712	52548901	27915743	11918171	129969436	2669535	19866943	28615084	15881194	6749881	73782637	2536445	24957344	-61614727	52027997	24686908	17264288	0	0	0	0	0	-2688525	0	57169730	5599999	88644037	29135988	20443214	2759105	146582343	4085046	81525	49687334	181894963	46401685	0	0	0	0
106364121	1997	4	ROBERT H. BALLARD REHAB HOSPITAL	SAN BERNARDINO	12	1209	2	010197	"123197"	60	60	60	303	53	0	0	165	521	0	6782	1615	0	0	3394	11791	0	1945	1072	0	0	7297	10314	10938476	9439086	1499390	0	7936937	2019449	0	0	4196771	14153157	476502	196662	0	0	1570963	2244127	2607775	986213	0	0	0	101032	0	0	0	0	0	0	2594790	6289810	5805664	1229898	0	-101032	3172944	10107474	233233	0	37373	12777	0	0	0	0	0