Table: 1997_quarter_4_sum_of_four_quarters , fac_name like A*

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
106010846	1997	4	ALAMEDA COUNTY MEDICAL CENTER	OAKLAND	05	0417	4	010197	"123197"	613	454	428	1823	5982	2269	1410	1761	13245	107	18791	74754	9384	9596	8380	120905	24360	11550	51339	76738	12263	26424	178314	198572973	140684371	57888602	0	30979237	82799362	27754491	17550380	13287127	172370597	5671167	17769882	31406489	6679269	9547844	71074651	8999590	9379118	-123486777	19538619	38658654	26798376	0	523617	-2693005	0	0	0	3188196	-19093612	27650814	205639841	39622361	-14429005	4054849	262538860	13682922	7328672	5881070	40066116	1165800	0	0	0	0
106010735	1997	4	ALAMEDA HOSPITAL	ALAMEDA	05	0417	1	010197	"123197"	142	142	142	1662	344	15	2110	111	4242	546	10385	1674	38	8796	363	21256	4846	16947	6579	80	38611	3884	66101	35600090	26902673	8697417	241329	42496904	7440473	144000	37392249	2317987	89791613	7200171	2940705	25840	16491625	2209421	28867762	35821000	8249000	0	86000	44076634	1878000	0	457000	0	0	0	-8742417	1381610	83206827	13876075	2132178	83840	18549657	810798	35452548	160244	746829	574694	13197367	0	0	0	0	0
106010739	1997	4	ALTA BATES MEDICAL CENTER	BERKELEY	05	0415	1	122996	"122797"	527	482	482	5701	3992	101	10484	1064	21342	1068	40394	31733	711	46643	4221	123702	25356	252526	21671	2694	184296	25770	486957	318562009	235304846	83257163	7449956	175350813	146665612	1793979	256448353	25068200	605326957	73220751	15640066	443309	103588502	21369543	214262171	142387034	130264809	0	1529848	255936503	10523268	0	9025175	0	0	0	-34404010	4273814	519536441	106184529	32040869	707440	127981094	33138755	300052687	17736433	2455750	24751237	106215297	0	0	0	0	0
106431013	1997	4	AGNEWS STATE HOSPITAL	SAN JOSE	07	0431	3	010197	"123197"	1290	1239	573	24	23	0	2	3	52	0	904	205935	0	154	2199	209192	0	0	0	0	0	0	0	79181753	79181753	0	0	894443	79506535	0	160442	5915076	86476496	0	0	0	0	0	0	19506	0	0	0	12	0	0	0	0	0	0	0	3858652	3878170	874937	79506535	0	160430	2056424	82598326	0	-3416573	0	0	0	0	0	0	0
106430705	1997	4	ALEXIAN BROTHERS HOSPITAL	SAN JOSE	07	0431	1	010197	"123197"	204	204	182	2397	2763	40	6134	211	11545	0	14791	11983	168	14843	2185	43970	0	26203	26420	10	51298	9625	113556	86666371	64126960	22539411	5463253	55557649	46978540	565872	66760140	7765653	177627854	14138485	11831132	6018	30817759	5434294	62227688	38934441	47188368	-5566220	571890	65830561	7719234	0	1826751	0	0	0	-7581423	1355067	150278669	30761693	17187523	0	39328761	2298896	89576873	605158	538259	4648969	36729027	0	0	0	0	0
106400466	1997	4	ARROYO GRANDE COMMUNITY HOSPITAL	ARROYO GRANDE	08	0801	1	010197	"123197"	79	65	25	1007	205	31	899	29	2171	0	4619	969	81	3048	205	8922	0	20149	11364	355	20473	7513	59854	18477602	11182579	7295023	0	11619140	2525440	189766	8203333	517207	23054886	5315475	2088825	65707	6418012	1001530	14889549	7536340	3681688	0	232729	7405908	601695	0	388278	0	0	0	0	50934	19897572	9398275	932577	22744	6613742	1079525	18046863	171952	187317	1383082	13738614	0	0	0	0	0
106400683	1997	4	ATASCADERO STATE HOSPITAL	ATASCADERO	08	0801	3	010197	"123197"	1061	1010	988	2	0	0	1	1315	1318	0	644	0	0	220	357756	358620	0	0	0	0	0	0	0	92079705	92079705	0	0	817995	0	0	67287	106684101	107569383	0	0	0	0	0	0	27	0	0	0	0	0	0	0	0	0	0	0	105855232	105855259	817968	0	0	67287	828869	1714124	0	90365581	0	0	0	0	0	0	0
106540680	1997	4	ALTA HOSPITAL DISTRICT	DINUBA	09	0608	5	010197	"123197"	50	50	50	791	254	7	164	212	1428	165	4550	855	20	535	657	6617	2298	5071	5152	181	4115	2718	17237	8418199	4898286	3519913	761320	4559971	1103828	25805	787563	1032662	7509829	1607678	1456164	70516	1264022	979813	5378193	1810283	1845119	0	24526	624852	1020890	0	70096	0	0	0	0	0	5395766	4357366	714873	71795	1426733	921489	7492256	725991	216231	401800	1274480	0	0	0	0	0
106560468	1997	4	ANACAPA HOSPITAL	PORT HUENEME	10	0811	2	010197	"123197"	48	48	48	309	59	0	437	45	850	0	3794	655	0	6649	433	11531	0	8767	0	0	0	0	8767	7810264	6025415	1784849	899401	4497742	761805	0	7666170	655518	13581235	3970427	0	0	0	0	3970427	3376726	416836	0	0	4847241	540053	0	0	0	0	0	0	0	9180856	4794821	344969	0	2646864	584152	8370806	149693	0	2250	11031	0	0	0	0	0
106190017	1997	4	ALHAMBRA HOSPITAL - ALHAMBRA	ALHAMBRA	11	0913	2	010197	"123197"	144	144	144	1563	591	0	580	125	2859	333	14573	14550	0	3432	1092	33647	14836	5801	4152	1	3625	17699	31278	28073947	23313805	4760142	392628	32462465	23340423	0	7965793	2493903	66262584	4709971	3326978	117	2914506	2483236	13434808	25467985	19387379	-3625206	0	6398660	1828193	0	16840	0	0	0	-281215	1792753	50985389	11704451	10905228	117	2934661	3167546	28712003	826182	100569	776091	9838782	0	0	0	0	0
106190020	1997	4	ALHAMBRA HOSPITAL - ROSEMEAD	ROSEMEAD	11	0913	2	010197	"123197"	98	86	49	455	982	0	586	127	2150	0	4165	9034	0	3335	439	16973	0	2821	0	0	592	19	3432	8192583	7475677	716906	328849	7468240	16376133	0	5383044	1447875	30675292	2336624	49540	0	462665	86104	2934933	6400237	12187846	0	0	4456271	1116885	0	0	0	0	0	0	414840	24576079	3404627	4237827	0	763669	628023	9034146	76777	0	1453080	3469189	0	547	4359	1932884	7972119
106194010	1997	4	AMERICAN RECOVERY CENTER	POMONA	11	0917	1	010197	"123197"	156	156	156	0	0	1407	0	161	1568	0	0	0	28248	0	1175	29423	0	0	0	0	0	0	0	4130787	4130787	0	155633	0	0	4180782	0	218982	4399764	0	0	0	0	0	0	0	0	0	64468	0	11205	0	9704	0	0	0	0	10326	95703	0	0	4116314	0	187747	4304061	13612	0	0	3279910	0	0	0	0	0
106190034	1997	4	ANTELOPE VALLEY HOSPITAL MEDICAL CTR	LANCASTER	11	0901	5	010197	"123197"	350	331	324	4118	4096	0	10432	1489	20135	0	33123	16291	0	32696	5656	87766	0	31945	33900	0	75574	21978	163397	119010688	92022026	26988662	0	83178526	47019221	0	108074554	11977249	250249550	13205871	13397630	0	39433196	7346986	73383683	53422851	42242408	0	0	95699349	11732704	0	2067302	0	0	0	-2457181	3369213	206076646	42961546	18174443	0	42243733	14176865	117556587	2199907	5989596	9555315	62271259	0	0	0	0	0
106190045	1997	4	AVALON MUNICIPAL HOSPITAL & CLINIC	AVALON	11	0933	1	010197	"123197"	12	12	12	42	15	2	15	12	86	43	724	1507	2	141	622	2996	2721	1454	1753	147	3597	2920	9871	2223098	1141041	1082057	309713	681669	597349	4452	104316	272430	1660216	301347	273511	29945	457356	581118	1643277	364699	380521	0	3256	117539	244909	0	31399	0	0	0	0	229617	1371940	618317	490338	31141	444133	347624	1931553	37423	117596	12283	216919	0	0	0	0	0
106301109	1997	4	ANAHEIM GENERAL HOSP-BUENA PARK CAMPUS	BUENA PARK	13	1011	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
106301097	1997	4	ANAHEIM GENERAL HOSPITAL	ANAHEIM	13	1012	2	010197	"123197"	122	122	70	1564	1252	49	907	376	4148	0	11956	4169	277	3004	1078	20484	0	15725	3651	780	5865	2613	28634	34675433	24202086	10473347	0	34848227	13304722	1144678	13043710	4364105	66705442	9320926	3145395	410544	13455596	2406810	28739271	22931389	14885172	0	1442535	474520	10629343	0	0	0	0	0	0	3416279	53779238	21237764	1564945	112687	15395443	3354636	41665475	69375	0	940414	6024025	0	0	0	0	0
106301098	1997	4	ANAHEIM MEMORIAL MEDICAL CENTER	ANAHEIM	13	1012	1	010197	"123197"	224	224	192	2701	483	203	5578	286	9251	0	15665	1729	960	24597	1123	44074	0	10210	2649	1010	30502	5136	49507	78338547	60332280	18006267	642896	53270850	6807574	2950185	91496772	3969732	158495113	9371309	1556677	784095	31045990	4287083	47045154	40440116	7215195	0	2877698	99141502	4894531	0	0	-46239	0	0	-26088994	0	128433809	22202043	1149056	856582	44595723	8303054	77106458	3507800	4050600	4281000	44778800	0	0	0	0	0
106370652	1997	4	ALVARADO HOSPITAL MEDICAL CENTER	SAN DIEGO	14	1418	2	010197	"123197"	231	231	98	3599	1474	9	2408	305	7795	0	19694	6193	34	8839	892	35652	0	8045	6016	2	11197	5662	30922	78275927	62359354	15916573	0	117868120	35420228	143305	54619111	6709760	214760524	18862602	8141918	475	22897430	5324105	55226530	95205702	38387682	0	626826	54974593	3346147	0	51248	0	0	0	-5544038	29370	187077530	41525020	5174464	-483046	22325934	14367152	82909524	533363	-662671	2927259	40725950	0	0	0	0	0