Table: 1997_quarter_4_sum_of_four_quarters , fac_name like E*

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
106320859	1997	4	EASTERN PLUMAS HEALTH CARE	PORTOLA	01	0217	5	010197	"123197"	24	24	24	226	57	6	96	53	438	36	1467	4936	12	201	284	6900	5823	20665	5478	465	16369	4211	47188	6675781	2867113	3808668	1026762	2262248	1370368	29707	603210	223995	4489528	2768076	770141	75867	1837881	504377	5956342	1948436	1102870	0	46017	214533	445213	0	53521	0	0	0	0	349551	4160141	3081888	1037639	54463	1868737	243002	6285729	57087	389725	502312	2481647	0	0	0	0	0
106094002	1997	4	EL DORADO COUNTY MENTAL HEALTH-PHF	PLACERVILLE	02	0304	4	010197	"123197"	15	10	10	0	0	0	404	0	404	0	0	0	0	2377	0	2377	0	0	0	0	0	0	0	1200988	1200988	0	0	0	0	0	1200988	0	1200988	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1200988	0	1200988	302184	0	0	0	0	0	0	0	0
106071053	1997	4	EAST BAY HOSPITAL	RICHMOND	05	0413	2	010197	"071497"	87	78	25	212	0	12	130	1	355	0	2390	0	127	1479	7	4003	0	2175	0	0	49	0	2224	3108408	2795167	313241	51527	2899281	0	154429	1791403	9076	4854189	524386	0	0	12762	0	537148	2086896	0	-324305	136220	1278167	361233	0	0	0	0	0	0	7320	3545531	1336771	205720	18209	574287	-289181	1845806	162424	53412	3150	0	0	0	0	0	0
106010805	1997	4	EDEN MEDICAL CENTER	CASTRO VALLEY	05	0421	5	010197	"123197"	258	245	216	2951	656	14	4606	642	8869	508	15759	3855	48	15993	6638	42293	13045	31972	5609	0	67901	11615	117097	66049297	50061681	15987616	2229431	38797337	9851848	290288	54458691	12681631	116079795	9864974	1742394	0	20904494	4573084	37084946	21188105	9589587	0	-214295	50296518	7512306	0	0	0	0	0	-1947701	455522	86880042	27474206	2004655	504583	19502062	16799193	66284699	1854274	3901863	1672372	17637675	0	0	0	0	0
106500867	1997	4	EMANUEL MEDICAL CENTER	TURLOCK	06	0516	1	010197	"123197"	318	318	270	1993	1675	0	3244	243	7155	577	14454	35974	0	14129	10692	75249	50060	25308	15569	0	33849	18605	93331	56277432	37592901	18684531	0	29623124	17042049	0	30922850	2898536	80486559	10115251	6902592	0	20936934	1950160	39904937	21245759	16910119	0	0	34960145	1586622	0	795651	0	0	0	-10234191	424808	65688913	20034655	7034522	0	24005168	3628238	54702583	771087	5025674	2563202	34081346	0	0	0	0	0
106430763	1997	4	EL CAMINO HEALTHCARE SYSTEM	MOUNTAIN VIEW	07	0429	1	122996	"011098"	426	319	248	4830	909	13	12889	364	19005	5	20583	2087	43	36693	849	60255	1092	102511	7741	22	177213	13356	300843	154809192	111087233	43721959	0	73098872	6833311	143696	152091442	3955202	236122523	46095335	1884380	25380	41739706	3201423	92946224	62406383	7747626	0	169076	102552630	3519899	0	163355	0	0	0	-14676387	1558509	163441091	56787823	970065	0	87758619	20111149	165627656	11809770	-8658336	3476884	111411853	0	0	0	0	0
106190256	1997	4	EAST LOS ANGELES DOCTOR'S HOSPITAL	LOS ANGELES	11	0925	2	010197	"123197"	127	127	127	602	723	0	504	237	2066	39	3466	10474	0	1615	901	16456	8217	1850	4374	0	3935	3164	13323	15858111	13131822	2726289	0	8134553	19772586	0	4786891	1333996	34028026	1777797	2314356	0	1957939	1127689	7177781	3793476	18324463	-4234209	0	6211777	1094269	0	0	0	0	0	-3366793	983942	22806925	6118874	7996688	0	533053	3750267	18398882	383381	-23291	610680	6635602	0	0	0	0	0
106190260	1997	4	EDGEMONT HOSPITAL	LOS ANGELES	11	0925	2	010197	"123197"	61	61	61	1182	78	0	0	213	1473	0	17737	846	0	0	1375	19958	0	5252	0	0	0	282	5534	9581741	8951512	630229	0	20102959	987729	0	0	1540480	22631168	1514998	0	0	0	79193	1594191	13013177	515272	0	0	0	0	0	0	0	0	0	0	1228955	14757404	8604780	472457	0	0	390718	9467955	7809	0	27882	126756	0	0	0	0	0
106190280	1997	4	ENCINO TARZANA RGNL MC - ENCINO	ENCINO	11	0905	2	010197	"123197"	151	151	76	2530	87	0	829	38	3484	0	21986	764	0	4527	183	27460	0	9479	755	2	9469	1722	21427	54724620	41556291	13168329	0	77339334	3700348	0	19815608	905117	101760407	11043095	867354	800	16853797	1973679	30738725	65327778	3077469	0	0	28322057	839802	0	21496	0	0	0	-166218	13061	97435445	23054651	1490233	800	7928602	2589401	35063687	187293	-116284	5114648	7953055	0	0	0	0	0
106190517	1997	4	ENCINO TARZANA RGNL MC - TARZANA	TARZANA	11	0905	2	010197	"123197"	233	233	142	3038	2109	2	5765	202	11116	0	19353	8945	3	22836	520	51657	0	14217	4642	7	23208	4605	46679	118125585	96032684	22092901	0	142257631	56575008	24019	154224401	3458976	356540035	21107515	6319088	12094	47136566	5806885	80382148	123522342	53693199	0	0	151516560	4102395	0	109570	0	0	0	-262005	2316557	334998618	39842804	9200897	36113	47191219	5652532	101923565	1462546	565932	5175715	23528558	0	0	0	0	0
106331168	1997	4	EISENHOWER MEDICAL CENTER	RANCHO MIRAGE	12	1105	1	010197	"123197"	261	261	261	6030	1111	38	6296	352	13827	0	30502	3151	140	20965	1191	55949	0	169113	12438	193	122370	28750	332864	145908253	100546183	45362070	0	115979701	10778495	299143	92176339	1938617	221172295	44703014	3327089	205955	47223067	3954244	99413369	89399741	11043027	0	988307	81019471	3124509	0	251563	0	0	0	-2613090	1333888	184547416	71282974	3062557	-483209	60993025	1182901	136038248	7717245	12865617	9458087	127601998	0	0	0	0	0
106130699	1997	4	EL CENTRO REGIONAL MEDICAL CENTER	EL CENTRO	14	1424	4	010197	"123197"	107	107	107	2020	1907	136	1902	834	6799	0	10352	6215	452	4322	3406	24747	0	17273	50198	4469	17726	9062	98728	42820542	28621031	14199511	3825947	28532888	15369915	1284700	12731195	9417192	67335890	9765593	9904852	1452318	8459092	3755297	33337152	19097934	18279371	0	603097	6631299	5322217	0	556622	-37500	0	0	0	4526653	54979693	19200547	6995396	2133921	9236771	8126714	45693349	323893	666564	2354914	9749575	0	0	0	0	0