Table: 2017_quarter_4_complete_data_set_4_13_18 , 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	10/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	2,289	451	725	1,809	11	0	0	3,845	0	60	9,190	0	14,007	2,883	7,090	11,238	108	0	0	20,090	0	329	55,745	0	99,249	15,109	21,427	46,928	328	0	0	167,131	0	6,509	356,681	516,755,944	109,453,197	267,138,596	353,834,865	655,700	0	0	760,139,212	0	8,338,964	2,016,316,478	388,813,110	51,528,259	77,649,339	181,473,643	2,585,685	0	0	668,853,304	0	26,965,685	1,397,869,025	8,633,769	719,703,747	134,637,603	288,484,273	450,674,958	0	2,520,865	0	0	876,718,680	0	15,660,866	0	0	0	2,232,113	2,499,266,874	0	0	0	722,241	722,241	185,652,370	26,040,020	55,463,467	82,283,281	711,254	0	0	549,081,200	0	16,409,278	915,640,870	31,117,443	891,366,137	0	(1,942,101)	0	0	0	0	29,948,615	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	10/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	2,492	293	1,130	1,807	1	1	252	2,371	87	0	8,434	0	15,653	1,775	9,737	9,170	52	10	1,456	10,857	299	0	49,009	0	77,577	7,341	7,364	14,361	96	6	12,382	129,551	1,512	0	250,190	465,013,864	57,298,405	242,839,158	237,970,710	375,504	166,075	46,868,309	330,769,479	10,574,848	0	1,391,876,352	256,614,743	24,078,464	38,993,937	85,526,335	578,383	34,593	60,279,233	355,831,816	8,540,939	0	830,478,443	27,289,906	599,438,303	66,363,541	230,026,857	267,394,535	0	(87,641,668)	178,747	95,472,360	404,579,841	0	3,281,160	0	0	0	26,579,186	1,632,962,768	0	0	0	29,785,821	29,785,821	122,190,304	15,013,328	42,965,098	56,102,510	89,617,516	21,921	10,653,221	282,021,453	592,495	2	619,177,848	29,442,568	514,744,940	0	4,378,915	0	0	0	0	30,130,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	10/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	1,144	517	786	1,325	0	0	66	1,374	106	0	5,318	0	6,203	3,114	7,868	6,702	0	0	725	7,388	401	0	32,401	0	44,471	7,920	7,338	32,790	432	0	483	47,949	4,366	0	145,749	132,782,718	75,307,920	110,522,721	150,775,129	0	0	17,091,401	157,107,642	16,904,751	0	660,492,282	117,855,503	27,266,661	13,147,671	79,482,585	731,787	0	4,414,640	130,393,430	13,874,754	0	387,167,031	15,114,767	200,218,031	74,660,493	94,595,309	209,396,167	0	2,244,520	0	0	154,268,351	0	25,271,072	0	1,970,400	(1,970,400)	3,202,190	778,970,900	0	368,154	0	0	368,154	50,420,190	27,914,088	24,865,207	25,439,577	(1,512,733)	0	6,391,274	133,232,721	2,306,243	0	269,056,567	11,178,181	259,828,970	0	966,761	0	0	0	0	31,195,626	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	10/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	1,962	668	813	2,045	1	0	187	2,003	170	0	7,849	0	12,404	4,121	7,534	11,757	9	0	1,098	10,685	974	0	48,582	0	44,418	6,946	18,872	19,035	42	0	2,253	134,460	2,698	0	228,724	200,067,163	61,325,629	89,780,985	153,498,230	80,082	0	16,270,545	161,684,583	29,477,466	0	712,184,683	164,881,593	44,232,211	31,473,769	124,821,620	66,733	0	16,380,986	254,360,107	59,974,198	0	696,191,217	479,773	277,024,067	78,787,778	64,805,924	239,592,953	(40,733,605)	102,873	0	24,580,188	205,032,683	0	77,305,590	0	0	0	12,731,026	939,709,250	0	0	0	0	0	87,924,689	26,770,062	97,182,435	38,726,896	43,942	0	7,591,570	198,280,981	12,146,075	0	468,666,650	42,376,264	461,895,300	0	4,701,380	0	0	0	0	34,369,388	1,631,491,580	40,733,605	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20174	10/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	103	17	55	48	0	0	5	116	0	0	344	0	775	143	706	436	0	0	70	751	0	0	2,881	0	10,513	1,135	1,172	1,166	0	0	1,231	11,283	0	164	26,664	8,846,903	1,844,548	8,090,433	4,831,501	0	0	697,557	10,661,486	0	0	34,972,428	57,119,250	6,593,117	9,311,955	8,166,685	0	0	2,295,647	50,954,339	0	524,854	134,965,847	539,544	55,564,061	4,767,901	15,329,102	7,564,013	0	0	0	1,695,193	31,233,200	0	0	0	0	0	170,671	116,863,685	0	0	0	0	0	10,192,652	3,642,975	2,018,034	5,392,905	0	0	1,288,509	30,186,998	0	352,517	53,074,590	1,788,248	51,079,423	0	0	0	0	0	0	1,365,451	38,405,109	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20174	10/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	703	218	37	122	0	0	0	606	14	3	1,703	0	4,003	1,272	176	341	0	0	0	1,892	31	9	7,724	0	5,301	627	245	1,657	0	0	0	7,588	555	417	16,390	32,231,431	7,034,868	1,555,408	5,146,149	0	0	0	21,522,801	61,502	270,002	67,822,161	22,313,321	4,870,131	1,076,785	3,562,599	0	0	0	14,138,389	42,577	948,432	46,952,234	390,878	40,631,642	8,868,308	1,960,781	6,487,347	0	0	0	0	26,745,426	0	77,531	0	0	0	727,057	85,888,970	0	0	0	0	0	13,913,110	3,036,691	671,412	2,221,401	0	0	0	8,915,763	26,548	100,500	28,885,425	310,974	30,642,504	0	(252,040)	0	0	0	0	810,406	30,694,556	0	0	0	0	0	0	0	0	0	0	0	0	0