Table: 1999_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
106281266	1999	4	NAPA STATE HOSPITAL	IMOLA	03	0407	3	01011999	"12311999"	1362	934	934	1	24	0	1	321	347	0	63	29036	0	101	295000	324200	0	0	0	0	0	0	0	119255908	119255908	0	0	213846	3276883	0	34165	97478712	101003606	0	0	0	0	0	0	2274	2915	0	0	5957	0	0	0	0	0	0	0	96909244	96920390	211572	3273968	0	28208	569468	4083216	0	115172692	0	0	0	0	0	0	0
106281297	1999	4	NELSON M HOLDERMAN MEMORIAL HOSPITAL	YOUNTVILLE	03	0407	3	01011999	"12311999"	1076	509	509	380	159	0	575	0	1114	0	1846	16685	0	159039	0	177570	0	12299	0	0	56579	0	68878	58409125	46998589	11410536	0	464216	3043136	0	28987705	0	32495057	1399349	0	0	6462031	0	7861380	-782415	1064728	0	0	33624834	0	0	0	0	0	0	0	0	33907147	2645980	1978408	0	1824902	0	6449290	113126	31515480	0	21375278	0	0	0	0	0
106481357	1999	4	NORTH BAY MEDICAL CENTER	FAIRFIELD	03	0408	1	01011999	"12311999"	132	132	132	1205	366	181	3436	71	5259	264	6261	1135	586	11709	245	19936	2712	19497	2782	1666	59244	5556	88745	64105509	38169255	25936254	0	35710560	6786096	4282780	75823951	1663386	124266773	13954178	1785733	2563543	60995622	4750868	84049944	32845183	7041007	-1455765	5552285	101003595	5861172	0	949433	0	0	0	-13385698	1425393	139836605	16532358	2807278	1294038	45650599	2195839	68480112	1404593	1646433	9598938	29969368	0	0	0	0	0
106490907	1999	4	NORTH COAST HEALTH CARE CTR-SOTOYOME	SANTA ROSA	03	0401	2	01011999	"12311999"	128	128	119	1219	40	0	925	34	2218	0	13756	898	0	10033	283	24970	0	17860	1841	0	47321	596	67618	20802083	15893223	4908860	0	18667099	905300	0	4892152	1165623	25630174	2634568	241234	0	4584172	419710	7879684	6634078	146935	0	0	7064194	735882	0	0	0	0	0	0	0	14581089	14436188	922466	0	2152093	1418022	18928769	40898	0	500076	1922001	0	0	0	0	0
106212637	1999	4	NOVATO COMMUNITY HOSPITAL	NOVATO	04	0405	1	01011999	"12311999"	64	63	33	882	88	42	877	45	1934	318	4227	398	207	3485	166	8483	3014	12814	3021	530	36877	2322	55564	24395975	15623047	8772928	0	21000694	2110420	579037	14706705	614845	39011701	4779983	1039088	219499	14601479	1134793	21774842	17602672	2348421	0	785684	13609593	741632	0	0	-3100	0	0	0	1127	35086029	8178005	801087	12852	15698591	1009979	25700514	211890	23685	11531096	16875588	0	0	0	0	0
106274043	1999	4	NATIVIDAD MEDICAL CENTER (NEW LOCATION)	SALINAS	08	0705	None	07011999	"12311999"	163	161	161	523	1901	309	1138	157	4028	96	2722	13110	1140	3910	367	21249	8399	11894	39369	13688	26876	8298	100125	44175119	31862450	12312669	0	10040014	33410825	6873078	17552362	2416065	70292344	3031990	8234116	4193464	8882458	2837587	27179615	6408847	23460068	-6897295	9495870	17544221	3656800	0	128898	0	0	0	0	0	53797409	6663157	25082168	1552439	8890599	1486187	43674550	816338	-2994973	170592794	145354356	0	0	0	0	0
106270831	1999	4	NATIVIDAD MEDICAL CENTER (OLD LOCATION)	SALINAS	08	0705	4	01011999	"06301999"	274	274	163	535	1641	328	1082	107	3693	103	3284	11400	1081	3455	425	19645	8176	10518	40011	13487	25755	7324	97095	42062017	29418924	12643093	0	10103584	26843095	6126788	14711872	1946267	59731606	2737104	8574224	4000931	7734385	2622801	25669445	6024886	15527949	-6972822	9510819	12975410	3740633	0	101278	0	0	0	0	0	40908153	6815802	26862192	616900	9470847	727157	44492898	1388385	-3301063	3746584	149395256	0	0	0	0	0
106190654	1999	4	NORTH HOLLYWOOD MEDICAL CENTER	NORTH HOLLYWOOD	11	0907	2	99999999	"00000000"	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
106190568	1999	4	NORTHRIDGE HOSPITAL MEDICAL CENTER	NORTHRIDGE	11	0905	1	01011999	"12311999"	435	415	415	3629	2307	88	8068	247	14339	0	35572	9465	497	35453	982	81969	0	21051	8612	4138	56858	9635	100294	170147115	130834192	39312923	0	116323724	42954157	1883655	145645207	3693708	310500451	22547543	8016621	2872719	53075884	6430015	92942782	89668398	43799410	0	4512526	126671533	6665019	1591347	578747	0	0	0	-38940730	7089241	241635491	49202869	7171368	243848	97236028	7953629	161807742	2699264	1506179	12414614	77735236	0	13641	33271	27637504	27637504
106190810	1999	4	NORTHRIDGE HOSPITAL MEDICAL CTR-SHERMAN	VAN NUYS	11	0905	1	01011999	"12311999"	209	209	209	2374	3406	0	1924	229	7933	0	17614	12340	0	7117	650	37721	0	6736	5813	0	13368	2689	28606	46581657	36902808	9678849	0	42125417	30451512	0	21883212	2283657	96743798	5974961	5150615	0	11867446	2387170	25380192	24392798	29874966	-3944422	0	24638537	3647932	0	1881159	0	0	0	-4698439	337318	76129849	23707580	9671583	0	9825310	2789668	45994141	525424	-28805	2904608	16262814	0	1746	4310	2217730	2217730
106141273	1999	4	NORTHERN INYO HOSPITAL	BISHOP	12	1203	5	01011999	"12311999"	32	32	30	483	282	39	398	47	1249	0	1980	685	123	853	110	3751	0	9662	2528	866	11171	1551	25778	21902741	11117693	10785048	913737	8646783	2380763	868212	3704974	432138	16032870	5913306	1288488	741194	6808945	705582	15457515	6388105	2146436	0	1011784	500562	199329	0	59290	-34744	0	0	0	181427	10452189	8171984	1522815	597622	9814028	931747	21038196	183720	1369467	4989322	9157899	0	0	0	0	0
106301304	1999	4	NEWPORT BAY HOSPITAL	NEWPORT BEACH	13	1016	2	01011999	"12311999"	34	34	34	401	0	0	0	20	421	0	5509	0	0	0	211	5720	0	0	0	0	0	0	0	5588432	5588432	0	0	7082558	0	0	0	337787	7420345	0	0	0	0	0	0	1912414	0	0	0	0	0	0	0	0	0	0	0	241386	2153800	5170144	0	0	0	96401	5266545	0	96862	7764	30582	0	0	0	0	0