Table: 2019_quarter_3_complete_data_set_1_10_20 , 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	20193	07/01/2019	09/30/2019	Open	Alameda	05 - East Bay	417	Non Profit Corp.	Comparable	None	510-428-3885	747 52ND STREET	OAKLAND	94609	MICHAEL ANDERSON, MD	190	190	190	0	0	699	799	0	0	0	600	0	33	2131	0	0	0	5211	2391	0	0	0	2338	0	78	10018	0	243	0	13897	32474	0	0	0	20033	142	2703	69492	0	0	106281926	45732043	0	0	0	55731906	0	1680187	209426062	2617937	0	38866855	65853954	0	0	0	63232789	140573	2670891	173382999	774804	1947979	0	106775894	93887853	0	0	0	0	71298980	0	540329	0	0	0	0	275225839	0	0	0	0	0	669958	0	38372887	17698144	0	0	0	46890912	0	3951321	107583222	17161206	156973272	0	3861346	0	0	0	0	11496000	332770000	0	0	0	0	0	0	0	0	0	0	0	0	0
106190818	USC VERDUGO HILLS HOSPITAL	20193	07/01/2019	09/30/2019	Open	Los Angeles	11 - Los Angeles	937	Non Profit Corp.	Comparable	None	818-790-7100	1812 VERDUGO BOULEVARD	GLENDALE	91208	KEITH HOBBS	158	158	86	679	318	33	101	0	0	0	477	0	27	1635	0	3883	1559	135	425	0	0	0	1731	0	104	7837	0	5984	1026	297	1864	0	0	0	7882	0	906	17959	43289009	10449279	1851031	6775442	0	0	0	28316467	0	645710	91326938	33915389	7476290	2189487	5191418	0	0	0	21593678	0	657700	71023962	438979	61093857	13853979	3204926	9597698	0	0	0	0	38673730	0	0	0	0	0	777923	127641092	0	0	0	0	0	16110541	4071590	835592	2369162	0	0	0	11236415	0	86508	34709808	344864	35224960	0	-518839	0	0	0	0	60092	28905261	0	0	0	0	0	0	0	0	0	0	0	0	0
106191216	USC KENNETH NORRIS JR. CANCER HOSPITAL	20193	07/01/2019	09/30/2019	Open	Los Angeles	11 - Los Angeles	925	Non Profit Corp.	Comparable	None	323-865-3000	1441 EASTLAKE AVENUE	LOS ANGELES	90089	RICHARD PINEDA	60	60	42	113	27	50	73	0	0	7	168	0	1	439	0	872	232	671	579	0	0	35	1418	0	3	3810	0	14781	2458	1544	1872	0	0	1075	15952	0	184	37866	11709646	3602857	10384350	8864134	0	0	562364	20090139	0	44346	55257836	75184451	14207585	11429187	9223748	0	0	2839893	60333869	0	206830	173425563	-101926	73111566	14471933	18693147	12529374	0	0	0	2719407	45254803	0	0	0	0	0	212948	166891252	0	0	0	0	0	13821260	3346448	3130113	5566569	0	0	684366	35205050	0	38341	61792147	959613	48364582	0	0	0	0	0	0	4262977	44151834	0	0	0	0	0	0	0	0	0	0	0	0	0
106301279	UNIVERSITY OF CALIFORNIA IRVINE MEDICAL CENTER	20193	07/01/2019	09/30/2019	Open	Orange	13 - Orange	1015	Non Profit Other	Comparable	Teaching	714-456-7890	101 CITY DRIVE SOUTH	ORANGE	92868	LARRY ANSTINE	402	402	402	1135	589	750	1461	22	0	128	1293	164	0	5542	0	6340	3093	6830	8309	120	0	559	6149	422	0	31822	0	50984	13527	5970	36263	208	0	2453	56594	5643	0	171642	147977148	76728020	104160545	165208079	1736964	0	15524780	135982498	12825750	0	660143784	138266768	44783841	16598886	95973863	794028	0	5966683	158218648	13620410	0	474223127	16557426	226157885	98782131	89274906	237000751	0	1190691	0	0	149159852	0	21332836	0	1970400	-1970400	7337747	846794225	0	134351	0	0	134351	60086031	22729730	31484525	24315542	1340301	0	4934037	145041294	-2224423	0	287707037	34623620	324128723	0	998093	0	0	0	0	12991822	764232165	0	0	0	0	0	0	0	0	0	0	0	0	0
106341006	UNIVERSITY OF CALIFORNIA DAVIS MEDICAL CENTER	20193	07/01/2019	09/30/2019	Open	Sacramento	02 - Golden Empire	311	Non Profit Other	Comparable	Teaching	916-734-7020	2315 STOCKTON BOULEVARD	SACRAMENTO	95817	BRAD SIMMONS	625	605	520	2135	340	1031	1682	4	1	287	1769	52	2	7303	0	12401	1814	6880	8836	15	29	1744	7868	233	37	39857	0	86873	10213	3764	8650	74	1	8446	133114	1131	14	252280	449701474	67452806	236716527	252732053	961966	602179	59522238	280479654	16963537	1211135	1366343569	332629822	39392601	45379057	126686353	1169417	11624	74379802	362747430	13245038	72554	995713698	11302181	660575425	88444942	237663091	318501072	0	1613495	539294	117434656	348879459	0	29280515	0	0	0	1041998	1815276128	0	7999700	0	10085141	18084841	116518211	17707603	44437206	66697157	517888	74509	15804052	302068356	807450	233548	564865980	17035067	591287442	0	-1953091	0	0	0	0	18702000	1113724000	0	0	0	0	0	0	0	0	0	0	0	0	0
106370782	UNIVERSITY OF CALIFORNIA SAN DIEGO MEDICAL CENTER	20193	07/01/2019	09/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	2110	818	831	2119	0	0	287	2148	158	0	8471	0	13419	5682	8037	12334	0	0	1809	12675	557	0	54513	0	43554	10488	20537	27658	0	0	2630	164471	777	0	270115	238499786	100309089	117061958	189488065	0	0	33383271	241069412	24369180	0	944180761	230435826	75736796	37771664	159617642	0	0	22925532	342502635	59279016	0	928269111	3802271	375518113	137235214	97322846	301726514	-30581750	0	0	43737358	300095165	0	63506648	0	0	0	18450736	1310813115	0	0	0	0	0	93417499	38810671	88092526	47379192	0	0	8769174	265026147	20141548	0	561636757	51504062	559781019	0	2968896	0	0	0	0	9150346	1592054810	0	0	0	0	0	0	0	0	0	0	0	0	0
106381154	UCSF MEDICAL CENTER	20193	07/01/2019	09/30/2019	Open	San Francisco	04 - West Bay	423	Non Profit Other	Comparable	Teaching	415-476-1000	505 PARNASSUS AVENUE	SAN FRANCISCO	94143	MARK LARET	1019	750	726	2478	511	524	2030	21	0	0	3708	0	63	9335	0	16118	3211	5655	13449	496	0	0	20745	0	212	59886	0	140797	22602	21842	62691	854	0	0	219627	0	8613	477026	625200607	131248719	260609159	441185671	24556526	0	0	826636119	0	3625462	2313062263	544907656	87472901	84531323	242623399	3304237	0	0	849994227	0	33334113	1846167856	13457546	994097729	201952598	287316127	572926647	0	13513748	0	0	1017708372	0	17627653	0	0	0	2697901	3121298321	0	0	0	940405	940405	175412553	16138327	57114601	107440908	14153942	0	0	653356619	0	15255253	1038872203	55065552	1098823295	0	1429449	0	0	0	0	39880566	2094732947	0	0	0	0	0	0	0	0	0	0	0	0	0