Table: 2018_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 20183 10/01/2017 09/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,542 717 4,343 5,730 165 0 1,722 779 0 153 17,151 0 29,262 3,984 25,271 29,327 1,006 0 15,537 2,866 0 680 107,933 0 152,636 2,524 103,393 251,235 43,510 0 17,649 59,161 1,289 15,913 647,310 524,119,669 106,399,393 491,547,932 608,205,576 26,747,677 0 229,897,708 102,462,362 0 16,754,000 2,106,134,317 297,962,394 14,613,953 194,420,449 485,689,937 103,623,513 0 80,943,711 112,379,793 7,278,172 49,209,030 1,346,120,952 109,802,999 686,491,509 98,600,832 566,275,902 1,039,456,198 (126,114,483) 69,042,132 0 193,750,940 151,680,533 0 7,072,453 0 0 0 18,738,195 2,814,797,210 0 60,729,837 0 40,478,462 101,208,299 125,000,241 20,664,090 226,534,986 106,449,283 56,388,832 0 107,742,962 95,694,736 191,228 0 738,666,358 90,362,357 902,047,565 0 135,491,104 0 0 0 0 1,946,341 146,036,318 0 0 0 0 0 0 0 0 0 0 0 0 0