Table: 2019_quarter_2_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	20192	07/01/2018	06/30/2019	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	19	0	3,245	3,345	0	0	0	2,501	0	78	9,188	0	131	0	23,458	10,251	0	0	0	11,702	0	280	45,822	0	1,152	0	58,422	135,807	0	0	0	79,218	562	10,678	285,839	2,304,296	0	428,672,581	164,640,489	0	0	0	239,249,421	0	3,760,139	838,626,926	9,312,415	0	153,645,637	253,666,991	0	0	0	231,446,020	455,703	10,373,570	658,900,336	6,362,190	7,827,426	0	386,118,671	245,358,970	0	0	0	0	263,232,408	0	619,220	0	0	0	0	909,518,885	0	0	0	0	0	3,789,285	0	196,199,548	172,948,510	0	0	0	201,100,842	356,949	13,613,243	588,008,377	65,019,000	648,145,000	0	37,055,000	0	0	0	0	37,950,000	330,502,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106381154	UCSF MEDICAL CENTER	20192	07/01/2018	06/30/2019	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	754	726	9,287	2,001	2,307	7,093	70	0	0	14,496	0	200	35,454	0	60,420	13,252	23,283	53,148	999	0	0	84,232	0	1,270	236,604	0	514,688	83,012	87,296	225,161	1,964	0	0	795,711	0	32,161	1,739,993	2,289,685,822	518,691,904	1,065,562,600	1,676,580,421	41,126,010	0	0	3,297,569,289	0	25,449,894	8,914,665,940	1,894,575,746	310,468,490	325,933,089	839,308,871	6,569,231	0	0	2,960,739,055	0	121,656,919	6,459,251,401	48,508,071	3,512,636,639	679,162,067	1,157,200,819	2,100,305,349	0	33,753,510	0	0	3,830,872,496	0	69,080,473	0	0	0	7,605,080	11,439,124,504	0	0	0	3,286,052	3,286,052	669,546,702	147,769,904	231,994,301	403,719,066	13,880,183	0	0	2,406,403,672	0	64,765,061	3,938,078,889	212,723,172	4,083,136,422	0	20,201,587	0	0	0	0	200,751,630	2,095,281,111	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA DAVIS MEDICAL CENTER	20192	07/01/2018	06/30/2019	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,142	1,213	4,364	6,872	12	2	993	7,685	259	13	30,555	0	60,644	7,633	37,759	40,825	55	16	7,039	36,192	1,167	70	191,400	0	349,253	40,554	28,667	66,146	530	5	49,986	469,715	7,032	253	1,012,141	1,826,945,447	238,306,013	923,727,425	1,083,181,534	1,751,802	394,710	227,412,668	1,163,715,579	39,609,159	2,925,944	5,507,970,281	1,226,216,802	136,472,694	172,089,026	417,974,865	3,403,976	36,628	256,438,752	1,355,789,615	39,440,494	1,150,666	3,609,013,518	92,730,936	2,497,362,426	310,435,590	903,566,942	1,196,517,070	0	4,168,060	393,588	418,828,506	1,435,018,075	0	73,249,343	0	0	0	2,224,950	6,934,495,486	0	15,486,059	0	55,651,443	71,137,502	514,857,622	59,362,052	192,264,285	300,773,401	987,716	37,751	58,322,587	1,120,762,944	5,022,769	1,234,688	2,253,625,815	76,706,036	2,236,817,969	0	11,528,091	0	0	0	0	118,295,000	1,115,955,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106301279	UNIVERSITY OF CALIFORNIA IRVINE MEDICAL CENTER	20192	07/01/2018	06/30/2019	Open	Orange	13 - Orange	1015	Non Profit Other	Comparable	Teaching	714-456-7890	101 CITY DRIVE SOUTH	ORANGE	92868	RICHARD J. GANNOTTA	402	402	402	4,778	2,519	3,052	5,615	69	0	520	5,137	621	0	22,311	0	25,541	13,855	28,998	28,414	264	0	2,596	25,771	1,425	0	126,864	0	182,289	48,878	24,386	127,264	797	0	2,882	206,020	19,920	0	612,436	559,837,462	324,564,509	439,766,081	595,525,664	5,537,058	0	78,603,098	534,444,956	69,403,353	0	2,607,682,181	511,869,365	153,704,595	62,739,151	340,859,268	2,275,234	0	17,376,188	559,842,730	75,095,399	0	1,723,761,930	79,961,756	845,058,954	381,495,725	342,377,533	813,323,223	0	6,029,312	0	0	584,869,640	0	72,903,112	0	7,881,600	(7,881,600)	44,005,676	3,170,024,931	0	1,405,694	0	0	1,405,694	226,647,873	96,773,379	160,127,699	124,467,403	1,782,980	0	16,017,530	509,418,046	27,589,964	0	1,162,824,874	103,906,060	1,170,100,965	0	17,228,626	0	0	0	0	93,098,749	772,415,083	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA SAN DIEGO MEDICAL CENTER	20192	07/01/2018	06/30/2019	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	701	701	8,381	3,201	3,269	8,501	2	0	880	8,493	736	0	33,463	0	56,602	20,905	29,870	50,440	16	0	4,292	49,025	2,868	0	214,018	0	189,950	35,600	80,234	109,544	1,023	0	9,830	578,578	4,294	0	1,009,053	915,937,353	334,879,613	387,339,313	726,360,198	237,136	0	69,431,975	850,878,121	69,517,660	0	3,354,581,369	851,213,197	255,715,723	148,566,926	727,810,276	54,792	0	79,865,756	1,213,966,306	226,996,339	0	3,504,189,315	23,307,530	1,391,501,769	455,029,086	318,674,415	1,114,360,534	(160,593,123)	251,015	0	111,856,341	1,009,541,769	0	246,295,982	0	0	0	77,873,533	4,588,098,851	0	0	0	0	0	375,648,781	135,566,250	377,964,408	339,639,774	81,108	0	25,141,530	946,429,128	70,200,854	0	2,270,671,833	193,782,776	2,079,258,636	0	20,342,321	0	0	0	0	166,668,230	32,252,825	0	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20192	07/01/2018	06/30/2019	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	413	131	206	271	0	0	14	549	0	2	1,586	0	3,030	913	2,387	3,070	0	0	104	5,132	0	5	14,641	0	57,950	8,301	6,505	7,730	0	0	4,743	60,128	0	842	146,199	36,703,886	13,151,393	30,203,726	38,579,594	0	0	1,258,587	65,083,261	0	92,936	185,073,383	298,477,672	50,721,153	41,021,346	42,534,096	0	0	10,001,354	228,423,704	0	1,497,177	672,676,502	1,129,603	270,293,784	44,015,021	58,408,277	50,080,681	0	0	0	8,593,751	155,042,252	0	0	0	0	0	887,836	588,451,205	0	0	0	0	0	64,449,720	19,772,112	12,721,243	30,929,410	0	0	2,651,497	138,074,226	0	700,472	269,298,680	4,305,618	203,795,851	0	0	0	0	0	0	7,434,690	41,051,450	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20192	07/01/2018	06/30/2019	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	2,942	1,007	142	516	0	0	0	2,165	50	51	6,873	0	15,570	7,067	708	1,507	0	0	0	7,262	115	172	32,401	0	22,819	3,672	1,078	7,395	0	0	0	30,841	1,742	2,143	69,690	172,885,613	42,555,719	9,280,110	27,063,596	0	0	0	110,877,856	409,451	789,231	363,861,576	122,590,814	28,796,026	6,588,974	19,476,993	0	0	0	78,605,695	839,579	1,640,589	258,538,670	2,567,594	230,391,225	56,176,510	12,572,984	36,942,213	0	0	0	0	148,404,164	0	86,726	0	0	0	764,417	487,905,833	0	0	0	0	0	65,085,202	15,175,235	3,296,100	9,598,376	0	0	0	41,079,387	23,226	236,887	134,494,413	3,007,940	138,574,760	0	(1,477,736)	0	0	0	0	4,821,922	29,453,281	0	0	0	0	0	0	0	0	0	0	0	0	0