Table: 1997_quarter_4_sum_of_four_quarters , fac_name like T*

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
106531059	1997	4	TRINITY GENERAL HOSPITAL	WEAVERVILLE	01	0207	4	010197	"123197"	65	60	60	382	237	14	190	80	903	75	2331	6622	36	528	1890	11407	8919	8219	2782	367	4419	1380	17167	8402924	5373585	3029339	0	2927694	2487134	115683	965510	752120	7248141	1728994	796218	144629	1035795	377689	4083325	591193	1269802	-57124	139931	537570	383036	0	43837	0	0	0	0	303	2908548	4065495	2070674	120381	1463735	702633	8422918	323085	121977	178468	2789556	152890	0	0	0	0
106291053	1997	4	TAHOE FOREST HOSPITAL	TRUCKEE	02	0302	5	010197	"123197"	72	72	57	675	267	15	931	224	2112	25	3420	13216	38	2458	746	19878	12874	17491	4729	244	33947	9969	66380	31430142	16752274	14677868	0	8188493	4594762	181531	8493218	1731818	23189822	4280252	990923	201772	11790419	3003569	20266935	5276249	2072227	0	252347	3875326	2760756	0	605634	0	0	0	0	-52809	14789730	7192496	3513458	130956	15165070	2665047	28667027	692030	1886071	3776276	30486815	0	0	0	0	0
106484028	1997	4	TELECARE SOLANO - PHF	FAIRFIELD	03	0408	2	010197	"123197"	16	16	16	115	188	79	0	97	479	0	1199	1697	895	0	652	4443	0	0	0	0	0	0	0	2103604	2103604	0	123782	646200	1084800	571200	0	371076	2673276	0	0	0	0	0	0	193860	206768	0	140894	0	38773	0	0	0	0	0	0	44143	624438	423260	878032	430306	0	317240	2048838	0	96	0	4176	0	0	0	0	0
106010782	1997	4	THUNDER ROAD CHEMICAL DEPNDCY RCVRY HOSP	OAKLAND	05	0417	1	010197	"123197"	50	50	50	0	0	69	132	19	220	0	0	0	9598	5715	777	16090	0	0	0	0	0	0	0	3474946	3474946	0	0	0	0	2222116	1929723	253689	4405528	0	0	0	0	0	0	0	0	0	665156	201465	149688	0	139630	0	0	0	0	0	1155939	0	0	1556960	1578570	114059	3249589	313911	10170	106862	187799	0	0	0	0	0
106551061	1997	4	TUOLUMNE GENERAL HOSPITAL	SONORA	06	0513	4	010197	"123197"	80	80	80	694	601	148	284	127	1854	31	3907	14254	990	710	881	20742	12939	37626	28738	3767	12932	13416	96479	20737166	10077358	10659808	1451410	6728940	5737761	1707061	1586020	617972	16377754	6048530	4731609	1197485	2666267	2668196	17312087	4607354	4997145	-364080	1859413	1843311	628482	0	373441	0	0	0	0	705254	14650320	8170116	5835878	1045133	1780494	2207900	19039521	821976	648597	1359249	3575589	266733	0	0	0	0
106400548	1997	4	TWIN CITIES COMMUNITY HOSPITAL	TEMPLETON	08	0801	2	010197	"123197"	84	84	48	1493	469	46	2186	68	4262	0	7101	1896	224	7942	240	17403	0	12291	8766	415	31028	6445	58945	30550809	21681625	8869184	0	33157324	9209939	1409897	41596386	1927030	87300576	7874404	4159495	429128	20745456	2384484	35592967	29768978	12768458	0	1341491	45997073	2326697	0	37397	0	0	0	-3856505	62820	88446409	11262750	600976	497534	19235702	2850172	34447134	173338	-363150	1179175	11607117	0	0	0	0	0
106150808	1997	4	TEHACHAPI HOSPITAL	TEHACHAPI	09	0623	5	010197	"123197"	28	28	21	55	27	3	35	4	124	30	698	4140	6	139	481	5464	5148	3791	12184	15	10131	1788	27909	6363405	1262890	5100515	0	448627	1195631	15967	336687	134644	2131556	1239711	3744607	5231	2977735	623542	8590826	906246	2853755	-1350	21198	917988	216019	0	220978	-22712	0	0	0	0	5112122	782092	2087833	13322	2396434	330579	5610260	9682	797307	668248	2541463	0	0	0	0	0
106540816	1997	4	TULARE DISTRICT HOSPITAL	TULARE	09	0611	5	010197	"123197"	112	79	79	1658	2005	110	1231	250	5254	0	8817	4174	324	3169	499	16983	0	26283	39725	1608	20354	8194	96164	34836922	17943398	16893524	0	16881220	8396013	491091	7190767	2892491	35851582	7879865	10433446	945431	10205134	4063380	33527256	10138982	14036935	0	966758	7015514	2759410	0	0	0	0	0	0	594141	35511740	14622103	4792524	469764	7620977	6361730	33867098	1384066	1323030	864047	22071033	0	0	0	0	0
106190782	1997	4	TARZANA TREATMENT CENTER	TARZANA	11	0905	1	010197	"123197"	38	38	22	0	0	368	654	0	1022	0	0	0	4230	3688	0	7918	0	0	0	2513	0	0	2513	1582160	1533500	48660	0	0	0	2115000	1844000	0	3959000	0	0	126699	0	0	126699	0	0	0	1095922	611029	0	0	0	0	0	0	0	0	1706951	0	0	1145777	1232971	0	2378748	0	0	0	0	0	0	0	0	0
106190784	1997	4	TEMPLE COMMUNITY HOSPITAL	LOS ANGELES	11	0925	2	010197	"123197"	170	130	130	1941	1109	0	358	108	3516	0	14107	10069	0	882	139	25197	0	4340	1822	0	1247	248	7657	28937756	19508418	9429338	0	33441401	19523588	0	3131410	467107	56563506	16311689	6296142	0	3295268	1377021	27280120	26167176	19569916	0	0	3664019	246668	0	221327	0	0	0	-134000	321723	50056829	23585914	6249814	0	2762659	1188410	33786797	167207	0	441086	2743163	0	0	0	0	0
106190114	1997	4	THOMPSON MEMORIAL MEDICAL CENTER	BURBANK	11	0907	2	010197	"033197"	105	105	105	334	130	0	100	22	586	0	1741	651	0	384	80	2856	0	747	633	0	475	438	2293	5743513	4231460	1512053	296444	7092690	2874327	0	2805569	470528	13243114	2195574	1067599	0	1154154	314916	4732243	5825442	3728893	0	0	2042217	505843	0	0	0	0	0	0	248494	12350889	3462822	213033	0	1411663	536950	5624468	128612	15332	163389	0	0	0	0	0	0
106191225	1997	4	TOM REDGATE MEMORIAL RECOVERY CENTER	LONG BEACH	11	0933	1	010197	"123197"	63	63	63	0	0	1321	0	18	1339	0	0	0	14789	0	80	14869	0	0	0	0	0	0	0	2382282	2382282	0	134460	0	0	2692852	0	21753	2714605	0	0	0	0	0	0	0	0	0	134047	0	0	0	0	0	0	0	0	0	134047	0	0	2558805	0	21753	2580558	7401	0	29035	2448055	0	0	0	0	0
106190422	1997	4	TORRANCE MEMORIAL MEDICAL CENTER	TORRANCE	11	0931	1	010197	"123197"	380	360	360	4128	1360	0	15262	965	21715	0	24901	4441	0	55622	3301	88265	0	19561	4170	0	98236	6750	128717	148020222	116679597	31340625	0	78760291	18614364	0	219340727	15206446	331921828	15152438	2307915	0	67384773	4035526	88880652	58766748	14893794	0	0	222402240	6963643	0	1210475	0	0	0	-38313608	0	265923292	35145981	6028485	0	102636868	11067854	154879188	0	7495074	16235084	81614370	0	0	0	0	0
106190159	1997	4	TRI-CITY REGIONAL MEDICAL CENTER	HAWAIIAN GARDENS	11	0921	1	010197	"123197"	137	125	125	907	855	0	627	42	2431	0	5427	3664	0	2649	259	11999	0	211	640	0	1379	465	2695	14941212	13631320	1309892	0	9901192	5792547	0	6720471	235048	22649258	205395	359126	0	1184925	229803	1979249	5385314	3916579	0	0	4387678	79559	0	0	0	0	0	0	194699	13963829	4721273	2235094	0	3411160	297151	10664678	75492	1763563	66000	66000	0	0	0	0	0
106301127	1997	4	THC ORANGE COUNTY	BREA	13	1011	2	010197	"123197"	48	48	33	169	0	0	18	1	188	0	6584	0	0	689	3	7276	0	0	0	0	0	0	0	9513674	9513674	0	0	16888413	0	0	2132098	6684	19027195	0	0	0	0	0	0	8126151	0	0	0	312168	131392	0	6684	0	0	0	0	-252141	8324254	8762262	0	0	1940679	0	10702941	173849	-490336	465295	8649514	0	0	0	0	0
106301357	1997	4	TUSTIN HOSPITAL MEDICAL CENTER	TUSTIN	13	1015	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
106304079	1997	4	TUSTIN REHABILITATION HOSPITAL	TUSTIN	13	1015	2	010197	"123197"	117	117	117	516	55	0	167	1	739	0	10576	1369	0	2934	95	14974	0	2214	29	0	1020	0	3263	13760309	13268521	491788	0	14619559	1997243	0	4224091	195688	21036581	518606	6859	0	241665	0	767130	6813238	663306	0	0	1631897	232918	0	0	0	0	0	0	5688	9347047	8324927	1340796	0	2600941	190000	12456664	25770	0	58005	443488	0	0	0	0	0
106374225	1997	4	THC - SAN DIEGO	SAN DIEGO	14	1418	2	010197	"123197"	10	10	10	38	0	0	14	0	52	0	1290	0	0	588	0	1878	0	0	0	0	0	0	0	5358140	5358140	0	42000	4521929	0	0	1721672	0	6243601	0	0	0	0	0	0	2453320	0	0	0	765459	0	0	0	0	0	0	0	0	3218779	2068609	0	0	956213	0	3024822	0	0	210450	1459694	0	0	0	0	0
106370780	1997	4	TRI-CITY MEDICAL CENTER	OCEANSIDE	14	1414	5	010197	"123197"	397	397	397	4105	2562	114	8994	813	16588	688	23748	7215	378	33764	3554	68659	5242	57652	13294	5	122754	19766	213471	130425033	92974496	37450537	393731	67191398	18473080	1304314	125646550	9340783	221956125	20618553	5598277	1372	55118354	7959590	89296146	43694532	19672644	-97212	-202371	115566615	10226690	0	1815420	-139316	0	0	-959711	1364645	190941936	43403843	3630587	815560	65573212	6887133	120310335	2645947	7378406	6344639	105288626	0	0	0	0	0