Table: 2019_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	20192	07/01/2018	06/30/2019	Open	Napa	03 - North Bay	0407	State	State Hospitals	None	707-253-5000	2100 NAPA-VALLEJO HIGHWAY	NAPA	94558	FRANK TURLEY	1,418	1,297	1,297	174	0	0	0	0	0	62	0	0	624	860	0	187,025	0	0	0	0	0	506	0	0	271,090	458,621	0	0	0	0	0	0	0	0	0	0	0	0	107,729,630	0	0	0	0	0	295,870	0	0	156,188,852	264,214,352	0	0	0	0	0	0	0	0	0	0	0	0	3,817	0	0	0	0	0	0	3,455	0	0	0	0	0	0	15,483	22,755	0	0	0	0	0	107,725,814	0	0	0	0	0	292,415	0	0	156,173,368	264,191,597	0	425,673,910	0	151,482,313	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106274043	NATIVIDAD MEDICAL CENTER	20192	07/01/2018	06/30/2019	Open	Monterey	08 - Mid-Coast	0705	City/County	Comparable	None	831-755-4111	1441 CONSTITUTION BOULEVARD	SALINAS	93906	GARY GRAY	172	116	116	1,843	0	2,393	2,828	0	0	1,782	0	8	284	9,138	0	11,570	0	9,803	10,319	0	0	8,318	0	21	797	40,828	0	26,717	0	29,399	78,860	0	0	32,186	0	2,610	8,837	178,609	208,988,740	0	190,463,098	223,692,531	0	0	188,092,252	0	1,713,239	8,773,397	821,723,257	50,528,824	0	51,356,541	162,921,725	0	0	90,233,280	0	3,752,478	20,394,039	379,186,887	28,687,036	211,086,879	0	204,014,251	323,811,579	(33,148,597)	0	0	154,309,469	0	0	5,465,717	0	0	0	0	894,226,334	0	0	0	0	0	48,430,683	0	70,953,983	62,802,679	0	0	124,016,062	0	0	480,403	306,683,810	13,853,799	300,342,846	0	5,424,367	0	0	0	0	13,475,452	120,144,341	0	0	0	0	0	0	0	0	0	0	0	0	0
106301304	NEWPORT BAY HOSPITAL	20192	07/01/2018	06/30/2019	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	817	61	0	0	0	0	3	0	0	0	881	0	10,909	824	0	0	0	0	30	0	0	0	11,763	0	0	0	0	0	0	0	0	0	0	0	0	15,118,141	1,112,972	0	0	0	0	27,510	0	0	0	16,258,623	0	0	0	0	0	0	0	0	0	0	0	0	4,481,414	461,884	0	0	0	0	0	6,052	0	0	0	0	0	0	0	4,949,350	0	0	0	0	0	10,636,727	651,088	0	0	0	0	21,458	0	0	0	11,309,273	0	11,592,885	0	0	0	0	0	0	0	518	0	0	0	0	0	0	0	0	0	0	0	0	0
106514033	NORTH VALLEY BEHAVIORAL HEALTH - PHF	20192	07/01/2018	06/30/2019	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	344	344	0	0	0	0	0	0	0	0	0	0	5,698	5,698	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5,099,877	5,099,877	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,099,877	5,099,877	0	5,088,573	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	20192	07/01/2018	06/30/2019	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,308	352	782	2,735	0	19	328	1,250	51	77	9,902	0	21,480	1,661	4,252	12,841	0	81	1,689	4,841	187	346	47,378	0	119,740	8,882	8,314	87,999	0	50	42,348	89,059	229	6,003	362,624	1,038,930,495	85,850,504	174,111,941	549,346,436	0	5,504,377	86,402,107	264,764,766	16,073,000	14,082,898	2,235,066,524	550,827,330	40,492,394	105,676,007	525,815,048	0	1,525,425	82,618,559	364,180,681	5,872,016	44,222,849	1,721,230,309	34,815,285	1,461,920,035	105,411,500	255,337,946	958,672,394	(2,730,666)	0	4,308,978	136,495,286	426,353,996	0	40,330,613	0	0	0	3,084,016	3,423,999,383	0	68,990,976	0	43,571,783	112,562,759	127,837,790	20,931,398	27,180,668	185,480,066	0	2,720,824	32,525,380	246,163,234	0	2,020,849	644,860,209	10,453,484	588,572,917	0	11,845,879	0	0	0	0	83,502,859	314,997,712	0	0	0	0	0	0	0	0	0	0	0	0	0
106141273	NORTHERN INYO HOSPITAL	20192	07/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	114	5	21	31	0	0	9	42	0	7	229	0	413	12	47	75	0	0	22	128	0	13	710	0	6,423	231	1,074	2,817	0	3	1,300	5,494	53	611	18,006	5,253,424	195,281	776,597	992,131	0	0	432,093	2,142,717	0	75,771	9,868,014	10,162,341	740,030	2,547,996	4,328,724	0	41,615	1,798,869	7,663,890	95,094	593,942	27,972,501	426,630	7,846,104	300,160	3,106,154	4,659,880	(2,471,502)	0	7,443	1,544,542	1,103,213	0	116,228	(10,014)	0	0	78,943	16,707,781	0	0	0	0	0	7,569,662	635,151	2,689,941	660,975	0	34,172	684,334	8,703,394	(9,035)	164,140	21,132,734	967,674	21,331,662	0	(1,555,462)	0	0	0	0	1,173,977	76,506,374	0	0	0	0	0	0	0	0	0	0	0	0	0
106190568	NORTHRIDGE HOSPITAL MEDICAL CENTER	20192	07/01/2018	06/30/2019	Open	Los Angeles	11 - Los Angeles	0905	Non Profit Corp.	Comparable	None	818-885-8500	18300 ROSCOE BOULEVARD	NORTHRIDGE	91325	PAUL WATKINS	394	394	209	4,164	2,379	1,600	2,512	0	0	503	3,314	93	325	14,890	0	22,512	11,094	8,417	8,792	0	0	2,015	13,674	396	1,326	68,226	0	20,376	8,046	12,356	28,132	0	0	5,076	25,328	2,216	1,269	102,799	574,032,295	302,646,257	209,203,351	226,738,122	0	0	58,936,882	327,105,630	8,598,949	29,182,745	1,736,444,231	176,721,347	76,159,985	70,703,824	148,214,546	0	0	14,909,740	155,424,461	10,997,011	6,360,450	659,491,364	47,156,284	650,606,642	323,086,557	200,657,169	318,672,508	0	0	0	52,193,143	327,745,468	0	29,451,335	0	0	0	41,743,521	1,991,312,627	0	0	0	0	0	86,359,128	52,637,992	51,011,563	52,666,369	0	0	14,676,751	142,473,914	0	4,797,251	404,622,968	7,998,713	423,204,851	0	2,786,236	0	0	0	0	7,962,711	171,193,041	0	0	0	0	0	0	0	0	0	0	0	0	0
106214034	NOVATO COMMUNITY HOSPITAL	20192	07/01/2018	06/30/2019	Open	Marin	04 - West Bay	0405	Non Profit Corp.	Comparable	None	415-209-1300	180 ROWLAND WAY	NOVATO	94945	GRANT DAVIES	40	40	25	1,267	169	92	202	0	2	39	288	25	34	2,118	0	4,200	593	430	718	0	3	71	752	64	108	6,939	0	4,285	519	762	4,540	0	6	595	3,705	652	373	15,437	73,169,515	9,933,311	5,760,893	10,218,318	0	60,515	2,058,387	16,463,106	1,025,129	1,658,443	120,347,617	54,362,080	6,554,268	4,277,616	23,034,731	0	48,795	5,199,867	39,889,513	3,392,346	1,946,210	138,705,426	2,289,133	103,717,389	13,199,207	7,937,028	28,319,094	0	0	47,457	4,826,974	22,610,374	0	4,417,475	0	0	0	1,540,879	188,905,010	0	0	0	0	0	22,914,685	3,283,725	1,995,855	4,932,955	0	61,853	2,392,719	33,018,435	0	1,547,806	70,148,033	857,161	93,160,005	0	2,056,312	0	0	0	0	7,303,557	37,836,091	0	0	0	0	0	0	0	0	0	0	0	0	0