Table: 2018_quarter_2_complete_data_set_10_10_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	20182	04/01/2018	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	2,236	485	634	1,673	13	0	0	3,643	0	78	8,762	0	14,452	2,993	6,249	11,308	257	0	0	20,417	0	351	56,027	0	113,226	18,138	21,489	47,628	389	0	0	171,467	0	7,107	379,444	545,390,885	114,965,888	244,642,986	352,400,185	12,099,274	0	0	784,281,024	0	4,481,887	2,058,262,129	440,467,762	70,921,771	83,697,712	184,626,276	1,389,269	0	0	666,424,441	0	28,431,669	1,475,958,900	7,652,301	829,062,616	148,738,330	221,609,991	442,361,523	0	10,064,923	0	0	892,772,660	0	14,504,810	0	0	0	2,853,691	2,569,620,845	0	0	0	1,029,365	1,029,365	156,457,320	36,845,273	106,241,191	92,773,007	3,410,866	0	0	554,597,087	0	15,304,805	965,629,549	46,441,611	949,903,162	0	1,439,299	0	0	0	0	59,288,623	2,048,944,847	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA DAVIS MEDICAL CENTER	20182	04/01/2018	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	2,393	296	1,128	1,823	0	0	262	2,095	84	6	8,087	0	14,680	1,822	9,366	10,501	0	0	1,650	10,073	233	53	48,378	0	96,800	10,487	9,938	15,388	68	0	8,533	144,165	3,281	647	289,307	438,310,793	56,890,247	223,944,952	244,462,702	0	0	56,389,254	292,056,113	9,061,375	2,156,478	1,323,271,914	304,572,917	34,063,138	43,293,679	100,728,482	783,840	0	36,836,133	338,969,265	8,808,073	125,411	868,180,938	26,062,950	657,464,480	83,209,899	219,264,424	284,695,169	0	(66,856)	964,315	74,594,842	430,532,729	0	11,315,563	0	0	0	(27,372,137)	1,760,665,378	0	0	0	19,914,144	19,914,144	85,419,230	7,743,485	47,974,207	60,496,015	850,696	(964,315)	18,630,545	220,406,793	6,553,885	3,591,077	450,701,618	4,077,486	527,178,253	0	6,788,397	0	0	0	0	29,846,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	20182	04/01/2018	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	1,154	566	699	1,348	0	0	136	1,171	173	0	5,247	0	5,982	2,847	7,269	6,924	0	0	543	6,321	526	0	30,412	0	53,510	9,529	8,829	39,455	520	0	581	57,695	5,253	0	175,372	127,726,861	66,402,584	99,630,313	148,363,825	0	0	18,443,638	132,320,131	15,064,236	0	607,951,588	127,241,687	37,485,795	17,204,271	84,707,972	853,123	0	4,579,266	133,711,137	20,348,470	0	426,131,721	14,654,224	229,870,935	67,256,432	(27,811,804)	189,160,484	0	4,267,973	0	0	158,423,135	0	25,169,993	0	1,970,400	(1,970,400)	12,171,742	673,163,114	0	477,851	0	0	477,851	25,097,613	36,631,947	144,646,388	44,389,164	(3,414,850)	0	8,368,680	107,608,133	(1,929,029)	0	361,398,046	16,585,828	271,875,026	0	3,920,312	0	0	0	0	31,718,439	764,559,415	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA SAN DIEGO MEDICAL CENTER	20182	04/01/2018	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	2,029	700	841	2,042	0	0	226	2,050	120	0	8,008	0	13,677	4,247	8,027	11,528	0	0	1,215	11,800	386	0	50,880	0	46,691	8,166	19,014	27,522	36	0	2,542	136,588	2,229	0	242,788	200,789,313	65,536,485	88,981,552	152,939,372	87,838	0	17,752,734	183,572,300	24,210,141	0	733,869,735	189,703,778	55,759,459	34,812,243	135,260,384	0	0	19,308,017	278,432,254	56,549,980	0	769,826,115	5,354,150	292,408,912	90,135,677	45,804,176	181,315,502	(61,907,831)	15,743	0	26,017,560	211,223,684	0	64,771,205	0	0	0	18,666,810	873,805,588	0	0	0	0	0	98,084,179	31,160,267	79,997,450	166,884,253	8,079	0	5,689,042	232,114,060	15,952,932	0	629,890,262	(29,188,352)	501,944,188	0	4,406,650	0	0	0	0	29,222,426	1,634,680,483	0	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20182	04/01/2018	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	125	39	51	66	0	0	11	148	0	0	440	0	883	363	654	749	0	0	95	986	0	0	3,730	0	14,411	2,272	1,779	1,926	0	0	1,380	13,289	0	249	35,306	10,416,150	4,622,537	7,847,734	7,856,827	0	0	1,771,758	15,515,516	0	0	48,030,522	77,185,297	11,480,681	10,661,925	10,647,140	0	0	3,240,546	54,840,812	0	618,587	168,674,988	(57,506)	68,056,644	8,949,053	15,943,728	10,876,921	0	0	0	4,892,623	39,526,532	0	0	0	0	0	581,512	148,769,507	0	0	0	0	0	19,568,050	7,158,438	2,570,844	7,631,957	0	0	121,010	30,848,560	0	37,144	67,936,003	1,933,108	53,577,631	0	0	0	0	0	0	128,985	38,128,701	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20182	04/01/2018	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	685	198	24	142	0	0	0	553	15	4	1,621	0	3,744	1,518	120	379	0	0	0	1,842	21	9	7,633	0	5,436	696	233	1,690	0	0	0	7,250	498	268	16,071	38,715,438	8,807,017	2,120,222	6,830,106	0	0	0	26,305,597	24,815	131,052	82,934,247	26,390,774	5,832,978	1,445,271	4,655,811	0	0	0	17,658,814	16,916	532,412	56,532,976	522,934	50,548,661	11,172,436	2,768,259	8,917,701	0	0	0	0	34,773,541	0	32,400	0	0	0	69,776	108,805,708	0	0	0	0	0	14,557,551	3,467,559	797,234	2,568,216	0	0	0	9,190,870	9,331	70,754	30,661,515	779,926	36,876,992	0	(344,325)	0	0	0	0	1,326,949	30,215,980	0	0	0	0	0	0	0	0	0	0	0	0	0