Table: 2017_quarter_4_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 20174 01/01/2017 12/31/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,253 646 3,872 5,060 131 0 1,477 733 0 202 15,374 0 29,187 3,614 25,370 27,593 1,005 0 13,820 3,019 0 716 104,324 0 148,582 2,333 99,711 257,055 40,973 0 16,565 58,182 1,246 16,900 641,547 484,547,414 91,492,766 452,054,916 568,045,628 26,220,129 0 197,534,851 101,482,536 0 12,969,771 1,934,348,011 258,064,625 15,157,759 176,533,738 479,937,888 88,193,628 0 81,200,332 107,143,497 6,548,936 47,362,541 1,260,142,944 72,443,317 623,639,048 86,991,705 526,461,930 992,048,358 (140,024,318) 58,372,759 0 188,111,466 143,256,680 0 6,285,630 0 0 0 17,929,205 2,575,515,780 0 87,161,088 0 37,174,682 124,335,770 114,392,237 18,878,770 232,714,454 126,000,998 53,834,063 0 87,056,894 110,179,409 254,120 0 743,310,945 90,379,011 877,846,168 0 (51,354,939) 0 0 0 0 9,631,520 159,208,017 0 0 0 0 0 0 0 0 0 0 0 0 0