Table: 1997_quarter_4_sum_of_four_quarters , fac_name like B*

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
106040802	1997	4	BIGGS-GRIDLEY MEMORIAL HOSPITAL	GRIDLEY	01	0221	1	010197	"123197"	52	52	52	654	181	13	130	72	1050	110	3609	2608	41	476	1988	8722	5357	8217	13766	2022	7366	3147	34518	10040410	4424427	5615983	953428	5541149	1271109	210215	1051052	630089	8703614	4129707	2944744	569419	2567219	758069	10969158	4442377	3242155	0	386017	1166572	246540	0	263371	0	0	0	0	0	9747032	5228479	973698	393617	2451699	878247	9925740	24971	47717	311155	2447249	0	0	0	0	0
106044006	1997	4	BUTTE COUNTY MENTAL HEALTH - PHF	CHICO	01	0219	4	010197	"123197"	16	16	16	0	0	0	1508	0	1508	0	0	0	0	4993	0	4993	0	0	0	0	0	0	0	2260533	2260533	0	0	0	0	0	2294382	0	2294382	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2294382	0	2294382	0	0	0	0	0	0	0	0	0
106090793	1997	4	BARTON MEMORIAL HOSPITAL	SOUTH LAKE TAHOE	02	0306	1	010197	"123197"	81	68	41	1310	664	73	2577	231	4855	0	5309	1397	149	7018	733	14606	0	27686	7875	984	39900	8499	84944	48888045	26230400	22657645	0	15724850	5103009	572127	19539746	2554834	43494566	9090749	3019218	665541	20991444	3800288	37567240	13176355	4762733	0	53307	5120937	5027455	0	1017053	-24158	0	0	0	2108132	31241814	11175244	3359494	1184361	30846798	3254095	49819992	782685	159464	3244309	22873881	0	0	0	0	0
106410715	1997	4	BELMONT HILLS HOSPITAL	BELMONT	04	0428	2	010197	"123197"	84	84	84	339	112	2	822	35	1310	0	3314	1003	12	5839	243	10411	0	844	41	0	1471	317	2673	6195794	5768834	426960	0	4893048	1658634	17958	9078142	451321	16099103	342216	6135	0	770063	65455	1183869	3373643	959710	0	83	5846561	392413	0	0	0	0	0	0	408196	10980606	1673196	663454	6966	3669886	288864	6302366	151979	0	361836	4074795	0	0	0	0	0
106070904	1997	4	BROOKSIDE HOSPITAL	SAN PABLO	05	0413	5	010197	"123197"	239	236	148	3391	1812	10	2523	499	8235	325	19194	8633	64	12853	2746	43490	3802	38106	17722	0	23112	8906	87846	70903453	57237593	13665860	1682917	80631173	33044140	55720	68043227	11256417	193030677	14830263	7946714	0	16320152	6265440	45362569	59091673	33676524	0	35820	57483468	7103748	0	3117269	-48622	0	0	0	4372461	164832341	36369763	7314330	19900	24218756	5638156	73560905	288244	27182	5081508	22525507	0	0	0	0	0
106240803	1997	4	BLOSS MEMORIAL DISTRICT HOSPITAL	ATWATER	06	0515	5	010197	"123197"	23	6	6	162	50	0	31	4	247	0	728	153	0	57	10	948	0	4348	35672	1878	4373	2917	49188	6368245	1109782	5258463	0	1047573	222842	0	90352	17738	1378505	744172	4165886	350094	814107	403748	6478007	805273	1779605	54067	0	376342	408955	0	0	0	0	0	0	0	3424242	986472	2554705	350094	420416	120583	4432270	86497	681090	23870	2752710	0	0	0	0	0
106150722	1997	4	BAKERSFIELD MEMORIAL HOSPITAL	BAKERSFIELD	09	0617	1	010197	"123197"	337	270	270	3839	202	51	6690	174	10956	469	26709	773	240	23122	864	51708	5533	11918	13693	107	29964	4404	60086	83430991	69945787	13485204	776988	67588014	1801260	1766092	72087434	4802182	148044982	7737157	2091315	20619	17360320	1290129	28499540	41594557	2788908	0	1263269	48992254	4155429	33992	1736310	0	0	0	0	212382	100777101	33730614	1103667	523442	36300071	4109627	75767421	1309070	8170750	10346330	76488959	0	0	0	0	0
106190052	1997	4	BARLOW HOSPITAL	LOS ANGELES	11	0925	1	010197	"123197"	111	61	49	205	53	0	40	5	303	0	8136	2371	0	1797	35	12339	0	422	128	0	59	23	632	16546290	16449413	96877	0	28179633	7921805	0	7514370	86958	43702766	130643	71916	0	35501	16399	254459	17874911	6904827	0	0	3292592	205502	0	89746	0	0	0	0	1064	28368642	10425455	1088894	0	4043817	30417	15588583	299440	506737	1284351	4876253	0	0	0	0	0
106190057	1997	4	BAY HARBOR HOSPITAL	HARBOR CITY	11	0933	1	010197	"123197"	338	338	338	991	1194	0	2973	93	5251	771	6558	38764	0	18036	3737	67095	48507	10317	6758	0	30594	3274	50943	52097426	42418042	9679384	627869	16284112	61261277	0	41760250	2102395	121408034	5079374	3358373	0	16710603	2460010	27608360	12913685	45564035	-419251	0	60563365	1711901	0	460200	0	0	0	-23474839	149550	97468646	8449801	19474866	0	19826067	3797014	51547748	639717	1928611	1674669	13105319	0	0	0	0	0
106190066	1997	4	BELLFLOWER MEDICAL CENTER	BELLFLOWER	11	0921	2	010197	"123197"	145	108	108	1798	3042	0	1024	140	6004	0	9381	12307	0	2983	631	25302	0	3157	12965	0	7813	1009	24944	29068956	21251445	7817511	0	29136881	34779316	0	11227245	2445134	77588576	5905934	10813920	0	10943274	936333	28599461	19463529	40091996	-1675055	0	7449350	5286988	0	0	0	0	0	-378331	2132771	72371248	15579286	7176295	0	9812512	1248696	33816789	101917	141428	988211	6459235	0	0	0	0	0
106190069	1997	4	BELLWOOD GENERAL HOSPITAL	BELLFLOWER	11	0921	2	999999	"000000"	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
106190081	1997	4	BEVERLY HOSPITAL	MONTEBELLO	11	0919	1	010197	"123197"	216	216	116	2620	3856	0	3887	243	10606	0	14865	13223	0	13376	647	42111	0	22537	13463	0	23489	4910	64399	64061438	49650699	14410739	696777	55120246	44238732	0	52550886	4621121	156530985	13862129	9267904	0	19526368	2628917	45285318	41205724	43301881	0	0	53147351	2628243	0	2074718	-18996	0	0	-5725728	535042	137148235	27776651	10204755	0	16301660	10385002	64668068	469369	1326074	9994351	27075061	0	0	0	0	0
106190110	1997	4	BROTMAN MEDICAL CENTER	CULVER CITY	11	0927	2	010197	"123197"	437	375	375	4395	1932	0	853	468	7648	0	36269	11104	0	5173	3214	55760	0	36443	8432	0	25538	9915	80328	68588955	56872796	11716159	0	99998347	26217038	0	19063748	10125142	155404275	14180604	3343017	0	10274815	4023005	31821441	65043670	28696351	0	0	24410456	4337884	0	761387	0	0	0	0	0	123249748	49135281	863704	0	3877298	10099685	63975968	1098418	-9605268	5008337	30703889	0	0	0	0	0
106361105	1997	4	BARSTOW COMMUNITY HOSPITAL	BARSTOW	12	1213	2	010197	"123197"	56	42	42	1000	677	0	962	310	2949	707	4886	1871	0	3117	912	10786	2391	4745	6932	0	8363	7154	27194	15199832	9739050	5460782	0	14705675	5633637	0	10000606	3218143	33558061	3497329	4005346	0	6697465	4574177	18774317	11125579	7613805	0	0	8876221	1741200	0	40783	0	0	0	0	1219898	30617486	7077425	2025178	0	7821850	4790439	21714892	63259	-2258159	234263	2719403	0	0	0	0	0
106361110	1997	4	BEAR VALLEY COMMUNITY HOSPITAL	BIG BEAR LAKE	12	1217	5	010197	"123197"	30	30	20	145	79	0	305	53	582	42	538	5314	0	832	277	6961	5598	3292	2864	0	7565	2415	16136	7475150	3466738	4008412	0	868906	1604762	0	1717317	364636	4555621	1368900	740852	0	2414956	749059	5273767	466211	859437	0	0	1449515	889375	0	12537	0	0	0	0	38878	3715953	1771595	1486177	0	1793383	1062280	6113435	37881	0	850344	2239431	0	0	0	0	0
106330120	1997	4	BETTY FORD CENTER OF EISENHOWER, THE	RANCHO MIRAGE	12	1105	1	010197	"123197"	80	80	80	0	0	0	487	631	1118	0	0	0	0	11934	15020	26954	0	0	0	0	1924	3473	5397	12065979	11330166	735813	0	0	0	0	4968000	6929207	11897207	0	0	0	384955	382421	767376	0	0	0	0	942363	227431	0	950536	0	0	0	0	116824	2237154	0	0	0	4183161	6244268	10427429	1591508	5026762	744952	7351124	0	0	0	0	0
106301126	1997	4	BREA COMMUNITY HOSPITAL	BREA	13	1011	2	010197	"123197"	162	162	41	909	59	12	1791	89	2860	0	5257	1454	47	6988	269	14015	0	12287	195	62	22541	1031	36116	32296024	20202949	12093075	0	13881109	3417233	163911	24266925	1078970	42808148	4728766	160805	52440	19936820	708268	25587099	7638229	2656371	0	224984	29396830	1098775	0	70180	0	0	0	-2763714	-618284	37703371	10971646	921666	-8633	16471854	2335343	30691876	238368	593085	835059	20628541	0	0	0	0	0
106370775	1997	4	BAYVIEW HOSPITAL & MENTAL HEALTH SYSTEM	CHULA VISTA	14	1420	2	010197	"123197"	64	64	64	783	232	0	92	84	1191	0	8040	2160	0	1080	536	11816	0	14435	21	0	0	314	14770	8554888	5618536	2936352	0	8663677	2235314	0	745462	563841	12208294	6296527	2600	0	0	58576	6357703	7801776	1279861	0	0	396775	488151	0	0	0	0	0	0	0	9966563	7158428	958053	0	221916	261037	8599434	21572	0	31722	58942	0	0	0	0	0