Table: 2017_quarter_1_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	20171	04/01/2016	03/31/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,185	1,290	7,624	3,773	143	0	0	12,854	0	223	35,092	0	57,329	8,117	50,985	23,190	1,055	0	0	76,420	0	1,341	218,437	0	370,179	40,721	74,592	165,974	1,409	0	0	607,631	0	22,468	1,282,974	1,898,116,527	328,973,604	1,187,404,014	1,199,537,770	26,353,722	0	0	2,691,256,151	0	20,158,903	7,351,800,691	1,386,753,838	174,296,941	286,879,878	629,125,989	5,201,009	0	0	2,320,621,296	0	95,026,946	4,897,905,897	39,977,544	2,725,024,393	323,945,686	1,201,251,890	1,223,436,334	0	23,296,606	0	0	3,510,885,607	0	41,708,012	0	0	0	7,767,836	9,097,293,908	0	0	0	6,804,952	6,804,952	557,136,414	178,077,788	269,035,477	594,848,158	8,156,096	0	0	1,490,180,606	0	61,783,093	3,159,217,632	142,942,184	3,370,472,683	0	29,389,653	0	0	0	0	102,602,636	2,061,633,015	0	0	0	0	0	0	0	0	0	0	0	0	0
106231396	UKIAH VALLEY MEDICAL CENTER	20171	04/01/2016	03/31/2017	Open	Mendocino	01	0113	Church	Comparable	Rural	(707) 462-3111	275 HOSPITAL DRIVE	UKIAH	95482	GWEN MATTHEWS	67	50	50	1,397	74	231	1,104	0	0	100	501	9	19	3,435	0	5,533	300	657	3,279	0	0	410	1,292	19	69	11,559	0	77,712	3,579	7,150	72,849	0	0	13,551	57,169	126	4,729	236,865	64,533,038	3,168,057	8,581,963	42,350,485	0	0	4,301,150	19,407,342	197,544	813,620	143,353,199	121,601,405	6,972,480	9,077,677	95,826,318	0	0	17,529,100	72,655,929	194,856	7,862,475	331,720,240	1,007,379	136,531,970	7,609,976	12,886,842	109,633,441	0	0	0	14,548,010	47,692,802	0	4,910,006	0	0	0	8,646,597	343,467,023	0	35,548,789	0	0	35,548,789	46,930,103	2,381,058	4,518,065	61,685,145	0	0	6,991,936	43,377,500	12,306	1,259,092	167,155,205	3,638,471	151,230,468	0	35,193	707	2,130	9,693,673	0	10,572,489	46,873,759	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA - DAVIS MEDICAL CENTER	20171	04/01/2016	03/31/2017	Open	Sacramento	02	0311	Non Profit Other	Comparable	Teaching	(916) 734-7020	2315 STOCKTON BOULEVARD	SACRAMENTO	95817	ANN MADDEN RICE	621	601	601	9,140	1,212	4,830	6,869	76	0	1,040	9,407	228	18	32,820	0	58,082	7,487	38,734	39,238	472	0	6,676	42,703	824	79	194,295	0	289,819	27,044	29,119	64,279	468	3	38,168	550,758	6,645	287	1,006,590	1,708,802,764	232,730,364	911,451,176	998,152,094	10,633,771	0	220,847,914	1,315,239,481	21,935,729	2,851,830	5,422,645,123	941,424,020	93,913,882	152,123,472	354,396,502	2,437,494	32,186	168,405,227	1,382,286,425	29,425,892	994,633	3,125,439,733	103,561,961	2,185,905,824	276,800,694	767,031,461	1,129,377,832	0	11,130,173	30,292	339,691,248	1,621,768,376	0	(20,099,262)	0	0	0	196,404,955	6,611,603,554	0	0	0	126,435,264	126,435,264	464,320,959	49,776,101	235,723,589	216,989,950	1,941,091	1,895	49,561,892	1,043,679,105	1,725,784	(803,800)	2,062,916,566	81,988,132	1,975,649,710	0	16,731,420	0	0	0	0	97,036,000	1,008,833,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106301279	UNIVERSITY OF CALIFORNIA - IRVINE MEDICAL CENTER	20171	04/01/2016	03/31/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,364	2,062	3,241	5,277	0	0	205	5,429	458	0	21,036	0	25,261	11,257	30,520	25,879	0	0	947	28,514	1,078	0	123,456	0	175,270	29,039	29,639	127,886	1,708	0	1,644	176,668	18,584	0	560,438	542,355,958	264,259,786	444,117,333	559,321,359	0	0	26,539,267	621,481,571	26,874,952	0	2,484,950,226	441,226,649	101,940,533	66,951,311	291,679,167	2,509,826	0	6,802,292	541,110,310	23,317,932	0	1,475,538,020	19,712,471	763,889,718	332,792,025	442,759,277	682,679,769	0	2,019,317	0	0	647,742,022	0	43,851,969	(636,615)	5,822,334	(5,822,334)	7,288,890	2,942,098,843	0	1,833,486	0	0	1,833,486	219,692,889	33,408,294	68,309,367	170,154,243	490,509	0	13,629,088	514,849,859	(311,360)	0	1,020,222,889	19,898,507	979,778,619	0	3,854,963	0	0	0	0	70,198,858	721,874,802	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA - SAN DIEGO MEDICAL CENTER	20171	04/01/2016	03/31/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,135	2,397	3,443	7,235	9	0	701	7,230	416	0	28,566	0	46,524	15,457	31,204	39,425	31	0	3,971	41,221	1,774	0	179,607	0	204,926	60,187	70,741	182,363	1,078	0	20,800	263,536	10,807	0	814,438	660,134,083	214,479,419	349,467,275	484,644,758	488,531	0	58,017,309	569,853,743	69,739,806	0	2,406,824,924	658,492,020	159,877,812	118,703,910	417,482,312	302,729	0	57,489,865	867,873,824	171,058,937	0	2,451,281,409	8,112,913	1,002,448,581	288,481,762	297,646,242	762,777,936	(177,936,592)	632,294	0	86,718,523	683,507,611	0	202,546,445	0	0	0	27,376,774	3,182,312,489	0	0	0	0	0	316,177,521	85,875,469	348,461,535	139,349,133	158,966	0	16,176,432	731,342,491	38,252,297	0	1,675,793,844	153,625,806	1,769,167,155	0	14,692,563	0	0	0	0	270,952,422	1,586,939,431	0	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20171	04/01/2016	03/31/2017	Open	Los Angeles	11	0925	Non Profit Corp.	Comparable	None	(323) 865-3000	1441 EASTLAKE AVENUE	LOS ANGELES	90089	BOB ALLEN	60	60	38	487	81	219	231	0	0	16	569	0	4	1,607	0	3,080	503	2,628	2,324	0	0	69	4,456	0	25	13,085	0	45,661	4,737	5,333	4,495	0	0	4,147	47,352	0	704	112,429	34,272,262	6,326,075	30,411,896	25,152,723	0	0	1,025,430	51,517,165	0	359,083	149,064,634	239,622,823	25,781,942	31,392,330	28,170,917	0	0	8,540,638	219,989,533	0	2,153,834	555,652,017	430,730	220,625,926	24,939,948	52,395,565	30,513,448	0	0	0	7,726,597	147,862,008	0	414,335	0	0	0	958,922	485,867,479	0	0	0	0	0	53,101,236	7,145,308	9,376,716	22,774,339	0	0	1,832,222	123,481,163	(298,034)	1,436,222	218,849,172	5,527,379	174,995,183	0	220,302	0	0	0	0	2,247,364	37,526,208	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20171	04/01/2016	03/31/2017	Open	Los Angeles	11	0937	Non Profit Corp.	Comparable	None	(818) 790-7100	1812 VERDUGO BOULEVARD	GLENDALE	91208	KEITH HOBBS	158	158	98	2,773	679	163	422	0	0	0	2,170	55	55	6,317	0	18,546	3,278	695	1,999	0	0	0	7,167	171	117	31,973	0	20,593	2,323	1,063	5,930	0	0	0	27,680	2,370	1,810	61,769	101,781,925	22,095,448	5,551,185	14,824,395	0	0	0	65,306,466	3,815,731	2,834,604	216,209,754	46,178,189	9,272,265	2,089,270	10,124,409	0	0	0	62,464,774	7,473,746	4,844,918	142,447,571	(3,898,913)	101,798,478	21,097,138	5,368,041	20,019,353	0	0	0	0	106,295,159	0	12,386,747	0	0	0	2,360,995	265,426,998	0	0	0	0	0	46,161,636	10,270,572	2,272,414	4,929,451	0	0	0	21,476,081	2,047,377	6,072,796	93,230,327	1,711,481	107,353,851	0	(650,975)	0	0	0	0	12,644,753	30,609,015	0	0	0	0	0	0	0	0	0	0	0	0	0