Table: 2017_quarter_2_complete_data_set_11_02_17 , 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	20172	04/01/2017	06/30/2017	Open	San Francisco	04	0423	Non Profit Other	Comparable	Teaching	(415) 476-1000	505 PARNASSUS AVENUE	SAN FRANCISCO	94143	MARK LARET	1,019	782	726	2,326	445	747	1,785	14	0	0	3,703	0	72	9,092	0	13,871	2,706	8,003	10,432	162	0	0	20,056	0	381	55,611	0	101,327	14,564	20,391	46,069	376	0	0	160,336	0	8,303	351,366	497,870,191	95,971,690	288,029,179	302,048,757	1,867,365	0	0	692,148,745	0	10,189,576	1,888,125,503	366,041,557	55,091,456	76,161,682	163,441,753	319,896	0	0	613,220,392	0	26,472,606	1,300,749,342	(787,974)	701,616,219	116,234,559	290,396,748	392,925,249	0	1,229,368	0	0	793,289,902	0	18,536,125	0	0	0	2,242,374	2,315,682,570	0	0	0	1,082,743	1,082,743	162,314,962	34,856,316	73,870,796	72,779,762	958,739	0	0	512,370,616	0	17,123,827	874,275,018	30,011,616	884,269,177	0	10,874,561	0	0	0	0	22,629,222	2,051,482,727	0	0	0	0	0	0	0	0	0	0	0	0	0
106231396	UKIAH VALLEY MEDICAL CENTER	20172	04/01/2017	06/30/2017	Open	Mendocino	01	0113	Church	Comparable	Rural	(707) 462-3111	275 HOSPITAL DRIVE	UKIAH	95482	GWEN MATTHEWS	67	50	50	344	24	64	283	0	0	21	110	0	3	849	0	1,191	105	174	774	0	0	94	294	0	3	2,635	0	19,233	1,118	1,273	17,027	0	0	2,545	13,405	0	1,249	55,850	15,437,347	1,142,997	2,226,867	11,135,213	0	0	1,112,192	4,366,895	0	131,826	35,553,337	32,059,562	2,362,824	2,081,663	24,820,129	0	0	4,095,629	17,690,200	0	2,318,248	85,428,255	568,795	35,855,472	2,729,718	3,272,458	26,941,622	0	0	0	3,294,574	11,103,455	0	1,412,910	0	0	0	2,164,367	87,343,371	0	11,450,481	0	0	11,450,481	10,825,729	705,688	951,656	19,878,433	0	0	1,828,261	10,776,430	0	122,505	45,088,702	951,072	40,552,673	0	182	183	366	1,803,397	0	3,571,182	50,444,941	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA - DAVIS MEDICAL CENTER	20172	04/01/2017	06/30/2017	Open	Sacramento	02	0311	Non Profit Other	Comparable	Teaching	(916) 734-7020	2315 STOCKTON BOULEVARD	SACRAMENTO	95817	ANN MADDEN RICE	627	601	601	2,403	259	1,178	1,770	23	2	295	2,307	60	2	8,299	0	13,923	1,357	9,100	9,254	102	52	1,824	10,356	225	3	46,196	0	77,659	7,313	9,816	12,917	54	0	5,285	137,865	3,102	459	254,470	445,592,302	46,333,652	234,622,221	254,782,663	2,354,194	2,194,509	57,628,568	332,628,763	3,786,640	102,847	1,380,026,359	229,620,675	23,556,465	35,037,721	78,110,877	526,559	0	121,944,377	324,851,122	6,374,661	280,184	820,302,641	28,202,988	563,737,354	57,362,063	201,092,017	278,330,551	0	2,224,736	1,928,507	164,605,403	354,114,501	0	4,551,867	0	0	0	43,028,072	1,699,178,059	0	0	0	38,918,449	38,918,449	111,475,623	12,528,054	43,616,133	54,562,988	656,017	266,002	14,967,542	301,625,827	178,162	193,042	540,069,390	13,825,859	517,644,996	0	5,859,556	0	0	0	0	40,014,000	1,028,734,000	0	0	0	0	0	0	0	0	0	0	0	0	0
106301279	UNIVERSITY OF CALIFORNIA - IRVINE MEDICAL CENTER	20172	04/01/2017	06/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	1,289	508	762	1,309	0	0	95	1,413	87	0	5,463	0	6,355	2,911	7,108	6,319	0	0	324	7,134	171	0	30,322	0	45,795	8,830	7,426	32,480	133	0	581	53,431	3,083	0	151,759	141,753,246	67,825,821	108,240,886	139,041,334	0	0	10,755,280	146,528,210	4,339,266	0	618,484,043	116,008,493	25,340,694	17,904,062	77,713,326	520,380	0	4,701,780	129,285,054	5,476,780	0	376,950,569	7,531,067	206,043,496	79,609,410	24,273,260	215,420,183	0	(184,817)	0	0	132,748,574	0	10,017,815	0	2,059,266	(2,059,266)	2,936,329	678,395,317	0	466,721	0	0	466,721	51,718,243	13,557,105	101,871,688	1,801,198	705,197	0	7,925,993	143,064,690	(3,138,098)	0	317,506,016	4,996,298	260,361,812	0	2,558,920	0	0	0	0	34,110,630	738,829,666	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA - SAN DIEGO MEDICAL CENTER	20172	04/01/2017	06/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	726	726	1,934	705	740	1,982	3	0	216	1,846	186	0	7,612	0	12,106	4,697	6,351	11,720	8	0	1,030	10,496	638	0	47,046	0	43,256	24,856	18,489	53,811	12	0	2,107	76,337	1,922	0	220,790	170,345,690	69,586,559	76,427,241	135,760,848	126,333	0	16,522,486	140,928,589	26,638,901	0	636,336,647	170,457,240	44,969,197	30,031,479	120,472,368	99,885	0	17,196,380	238,108,925	53,468,199	0	674,803,673	3,209,840	263,518,209	84,045,075	35,651,301	219,176,337	(62,136,040)	96,925	0	25,184,796	164,911,808	0	61,858,055	0	0	0	12,214,105	807,730,411	0	0	0	0	0	77,284,721	30,510,681	132,943,459	37,056,879	29,293	0	5,424,230	201,911,602	18,249,044	0	503,409,909	47,101,412	464,331,971	0	8,644,551	0	0	0	0	58,332,267	1,623,785,186	0	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20172	04/01/2017	06/30/2017	Open	Los Angeles	11	0925	Non Profit Corp.	Comparable	None	(323) 865-3000	1441 EASTLAKE AVENUE	LOS ANGELES	90089	BOB ALLEN	60	60	34	118	33	44	36	0	0	5	179	0	0	415	0	609	289	426	344	0	0	99	1,324	0	0	3,091	0	11,634	1,290	1,191	1,393	0	0	1,192	11,930	0	204	28,834	6,919,824	3,254,047	4,989,237	4,274,072	0	0	957,913	16,835,582	0	0	37,230,675	63,365,891	8,752,367	6,914,224	9,577,946	0	0	3,607,465	51,653,827	0	618,458	144,490,178	313,160	55,978,392	9,132,232	9,789,095	9,991,051	0	0	0	3,162,971	35,092,767	0	123,889	0	0	0	338,217	123,921,774	0	0	0	0	0	14,186,200	2,853,491	2,093,853	3,837,096	0	0	1,394,539	33,278,614	0	155,286	57,799,079	2,978,132	46,562,109	0	15,479	0	0	0	0	492,482	36,801,502	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20172	04/01/2017	06/30/2017	Open	Los Angeles	11	0937	Non Profit Corp.	Comparable	None	(818) 790-7100	1812 VERDUGO BOULEVARD	GLENDALE	91208	KEITH HOBBS	158	158	92	732	226	30	128	0	0	0	584	5	9	1,714	0	4,483	1,197	137	507	0	0	0	1,970	5	22	8,321	0	5,407	664	247	1,654	0	0	0	6,889	465	323	15,649	27,262,615	8,192,609	1,248,637	3,624,066	0	0	0	26,293,714	824,204	1,139,824	68,585,669	17,177,464	5,161,949	786,734	2,283,430	0	0	0	16,566,985	519,310	718,174	43,214,046	584,378	33,378,821	10,030,572	1,528,761	4,437,104	0	0	0	0	32,442,553	0	1,145,537	0	0	0	1,009,109	84,556,835	0	0	0	0	0	11,061,258	3,323,986	506,609	1,470,392	0	0	0	10,418,146	334,404	128,085	27,242,880	483,545	28,790,619	0	(303,672)	0	0	0	0	1,430,623	30,741,709	0	0	0	0	0	0	0	0	0	0	0	0	0