Table: 2018_quarter_2_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	2018R2	07/01/2017	06/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,314	1,314	150	0	0	0	0	0	18	0	0	669	837	0	197,062	0	0	0	0	0	232	0	0	245,961	443,255	0	0	0	0	0	0	0	0	0	0	0	0	113,373,520	0	0	0	0	0	133,377	0	0	140,961,047	254,467,944	0	0	0	0	0	0	0	0	0	0	0	0	3,478	0	0	0	0	0	0	0	0	0	0	0	0	0	176,990	180,468	0	0	0	0	0	113,370,042	0	0	0	0	0	133,377	0	0	140,784,057	254,287,476	0	329,967,183	0	75,679,707	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106274043	NATIVIDAD MEDICAL CENTER	2018R2	07/01/2017	06/30/2018	Open	Monterey	08 - Mid-Coast	0705	City/County	Comparable	None	831-755-4111	1441 CONSTITUTION BOULEVARD	SALINAS	93906	GARY GRAY	172	116	116	1,743	0	2,497	2,719	0	0	1,754	0	20	267	9,000	0	10,413	0	11,038	9,971	0	0	8,760	0	65	692	40,939	0	25,503	0	30,439	80,225	0	0	31,850	0	3,876	9,603	181,496	178,878,184	0	222,185,768	208,201,334	0	0	193,872,768	0	2,467,490	11,886,245	817,491,789	47,106,242	0	53,693,314	152,759,370	0	0	87,736,515	0	5,093,555	21,531,464	367,920,460	32,213,496	183,452,744	0	230,992,921	300,707,273	(34,836,347)	0	0	167,591,067	0	0	7,622,589	0	0	0	0	887,743,743	0	0	0	0	0	42,531,682	0	79,722,509	60,253,429	0	0	114,018,214	0	0	1,142,672	297,668,506	4,893,756	271,401,180	0	5,334,863	0	0	0	0	6,394,484	119,638,671	0	0	0	0	0	0	0	0	0	0	0	0	0
106301304	NEWPORT BAY HOSPITAL	2018R2	07/01/2017	06/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	844	86	0	0	0	0	3	0	0	0	933	0	10,218	1,111	0	0	0	0	49	0	0	0	11,378	0	0	0	0	0	0	0	0	0	0	0	0	14,211,393	1,539,471	0	0	0	0	52,610	0	0	0	15,803,474	0	0	0	0	0	0	0	0	0	0	0	0	4,085,464	637,764	0	0	0	0	0	10,831	0	0	0	0	0	0	0	4,734,059	0	0	0	0	0	10,125,929	901,707	0	0	0	0	41,779	0	0	0	11,069,415	770	11,168,203	0	0	0	0	0	0	0	735	0	0	0	0	0	0	0	0	0	0	0	0	0
106514033	NORTH VALLEY BEHAVIORAL HEALTH - PHF	2018R2	07/01/2017	06/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	374	374	0	0	0	0	0	0	0	0	0	0	5,680	5,680	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5,185,827	5,185,827	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,185,827	5,185,827	35,505	5,015,312	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	2018R2	07/01/2017	06/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	3,821	280	739	2,324	0	10	321	1,159	28	71	8,753	0	19,743	1,152	3,627	10,428	0	107	1,496	4,219	174	271	41,217	0	104,973	6,029	9,478	93,560	0	91	41,222	85,964	288	8,340	349,945	927,348,643	68,927,313	150,548,708	462,561,677	0	5,705,558	82,820,747	244,314,677	9,271,725	10,846,314	1,962,345,362	525,821,017	33,230,889	104,508,745	526,394,841	0	633,183	82,995,118	340,654,353	3,160,023	53,141,282	1,670,539,451	11,628,879	1,332,207,898	86,861,954	215,765,554	947,301,319	(2,135,942)	0	5,659,773	105,378,675	413,487,993	0	53,655,136	0	0	0	5,392,717	3,175,203,956	0	52,274,095	0	36,453,841	88,727,936	120,961,762	15,296,248	41,427,841	93,929,294	0	678,968	60,437,190	207,934,878	0	5,742,612	546,408,793	11,000,075	553,259,938	0	10,614,539	0	0	0	0	67,933,805	245,714,623	0	0	0	0	0	0	0	0	0	0	0	0	0
106141273	NORTHERN INYO HOSPITAL	2018R2	07/01/2017	06/30/2018	Open	Inyo	12 - Inland Counties	1203	District	Comparable	Rural	760-873-5811	150 PIONEER LANE	BISHOP	93514	KEVIN FLANIGAN, MD	25	25	10	562	37	83	139	0	0	52	209	4	20	1,106	0	2,041	119	216	379	0	0	127	525	16	51	3,474	0	24,466	651	4,783	12,063	0	5	4,953	22,083	571	1,791	71,366	23,264,216	1,473,169	2,941,258	5,019,964	0	0	2,025,042	8,429,735	327,984	551,864	44,033,232	40,744,592	1,728,209	8,088,008	14,611,629	0	5,106	5,910,813	31,429,412	786,744	2,288,118	105,592,631	2,692,023	30,962,929	931,971	9,091,513	14,354,423	(6,847,331)	0	0	6,721,270	5,285,664	0	1,233,603	(4)	0	0	283,221	64,709,282	0	0	0	0	0	33,045,878	2,269,406	8,785,084	5,277,171	0	5,605	1,214,585	34,573,483	(119,369)	(135,262)	84,916,581	1,148,544	81,584,083	8,845,079	(3,564,495)	0	0	0	0	1,720,104	76,802,723	0	0	0	0	0	0	0	0	0	0	0	0	0
106190568	NORTHRIDGE HOSPITAL MEDICAL CENTER	2018R2	07/01/2017	06/30/2018	Open	Los Angeles	11 - Los Angeles	0905	Non Profit Corp.	Comparable	None	818-885-8500	18300 ROSCOE BOULEVARD	NORTHRIDGE	91325	SALIBA SALO	412	412	192	4,380	2,148	1,734	2,698	0	0	488	3,398	86	118	15,050	0	22,465	10,247	7,232	9,108	0	0	1,794	15,052	233	371	66,502	0	20,715	8,064	12,179	30,316	12	0	4,637	27,478	1,041	3,661	108,103	571,117,818	254,818,044	179,772,883	222,374,416	0	0	55,466,954	342,778,069	2,890,527	4,313,669	1,633,532,380	160,137,903	68,884,093	60,026,918	145,348,025	67,926	0	13,498,258	157,938,339	5,143,066	18,987,258	630,031,786	36,755,949	633,995,251	267,100,668	154,377,351	328,316,087	0	55,058	0	51,908,509	337,912,087	0	8,281,622	0	0	0	8,795,822	1,827,498,404	0	0	0	0	0	92,452,692	55,367,504	81,278,316	37,833,454	9,997	0	14,739,169	153,004,523	0	1,380,107	436,065,762	9,325,728	431,716,460	0	2,186,016	0	0	0	0	6,210,013	178,038,964	0	0	0	0	0	0	0	0	0	0	0	0	0
106214034	NOVATO COMMUNITY HOSPITAL	2018R2	07/01/2017	06/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,140	102	78	202	0	2	29	275	18	5	1,851	0	3,831	333	263	650	0	14	82	756	31	10	5,970	0	4,780	454	628	4,782	1	3	519	5,194	566	456	17,383	62,846,505	4,905,923	3,934,069	10,102,162	0	124,496	1,913,998	14,012,561	655,950	230,017	98,725,681	52,580,900	6,279,545	3,554,996	21,605,322	1,500	7,940	4,399,059	43,597,385	2,504,514	1,887,537	136,418,698	1,275,279	94,593,217	9,210,290	5,825,205	27,327,796	0	1,500	95,753	4,528,511	22,805,245	0	3,160,464	0	0	0	382,708	169,205,968	0	0	0	0	0	20,834,188	1,975,178	1,663,860	4,379,688	0	36,683	1,784,546	34,668,476	0	595,792	65,938,411	3,024,824	95,595,777	0	4,217,287	0	0	0	0	3,492,883	35,399,528	0	0	0	0	0	0	0	0	0	0	0	0	0