Table: 2018_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	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	20184	01/01/2018	12/31/2018	Open	Napa	03 - North Bay	0407	State	State Hospitals	None	707-253-5000	2100 NAPA-VALLEJO HIGHWAY	NAPA	94558	FRANK TURLEY	1,418	1,296	1,296	141	0	0	0	0	0	73	0	0	693	907	0	212,430	0	0	0	0	0	514	0	0	242,723	455,667	0	0	0	0	0	0	0	0	0	0	0	0	122,318,968	0	0	0	0	0	293,956	0	0	139,570,452	262,183,376	0	0	0	0	0	0	0	0	0	0	0	0	6,916	0	0	0	0	0	0	3,455	0	0	0	0	0	0	14,046	24,417	0	0	0	0	0	122,312,052	0	0	0	0	0	290,501	0	0	139,556,406	262,158,959	0	334,388,034	0	72,229,075	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106274043	NATIVIDAD MEDICAL CENTER	20184	01/01/2018	12/31/2018	Open	Monterey	08 - Mid-Coast	0705	City/County	Comparable	None	831-755-4111	1441 CONSTITUTION BOULEVARD	SALINAS	93906	GARY GRAY	172	114	114	1,735	0	2,486	2,795	0	0	1,723	0	9	284	9,032	0	10,582	0	11,029	10,246	0	0	8,246	0	23	743	40,869	0	25,851	0	31,720	78,092	0	0	31,974	0	3,056	8,667	179,360	184,471,535	0	221,417,472	222,298,300	0	0	188,587,451	0	1,437,890	9,654,438	827,867,086	49,340,813	0	53,739,855	154,557,424	0	0	88,964,960	0	4,385,467	21,119,332	372,107,851	29,394,055	191,516,439	0	226,845,635	314,851,063	(35,776,171)	0	0	158,222,881	0	0	5,823,357	0	0	0	0	890,877,259	0	0	0	0	0	42,295,909	0	84,087,863	62,004,662	0	0	119,329,529	0	0	1,379,715	309,097,678	10,920,758	286,629,690	0	1,654,428	0	0	0	0	6,622,450	116,721,853	0	0	0	0	0	0	0	0	0	0	0	0	0
106301304	NEWPORT BAY HOSPITAL	20184	01/01/2018	12/31/2018	Open	Orange	13 - Orange	1016	Investor - Corp.	Comparable	None	949-650-9750	1501 EAST 16TH STREET	NEWPORT BEACH	92663	JAMES E PARKHURST	36	36	36	839	71	0	0	0	0	3	0	0	0	913	0	10,428	910	0	0	0	0	52	0	0	0	11,390	0	0	0	0	0	0	0	0	0	0	0	0	14,411,185	1,288,368	0	0	0	0	56,750	0	0	0	15,756,303	0	0	0	0	0	0	0	0	0	0	0	0	4,203,392	529,904	0	0	0	0	0	12,026	0	0	0	0	0	0	0	4,745,322	0	0	0	0	0	10,207,793	758,464	0	0	0	0	44,724	0	0	0	11,010,981	405	11,249,009	0	0	0	0	0	0	0	667	0	0	0	0	0	0	0	0	0	0	0	0	0
106514033	NORTH VALLEY BEHAVIORAL HEALTH - PHF	20184	01/01/2018	12/31/2018	Open	Sutter	02 - Golden Empire	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	389	389	0	0	0	0	0	0	0	0	0	0	5,686	5,686	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5,157,448	5,157,448	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,157,448	5,157,448	0	4,729,854	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	20184	01/01/2018	12/31/2018	Open	Solano	03 - North Bay	0408	Non Profit Corp.	Comparable	None	707-646-5000	1200 B. GALE WILSON BOULEVARD	FAIRFIELD	94533	B KONARD JONES	182	182	182	4,206	313	798	2,523	0	10	317	1,235	49	69	9,520	0	20,943	1,283	4,126	11,196	0	46	1,551	4,498	183	225	44,051	0	117,411	6,851	8,858	93,764	0	39	40,827	88,828	382	7,582	364,542	980,258,338	70,887,372	162,454,327	496,734,514	0	2,214,180	78,102,792	255,216,267	15,594,383	8,530,684	2,069,992,857	546,124,016	33,198,065	108,799,815	544,467,693	0	924,137	80,800,712	360,602,046	5,055,979	49,166,326	1,729,138,789	13,969,141	1,409,129,867	90,442,705	242,186,788	975,017,611	(2,961,989)	0	586,760	122,072,358	408,452,245	0	58,707,835	0	0	0	0	3,317,603,321	0	65,205,168	0	38,001,330	103,206,498	117,252,487	13,642,732	32,029,343	131,389,764	0	2,551,557	36,831,146	245,367,398	0	5,670,396	584,734,823	9,045,265	545,975,022	0	(3,790,855)	0	0	0	0	81,766,545	287,443,376	0	0	0	0	0	0	0	0	0	0	0	0	0
106141273	NORTHERN INYO HOSPITAL	20184	01/01/2018	09/30/2018	Open	Inyo	12 - Inland Counties	1203	District	Comparable	Rural	760-873-5811	150 PIONEER LANE	BISHOP	93514	KEVIN FLANIGAN, MD	25	25	8	413	28	59	95	0	0	42	136	2	19	794	0	1,499	87	138	274	0	0	101	371	7	48	2,525	0	19,406	603	3,612	9,337	0	6	3,998	16,836	349	1,642	55,789	17,305,338	1,113,157	2,250,565	3,407,030	0	0	1,608,882	5,842,137	75,761	314,071	31,916,941	31,611,560	1,654,443	7,035,893	12,212,088	0	44,561	4,619,272	23,294,791	492,603	1,725,043	82,690,254	1,942,635	24,096,377	816,061	8,708,687	11,730,297	(7,041,256)	0	7,443	5,504,253	3,631,684	0	647,334	(10,014)	0	0	227,120	50,260,621	0	0	0	0	0	24,820,521	1,951,538	7,619,027	3,888,822	0	37,617	721,815	25,505,244	(67,369)	(130,641)	64,346,574	1,822,010	63,451,392	3,117,293	(3,483,079)	0	0	0	0	2,230,459	76,506,374	0	0	0	0	0	0	0	0	0	0	0	0	0
106190568	NORTHRIDGE HOSPITAL MEDICAL CENTER	20184	01/01/2018	12/31/2018	Open	Los Angeles	11 - Los Angeles	0905	Non Profit Corp.	Comparable	None	818-885-8500	18300 ROSCOE BOULEVARD	NORTHRIDGE	91325	SALIBA SALO	394	394	200	4,315	2,242	1,683	2,647	0	0	505	3,326	134	138	14,990	0	23,289	10,389	7,680	8,605	0	0	2,029	14,492	405	436	67,325	0	20,936	7,559	12,379	29,345	0	0	4,620	26,051	2,236	1,909	105,035	590,003,919	277,101,446	192,243,088	218,912,786	0	0	60,159,340	335,198,809	7,371,894	11,300,841	1,692,292,123	171,713,469	66,851,177	64,875,204	147,420,038	0	0	13,943,606	153,544,313	10,954,475	9,382,047	638,684,329	41,083,550	660,199,136	288,530,108	190,449,417	326,610,758	0	0	0	54,077,674	325,308,724	0	22,200,813	0	0	0	11,510,383	1,919,970,563	0	0	0	0	0	93,035,603	53,365,687	62,034,639	36,931,327	0	0	15,335,014	149,430,336	0	873,283	411,005,889	9,312,893	419,508,052	0	2,655,642	0	0	0	0	7,183,333	173,594,801	0	0	0	0	0	0	0	0	0	0	0	0	0
106214034	NOVATO COMMUNITY HOSPITAL	20184	01/01/2018	12/31/2018	Open	Marin	04 - West Bay	0405	Non Profit Corp.	Comparable	None	415-209-1300	180 ROWLAND WAY	NOVATO	94945	MICHAEL L. PURVIS	47	47	23	1,182	116	85	202	0	2	43	276	15	25	1,946	0	3,926	375	287	611	0	7	91	731	40	63	6,131	0	4,142	427	723	4,542	0	5	613	3,579	548	280	14,859	67,282,754	6,123,213	4,300,019	9,567,663	0	66,500	2,186,706	14,276,561	613,688	1,067,399	105,484,503	51,797,827	6,081,756	3,861,103	21,673,658	0	11,695	5,468,354	40,400,247	2,590,156	1,343,682	133,228,478	1,142,900	96,923,270	9,680,551	6,492,470	26,534,793	0	0	6,513	4,903,848	22,137,679	0	3,203,844	0	0	0	1,491,207	172,517,075	0	0	0	0	0	22,060,009	2,526,378	1,650,951	4,706,528	0	71,344	2,751,212	31,789,995	0	639,489	66,195,906	741,846	106,049,830	0	2,912,611	0	0	0	0	7,113,149	37,614,699	0	0	0	0	0	0	0	0	0	0	0	0	0