Table: 2017_quarter_3_complete_data_set_1_12_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	20173	07/01/2017	09/30/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,233	467	758	1,848	17	0	0	3,734	0	66	9,123	0	13,805	2,911	7,523	11,342	92	0	0	20,434	0	368	56,475	0	96,937	14,641	20,093	46,494	297	0	0	163,472	0	6,265	348,199	496,454,468	106,566,665	292,652,100	347,577,360	4,088,001	0	0	771,013,185	0	7,702,384	2,026,054,163	375,111,879	56,718,332	77,645,393	179,892,807	1,129,887	0	0	632,246,071	0	24,254,529	1,346,998,898	11,989,974	727,891,531	136,132,024	311,698,647	446,324,773	0	3,759,099	0	0	869,134,292	0	15,531,149	0	0	0	2,358,190	2,524,819,679	0	0	0	170,565	170,565	143,379,106	26,731,030	57,432,044	77,881,507	1,445,917	0	0	529,691,255	0	11,843,088	848,403,947	28,590,842	852,576,802	0	8,198,669	0	0	0	0	28,280,742	2,040,931,375	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA - DAVIS MEDICAL CENTER	20173	07/01/2017	09/30/2017	Open	Sacramento	02	0311	Non Profit Other	Comparable	Teaching	(916) 734-7020	2315 STOCKTON BOULEVARD	SACRAMENTO	95817	ANN MADDEN RICE	627	605	605	2,370	256	1,227	1,803	0	0	295	2,329	65	4	8,349	0	15,224	1,666	10,598	9,573	0	0	1,707	9,987	231	30	49,016	0	72,286	7,710	7,231	15,062	101	0	15,144	127,619	1,795	56	247,004	431,745,358	53,249,167	261,557,973	249,019,698	0	0	62,218,163	321,363,262	8,575,671	1,326,988	1,389,056,280	248,693,583	25,469,901	39,587,834	83,515,341	624,588	0	76,779,371	348,111,171	9,242,978	177,074	832,201,841	26,561,229	568,383,051	66,022,267	247,129,505	278,306,395	0	477,879	0	124,788,822	401,795,734	0	4,041,936	0	0	0	33,342,126	1,750,848,944	0	0	0	29,544,004	29,544,004	112,055,890	12,696,801	37,234,790	54,228,644	146,709	0	14,208,712	267,678,699	1,359,512	343,424	499,953,181	19,665,968	498,897,082	0	4,354,918	0	0	0	0	29,002,000	1,038,460,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106301279	UNIVERSITY OF CALIFORNIA - IRVINE MEDICAL CENTER	20173	07/01/2017	09/30/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,233	560	850	1,494	0	0	103	1,344	117	0	5,701	0	6,445	3,055	7,358	6,590	0	0	533	6,646	420	0	31,047	0	45,271	9,366	7,247	32,064	179	0	565	51,377	3,059	0	149,128	142,136,364	72,676,383	111,525,850	137,824,869	0	0	15,290,497	144,211,321	9,769,284	0	633,434,568	114,803,892	29,521,332	18,206,715	77,488,960	659,447	0	3,409,449	130,883,705	5,575,937	0	380,549,437	11,988,554	202,503,388	77,588,407	99,960,938	193,974,033	0	860,341	0	0	151,166,433	0	13,908,141	(100,000)	1,970,400	(1,970,400)	582,170	752,432,405	0	500,726	0	0	500,726	54,436,868	24,609,308	29,771,627	21,840,522	(200,894)	0	6,711,392	123,928,593	954,910	0	262,052,326	7,558,542	251,339,463	0	839,188	0	0	0	0	16,094,767	737,056,187	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA - SAN DIEGO MEDICAL CENTER	20173	07/01/2017	09/30/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,901	655	804	2,228	1	0	233	2,009	174	0	8,005	0	12,619	3,966	6,557	12,525	2	0	1,424	11,272	769	0	49,134	0	43,820	21,889	17,732	25,932	38	0	1,909	111,874	2,144	0	225,338	194,334,439	66,108,300	81,759,525	168,494,543	93,299	0	21,733,698	174,374,826	21,350,996	0	728,249,626	178,574,531	44,535,106	29,800,259	128,628,432	46,550	0	15,566,588	250,091,453	50,569,736	0	697,812,655	2,545,386	290,570,357	86,088,710	77,466,447	257,201,686	(42,553,105)	76,479	0	27,687,257	215,492,573	0	59,872,076	0	0	0	8,633,079	983,080,945	0	0	0	0	0	82,338,613	24,554,696	76,646,442	39,921,289	63,370	0	7,067,643	200,340,628	12,048,655	0	442,981,336	42,529,504	454,088,141	0	3,338,742	0	0	0	0	19,422,808	1,618,561,998	0	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20173	07/01/2017	09/30/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	120	21	41	62	0	0	3	166	0	1	414	0	987	180	424	382	0	0	27	923	0	4	2,927	0	10,935	1,146	1,128	1,249	0	0	1,168	10,770	0	144	26,540	16,887,234	1,859,745	5,162,296	4,548,357	0	0	55,403	12,264,639	0	24,247	40,801,921	59,090,612	6,567,039	8,239,223	8,148,830	0	0	1,836,175	50,548,107	0	221,721	134,651,707	187,883	62,068,519	6,534,310	11,451,721	9,202,742	0	0	0	1,794,472	34,341,858	0	0	0	0	0	333,119	125,914,624	0	0	0	0	0	13,827,967	1,883,450	1,935,447	3,480,848	0	0	95,080	28,403,626	0	(87,414)	49,539,004	1,382,489	45,770,876	0	209,598	0	0	0	0	1,013,857	38,226,476	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20173	07/01/2017	09/30/2017	Open	Los Angeles	11	0937	Non Profit Corp.	Comparable	None	(818) 790-7100	1812 VERDUGO BOULEVARD	GLENDALE	91208	KEITH HOBBS	158	158	85	674	223	45	131	0	0	0	559	11	11	1,654	0	3,964	1,057	139	416	0	0	0	1,801	17	15	7,409	0	5,264	692	247	1,556	0	0	0	7,011	513	562	15,845	27,625,819	6,602,691	1,659,926	4,777,789	0	0	0	21,555,563	50,787	1,856,970	64,129,545	18,933,394	4,525,164	1,137,633	3,274,465	0	0	0	14,773,136	34,807	1,272,676	43,951,275	139,095	34,470,796	8,238,671	2,071,214	5,961,604	0	0	0	0	27,146,485	0	63,371	0	0	0	2,067,081	80,158,317	0	0	0	0	0	12,088,416	2,889,184	726,345	2,090,650	0	0	0	9,182,213	22,223	923,472	27,922,503	935,381	29,398,128	0	(312,708)	0	0	0	0	1,608,621	31,118,607	0	0	0	0	0	0	0	0	0	0	0	0	0