Table: 2017_quarter_2_sum_of_four_quarters , fac_name like Z*

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
106380939	ZUCKERBERG SAN FRANCISCO GENERAL HOSPITAL & TRAUMA CENTER	20172	07/01/2016	06/30/2017	Open	San Francisco	04	0423	City/County	Comparable	Teaching	(415) 206-8000	1001 POTRERO AVENUE	SAN FRANCISCO	94110	SUSAN P. EHRLICH	397	324	305	3,031	560	3,736	4,960	120	0	1,310	703	0	274	14,694	0	28,025	3,167	24,886	27,761	799	0	13,113	2,753	0	1,152	101,656	0	144,531	2,183	97,317	256,353	40,185	0	15,607	57,897	1,255	17,969	633,297	453,512,341	80,043,789	439,483,319	558,986,498	20,805,120	0	177,402,246	89,535,068	0	16,063,368	1,835,831,749	241,019,792	14,679,876	168,166,121	464,159,533	85,235,355	0	75,029,614	104,170,443	8,760,680	52,140,432	1,213,361,846	73,208,102	581,227,236	78,650,809	501,572,668	969,835,803	(132,041,262)	48,653,672	0	174,090,424	132,211,908	0	8,268,926	0	0	0	24,050,752	2,459,729,038	0	94,082,765	0	42,578,529	136,661,294	109,037,102	15,464,997	228,872,590	130,057,657	55,258,414	0	75,344,370	111,617,929	472,792	0	726,125,851	77,082,668	878,646,349	0	(47,674,288)	0	0	0	0	12,547,769	171,993,594	0	0	0	0	0	0	0	0	0	0	0	0	0