Table: 1999_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	1999	4	REDBUD COMMUNITY HOSPITAL	CLEARLAKE	01	0115	1	01011999	"12311999"	40	28	28	733	341	52	228	77	1431	0	3183	1129	163	942	248	5665	0	34195	14708	2917	9723	2229	63772	22793564	9281282	13512282	0	12995317	4494496	714897	3248525	1053616	22506851	14106151	7954477	1441338	7156767	1838510	32497243	16180836	9227906	0	1582366	3709268	1531073	0	255520	0	0	0	-242291	592866	32837544	10920632	3221067	573869	6938315	512667	22166550	268838	269568	561980	5429906	0	0	0	0	0
106450940	1999	4	REDDING MEDICAL CENTER	REDDING	01	0209	2	01011999	"12311999"	193	193	120	4558	986	243	2576	114	8477	0	27645	4308	1130	10346	344	43773	0	29276	15551	2934	39908	4073	91742	107317356	88632522	18684834	0	325667703	41818346	14168849	142953045	3662674	528270617	43066433	17438428	5449634	42815648	2703294	111473437	294517843	54643361	0	23803247	108676936	4167789	0	1541432	0	0	0	-9374	146390	487487624	74216293	4613413	-4184764	72923968	4687520	152256430	685844	-229463	18607987	88404549	0	0	0	0	0
106121051	1999	4	REDWOOD MEMORIAL HOSPITAL	FORTUNA	01	0107	1	01011999	"12311999"	46	35	35	862	321	52	536	60	1831	117	4046	989	169	1456	189	6849	737	10649	9504	1004	18152	3437	42746	16888913	9036301	7852612	0	13063002	2845457	629090	5041760	609809	22189118	5304014	3119973	708386	9068374	1070343	19271090	12280711	4017037	0	1014173	6084326	936090	0	75670	-12119	0	0	0	42212	24438100	6086305	1948393	323303	8025808	638299	17022108	128597	888588	1626719	7636665	0	0	0	0	0
106580996	1999	4	RIDEOUT MEMORIAL HOSPITAL	MARYSVILLE	02	0227	1	01011999	"12311999"	164	164	164	3333	871	340	1532	384	6460	129	18991	3339	1392	7538	2421	33681	2116	18519	12232	4446	21284	6723	63204	58463192	38261416	20201776	2778582	42892691	14430856	4289084	17586707	3104991	82304329	14410808	8403590	2427255	13399563	4816004	43457220	33773180	15054468	0	5592476	7751136	2154727	0	528268	0	0	0	0	615383	65469638	22530319	7779978	1123863	21158305	7699446	60291911	571188	3340388	4660855	38109616	0	0	0	0	0
106414018	1999	4	RECOVERY INN OF MENLO PARK	MENLO PARK	04	0428	2	01011999	"12311999"	16	16	16	38	0	0	536	35	609	0	77	0	0	1029	53	1159	0	99	1	0	1448	77	1625	6031671	1999785	4031886	0	402040	0	0	4487653	237825	5127518	482273	1450	0	9364657	492880	10341260	671378	1233	0	0	7494925	138204	0	0	0	0	0	0	267350	8573090	212935	217	0	6346855	335681	6895688	6535	0	299562	881163	0	0	0	0	0
106214005	1999	4	ROSS HOSPITAL	KENTFIELD	04	0405	2	01011999	"11041999"	72	45	45	118	121	16	774	70	1099	0	1206	829	95	5153	628	7911	0	821	0	0	2042	1247	4110	5453736	4927969	525767	23047	1410693	862524	103132	5053732	472214	7902295	222628	0	0	436147	191290	850065	893036	376121	0	29428	2407131	351083	0	0	0	0	0	0	326026	4382825	740285	486403	73704	2724139	345004	4369535	79476	7703	100786	2783218	0	0	0	0	0
106430705	1999	4	REGIONAL MEDICAL CENTER OF SAN JOSE	SAN JOSE	07	0431	1	01011999	"12311999"	204	199	182	2524	1854	0	6057	869	11304	0	15807	8672	0	17168	2772	44419	0	28852	14020	0	65474	34267	142613	138727621	104948896	33778725	4791735	68391356	37465682	0	130046511	13394315	249297864	17143704	7856038	0	44086479	11009384	80095605	52714146	35208737	-5230848	0	142615238	6588513	0	1853570	0	0	0	-45328624	8571222	196991954	32820914	15343831	0	76846376	7390394	132401515	453465	1583402	2398323	51350429	0	0	0	0	0
106150782	1999	4	RIDGECREST REGIONAL HOSPITAL	RIDGECREST	09	0621	1	01011999	"12311999"	80	80	80	1065	441	10	1168	71	2755	0	4067	1130	33	3058	239	8527	0	14817	6038	300	23603	2126	46884	24722904	14269480	10453424	0	11888617	3088211	83070	9592165	975843	25627906	5874500	2480490	127374	9364230	843623	18690217	10627251	3957589	0	97263	3696136	1112751	0	58539	-8829	0	0	0	333738	19874438	7135866	1611112	114898	15242134	339675	24443685	274597	428758	712682	14464399	0	0	0	0	0
106421167	1999	4	REHABILITATION INSTITUTE AT SNTA BARBARA	SANTA BARBARA	10	0807	1	01011999	"12311999"	41	41	27	254	21	6	121	2	404	0	6478	362	134	2713	71	9758	0	3030	250	132	7684	325	11421	11288120	10168270	1119850	0	12307197	794128	257608	5441881	112026	18912840	752181	27760	16325	1243854	38612	2078732	7702162	429673	0	121776	2956928	17708	0	42662	-34051	0	0	-2446	69798	11304210	5340578	383157	145895	3731661	86071	9687362	119412	374959	7407971	13091310	0	0	0	0	0
106190366	1999	4	ROBERT F. KENNEDY MEDICAL CENTER	HAWTHORNE	11	0929	1	01011999	"12311999"	269	210	210	2083	2245	0	1662	196	6186	0	16499	12891	0	7069	875	37334	0	8596	7387	0	18641	8231	42855	50062499	37296010	12766489	0	34235370	21529798	0	18038486	2118129	75921783	7920287	5487886	0	8379252	4377647	26165072	20477729	17913789	-3802430	0	21367322	3243253	0	1003127	0	0	0	-6475599	898122	54625313	21677928	12906325	0	11526015	1351274	47461542	386039	77067	8705063	27793605	0	0	0	0	0
106334068	1999	4	RANCHO SPRINGS MEDICAL CENTER	MURRIETA	12	1109	1	01011999	"12311999"	99	99	87	913	562	22	3505	149	5151	403	5000	8269	52	12769	482	26572	11666	5187	2614	261	29632	4267	41961	33967211	21561440	12405771	0	16094305	8273732	181222	48301039	2260054	75110352	5411649	2572233	219198	31536395	3596528	43336003	16233342	6874825	0	0	67215400	2514496	0	1001515	0	0	0	-12125252	1371039	83085365	5272612	3971140	400420	23215852	2500966	35360990	252160	-260880	3026023	19490674	0	0	0	0	0
106361308	1999	4	REDLANDS COMMUNITY HOSPITAL	REDLANDS	12	1209	1	01011999	"12311999"	172	172	172	1386	891	11	9150	150	11588	0	8622	4234	36	36053	726	49671	0	17738	11200	12	112589	7485	149024	69886498	53464056	16422442	0	24552710	10867944	148362	128331200	2488264	166388480	8828264	2337700	9140	36249986	3682629	51107719	21790773	9981493	0	157502	140762047	1455286	0	503870	0	0	0	-29793847	4807432	149664556	11590201	3224151	0	51653830	1363461	67831643	823021	2905612	7171968	31717959	0	0	0	0	0
106331312	1999	4	RIVERSIDE COMMUNITY HOSPITAL	RIVERSIDE	12	1111	2	01011999	"12311999"	369	329	329	2617	1018	191	11370	1011	16207	878	17444	5220	843	43227	4020	70754	6836	7782	5155	459	38094	10986	62476	116783471	98429812	18353659	1306625	58025952	18407811	6293458	159591931	18560086	260879238	6005850	2719170	591997	29692874	9549978	48559869	39833525	18781024	0	6196910	139478226	8540705	0	378682	0	0	0	-27842135	12014637	197381574	24198277	2345957	688545	77648714	7176040	112057533	938221	575152	1885449	44212461	0	0	0	0	0
106334487	1999	4	RIVERSIDE COUNTY REGIONAL MED CTR	MORENO VALLEY	12	1109	4	01011999	"12311999"	384	359	359	903	5220	3254	3170	1115	13662	0	5817	26938	17488	18026	5795	74064	0	6061	47595	72955	28416	15180	170207	227477951	159779744	67698207	0	12374789	71594520	44665272	43253799	16471772	188360152	2855568	20640745	31812588	15849366	6928592	78086859	8791004	54274200	-27240410	60794827	39703623	18486674	0	0	0	0	0	-1982884	0	152827034	6439353	65201475	15683033	21382426	4913690	113619977	17026159	25585042	9963547	210012694	37837788	0	0	0	0
106331314	1999	4	RIVERSIDE GENERAL HOSP-MENTAL HEALTH FAC	RIVERSIDE	12	1111	4	01011999	"06301999"	77	77	77	161	475	467	230	0	1333	0	1564	3670	3007	1293	0	9534	0	287	856	770	568	0	2481	8680053	7572127	1107926	0	1126597	2763400	2297958	1026958	0	7214913	145652	296410	330830	286362	0	1059254	660794	703998	-3000000	1333729	1063788	82743	0	0	0	0	0	0	0	845052	611455	5355812	1295059	166789	0	7429115	0	2734485	0	5570002	0	0	0	0	0
106331313	1999	4	RIVERSIDE GENERAL HOSP-UNIV MED CTR	RIVERSIDE	12	1111	4	99999999	"00000000"	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	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