Table: 2017_quarter_3_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	20173	10/01/2016	09/30/2017	Open	San Francisco	04	0423	Non Profit Other	Comparable	Teaching	(415) 476-1000	505 PARNASSUS AVENUE	SAN FRANCISCO	94143	MARK LARET	1019	782	726	9163	1673	4603	6064	97	0	0	13956	0	250	35806	0	56942	10494	38786	36741	839	0	0	78107	0	1407	223316	0	391661	50066	77700	179981	1256	0	0	631538	0	25375	1357577	1960637257	387160287	1215742648	1263849959	18999832	0	0	2802244701	0	28808017	7677442701	1450875346	209482845	299748148	670636969	3774897	0	0	2415709988	0	100475250	5150703443	30143067	2816758991	473463547	1256425723	1642773383	0	15551172	0	0	3213143269	0	61873200	0	0	0	8501328	9518633680	0	0	0	2953030	2953030	593790354	122232639	256117894	283398240	7163272	0	0	1993705482	0	56057613	3312465494	126043966	3493186526	0	35013196	0	0	0	0	114401437	2040931375	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA - DAVIS MEDICAL CENTER	20173	10/01/2016	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	9413	1104	4684	6970	55	2	1102	9235	249	18	32832	0	59833	6849	37803	37977	413	52	7002	41722	909	85	192645	0	301419	30125	31233	58928	388	0	36334	557951	8256	661	1025295	1781946836	216619817	920632442	1001095892	7104378	2194509	233139238	1312727687	26413154	2607493	5504481446	963177848	97393420	150850910	333651578	2327912	0	257567115	1367606283	30296070	866685	3203737821	116061221	2259048425	264890402	827706388	1110524596	0	7333826	1928507	436888097	1585005270	0	18798405	0	0	0	143796641	6771981778	0	0	0	130774744	130774744	486076259	49122835	159573364	218042059	2098463	266002	53818256	1093656595	3107277	1251123	2067012233	71070290	2015020897	0	18578082	0	0	0	0	117393000	1038460000	0	0	0	0	0	0	0	0	0	0	0	0	0
106301279	UNIVERSITY OF CALIFORNIA - IRVINE MEDICAL CENTER	20173	10/01/2016	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	4694	2158	3176	5457	0	0	310	5408	433	0	21636	0	26172	11911	29167	25710	0	0	1383	27857	1157	0	123357	0	179368	33795	28505	128950	1127	0	2028	202659	15439	0	591871	569002009	282518527	432605840	561680808	0	0	38062104	598475146	26196880	0	2508541314	463245284	106893346	69618260	304614071	2333530	0	11809863	525271260	21699592	0	1505485206	28784193	824770133	340535214	319473136	755329775	0	2102914	0	0	598795836	0	44778754	-100000	7911222	-7911222	7187599	2921657554	0	1946459	0	0	1946459	207477160	48876659	182750964	112911563	230616	0	21087774	524950570	-3969881	0	1094315425	23024035	1001266604	0	5190834	0	0	0	0	90526210	737056187	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA - SAN DIEGO MEDICAL CENTER	20173	10/01/2016	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	7470	2592	3171	7993	8	0	771	7583	556	0	30144	0	49043	16663	27904	44938	23	0	4254	43795	2372	0	188992	0	181609	78520	73685	177153	89	0	13616	321016	8909	0	854597	715840758	245853262	328896627	560169270	329159	0	64165197	618310677	82377688	0	2615942638	674094233	170650175	113507553	466484851	295449	0	63496656	929161030	197315482	0	2615005429	9192730	1069511407	320882419	253733089	874497331	-189960945	332979	0	95971889	739940471	0	235054828	0	0	0	37913744	3447069942	0	0	0	0	0	320423584	95621018	378632036	152156789	191629	0	22597234	769617496	44638339	0	1783878125	166553018	1834377105	0	19080255	0	0	0	0	200251507	1618561998	0	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20173	10/01/2016	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	502	105	205	215	0	0	18	622	0	3	1670	0	3190	770	2266	1748	0	0	193	4654	0	19	12840	0	45387	4976	4912	5002	0	0	4334	46747	0	644	112002	40706526	9130795	26779949	20097454	0	0	1978369	57598013	0	202126	156493232	245151733	28945385	30891469	33165824	0	0	9406905	213554812	0	1440727	562556855	598281	226872296	29339972	48829259	35200603	0	0	0	7919632	145640596	0	323335	0	0	0	905735	495629709	0	0	0	0	0	58746191	8700495	8800204	18017028	0	0	3453868	125290296	-83145	495441	223420378	7909694	184131294	0	267680	0	0	0	0	1870174	38226476	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20173	10/01/2016	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	2795	813	167	480	0	0	0	2231	39	45	6570	0	17829	4223	562	2006	0	0	0	7651	109	87	32467	0	21028	2569	971	6232	0	0	0	27820	1913	1815	62348	104927949	26769841	5647402	16094348	0	0	0	85977930	3017879	4730145	247165494	61485961	15356096	3115686	9964811	0	0	0	61223857	2225332	5105415	158477158	-1374024	122214798	30408282	5893915	19111009	0	0	0	0	114061589	0	6120281	0	0	0	4937302	301373152	0	0	0	0	0	44199111	11717655	2869172	6948150	0	0	0	33140197	2309618	3085597	104269500	2201134	113932489	0	-1279337	0	0	0	0	5448362	31118607	0	0	0	0	0	0	0	0	0	0	0	0	0