Table: 2017_quarter_3_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 20173 10/01/2016 09/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 3104 595 3706 5007 120 0 1355 714 0 249 14850 0 28328 3343 25101 27960 891 0 13387 2841 0 958 102809 0 145359 2267 97310 257065 40207 0 15870 57707 1264 17189 634238 461260244 85626625 441019628 570973455 23553824 0 186305869 94790491 0 14629882 1878160018 248276734 15284362 176494563 480787258 86763343 0 79379262 106702539 6781446 50471900 1250941407 75137609 598548734 83783497 510593083 997808414 -134406021 65111216 0 181628344 137252156 0 6464706 0 0 0 19310903 2541232641 0 93650750 0 40407617 134058367 106739343 16464164 231798460 130208684 43528784 0 80772180 112110889 304647 0 721927151 76569494 880216935 0 -59459748 0 0 0 0 11388860 165604986 0 0 0 0 0 0 0 0 0 0 0 0 0