Table: 2018_quarter_2_complete_data_set_10_10_18 , 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	20182	04/01/2018	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	28	0	0	0	0	0	11	0	0	190	229	0	69,065	0	0	0	0	0	99	0	0	44,499	113,663	0	0	0	0	0	0	0	0	0	0	0	0	40,036,277	0	0	0	0	0	57,131	0	0	25,795,590	65,888,998	0	0	0	0	0	0	0	0	0	0	0	0	2,423	0	0	0	0	0	0	0	0	0	0	0	0	0	3,439	5,862	0	0	0	0	0	40,033,855	0	0	0	0	0	57,131	0	0	25,792,150	65,883,136	0	93,528,679	0	27,645,543	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106274043	NATIVIDAD MEDICAL CENTER	20182	04/01/2018	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	430	0	669	692	0	0	437	0	2	64	2,294	0	2,425	0	2,927	2,662	0	0	2,249	0	7	157	10,427	0	6,473	0	8,822	19,763	0	0	7,981	0	786	2,207	46,032	42,935,818	0	59,372,634	54,176,947	0	0	51,348,616	0	230,209	32,791	208,097,015	11,694,733	0	14,398,201	37,022,819	0	0	23,312,654	0	1,293,563	4,790,125	92,512,095	4,117,078	43,778,993	0	61,446,558	74,295,907	(9,527,481)	0	0	43,679,365	0	0	1,523,774	0	0	0	0	219,314,194	0	0	0	0	0	10,851,558	0	21,851,758	16,903,858	0	0	30,981,905	0	0	705,837	81,294,916	2,078,916	69,601,228	0	(1,966,210)	0	0	0	0	1,159,057	119,638,671	0	0	0	0	0	0	0	0	0	0	0	0	0
106301304	NEWPORT BAY HOSPITAL	20182	04/01/2018	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	202	27	0	0	0	0	0	0	0	0	229	0	2,453	327	0	0	0	0	0	0	0	0	2,780	0	0	0	0	0	0	0	0	0	0	0	0	3,405,332	467,226	0	0	0	0	0	0	0	0	3,872,558	0	0	0	0	0	0	0	0	0	0	0	0	971,409	187,421	0	0	0	0	0	0	0	0	0	0	0	0	0	1,158,830	0	0	0	0	0	2,433,923	279,805	0	0	0	0	0	0	0	0	2,713,728	160	2,735,278	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	20182	04/01/2018	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	106	106	0	0	0	0	0	0	0	0	0	0	1,396	1,396	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1,301,406	1,301,406	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	1,301,406	1,301,406	0	1,166,517	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	20182	04/01/2018	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	1,062	76	208	633	0	3	76	328	8	14	2,408	0	5,271	248	1,037	2,521	0	9	361	1,056	27	45	10,575	0	30,167	1,680	2,672	26,301	0	12	10,746	22,034	122	3,138	96,872	243,768,767	16,595,353	41,363,663	121,908,017	0	507,865	15,166,120	68,483,419	3,093,787	1,449,689	512,336,680	135,774,354	8,887,669	29,965,703	139,565,609	0	168,191	19,179,690	87,631,262	1,098,960	11,752,281	434,023,719	(11,101,944)	346,306,751	21,637,142	59,446,848	247,237,702	(1,748,065)	0	280,222	23,336,056	114,374,411	0	18,953,911	0	0	0	5,392,717	824,115,751	0	12,902,180	0	9,700,151	22,602,331	33,236,370	3,845,880	13,630,583	27,138,104	0	395,834	11,009,754	51,440,421	0	4,150,033	144,846,979	5,451,805	136,444,269	0	2,986,212	0	0	0	0	15,306,921	245,714,623	0	0	0	0	0	0	0	0	0	0	0	0	0
106141273	NORTHERN INYO HOSPITAL	20182	04/01/2018	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	143	11	19	37	0	0	18	47	0	7	282	0	475	36	46	85	0	0	31	126	0	23	822	0	6,471	209	1,238	3,290	0	0	1,365	5,451	123	512	18,659	5,373,830	435,886	789,437	1,405,956	0	0	499,989	1,938,237	0	236,246	10,679,581	10,643,905	509,948	2,355,566	4,169,607	0	0	1,638,848	7,608,610	110,468	435,454	27,472,406	791,013	8,064,386	228,424	2,574,122	3,562,449	(3,142,669)	0	0	2,800,211	1,227,086	0	101,989	(1,190)	0	0	74,198	16,280,019	0	0	0	0	0	7,953,349	717,409	3,713,550	2,013,115	0	499	(661,374)	8,319,761	9,171	(193,512)	21,871,968	703,677	22,050,215	0	(1,377,173)	0	0	0	0	360,064	76,802,723	0	0	0	0	0	0	0	0	0	0	0	0	0
106190568	NORTHRIDGE HOSPITAL MEDICAL CENTER	20182	04/01/2018	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	992	533	395	661	0	0	101	828	60	61	3,631	0	5,201	2,446	1,788	2,099	0	0	370	3,784	97	99	15,884	0	5,203	1,687	3,084	7,087	0	0	1,173	6,432	505	539	25,710	139,986,474	65,098,210	47,051,661	52,352,878	0	0	14,505,113	89,213,351	1,542,016	1,567,445	411,317,148	43,444,743	15,833,967	15,798,389	36,843,416	0	0	2,900,228	37,610,924	2,670,533	2,852,664	157,954,864	10,655,145	157,735,980	66,787,758	46,832,947	78,905,572	0	0	0	12,586,921	83,417,742	0	4,651,427	0	0	0	3,385,026	464,958,518	0	0	0	0	0	22,757,596	13,547,967	15,808,951	9,226,637	0	0	3,585,176	39,117,136	0	270,031	104,313,494	2,771,259	103,099,380	0	403,127	0	0	0	0	2,598,962	178,038,964	0	0	0	0	0	0	0	0	0	0	0	0	0
106214034	NOVATO COMMUNITY HOSPITAL	20182	04/01/2018	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	280	24	15	63	0	0	8	72	2	4	468	0	897	71	46	172	0	0	16	176	3	8	1,389	0	1,007	95	134	1,043	0	1	83	840	140	99	3,442	15,394,806	1,132,502	884,238	3,010,735	0	0	433,840	3,160,121	120,624	207,977	24,344,843	13,026,935	1,525,276	830,511	5,002,078	0	1,011	978,647	9,997,530	663,522	452,320	32,477,830	796,522	23,382,426	2,126,601	1,433,017	6,840,347	0	0	1,011	987,832	5,668,907	0	784,146	0	0	0	0	42,020,809	0	0	0	0	0	5,039,315	531,177	281,732	1,172,466	0	0	424,655	7,352,519	0	0	14,801,864	320,238	25,709,095	0	964,397	0	0	0	0	1,547,796	35,399,528	0	0	0	0	0	0	0	0	0	0	0	0	0