Table: 2018_quarter_3_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	20183	10/01/2017	09/30/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,159	1,265	177	0	0	0	0	0	28	0	0	697	902	0	225,809	0	0	0	0	0	436	0	0	224,193	450,438	0	0	0	0	0	0	0	0	0	0	0	0	129,653,869	0	0	0	0	0	248,931	0	0	128,635,327	258,538,127	0	0	0	0	0	0	0	0	0	0	0	0	7,005	0	0	0	0	0	0	3,440	0	0	0	0	0	0	53,684	64,129	0	0	0	0	0	129,646,864	0	0	0	0	0	245,491	0	0	128,581,643	258,473,998	0	330,651,753	0	72,177,755	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106274043	NATIVIDAD MEDICAL CENTER	20183	10/01/2017	09/30/2018	Open	Monterey	08 - Mid-Coast	0705	City/County	Comparable	None	831-755-4111	1441 CONSTITUTION BOULEVARD	SALINAS	93906	GARY GRAY	172	107	107	1,768	0	2,469	2,777	0	0	1,764	0	15	269	9,062	0	10,738	0	10,987	9,830	0	0	8,698	0	42	676	40,971	0	25,740	0	31,263	79,536	0	0	31,735	0	3,350	8,798	180,422	182,738,457	0	219,302,547	210,959,599	0	0	198,012,928	0	1,725,038	11,173,811	823,912,380	48,451,098	0	54,094,515	154,628,172	0	0	88,991,797	0	4,616,785	22,111,798	372,894,165	32,185,444	187,190,801	0	227,885,749	302,835,754	(35,339,593)	0	0	166,640,135	0	0	6,372,594	0	0	0	0	887,770,884	0	0	0	0	0	43,998,754	0	80,850,907	62,752,016	0	0	120,364,589	0	0	1,069,395	309,035,661	8,047,471	278,159,114	0	4,637,830	0	0	0	0	6,046,358	117,509,399	0	0	0	0	0	0	0	0	0	0	0	0	0
106301304	NEWPORT BAY HOSPITAL	20183	10/01/2017	09/30/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	857	79	0	0	0	0	3	0	0	0	939	0	10,431	1,037	0	0	0	0	49	0	0	0	11,517	0	0	0	0	0	0	0	0	0	0	0	0	14,439,791	1,328,454	0	0	0	0	52,610	0	0	0	15,820,855	0	0	0	0	0	0	0	0	0	0	0	0	4,224,485	548,335	0	0	0	0	0	10,831	0	0	0	0	0	0	0	4,783,651	0	0	0	0	0	10,215,306	780,119	0	0	0	0	41,779	0	0	0	11,037,204	490	11,224,221	0	0	0	0	0	0	0	701	0	0	0	0	0	0	0	0	0	0	0	0	0
106514033	NORTH VALLEY BEHAVIORAL HEALTH - PHF	20183	10/01/2017	09/30/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	407	407	0	0	0	0	0	0	0	0	0	0	5,660	5,660	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5,186,854	5,186,854	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,186,854	5,186,854	1,114	5,005,146	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	20183	10/01/2017	09/30/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,022	308	757	2,428	0	13	292	1,201	36	75	9,132	0	20,453	1,234	3,716	10,981	0	115	1,612	4,297	213	272	42,893	0	111,185	6,268	8,998	91,907	0	107	41,961	87,343	391	7,816	355,976	947,819,101	68,161,648	153,041,110	482,574,084	0	6,524,408	75,466,364	247,740,866	12,563,400	9,718,877	2,003,609,858	538,417,579	32,698,804	106,283,750	540,857,896	0	844,803	84,386,725	348,457,830	4,905,277	46,868,387	1,703,721,051	14,383,027	1,367,424,698	87,460,603	220,872,867	968,297,340	(2,135,942)	0	5,691,423	101,912,650	429,138,140	0	53,480,204	0	0	0	0	3,246,525,010	0	52,551,703	0	37,057,967	89,609,670	118,811,982	13,399,849	40,587,935	107,686,343	0	1,677,788	57,940,439	204,118,523	0	6,192,710	550,415,569	12,242,719	552,994,071	0	9,342,742	0	0	0	0	76,346,492	256,636,529	0	0	0	0	0	0	0	0	0	0	0	0	0
106141273	NORTHERN INYO HOSPITAL	20183	10/01/2017	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	550	32	78	134	0	0	52	191	3	21	1,061	0	2,000	97	202	362	0	0	126	515	15	49	3,366	0	25,613	736	4,913	12,510	0	7	5,344	22,942	526	2,068	74,659	23,264,317	1,221,877	2,953,693	4,682,573	0	0	1,929,675	8,223,825	324,801	315,378	42,916,139	41,560,607	2,090,759	8,747,570	15,547,736	0	45,171	5,971,004	31,155,135	798,176	2,351,599	108,267,757	2,408,681	32,255,548	1,048,979	10,602,623	15,370,391	(9,318,833)	0	7,443	7,032,080	5,117,088	0	1,168,948	(10,018)	0	0	319,131	66,002,061	0	0	0	0	0	32,569,376	2,263,656	10,417,473	4,859,919	0	38,227	866,513	34,261,872	(34,366)	(60,835)	85,181,835	1,971,239	83,539,469	6,007,938	(4,070,724)	0	0	0	0	2,371,334	76,506,374	0	0	0	0	0	0	0	0	0	0	0	0	0
106190568	NORTHRIDGE HOSPITAL MEDICAL CENTER	20183	10/01/2017	09/30/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,417	2,232	1,727	2,702	0	0	450	3,318	125	127	15,098	0	23,243	10,408	7,807	8,794	0	0	1,815	14,468	364	396	67,295	0	21,020	7,779	12,527	30,010	0	0	4,734	26,697	1,779	2,547	107,093	588,680,133	267,554,879	192,925,849	223,088,841	0	0	59,812,289	334,264,754	5,744,207	4,936,826	1,677,007,778	165,204,083	68,155,670	64,180,239	147,234,228	0	0	14,407,783	157,063,669	8,131,064	12,989,941	637,366,677	40,334,195	652,333,757	278,523,521	161,648,275	330,086,597	0	0	0	54,219,659	326,851,110	0	14,390,722	0	0	0	11,013,950	1,869,401,786	0	0	0	0	0	93,604,517	54,958,704	92,347,118	37,718,662	0	0	15,416,622	149,850,223	0	1,076,823	444,972,669	9,464,154	436,910,278	0	2,262,528	0	0	0	0	6,058,458	174,850,249	0	0	0	0	0	0	0	0	0	0	0	0	0
106214034	NOVATO COMMUNITY HOSPITAL	20183	10/01/2017	09/30/2018	Open	Marin	04 - West Bay	0405	Non Profit Corp.	Comparable	None	415-209-1300	180 ROWLAND WAY	NOVATO	94945	GRANT DAVIES	47	47	20	1,173	108	76	208	0	1	33	256	21	7	1,883	0	3,854	344	224	671	0	6	94	682	44	15	5,934	0	4,311	421	665	4,559	2	3	611	4,130	564	313	15,579	64,415,563	5,194,607	3,552,600	10,107,438	0	40,356	1,765,302	12,749,927	776,467	265,778	98,868,038	51,253,955	6,074,314	3,586,709	21,080,460	7,194	3,659	5,502,218	41,894,744	2,624,216	1,463,416	133,490,885	420,947	94,288,571	9,145,851	5,035,657	26,752,204	0	6,922	3,461	4,667,508	22,015,621	0	3,400,683	0	0	0	671,141	166,408,566	0	0	0	0	0	21,366,992	2,115,887	2,096,811	4,426,724	272	40,554	2,595,686	32,626,857	0	680,574	65,950,357	2,264,009	102,724,567	0	5,117,224	0	0	0	0	4,610,843	36,192,405	0	0	0	0	0	0	0	0	0	0	0	0	0