Table: 2017_quarter_2_sum_of_four_quarters , fac_name like U*

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
106381154	UCSF MEDICAL CENTER	20172	07/01/2016	06/30/2017	Open	San Francisco	04	0423	Non Profit Other	Comparable	Teaching	(415) 476-1000	505 PARNASSUS AVENUE	SAN FRANCISCO	94143	MARK LARET	1,019	782	726	9,270	1,490	6,183	4,900	130	0	0	13,326	0	246	35,545	0	57,496	9,327	45,607	29,596	1,054	0	0	76,718	0	1,422	221,220	0	384,371	45,410	76,185	172,882	1,384	0	0	618,479	0	24,936	1,323,647	1,941,714,699	356,113,219	1,210,269,620	1,215,658,802	23,461,347	0	0	2,718,951,503	0	26,723,801	7,492,892,991	1,421,605,982	191,982,597	292,323,091	643,569,835	4,204,398	0	0	2,364,604,331	0	98,577,856	5,016,868,090	33,742,951	2,775,954,968	432,938,278	1,252,023,173	1,586,918,635	0	19,481,511	0	0	3,129,722,466	0	60,244,137	0	0	0	7,642,141	9,298,668,260	0	0	0	3,728,194	3,728,194	586,136,282	114,135,763	247,274,323	262,954,051	8,094,350	0	0	1,941,448,263	0	54,777,983	3,214,821,015	130,701,429	3,446,939,707	0	34,583,214	0	0	0	0	109,925,516	2,051,482,727	0	0	0	0	0	0	0	0	0	0	0	0	0
106231396	UKIAH VALLEY MEDICAL CENTER	20172	07/01/2016	06/30/2017	Open	Mendocino	01	0113	Church	Comparable	Rural	(707) 462-3111	275 HOSPITAL DRIVE	UKIAH	95482	GWEN MATTHEWS	67	50	50	1,361	80	238	1,116	0	0	97	482	9	19	3,402	0	5,260	325	651	3,339	0	0	403	1,272	19	66	11,335	0	77,438	3,945	5,898	71,151	0	0	13,080	55,714	126	4,902	232,254	62,330,604	3,497,577	8,687,562	44,915,152	0	0	4,349,614	18,502,856	197,544	889,187	143,370,096	123,126,025	7,020,744	8,838,061	96,588,600	0	0	17,109,643	72,745,018	194,856	8,149,482	333,772,429	2,391,813	137,148,075	8,005,902	13,073,535	109,502,196	0	0	0	14,205,890	46,844,067	0	4,773,772	0	0	0	8,530,277	344,475,527	0	38,804,053	0	0	38,804,053	45,524,519	2,340,401	4,170,018	68,275,936	0	0	6,938,348	43,339,146	12,306	870,377	171,471,051	3,748,678	155,499,265	0	65,111	727	1,995	9,560,995	0	11,717,838	50,444,941	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA - DAVIS MEDICAL CENTER	20172	07/01/2016	06/30/2017	Open	Sacramento	02	0311	Non Profit Other	Comparable	Teaching	(916) 734-7020	2315 STOCKTON BOULEVARD	SACRAMENTO	95817	ANN MADDEN RICE	627	601	601	9,249	1,161	4,714	6,923	71	2	1,074	9,351	250	20	32,815	0	58,057	7,104	37,107	38,949	486	52	6,937	42,264	863	82	191,901	0	300,091	29,141	31,822	60,745	411	0	31,180	562,362	8,393	678	1,024,823	1,757,454,051	225,846,376	889,757,075	1,020,120,142	8,612,894	2,194,509	225,469,581	1,332,074,147	25,076,380	2,954,677	5,489,559,832	947,599,143	95,664,343	151,010,009	339,428,626	2,320,157	0	226,197,926	1,369,004,446	30,241,555	892,363	3,162,358,568	108,875,915	2,236,462,502	272,807,909	794,312,953	1,138,232,261	0	8,518,717	1,928,508	400,084,882	1,596,508,506	0	19,862,948	0	0	0	152,559,043	6,730,154,144	0	0	0	133,207,834	133,207,834	468,590,692	48,635,359	160,682,742	215,135,692	2,414,333	266,002	51,582,624	1,102,897,984	3,628,658	1,138,004	2,054,972,090	76,165,851	2,019,864,903	0	17,850,796	0	0	0	0	104,527,000	1,028,734,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106301279	UNIVERSITY OF CALIFORNIA - IRVINE MEDICAL CENTER	20172	07/01/2016	06/30/2017	Open	Orange	13	1015	Non Profit Other	Comparable	Teaching	(714) 456-7890	101 CITY DRIVE SOUTH	ORANGE	92868	TERRY BELMONT	417	417	417	4,574	2,069	3,145	5,301	0	0	264	5,495	422	0	21,270	0	25,648	11,591	29,427	25,775	0	0	1,095	28,639	1,016	0	123,191	0	177,883	31,678	29,351	131,160	1,727	0	1,931	191,794	17,463	0	582,987	554,716,888	273,614,407	437,851,378	561,843,740	0	0	31,026,880	612,909,441	22,991,108	0	2,494,953,842	456,210,412	104,025,064	69,214,884	300,645,146	2,431,424	0	10,079,778	531,352,109	21,177,265	0	1,495,136,082	23,415,446	812,769,065	343,900,488	338,126,517	728,713,873	0	1,834,500	0	0	613,202,324	0	40,958,047	0	7,881,600	(7,881,600)	7,765,996	2,910,686,256	0	1,912,875	0	0	1,912,875	198,158,235	33,738,983	168,939,745	135,687,888	596,924	0	17,691,212	531,059,226	(4,555,670)	0	1,081,316,543	20,128,082	986,301,030	0	5,230,551	0	0	0	0	86,499,184	738,829,666	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA - SAN DIEGO MEDICAL CENTER	20172	07/01/2016	06/30/2017	Open	San Diego	14	1418	Non Profit Other	Comparable	Teaching	(858) 657-7000	200 WEST ARBOR DRIVE	SAN DIEGO	92103	PATTY MAYSENT	808	726	726	7,313	2,496	3,204	7,625	7	0	742	7,301	511	0	29,199	0	47,444	16,445	29,513	42,555	21	0	4,057	42,072	2,022	0	184,129	0	192,135	71,613	74,650	196,790	1,037	0	19,311	267,618	9,056	0	832,210	678,975,574	231,879,903	338,047,427	515,119,452	235,860	0	61,753,040	583,404,884	80,852,560	0	2,490,268,700	665,469,160	166,667,180	115,344,223	444,829,011	328,480	0	61,721,689	895,884,402	193,921,966	0	2,544,166,111	9,213,329	1,029,644,172	305,290,681	254,326,661	816,961,965	(190,043,740)	291,308	0	93,429,778	698,313,055	0	235,517,499	0	0	0	35,091,573	3,288,036,281	0	0	0	0	0	314,800,562	93,256,402	389,108,729	142,986,497	173,032	0	20,931,622	745,884,662	39,257,024	0	1,746,398,530	164,536,472	1,807,416,358	0	19,139,003	0	0	0	0	230,163,741	1,623,785,186	0	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20172	07/01/2016	06/30/2017	Open	Los Angeles	11	0925	Non Profit Corp.	Comparable	None	(323) 865-3000	1441 EASTLAKE AVENUE	LOS ANGELES	90089	BOB ALLEN	60	60	34	511	94	217	208	0	0	21	605	0	3	1,659	0	3,056	647	2,635	2,013	0	0	168	4,764	0	21	13,304	0	45,877	4,910	5,146	4,850	0	0	4,226	47,836	0	654	113,499	33,141,884	7,848,957	29,661,987	21,606,242	0	0	1,983,343	56,274,721	0	254,167	150,771,301	244,133,369	28,354,057	30,370,141	31,844,257	0	0	9,613,013	218,441,892	0	2,110,753	564,867,482	250,445	217,788,447	28,037,430	50,411,678	32,935,360	0	0	0	8,361,802	148,628,772	0	538,224	0	0	0	975,986	487,928,144	0	0	0	0	0	59,391,053	8,144,988	9,607,501	20,495,068	0	0	3,226,761	125,994,882	(298,034)	1,148,420	227,710,639	7,818,477	181,163,144	0	82,968	0	0	0	0	1,588,129	38,415,958	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20172	07/01/2016	06/30/2017	Open	Los Angeles	11	0937	Non Profit Corp.	Comparable	None	(818) 790-7100	1812 VERDUGO BOULEVARD	GLENDALE	91208	KEITH HOBBS	158	158	92	2,812	759	147	465	0	0	0	2,248	42	47	6,520	0	18,475	3,923	516	2,042	0	0	0	7,533	124	90	32,703	0	20,906	2,449	968	6,144	0	0	0	27,924	1,876	2,133	62,400	103,189,900	25,733,218	4,522,562	14,835,707	0	0	0	78,593,652	3,622,356	3,359,759	233,857,154	52,890,053	12,666,049	2,336,752	9,599,353	0	0	0	63,506,132	4,358,648	5,563,092	150,920,079	(1,941,809)	110,921,606	26,905,027	4,565,014	18,582,268	0	0	0	0	114,616,458	0	8,880,297	0	0	0	3,370,104	285,898,965	0	0	0	0	0	45,158,347	11,494,237	2,294,299	5,852,792	0	0	0	27,483,326	2,381,781	4,213,486	98,878,268	2,055,576	111,013,563	0	(965,959)	0	0	0	0	12,498,481	30,741,709	0	0	0	0	0	0	0	0	0	0	0	0	0