Table: 2017_quarter_4_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	20174	01/01/2017	12/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,223	1,782	3,046	7,188	55	0	0	14,830	0	253	36,377	0	56,774	11,204	31,361	43,622	611	0	0	79,300	0	1,373	224,245	0	403,942	55,050	81,028	184,800	1,304	0	0	649,775	0	26,530	1,402,429	2,019,097,156	404,105,004	1,181,338,643	1,310,684,597	8,839,397	0	0	2,877,226,115	0	32,076,900	7,833,367,812	1,501,036,288	217,206,375	306,575,176	694,610,316	5,344,213	0	0	2,504,629,320	0	108,535,046	5,337,936,734	27,562,156	2,878,384,188	500,886,767	1,237,406,421	1,696,028,551	0	9,577,408	0	0	3,302,500,990	0	63,437,277	0	0	0	10,228,244	9,726,012,002	0	0	0	3,617,191	3,617,191	640,977,256	119,531,190	247,809,734	301,697,285	4,567,203	0	0	2,069,165,470	0	65,161,597	3,448,909,735	124,476,007	3,441,692,131	0	(11,308,077)	0	0	0	0	103,598,518	2,037,673,026	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA DAVIS MEDICAL CENTER	20174	01/01/2017	12/31/2017	Open	Sacramento	02	0311	Non Profit Other	Comparable	Teaching	916-734-7020	2315 STOCKTON BOULEVARD	SACRAMENTO	95817	ANN MADDEN RICE	625	605	605	9,681	1,092	4,652	7,115	39	3	1,109	9,329	268	10	33,298	0	60,460	6,628	38,783	38,061	200	62	6,862	42,326	942	44	194,368	0	307,432	30,489	31,615	57,853	375	6	41,076	551,617	8,120	585	1,029,168	1,792,597,682	212,234,501	939,257,317	987,284,660	2,889,850	2,360,584	231,348,545	1,329,048,763	27,817,322	2,180,627	5,527,019,851	984,371,838	97,529,854	152,618,783	332,829,847	2,289,856	34,593	283,933,566	1,374,007,884	30,473,462	667,224	3,258,756,907	109,104,886	2,292,685,167	257,693,600	849,067,310	1,099,010,304	0	(84,779,784)	2,107,254	459,977,536	1,582,339,588	0	16,978,108	0	0	0	142,709,154	6,726,893,123	0	0	0	130,650,712	130,650,712	484,284,353	52,070,755	168,113,349	219,292,081	90,981,450	287,923	54,282,614	1,118,977,503	374,441	869,878	2,189,534,347	79,889,202	2,042,593,714	0	17,975,668	0	0	0	0	128,986,000	1,049,673,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106301279	UNIVERSITY OF CALIFORNIA IRVINE MEDICAL CENTER	20174	01/01/2017	12/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,740	2,127	3,167	5,428	0	0	324	5,351	425	0	21,562	0	25,909	12,187	29,279	26,012	0	0	1,889	27,706	1,212	0	124,194	0	181,480	34,515	29,161	128,921	906	0	2,139	204,973	13,525	0	595,620	567,813,793	292,558,775	432,772,239	569,405,446	0	0	52,160,278	588,249,825	37,765,082	0	2,540,725,438	471,906,490	109,373,410	67,198,319	314,669,014	2,412,988	0	14,825,723	518,550,386	29,061,282	0	1,527,997,612	39,515,619	828,457,206	333,320,676	306,895,721	798,677,871	0	3,646,001	0	0	579,993,138	0	59,515,226	(100,000)	7,940,844	(7,940,844)	9,174,838	2,959,096,296	0	1,806,868	0	0	1,806,868	211,263,077	68,611,509	188,864,961	91,413,333	(1,233,013)	0	27,470,382	526,807,073	(1,763,700)	0	1,111,433,622	29,444,326	1,016,262,639	0	5,687,015	0	0	0	0	107,540,887	749,820,143	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA SAN DIEGO MEDICAL CENTER	20174	01/01/2017	12/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	762	762	7,669	2,693	3,182	8,190	8	0	797	7,687	608	0	30,834	0	50,116	17,224	27,559	47,025	28	0	4,407	43,912	2,816	0	193,087	0	171,874	54,837	73,887	150,626	107	0	10,853	408,367	9,055	0	879,606	748,537,797	255,352,027	326,038,920	597,512,150	409,241	0	68,029,124	632,453,616	92,111,000	0	2,720,443,875	680,940,804	174,826,805	115,037,382	485,007,017	276,373	0	65,198,133	962,839,845	210,114,598	0	2,694,240,957	8,729,920	1,104,276,823	326,251,838	245,314,051	870,786,320	(188,058,650)	435,597	0	99,214,751	757,843,132	0	252,514,460	0	0	0	42,311,367	3,519,619,609	0	0	0	0	0	325,201,778	103,926,994	383,820,901	211,732,846	150,017	0	25,382,586	795,138,965	49,711,136	0	1,895,065,223	166,906,695	1,850,018,577	0	19,875,566	0	0	0	0	146,073,888	1,631,491,580	83,285,710	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20174	01/01/2017	12/31/2017	Open	Los Angeles	11	0925	Non Profit Corp.	Comparable	None	323-865-3000	1441 EASTLAKE AVENUE	LOS ANGELES	90089	ANGELIE GAWECO	60	60	32	461	102	193	206	0	0	16	589	0	3	1,570	0	3,188	818	2,220	1,654	0	0	222	4,168	0	19	12,289	0	44,799	4,912	4,723	4,978	0	0	4,624	46,056	0	707	110,799	42,006,192	9,949,263	26,158,746	19,773,991	0	0	2,051,520	53,723,165	0	202,126	153,865,003	244,864,959	29,805,517	32,101,130	35,233,089	0	0	10,668,153	213,164,798	0	1,547,828	567,385,474	1,172,508	231,503,110	28,635,608	49,825,755	34,809,043	0	0	0	8,823,340	141,194,450	0	240,190	0	0	0	1,087,014	497,291,018	0	0	0	0	0	54,905,397	11,055,272	8,333,437	20,108,796	0	0	3,874,715	125,262,332	0	419,510	223,959,459	8,475,935	189,369,594	0	241,646	0	0	0	0	3,147,836	38,405,109	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20174	01/01/2017	12/31/2017	Open	Los Angeles	11	0937	Non Profit Corp.	Comparable	None	818-790-7100	1812 VERDUGO BOULEVARD	GLENDALE	91208	KEITH HOBBS	158	158	85	2,873	854	162	477	0	0	0	2,289	43	37	6,735	0	17,739	4,555	549	1,715	0	0	0	7,504	98	73	32,233	0	21,350	2,639	963	6,396	0	0	0	28,258	2,034	1,671	63,311	113,082,091	28,030,867	5,775,733	16,131,381	0	0	0	91,275,863	2,612,413	4,425,001	261,333,349	73,505,838	18,159,278	3,763,165	10,621,198	0	0	0	58,202,589	1,570,249	3,612,092	169,434,409	184,659	138,363,300	34,274,440	7,070,570	19,859,474	0	0	0	0	111,545,314	0	3,215,391	0	0	0	5,136,319	319,649,467	0	0	0	0	0	48,224,628	11,915,705	2,468,327	6,893,105	0	0	0	37,933,136	1,699,578	1,983,812	111,118,291	2,409,987	117,466,498	0	(1,532,048)	0	0	0	0	5,787,473	30,694,556	0	0	0	0	0	0	0	0	0	0	0	0	0