Table: 2018_quarter_1_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	fac_name	year_qtr	beg_date	end_date	op_status	county_name	hsa	hfpa	type_cntrl	type_hosp	teach_rurl	phone	address	city	zip_code	ceo	lic_beds	avl_beds	stf_beds	dis_mcar	dis_mcar_mc	dis_mcal	dis_mcal_mc	dis_cnty	dis_cnty_mc	dis_thrd	dis_thrd_mc	dis_indgnt	dis_oth	dis_tot	dis_ltc	day_mcar	day_mcar_mc	day_mcal	day_mcal_mc	day_cnty	day_cnty_mc	day_thrd	day_thrd_mc	day_indgnt	day_oth	day_tot	day_ltc	vis_mcar	vis_mcar_mc	vis_mcal	vis_mcal_mc	vis_cnty	vis_cnty_mc	vis_thrd	vis_thrd_mc	vis_indgnt	vis_oth	vis_tot	grip_mcar	grip_mcar_mc	grip_mcal	grip_mcal_mc	grip_cnty	grip_cnty_mc	grip_thrd	grip_thrd_mc	grip_indgnt	grip_oth	grip_tot	grop_mcar	grop_mcar_mc	grop_mcal	grop_mcal_mc	grop_cnty	grop_cnty_mc	grop_thrd	grop_thrd_mc	grop_indgnt	grop_oth	grop_tot	bad_debt	cadj_mcar	cadj_mcar_mc	cadj_mcal	cadj_mcal_mc	disp_855	cadj_cnty	cadj_cnty_mc	cadj_thrd	cadj_thrd_mc	char_hb	char_oth	sub_indgnt	tch_allow	tch_supp	ded_oth	ded_tot	cap_mcar	cap_mcal	cap_cnty	cap_thrd	cap_tot	net_mcar	net_mcar_mc	net_mcal	net_mcal_mc	net_cnty	net_cnty_mc	net_thrd	net_thrd_mc	net_indgnt	net_oth	net_tot	oth_op_rev	tot_op_exp	phy_comp	nonop_rev	dis_pips	day_pips	exp_pips	exp_pops	cap_exp	fix_assets	disp_trnfr	dis_tot_cc	pat_day_tot_cc	tot_out_vis_cc	gros_inpat_rev_cc	gros_outpat_rev_cc	contr_adj_cc	othr_deduct_cc	cap_prem_rev_cc	net_pat_rev_cc	qa_fees	qa_suppl_pay	mngd_care_qa_pay
106281266	NAPA STATE HOSPITAL	2018R1	04/01/2017	03/31/2018	Open	Napa	03	0407	State	State Hospitals	None	707-253-5000	2100 NAPA-VALLEJO HIGHWAY	NAPA	94558	FRANK TURLEY	1,418	1,314	1,314	166	0	0	0	0	0	8	0	0	638	812	0	178,411	0	0	0	0	0	338	0	0	258,453	437,202	0	0	0	0	0	0	0	0	0	0	0	0	103,020,792	0	0	0	0	0	196,827	0	0	148,721,408	251,939,027	0	0	0	0	0	0	0	0	0	0	0	0	1,129	0	0	0	0	0	0	0	0	0	0	0	0	0	190,275	191,404	0	0	0	0	0	103,019,662	0	0	0	0	0	196,827	0	0	148,531,134	251,747,623	0	320,245,041	0	68,497,418	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106274043	NATIVIDAD MEDICAL CENTER	2018R1	04/01/2017	03/31/2018	Open	Monterey	08	0705	City/County	Comparable	None	831-755-4111	1441 CONSTITUTION BOULEVARD	SALINAS	93906	GARY GRAY	172	137	137	1,776	0	2,439	2,738	0	0	1,788	0	25	260	9,026	0	10,700	0	10,354	9,505	0	0	8,614	0	71	682	39,926	0	25,435	0	28,042	80,431	0	0	31,234	0	4,182	10,017	179,341	184,877,978	0	204,148,254	202,838,934	0	0	192,909,702	0	2,911,910	13,998,630	801,685,408	45,821,021	0	51,207,414	155,454,475	0	0	86,645,197	0	5,200,567	20,672,931	365,001,605	33,814,337	188,438,355	0	214,741,046	301,417,397	(33,745,182)	0	0	164,853,822	0	0	8,174,020	0	0	0	0	877,693,795	0	0	0	0	0	42,260,644	0	74,359,804	56,876,011	0	0	114,701,075	0	0	795,684	288,993,218	4,190,325	269,356,456	0	11,062,871	0	0	0	0	14,318,128	121,482,898	0	0	0	0	0	0	0	0	0	0	0	0	0
106301304	NEWPORT BAY HOSPITAL	2018R1	04/01/2017	03/31/2018	Open	Orange	13	1016	Investor - Corp.	Comparable	None	949-650-9750	1501 EAST 16TH STREET	NEWPORT BEACH	92663	JAMES E PARKHURST	36	36	36	857	73	0	0	0	0	3	0	0	0	933	0	10,388	1,001	0	0	0	0	49	0	0	0	11,438	0	0	0	0	0	0	0	0	0	0	0	0	14,557,332	1,345,032	0	0	0	0	52,610	0	0	0	15,954,974	0	0	0	0	0	0	0	0	0	0	0	0	4,368,271	564,914	0	0	0	0	0	10,831	0	0	0	0	0	0	0	4,944,016	0	0	0	0	0	10,189,061	780,118	0	0	0	0	41,779	0	0	0	11,010,958	935	11,123,537	0	0	0	0	0	0	0	769	0	0	0	0	0	0	0	0	0	0	0	0	0
106514033	NORTH VALLEY BEHAVIORAL HEALTH - PHF	2018R1	04/01/2017	03/31/2018	Open	Sutter	02	0227	Investor - Corp.	Psychiatric Health Facilities	None	530-790-2520	1535 PLUMAS COURT	YUBA CITY	95993	ARNE HYSON	16	16	16	0	0	0	0	0	0	0	0	0	360	360	0	0	0	0	0	0	0	0	0	0	5,716	5,716	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5,119,471	5,119,471	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	5,119,471	5,119,471	65,655	5,258,394	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106481357	NORTHBAY MEDICAL CENTER	2018R1	04/01/2017	03/31/2018	Open	Solano	03	0408	Non Profit Corp.	Comparable	None	707-646-5000	1200 B. GALE WILSON BOULEVARD.	FAIRFIELD	94533	B KONARD JONES	182	182	182	3,707	283	728	2,275	0	7	329	1,130	26	75	8,560	0	19,197	1,276	3,893	10,672	0	98	1,580	4,223	172	276	41,387	0	96,138	5,878	8,843	86,388	0	79	41,847	81,934	180	6,440	327,727	907,588,371	70,901,164	150,569,533	468,801,430	0	5,197,693	82,912,108	233,008,460	8,133,648	12,056,328	1,939,168,735	506,692,124	31,720,640	98,138,557	520,013,830	0	464,992	91,520,161	333,012,884	2,570,756	48,936,829	1,633,070,773	25,013,311	1,297,656,269	85,770,456	215,728,091	941,506,837	(387,877)	0	5,379,551	107,177,375	403,241,467	0	44,519,907	0	0	0	0	3,125,605,387	0	52,562,166	0	36,796,338	89,358,504	116,624,226	16,851,348	33,367,876	99,870,589	0	283,134	67,254,894	199,576,215	0	2,164,343	535,992,625	7,499,434	558,645,463	0	12,224,306	0	0	0	0	63,448,087	234,106,565	0	0	0	0	0	0	0	0	0	0	0	0	0
106141273	NORTHERN INYO HOSPITAL	2018R1	04/01/2017	03/31/2018	Open	Inyo	12	1203	District	Comparable	Teaching	760-873-5811	150 PIONEER LANE	BISHOP	93514	KEVIN FLANIGAN, MD	25	25	12	559	27	103	138	0	0	43	210	11	19	1,110	0	2,009	89	250	370	0	0	117	515	57	47	3,454	0	25,018	572	5,342	13,085	0	8	5,125	22,969	650	1,785	74,554	22,416,440	1,076,520	3,250,804	4,700,925	0	0	1,896,004	8,149,357	677,019	417,008	42,584,077	39,755,160	1,479,081	7,627,120	13,737,670	0	11,709	5,653,707	30,475,719	834,455	2,303,444	101,878,065	2,236,487	28,919,621	769,105	8,808,064	13,479,330	(4,237,398)	0	4,438	5,539,873	5,266,279	0	1,586,305	1,186	0	0	261,478	62,634,768	0	0	0	0	0	33,251,978	1,786,495	5,774,522	5,492,001	0	7,271	2,009,838	33,358,797	(76,017)	222,489	81,827,374	471,643	78,180,968	11,312,944	(3,039,557)	0	0	0	0	1,376,323	77,685,621	0	0	0	0	0	0	0	0	0	0	0	0	0
106190568	NORTHRIDGE HOSPITAL MEDICAL CENTER	2018R1	04/01/2017	03/31/2018	Open	Los Angeles	11	0905	Non Profit Corp.	Comparable	None	818-885-8500	18300 ROSCOE BOULEVARD	NORTHRIDGE	91325	SALIBA SALO	412	412	220	4,490	2,154	1,708	2,602	0	0	485	3,446	26	64	14,975	0	22,224	10,465	7,119	8,888	0	0	1,805	14,949	136	304	65,890	0	20,738	8,631	11,671	30,678	12	0	4,644	28,127	536	4,841	109,878	563,139,503	252,981,945	176,437,064	219,118,882	0	0	50,646,241	345,063,675	1,348,511	3,311,762	1,612,047,583	156,558,713	74,621,680	58,949,330	149,361,507	67,926	0	13,846,148	160,538,744	2,472,533	24,697,156	641,113,737	35,532,684	627,000,791	271,102,074	160,505,415	331,180,615	0	55,058	0	49,468,349	343,894,401	0	3,010,458	0	0	0	9,946,815	1,831,696,660	0	0	0	0	0	90,026,754	55,672,200	70,183,350	36,377,238	9,997	0	13,539,054	154,099,344	0	1,556,723	421,464,660	8,827,438	432,416,829	0	2,122,081	0	0	0	0	16,493,434	179,749,163	0	0	0	0	0	0	0	0	0	0	0	0	0
106214034	NOVATO COMMUNITY HOSPITAL	2018R1	04/01/2017	03/31/2018	Open	Marin	04	0405	Non Profit Corp.	Comparable	None	415-209-1300	180 ROWLAND WAY	NOVATO	94945	GRANT DAVIES	47	47	23	1,151	108	78	187	0	2	26	277	18	7	1,854	0	3,937	372	331	646	0	14	77	789	28	13	6,207	0	5,394	504	888	5,861	1	3	609	6,402	600	537	20,799	64,067,274	5,458,769	4,220,684	9,713,694	0	124,483	1,708,763	15,225,532	616,059	303,481	101,438,739	54,249,238	6,377,931	3,944,027	22,202,669	1,500	11,434	4,471,656	45,098,133	2,316,754	2,003,439	140,676,781	1,113,459	96,541,308	9,740,233	6,665,536	27,519,514	0	1,500	99,051	4,307,600	24,170,583	0	2,932,813	0	0	0	471,480	173,563,077	0	0	0	0	0	21,775,204	2,096,467	1,499,175	4,394,531	0	39,184	1,872,819	36,153,082	0	721,981	68,552,443	4,413,432	89,731,584	0	2,615,148	0	0	0	0	2,264,061	34,805,084	0	0	0	0	0	0	0	0	0	0	0	0	0