Table: 2018_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	2018R1	04/01/2017	03/31/2018	Open	San Francisco	04	0423	Non Profit Other	Comparable	Rural	415-476-1000	505 PARNASSUS AVENUE	SAN FRANCISCO	94143	MARK LARET	1,019	782	726	9,261	1,864	2,918	7,307	57	0	0	14,855	0	251	36,513	0	57,385	11,463	29,810	44,841	646	0	0	80,752	0	1,359	226,256	0	410,700	61,081	82,410	187,370	1,460	0	0	665,903	0	27,905	1,436,829	2,093,974,489	425,198,556	1,130,269,014	1,385,047,056	19,384,233	0	0	2,956,093,155	0	28,669,321	8,038,635,824	1,570,552,475	228,387,800	311,134,488	710,964,000	5,797,126	0	0	2,594,799,455	0	104,257,949	5,525,893,293	27,917,599	3,004,884,711	531,816,084	1,167,732,334	1,762,577,092	0	18,515,404	0	0	3,410,988,031	0	62,391,188	0	0	0	8,411,007	9,995,233,450	0	0	0	3,851,467	3,851,467	658,953,715	120,787,816	270,954,372	325,834,290	6,635,987	0	0	2,129,581,078	0	60,399,876	3,573,147,134	125,193,987	3,473,793,375	0	(1,234,347)	0	0	0	0	126,427,677	2,052,435,807	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA - DAVIS MEDICAL CENTER	2018R1	04/01/2017	03/31/2018	Open	Sacramento	02	0311	Non Profit Other	Comparable	Rural	916-734-7020	2315 STOCKTON BOULEVARD	SACRAMENTO	95817	ANN MADDEN RICE	625	611	611	9,694	1,114	4,760	7,172	24	3	1,089	9,134	291	8	33,289	0	59,920	6,535	39,214	37,393	154	62	6,370	40,748	1,005	96	191,497	0	313,460	30,889	34,396	56,219	325	6	41,045	517,589	9,779	1,084	1,004,792	1,804,347,374	217,359,594	983,194,940	988,998,878	2,729,698	2,360,584	211,715,045	1,286,363,613	33,924,830	5,031,826	5,536,026,382	1,010,138,561	101,069,693	152,773,503	336,079,560	2,671,919	34,593	329,868,138	1,340,945,634	32,106,284	634,760	3,306,322,645	109,892,962	2,350,886,484	265,366,734	880,493,110	1,111,746,682	0	(85,461,120)	2,107,254	485,208,986	1,509,940,844	0	20,837,686	0	0	0	128,474,310	6,779,493,932	0	0	0	113,338,596	113,338,596	463,599,451	53,062,553	178,867,295	213,331,755	91,884,698	287,923	55,352,235	1,115,628,845	2,654,254	1,524,682	2,176,193,691	83,673,009	2,044,275,668	0	22,465,321	0	0	0	0	133,773,000	1,065,367,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106301279	UNIVERSITY OF CALIFORNIA - IRVINE MEDICAL CENTER	2018R1	04/01/2017	03/31/2018	Open	Orange	13	1015	Non Profit Other	Comparable	Rural	714-456-7890	101 CITY DRIVE SOUTH	ORANGE	92868	TERRY BELMONT	417	417	417	4,867	2,174	3,059	5,571	0	0	391	5,419	463	0	21,944	0	25,377	12,580	29,436	26,673	0	0	2,233	28,097	1,151	0	125,547	0	187,535	35,376	30,591	135,674	1,249	0	2,193	208,822	15,613	0	617,053	547,760,271	291,302,325	432,440,418	572,323,609	0	0	63,936,808	589,959,792	34,129,368	0	2,531,852,591	468,167,855	114,197,754	65,698,582	311,706,566	2,817,305	0	17,547,821	514,782,846	40,908,755	0	1,535,827,484	51,389,774	803,870,121	306,569,307	291,221,922	821,539,968	0	6,638,624	0	0	591,571,935	0	62,297,074	(100,000)	7,970,466	(7,970,466)	13,051,879	2,948,050,604	0	1,645,569	0	0	1,645,569	212,058,005	98,930,772	202,707,202	68,345,652	(3,821,319)	0	30,094,855	513,170,703	(210,830)	0	1,121,275,040	33,275,906	1,038,367,985	0	9,393,421	0	0	0	0	107,406,251	754,547,941	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA - SAN DIEGO MEDICAL CENTER	2018R1	04/01/2017	03/31/2018	Open	San Diego	14	1418	Non Profit Other	Comparable	Rural	858-657-7000	200 WEST ARBOR DRIVE	SAN DIEGO	92103	PATTY MAYSENT	808	762	762	7,806	2,744	3,124	8,316	9	0	860	7,737	691	0	31,287	0	50,394	17,941	27,873	49,015	50	0	5,105	44,168	3,051	0	197,597	0	175,899	45,481	73,746	125,368	150	0	8,219	471,708	8,865	0	909,436	769,275,960	275,635,071	335,704,526	628,233,973	759,678	0	76,633,080	651,759,515	103,979,642	0	2,841,981,445	693,579,028	186,899,703	122,061,634	506,845,408	330,046	0	65,075,197	987,350,635	222,764,853	0	2,784,906,504	9,162,245	1,128,551,081	348,940,876	242,876,672	983,256,478	(199,191,605)	639,302	0	106,647,228	791,278,325	0	260,596,517	0	0	0	51,473,564	3,724,230,683	0	0	0	0	0	334,303,907	113,593,898	414,081,093	151,822,902	250,422	0	25,998,806	796,358,262	66,247,976	0	1,902,657,266	175,607,168	1,855,603,303	0	24,445,716	0	0	0	0	136,642,022	1,629,507,216	83,285,710	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	2018R1	04/01/2017	03/31/2018	Open	Los Angeles	11	0925	Non Profit Corp.	Comparable	None	323-865-3000	1441 EASTLAKE AVENUE	LOS ANGELES	90089	ANGELIE GAWECO	60	60	37	452	104	195	189	0	0	16	595	0	2	1,553	0	3,128	877	2,197	1,650	0	0	252	4,084	0	19	12,207	0	44,308	4,855	4,982	5,088	0	0	4,731	45,497	0	647	110,108	41,199,728	9,530,779	25,637,276	19,533,543	0	0	2,164,660	55,055,877	0	74,778	153,196,641	239,908,340	28,231,308	33,906,227	35,816,816	0	0	10,829,089	198,304,186	0	1,696,560	548,692,526	1,471,593	229,099,460	25,264,100	50,413,615	37,407,587	0	0	0	9,670,343	133,305,919	0	123,889	0	0	0	1,361,854	488,118,360	0	0	0	0	0	51,426,828	12,419,557	8,998,253	17,825,065	0	0	3,077,937	119,524,174	0	498,993	213,770,807	7,313,220	195,530,392	0	225,077	0	0	0	0	4,762,499	39,146,840	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	2018R1	04/01/2017	03/31/2018	Open	Los Angeles	11	0937	Non Profit Corp.	Comparable	None	818-790-7100	1812 VERDUGO BOULEVARD	GLENDALE	91208	KEITH HOBBS	158	158	98	2,991	897	150	538	0	0	0	2,337	39	26	6,978	0	17,269	4,855	611	1,785	0	0	0	7,598	64	56	32,238	0	21,173	2,658	1,001	6,745	0	0	0	29,033	2,061	1,514	64,185	123,047,854	30,258,913	6,261,446	19,657,153	0	0	0	92,951,532	1,018,135	3,413,908	276,608,941	80,688,264	19,655,566	4,128,522	12,952,132	0	0	0	60,267,465	647,900	3,489,538	181,829,387	1,733,417	150,142,138	36,759,285	7,666,257	24,042,103	0	0	0	0	114,754,631	0	1,382,072	0	0	0	3,850,917	340,330,820	0	0	0	0	0	53,593,979	13,155,194	2,723,710	8,567,182	0	0	0	38,464,364	420,390	1,182,689	118,107,508	1,976,534	121,878,305	0	(1,109,634)	0	0	0	0	4,643,657	30,207,613	0	0	0	0	0	0	0	0	0	0	0	0	0