Table: 1997_quarter_4_sum_of_four_quarters , fac_name like N*

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
106040962	1997	4	N T ENLOE MEMORIAL HOSPITAL	CHICO	01	0219	1	010197	"123197"	208	208	208	4371	2267	329	4270	353	11590	0	24158	6240	1579	13992	658	46627	0	61598	45531	3152	54822	26369	191472	109787075	74220447	35566628	0	73620106	16620368	5562396	52140984	1965851	149909705	24362056	11341767	1971667	29240907	4919767	71836164	51676509	18709526	0	5029947	27262243	4822534	0	280017	0	0	0	0	1571455	109352231	46305653	9252609	2504116	49297114	5034146	112393638	992056	764786	6964784	54071831	0	0	0	0	0
106281266	1997	4	NAPA STATE HOSPITAL	IMOLA	03	0407	3	010197	"123197"	1362	842	842	3	23	0	84	508	618	0	388	49808	0	34196	210452	294844	0	0	0	0	0	0	0	106141628	106141628	0	0	1709305	17871083	0	352028	72971825	92904241	0	0	0	0	0	0	28144	0	0	0	701	0	0	0	0	0	0	0	70865429	70894274	1681161	17871083	0	351327	2106396	22009967	0	84131661	0	0	0	0	0	0	0
106281297	1997	4	NELSON M HOLDERMAN MEMORIAL HOSPITAL	YOUNTVILLE	03	0407	3	010197	"123197"	888	742	742	560	219	0	556	0	1335	0	4958	19283	0	166042	0	190283	0	13384	0	0	45369	0	58753	43048844	35796341	7252503	0	910013	3537696	0	30468349	0	34916058	1611267	0	0	5458241	0	7069508	-1593747	1658036	0	0	34596870	0	0	0	0	0	0	0	0	34661159	4115027	1879660	0	1329720	0	7324407	117660	35606777	421883	23030461	0	0	0	0	0
106481357	1997	4	NORTH BAY MEDICAL CENTER	FAIRFIELD	03	0408	1	010197	"123197"	132	132	132	1105	386	123	3464	66	5144	276	5544	1192	478	12037	147	19398	3313	25055	2685	1897	38846	5131	73614	54441764	34349630	20092134	0	31188643	7566495	3220259	77368226	851922	120195545	12640943	2024506	2389646	49506636	3696872	70258603	28469537	7953156	0	4326792	77633585	3953826	0	597008	0	0	0	0	1981783	124915687	15166331	1391150	1283113	45817678	1880189	65538461	364055	982558	1614995	23455028	0	0	0	0	0
106490907	1997	4	NORTH COAST REHABILITATION CTR-SOTOYOME	SANTA ROSA	03	0401	2	010197	"123197"	119	118	118	1131	25	6	947	13	2122	687	17450	375	58	12200	193	30276	11887	16652	1288	200	42039	545	60724	17782306	13767032	4015274	0	14085705	454313	79361	11132494	104800	25856673	2948450	163665	12515	4329606	99613	7553849	6352783	0	0	429	7477795	45000	0	0	0	0	0	0	8356	13884363	10681372	617978	91447	7984305	151057	19526159	91765	175933	329634	1435677	0	0	0	0	0
106212637	1997	4	NOVATO COMMUNITY HOSPITAL	NOVATO	04	0405	1	010197	"123197"	64	63	33	904	180	12	1010	65	2171	147	3997	721	39	3928	263	8948	1911	10039	2866	372	25846	2129	41252	22830490	15334017	7496473	0	15885929	2527731	162119	14133962	672502	33382243	3826493	911456	191863	10374834	931362	16236008	10204442	2826755	0	314293	9471430	645814	0	84563	-5645	0	0	0	575949	24117601	9507980	612432	39689	15037366	303183	25500650	138050	-114550	735533	4664175	0	0	0	0	0
106270831	1997	4	NATIVIDAD MEDICAL CENTER	SALINAS	08	0705	4	010197	"123197"	211	181	181	808	3243	615	1678	238	6582	209	4268	16930	2161	6460	952	30771	15915	16946	58262	23565	40711	12996	152480	67684831	47209840	20474991	4323249	12956021	45680245	9852039	20038038	4292049	92818392	4174650	14827010	7293148	9416380	3944205	39655393	7848024	38922135	-7192452	13967723	10194605	6615740	0	909467	-2489881	0	0	0	1594260	70369621	9282647	28777572	2829013	16568947	4645985	62104164	4191553	702775	36702913	127279926	0	0	0	0	0
106190559	1997	4	NEWHALL COMMUNITY HOSPITAL	NEWHALL	11	0903	2	010197	"122997"	14	9	9	305	0	0	61	4	370	0	1769	0	0	332	9	2110	0	695	440	0	1707	8	2850	3331996	2893126	438870	0	2536289	0	0	574199	23904	3134392	265909	55211	0	137144	16951	475215	291429	33126	0	0	213152	0	0	0	0	0	0	-103970	14277	448014	2510769	22085	0	602161	26578	3161593	10592	0	21752	722095	0	0	0	0	0
106190654	1997	4	NORTH HOLLYWOOD MEDICAL CENTER	NORTH HOLLYWOOD	11	0907	2	010197	"123197"	160	160	96	1137	2010	0	1358	272	4777	0	9260	19986	0	4645	834	34725	0	4074	4613	0	9644	4849	23180	35971961	27154807	8817154	0	36685565	43061075	0	31059984	6119638	116926262	6391344	5698734	0	19984965	5835218	37910261	29323514	43275724	0	0	55564657	5642794	0	649668	0	0	0	-15199820	11202	119267739	13753395	5484085	0	2783656	13547648	35568784	167574	24353	1987407	13969654	0	0	0	0	0
106190568	1997	4	NORTHRIDGE HOSPITAL MEDICAL CENTER	NORTHRIDGE	11	0905	1	010197	"123197"	435	356	356	4779	2305	63	7307	440	14894	0	37260	11120	419	48794	978	98571	0	28412	13991	4797	112119	6895	166214	161165459	125632596	35532863	0	106043142	43518985	1262069	175588152	1921611	328333959	15843191	7797254	2207384	62586319	4335898	92770046	74994509	42783351	0	3101430	181175067	5336065	3403416	689250	-469206	0	0	-49222450	7467541	269258973	46891824	7986011	368023	93887454	2711720	151845032	2594089	5320414	3679000	75920000	0	11734	28986	15394609	15394609
106190810	1997	4	NORTHRIDGE HOSPITAL MEDICAL CTR-SHERMAN	VAN NUYS	11	0905	1	010197	"123197"	211	210	210	2206	2753	0	1646	190	6795	0	17569	9262	0	6705	725	34261	0	10802	8598	0	13963	2309	35672	40572623	31398141	9174482	0	32907907	20887765	0	17450577	580150	71826399	6347438	5045789	0	8199366	1359794	20952387	16339191	19806505	-1901709	0	18747060	1875113	0	1520967	0	0	0	-4187183	483733	52683677	22916154	8028758	0	8731220	418977	40095109	1382833	351869	1028852	15916543	0	917	1691	1088964	1088964
106361458	1997	4	NEEDLES-DESERT COMMUNITIES HOSPITAL	NEEDLES	12	1215	2	010197	"123197"	53	40	40	757	192	0	576	116	1641	0	2722	450	0	1609	332	5113	0	2984	2803	0	4710	2130	12627	11833461	7776246	4057215	413939	5562066	1379481	0	4052408	1631697	12625652	1561522	1270798	0	2110610	1556296	6499226	2711641	1355839	0	0	1561484	1382843	425750	92018	0	0	0	0	0	7529575	4411947	1294440	0	4076092	1812824	11595303	351311	62168	1738455	1714885	0	0	0	0	0
106141273	1997	4	NORTHERN INYO HOSPITAL	BISHOP	12	1203	5	010197	"123197"	32	32	30	428	284	60	491	58	1321	0	1671	630	195	1145	154	3795	0	8008	2722	697	10681	1522	23630	19019513	10000034	9019479	964152	6554920	1916759	769900	4879921	425894	14547394	4171407	1350259	537016	6229462	800909	13089053	4484736	1843800	0	704865	267599	404108	0	119609	0	0	0	0	139115	7963832	6241591	1423219	602051	10437675	968079	19672615	245161	951240	1241760	4071724	0	0	0	0	0
106301304	1997	4	NEWPORT BAY HOSPITAL	NEWPORT BEACH	13	1016	2	010197	"123197"	34	34	34	314	0	0	0	17	331	0	7251	0	0	0	153	7404	0	0	0	0	0	0	0	7611180	7611180	0	0	9287794	0	0	0	258135	9545929	0	0	0	0	0	0	1963252	0	0	0	0	0	0	0	0	0	0	0	0	1963252	7324542	0	0	0	258135	7582677	0	43607	55785	139439	0	0	0	0	0