Table: 2018_quarter_3_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	20183	10/01/2017	09/30/2018	Open	San Francisco	04 - West Bay	0423	Non Profit Other	Comparable	Teaching	415-476-1000	505 PARNASSUS AVENUE	SAN FRANCISCO	94143	MARK LARET	1,019	782	726	9,205	1,908	2,769	7,020	56	0	0	14,729	0	239	35,926	0	59,231	12,028	26,562	47,293	908	0	0	81,621	0	1,207	228,850	0	433,029	67,828	82,226	190,926	1,640	0	0	684,781	0	27,861	1,488,291	2,208,513,567	462,055,245	1,044,089,762	1,497,270,426	39,044,704	0	0	3,085,081,248	0	20,137,263	8,356,192,215	1,711,671,514	260,765,992	318,419,445	751,821,330	7,600,139	0	0	2,720,207,457	0	112,564,562	5,883,050,439	36,041,353	3,251,819,190	591,814,828	1,059,767,407	1,876,636,753	0	35,398,709	0	0	3,595,319,631	0	59,163,352	0	0	0	8,557,866	10,514,519,089	0	0	0	3,714,871	3,714,871	667,095,280	129,590,863	299,958,274	363,104,203	11,193,194	0	0	2,195,312,539	0	62,184,083	3,728,438,436	158,294,929	3,676,995,823	0	8,074,486	0	0	0	0	177,720,544	2,045,598,875	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA DAVIS MEDICAL CENTER	20183	10/01/2017	09/30/2018	Open	Sacramento	02 - Golden Empire	0311	Non Profit Other	Comparable	Teaching	916-734-7020	2315 STOCKTON BOULEVARD	SACRAMENTO	95817	ANN MADDEN RICE	625	605	596	9,612	1,203	4,619	7,170	1	1	1,025	8,655	320	14	32,620	0	58,887	7,247	38,195	38,574	52	10	6,545	39,522	1,053	287	190,372	0	332,601	34,063	34,518	58,690	339	6	44,293	523,889	9,958	1,272	1,039,629	1,781,871,050	232,573,462	922,970,542	994,544,194	375,504	166,075	217,450,044	1,212,516,633	42,527,591	38,162,465	5,443,157,560	1,134,185,958	120,654,834	162,898,695	375,561,521	3,374,518	34,593	233,894,916	1,329,196,473	36,874,226	685,707	3,397,361,441	111,897,209	2,473,719,533	302,705,770	871,421,805	1,144,040,564	0	(87,151,562)	1,143,062	387,273,839	1,537,988,033	0	45,706,757	0	0	0	25,492,854	6,814,237,864	0	0	0	82,191,128	82,191,128	442,337,475	50,522,525	179,572,698	226,065,151	91,923,545	(942,394)	63,049,159	1,041,040,057	9,004,359	5,899,690	2,108,472,265	66,197,828	2,076,538,168	0	25,233,529	0	0	0	0	118,684,103	1,082,802,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106301279	UNIVERSITY OF CALIFORNIA IRVINE MEDICAL CENTER	20183	10/01/2017	09/30/2018	Open	Orange	13 - Orange	1015	Non Profit Other	Comparable	Teaching	714-456-7890	101 CITY DRIVE SOUTH	ORANGE	92868	TERRY BELMONT	417	417	417	4,689	2,272	2,936	5,640	19	0	467	5,068	588	0	21,679	0	24,773	12,625	29,686	28,233	35	0	2,615	27,118	1,401	0	126,486	0	194,174	37,918	31,041	141,489	1,649	0	2,339	212,154	19,809	0	640,573	526,683,780	291,074,759	424,955,909	600,627,656	874,441	0	81,595,814	570,331,265	43,212,256	0	2,539,355,880	487,818,145	133,583,778	61,261,670	327,173,105	2,768,745	0	18,369,028	525,265,723	70,941,150	0	1,627,181,344	71,078,442	829,781,265	303,392,243	232,703,048	809,771,237	0	11,027,979	0	0	620,428,398	0	82,947,330	0	7,881,600	(7,881,600)	30,427,920	2,991,557,862	0	1,492,804	0	0	1,492,804	184,720,660	121,266,294	249,304,655	123,732,204	(7,384,793)	0	28,886,400	475,168,590	778,156	0	1,176,472,166	57,752,919	1,084,435,011	0	12,085,505	0	0	0	0	109,680,207	764,723,551	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA SAN DIEGO MEDICAL CENTER	20183	10/01/2017	09/30/2018	Open	San Diego	14 - San Diego/Imperial	1418	Non Profit Other	Comparable	Teaching	858-657-7000	200 WEST ARBOR DRIVE	SAN DIEGO	92103	PATTY MAYSENT	808	693	693	8,068	2,857	3,232	8,289	8	0	818	8,100	659	0	32,031	0	53,496	18,677	30,601	49,319	62	0	4,885	46,836	2,749	0	206,625	0	182,612	31,089	75,009	98,928	155	0	9,227	540,857	9,052	0	946,929	832,621,274	288,837,356	365,050,451	665,124,537	865,020	0	71,163,266	726,987,615	102,633,907	0	3,053,283,426	735,328,857	213,757,247	133,811,869	532,068,073	436,365	0	71,020,874	1,071,812,138	230,772,387	0	2,989,007,810	15,613,948	1,188,964,077	379,599,118	247,478,166	971,752,603	(200,701,051)	660,262	0	106,587,449	879,100,128	0	278,242,104	0	0	0	61,703,997	3,929,000,801	0	0	0	0	0	378,986,054	122,995,485	392,415,366	285,440,004	246,946	0	19,982,746	857,995,627	55,228,207	0	2,113,290,435	102,695,168	1,925,525,933	0	21,963,784	0	0	0	0	147,245,423	1,652,071,857	40,733,605	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20183	10/01/2017	09/30/2018	Open	Los Angeles	11 - Los Angeles	0925	Non Profit Corp.	Comparable	None	323-865-3000	1441 EASTLAKE AVENUE	LOS ANGELES	90089	RICHARD PINEDA	60	60	41	449	120	215	234	0	0	19	515	0	2	1,554	0	3,275	1,024	2,580	2,606	0	0	221	3,938	0	16	13,660	0	50,435	6,594	5,959	6,271	0	0	5,036	49,437	0	780	124,512	37,865,550	12,542,363	30,549,900	28,815,321	0	0	2,923,102	56,064,900	0	117,625	168,878,761	266,267,616	35,585,193	39,304,195	38,782,536	0	0	11,715,986	202,388,683	0	1,953,182	595,997,391	935,488	243,123,531	27,923,859	59,067,492	41,848,077	0	0	0	12,543,465	140,867,408	0	0	0	0	0	1,642,539	527,951,859	0	0	0	0	0	60,644,574	20,157,635	10,692,859	25,672,213	0	0	1,861,035	117,252,974	0	643,003	236,924,293	5,960,727	206,239,181	0	0	0	0	0	0	3,932,455	37,558,437	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20183	10/01/2017	09/30/2018	Open	Los Angeles	11 - Los Angeles	0937	Non Profit Corp.	Comparable	None	818-790-7100	1812 VERDUGO BOULEVARD	GLENDALE	91208	KEITH HOBBS	158	158	89	2,995	884	143	554	0	0	0	2,298	54	16	6,944	0	16,406	5,691	663	1,637	0	0	0	7,687	118	35	32,237	0	21,434	2,764	991	6,925	0	0	0	29,532	2,125	1,288	65,059	148,823,140	33,774,963	7,693,119	25,024,672	0	0	0	98,314,723	207,118	753,852	314,591,587	98,852,801	22,157,272	5,134,018	16,690,551	0	0	0	64,512,541	136,886	2,403,013	209,887,082	2,026,006	186,617,428	42,006,818	9,794,564	31,500,887	0	0	0	0	124,893,778	0	266,013	0	0	0	873,930	397,979,424	0	0	0	0	0	61,058,513	13,925,417	3,032,573	10,214,336	0	0	0	37,933,485	77,991	256,930	126,499,245	1,600,460	133,480,792	0	(1,146,569)	0	0	0	0	3,157,868	28,187,862	0	0	0	0	0	0	0	0	0	0	0	0	0