Table: 2019_quarter_2_complete_data_set_10_10_19 , 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	04/01/2019	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	7	0	783	812	0	0	0	629	0	0	2,231	0	27	0	4,845	2,533	0	0	0	2,759	0	0	10,164	0	261	0	14,331	35,232	0	0	0	20,625	150	2,854	73,453	522,295	0	87,738,858	45,697,801	0	0	0	66,196,814	0	301,013	200,456,781	2,546,884	0	35,654,237	65,971,991	0	0	0	59,111,292	186,314	1,464,628	164,935,346	(780,149)	2,184,461	0	64,180,479	73,493,370	0	0	0	0	69,547,648	0	821,042	0	0	0	0	209,446,851	0	0	0	0	0	884,718	0	59,212,616	38,176,422	0	0	0	56,540,607	186,314	944,599	155,945,276	14,881,000	166,090,000	0	8,802,000	0	0	0	0	10,618,000	330,502,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106381154	UCSF MEDICAL CENTER	20192	04/01/2019	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	2,278	559	489	1,960	22	0	0	3,583	0	44	8,935	0	14,548	3,416	5,695	13,486	180	0	0	21,218	0	293	58,836	0	150,769	23,994	24,801	65,368	594	0	0	227,469	0	9,041	502,036	572,406,868	136,955,224	281,910,302	422,342,001	7,825,994	0	0	850,461,663	0	6,001,268	2,277,903,320	516,386,824	87,000,316	88,360,889	236,052,459	1,640,746	0	0	805,438,811	0	34,303,100	1,769,183,145	13,389,079	914,190,001	182,137,664	306,578,770	546,335,759	0	4,694,434	0	0	989,936,446	0	19,619,005	0	0	0	1,030,547	2,977,911,705	0	0	0	186,139	186,139	174,034,353	41,164,849	63,320,209	108,658,113	4,743,815	0	0	660,171,294	0	17,268,266	1,069,360,899	48,615,538	1,082,165,569	0	7,061,904	0	0	0	0	70,012,294	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	04/01/2019	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	2,367	298	1,107	1,750	0	2	265	1,778	69	2	7,638	0	16,045	2,143	10,551	11,056	0	16	1,984	8,552	319	28	50,694	0	102,268	11,579	7,455	20,739	101	5	12,400	131,138	2,066	80	287,831	480,113,202	63,214,169	247,439,559	290,593,104	0	394,710	60,800,069	263,708,276	7,683,289	1,032,843	1,414,979,221	334,932,366	34,999,317	46,280,050	133,321,041	696,363	36,628	61,197,119	348,182,541	10,673,575	358,735	970,677,735	20,821,626	662,554,409	82,622,902	222,676,042	342,494,738	0	496,695	393,588	103,783,403	334,719,046	0	16,850,331	0	0	0	262,268	1,787,675,048	0	15,486,059	0	2,355,572	17,841,631	142,803,715	14,448,609	71,049,659	92,537,317	199,667	37,751	16,092,612	276,981,987	1,344,192	328,030	615,823,539	18,317,980	591,051,850	0	(14,908,970)	0	0	0	0	27,011,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	04/01/2019	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	1,216	673	773	1,402	6	0	131	1,288	172	0	5,661	0	6,410	3,592	7,042	7,087	34	0	735	6,301	314	0	31,515	0	48,801	14,001	6,140	33,646	209	0	735	54,633	5,353	0	163,518	144,913,845	86,132,168	107,065,058	154,382,845	547,651	0	17,623,900	131,992,803	18,246,244	0	660,904,514	137,967,493	43,288,014	17,108,598	92,001,298	753,789	0	4,687,864	143,218,658	4,709,265	0	443,734,979	25,926,646	222,044,899	102,749,731	68,858,420	210,801,553	0	445,037	0	0	150,094,885	0	3,578,689	0	1,970,400	(1,970,400)	8,409,194	792,909,054	0	281,819	0	0	281,819	60,836,439	26,670,451	55,315,236	35,864,409	856,403	0	(3,614,882)	125,116,576	10,967,626	0	312,012,258	29,991,953	310,616,611	0	4,412,950	0	0	0	0	22,901,735	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	04/01/2019	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	2,160	795	822	2,114	0	0	236	2,119	188	0	8,434	0	14,571	5,310	7,413	13,017	0	0	1,138	11,890	568	0	53,907	0	48,866	9,299	22,324	29,310	0	0	2,572	156,906	1,543	0	270,820	235,996,354	85,019,510	94,854,187	187,321,063	0	0	17,844,023	215,127,771	22,174,351	0	858,337,259	222,774,958	67,758,395	36,038,272	150,285,963	0	0	21,385,740	328,102,084	56,131,801	0	882,477,213	16,013,417	363,136,651	121,132,707	90,970,522	283,253,214	(26,527,321)	31,571	0	27,609,776	261,004,585	0	51,948,949	0	0	0	23,384,872	1,211,958,943	0	0	0	0	0	95,634,661	31,645,198	66,588,720	54,219,854	(39,461)	0	6,614,240	257,840,398	16,351,919	0	528,855,529	51,574,554	448,042,626	0	3,921,020	0	0	0	0	29,222,425	32,252,825	0	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20192	04/01/2019	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	105	35	42	56	0	0	1	147	0	1	387	0	739	150	489	868	0	0	12	1,395	0	4	3,657	0	14,868	2,286	1,616	1,893	0	0	1,024	15,905	0	169	37,761	9,515,919	2,538,085	6,281,821	12,808,935	0	0	261,120	17,211,249	0	25,842	48,642,971	78,762,845	13,545,158	11,702,040	9,689,837	0	0	1,911,613	62,266,791	0	333,105	178,211,389	248,110	74,347,264	11,158,825	14,771,949	14,410,605	0	0	0	693,537	38,619,872	0	0	0	0	0	110,012	154,360,174	0	0	0	0	0	13,834,950	4,906,829	3,192,244	8,063,560	0	0	1,476,819	40,771,244	0	248,540	72,494,186	814,842	49,557,592	0	0	0	0	0	0	4,273,497	41,051,450	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20192	04/01/2019	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	696	256	30	117	0	0	0	492	0	22	1,613	0	3,647	1,917	160	300	0	0	0	1,429	0	67	7,520	0	5,835	1,132	245	1,973	0	0	0	7,920	0	954	18,059	40,661,468	10,715,032	2,161,364	5,870,258	0	0	0	26,081,108	0	294,377	85,783,607	33,350,827	8,050,360	1,772,766	5,142,911	0	0	0	21,391,911	0	651,554	70,360,329	580,994	59,009,143	14,743,869	3,136,637	9,249,587	0	0	0	0	38,049,687	0	0	0	0	0	302,824	125,072,741	0	0	0	0	0	15,003,152	4,021,523	797,493	1,763,582	0	0	0	9,423,332	0	62,113	31,071,195	2,037,101	34,971,806	0	(410,786)	0	0	0	0	3,149,300	29,453,281	0	0	0	0	0	0	0	0	0	0	0	0	0