Table: 2018_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
106010776	UCSF BENIOFF CHILDREN'S HOSPITAL OAKLAND	20184	01/01/2018	12/31/2018	Open	Alameda	05 - East Bay	0417	Non Profit Corp.	Comparable	None	510-428-3885	747 52ND STREET	OAKLAND	94609	MICHAEL ANDERSON, MD	190	190	190	25	0	3,394	3,099	0	0	0	2,479	0	135	9,132	0	173	0	24,949	8,612	0	0	0	12,026	0	338	46,098	0	1,107	0	60,426	129,566	0	0	0	78,269	461	10,826	280,655	2,565,704	0	471,663,569	145,535,657	0	0	0	244,447,462	0	3,177,692	867,390,084	8,563,584	0	157,617,749	245,947,190	0	0	0	231,267,135	263,522	8,783,743	652,442,923	3,636,613	7,726,392	0	403,853,218	327,715,938	(29,269,669)	0	0	0	264,616,899	0	(272,568)	0	0	0	0	978,006,823	0	0	0	0	0	3,402,896	0	254,697,770	63,766,909	0	0	0	207,298,240	356,222	12,304,147	541,826,184	70,130,127	619,763,900	0	13,451,925	0	0	0	0	44,818,520	322,674,810	0	0	0	0	0	0	0	0	0	0	0	0	0
106381154	UCSF MEDICAL CENTER	20184	01/01/2018	12/31/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	9,230	1,918	2,717	6,741	61	0	0	14,631	0	223	35,521	0	59,929	12,458	25,681	48,669	1,125	0	0	82,296	0	1,348	231,506	0	445,888	71,202	80,818	193,215	1,703	0	0	697,238	0	28,486	1,518,550	2,253,895,657	483,745,601	1,054,499,957	1,541,383,754	48,711,873	0	0	3,128,334,947	0	21,076,248	8,531,648,037	1,767,921,273	281,511,668	320,031,978	761,373,425	6,153,717	0	0	2,761,623,019	0	112,865,594	6,011,480,674	39,549,272	3,377,622,320	623,164,077	1,070,442,115	1,919,682,943	0	42,039,139	0	0	3,642,743,029	0	61,319,705	0	0	0	8,841,990	10,785,404,590	0	0	0	3,971,418	3,971,418	642,663,185	140,486,604	301,482,488	373,473,224	12,783,749	0	0	2,230,798,351	0	60,007,938	3,761,695,539	179,982,288	3,807,652,072	0	17,247,384	0	0	0	0	199,685,699	2,056,535,630	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA DAVIS MEDICAL CENTER	20184	01/01/2018	12/31/2018	Open	Sacramento	02 - Golden Empire	0311	Non Profit Other	Comparable	Teaching	916-734-7020	2315 STOCKTON BOULEVARD	SACRAMENTO	95817	BRAD SIMMONS	625	605	605	9,376	1,235	4,561	7,058	8	0	1,006	8,330	295	18	31,887	0	59,199	7,401	37,374	39,506	28	0	6,609	38,458	1,000	155	189,730	0	346,484	38,024	33,609	59,296	453	0	42,028	493,135	10,209	1,354	1,024,592	1,764,807,674	241,149,173	926,196,351	1,019,033,842	1,354,482	0	213,966,668	1,200,796,664	38,641,915	7,423,100	5,413,369,869	1,166,934,876	127,690,584	164,238,463	377,268,724	3,646,187	0	239,259,521	1,318,068,246	37,364,115	957,265	3,435,427,981	100,551,215	2,479,628,998	318,390,830	853,453,148	1,140,467,893	0	1,990,139	964,315	391,253,713	1,513,702,397	0	57,682,705	0	0	0	7,366,611	6,865,451,964	0	0	0	70,748,716	70,748,716	452,113,552	50,448,926	177,149,059	239,228,699	3,002,436	(964,315)	61,883,101	1,057,194,823	8,874,756	5,163,565	2,054,094,602	65,149,633	2,118,039,540	0	21,932,526	0	0	0	0	120,221,103	1,095,884,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106301279	UNIVERSITY OF CALIFORNIA IRVINE MEDICAL CENTER	20184	01/01/2018	12/31/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	4,726	2,362	2,864	5,633	41	0	529	5,009	636	0	21,800	0	25,124	12,698	28,833	28,280	125	0	2,473	26,404	1,545	0	125,482	0	192,879	41,096	29,696	138,931	1,450	0	2,582	214,409	19,988	0	641,031	533,268,685	287,144,860	421,779,664	594,752,001	2,655,873	0	82,330,713	546,510,143	51,758,566	0	2,520,200,505	493,334,491	144,998,141	63,581,484	329,416,013	2,812,291	0	17,478,036	531,740,676	81,971,193	0	1,665,332,325	68,563,559	834,025,755	319,575,889	232,061,437	798,592,610	0	11,422,860	0	0	601,756,965	0	86,456,943	0	7,881,600	(7,881,600)	42,109,159	2,994,565,177	0	1,481,397	0	0	1,481,397	192,577,421	112,567,112	253,299,711	127,056,801	(5,954,696)	0	31,245,190	476,493,854	5,163,657	0	1,192,449,050	73,738,316	1,119,533,685	0	16,835,113	0	0	0	0	106,713,340	772,369,011	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA SAN DIEGO MEDICAL CENTER	20184	01/01/2018	12/31/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	693	693	8,115	2,978	3,170	8,326	7	0	867	8,280	682	0	32,425	0	54,661	19,515	29,613	48,916	53	0	4,845	48,778	2,792	0	209,173	0	184,285	32,809	75,267	105,592	113	0	9,386	544,967	6,569	0	958,988	850,888,393	305,676,476	363,695,807	683,048,553	784,938	0	73,602,282	787,171,592	74,884,629	0	3,139,752,670	781,459,863	232,770,784	136,812,531	699,716,259	369,632	0	73,782,769	1,109,309,232	229,086,292	0	3,263,307,362	15,437,989	1,262,747,957	406,701,389	248,807,666	996,686,832	(205,053,887)	569,269	0	111,049,670	924,921,706	0	258,766,575	0	0	0	69,498,661	4,090,133,827	0	0	0	0	0	367,522,724	130,545,757	394,563,620	438,533,865	203,004	0	20,897,395	885,327,854	75,331,986	0	2,312,926,205	106,580,889	2,036,039,361	0	23,547,737	0	0	0	0	140,804,568	1,640,649,151	0	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20184	01/01/2018	12/31/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	454	135	214	257	0	0	21	538	0	2	1,621	0	3,338	1,132	2,503	2,893	0	0	208	4,409	0	16	14,499	0	54,104	7,570	6,462	7,106	0	0	4,998	54,148	0	871	135,259	38,925,288	14,544,268	29,643,587	32,138,532	0	0	2,800,939	61,546,314	0	117,625	179,716,553	281,395,363	42,260,556	38,645,262	42,133,708	0	0	11,985,185	211,464,116	0	1,821,613	629,705,803	763,012	253,322,248	35,711,862	56,894,272	47,105,632	0	0	0	13,282,209	150,740,870	0	0	0	0	0	1,600,138	559,420,243	0	0	0	0	0	66,702,184	21,044,400	11,328,981	27,096,641	0	0	1,273,455	122,001,624	0	554,828	250,002,113	5,144,634	207,916,146	0	0	0	0	0	0	3,298,978	37,193,609	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20184	01/01/2018	12/31/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	91	3,056	895	140	564	0	0	0	2,256	74	13	6,998	0	16,394	6,208	655	1,669	0	0	0	7,697	147	26	32,796	0	21,726	2,906	1,026	6,940	0	0	0	29,844	2,768	871	66,081	161,354,077	37,490,215	8,617,169	27,114,121	0	0	0	105,488,500	515,908	483,850	341,063,840	106,306,495	24,052,040	5,709,767	17,950,405	0	0	0	69,400,130	907,701	1,454,581	225,781,119	2,613,404	203,633,496	46,853,873	11,123,027	34,520,448	0	0	0	0	135,089,800	0	214,759	0	0	0	307,675	434,356,482	0	0	0	0	0	64,027,076	14,688,382	3,203,909	10,544,078	0	0	0	39,798,830	69,772	156,430	132,488,477	1,748,959	137,689,744	0	(1,280,125)	0	0	0	0	2,961,346	28,229,766	0	0	0	0	0	0	0	0	0	0	0	0	0