Table: 2018_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	2018R2	07/01/2017	06/30/2018	Open	San Francisco	04 - West Bay	0423	City/County	Comparable	Teaching	415-206-8000	1001 POTRERO AVENUE	SAN FRANCISCO	94110	SUSAN P. EHRLICH	397	324	305	3,444	716	4,261	5,627	142	0	1,675	768	0	180	16,813	0	29,107	3,922	24,143	29,480	1,060	0	15,210	2,858	0	723	106,503	0	152,636	2,524	103,393	251,235	43,510	0	17,649	59,161	1,289	15,913	647,310	505,623,611	99,599,973	464,880,245	608,525,028	28,982,898	0	223,201,437	102,906,740	0	16,821,265	2,050,541,197	281,026,293	14,839,821	185,809,374	483,701,452	98,494,706	0	82,205,826	111,085,875	7,083,834	50,031,895	1,314,279,076	101,414,074	654,635,604	92,266,536	532,602,485	1,031,391,225	(129,623,561)	67,515,697	0	193,658,013	148,270,502	0	6,849,578	0	0	0	18,150,792	2,717,130,945	0	59,157,181	0	39,533,846	98,691,027	123,377,891	20,741,362	231,594,570	111,860,644	55,882,600	0	104,258,891	98,445,628	218,769	0	746,380,355	91,981,023	934,290,544	0	144,836,219	0	0	0	0	296,673	146,414,080	0	0	0	0	0	0	0	0	0	0	0	0	0