Table: 2018_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	2018R2	07/01/2017	06/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,171	1,904	2,805	7,195	56	0	0	14,795	0	257	36,183	0	57,966	11,750	28,056	45,717	741	0	0	81,113	0	1,329	226,672	0	422,599	64,655	83,508	188,929	1,473	0	0	677,034	0	26,709	1,464,907	2,141,495,183	444,192,754	1,086,882,821	1,435,398,484	29,616,142	0	0	3,048,225,434	0	22,961,632	8,208,772,450	1,644,978,680	244,218,115	318,670,518	732,148,523	6,866,499	0	0	2,648,003,504	0	106,217,012	5,701,102,851	36,357,874	3,132,331,108	564,319,855	1,098,945,577	1,812,013,366	0	27,350,959	0	0	3,510,470,789	0	58,359,873	0	0	0	9,022,324	10,249,171,725	0	0	0	3,798,089	3,798,089	653,096,073	122,776,773	303,324,767	345,827,535	9,088,114	0	0	2,171,807,549	0	58,580,854	3,664,501,665	140,297,919	3,576,839,384	0	1,917,469	0	0	0	0	163,087,078	2,048,944,847	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA DAVIS MEDICAL CENTER	2018R2	07/01/2017	06/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	611	611	9,684	1,151	4,710	7,225	1	1	1,056	8,922	315	12	33,077	0	60,677	7,000	39,480	38,640	52	10	6,196	40,465	1,013	146	193,679	0	332,601	34,063	34,518	58,690	339	6	44,293	523,889	9,958	1,272	1,039,629	1,797,065,865	227,916,189	972,517,671	978,678,917	375,504	166,075	210,475,731	1,245,790,963	39,199,565	7,085,457	5,479,271,937	1,085,090,803	111,576,366	161,029,461	358,697,165	2,929,200	34,593	244,759,894	1,355,063,777	34,539,696	479,987	3,354,200,942	107,752,924	2,444,613,610	291,214,570	898,665,517	1,118,111,300	0	(87,752,712)	1,143,062	395,198,425	1,586,359,072	0	27,601,382	0	0	0	58,074,101	6,840,981,251	0	0	0	94,334,291	94,334,291	437,543,058	48,277,984	183,225,369	219,264,782	92,079,377	(942,394)	59,015,238	1,034,409,811	9,029,977	4,922,717	2,086,825,919	73,924,636	2,053,808,925	0	23,394,162	0	0	0	0	123,605,103	1,078,568,104	0	0	0	0	0	0	0	0	0	0	0	0	0
106301279	UNIVERSITY OF CALIFORNIA IRVINE MEDICAL CENTER	2018R2	07/01/2017	06/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,732	2,232	2,996	5,610	0	0	432	5,177	549	0	21,728	0	25,004	12,516	29,597	27,278	0	0	2,452	27,284	1,506	0	125,637	0	195,250	36,075	31,994	142,649	1,636	0	2,193	213,086	17,783	0	640,666	533,733,886	289,879,088	423,829,845	581,646,100	0	0	71,625,166	575,751,713	44,854,338	0	2,521,320,136	479,401,049	126,342,855	64,998,791	318,701,212	3,150,048	0	17,425,307	519,208,929	55,780,445	0	1,585,008,636	58,512,931	827,697,560	294,216,329	239,136,858	795,280,269	0	11,091,414	0	0	617,246,496	0	77,449,252	(100,000)	7,881,600	(7,881,600)	22,287,292	2,942,818,401	0	1,656,699	0	0	1,656,699	185,437,375	122,005,614	245,481,902	110,933,618	(7,941,366)	0	30,537,542	477,714,146	998,239	0	1,165,167,070	44,865,436	1,049,881,199	0	10,754,813	0	0	0	0	105,014,060	764,559,415	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA SAN DIEGO MEDICAL CENTER	2018R2	07/01/2017	06/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	707	707	7,901	2,739	3,225	8,376	6	0	870	7,941	625	0	31,683	0	51,965	17,491	29,549	48,823	42	0	5,290	45,472	2,799	0	201,431	0	179,334	28,791	74,271	99,079	174	0	8,654	531,959	9,172	0	931,434	799,719,583	271,584,997	348,258,837	645,412,497	721,183	0	77,863,328	694,403,226	101,550,882	0	2,939,514,533	712,825,566	197,689,965	126,842,398	521,633,424	230,161	0	67,186,834	1,027,673,964	225,846,634	0	2,879,928,946	11,306,555	1,157,441,784	355,031,478	253,029,547	945,395,643	(198,963,396)	558,120	0	107,479,992	837,590,201	0	263,509,667	0	0	0	57,926,269	3,790,305,860	0	0	0	0	0	355,103,365	114,243,484	361,135,084	281,650,276	229,208	0	26,263,618	826,560,720	63,951,864	0	2,029,137,619	99,317,404	1,893,215,520	0	20,207,815	0	0	0	0	107,532,181	1,634,680,483	83,285,710	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	2018R2	07/01/2017	06/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	459	110	202	219	0	0	22	564	0	2	1,578	0	3,402	951	2,425	2,055	0	0	248	3,746	0	19	12,846	0	47,085	5,837	5,570	5,621	0	0	4,919	46,856	0	692	116,580	44,696,054	10,899,269	28,495,773	23,116,298	0	0	2,978,505	53,735,811	0	74,778	163,996,488	253,727,746	30,959,622	37,653,928	36,886,010	0	0	10,462,170	201,491,171	0	1,696,689	572,877,336	1,100,927	241,177,712	25,080,921	56,568,248	38,293,457	0	0	0	11,399,995	137,739,684	0	0	0	0	0	1,605,149	512,966,093	0	0	0	0	0	56,808,678	16,724,504	9,475,244	21,619,926	0	0	1,804,408	117,094,120	0	380,851	223,907,731	6,268,196	202,545,914	0	209,598	0	0	0	0	4,399,002	38,128,701	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	2018R2	07/01/2017	06/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	85	2,944	869	144	552	0	0	0	2,306	49	21	6,885	0	16,530	5,176	594	1,657	0	0	0	7,470	80	43	31,550	0	21,202	2,690	987	6,781	0	0	0	29,394	2,094	1,459	64,607	134,500,677	30,873,321	7,133,031	22,863,193	0	0	0	92,963,415	218,746	2,405,136	290,957,519	89,901,574	20,326,595	4,787,059	15,324,513	0	0	0	61,359,294	145,506	3,303,776	195,148,317	1,671,973	167,311,978	37,901,149	8,905,755	28,522,700	0	0	0	0	117,085,619	0	268,935	0	0	0	2,911,584	364,579,693	0	0	0	0	0	57,090,272	13,298,767	3,014,335	9,665,006	0	0	0	37,237,088	95,317	1,125,358	121,526,143	2,272,915	129,964,678	0	(1,150,287)	0	0	0	0	4,539,983	30,215,980	0	0	0	0	0	0	0	0	0	0	0	0	0