Table: 2017_quarter_2_complete_data_set_11_02_17 , 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 04/01/2017 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 790 131 883 1,171 30 0 362 155 0 45 3,567 0 7,109 831 6,131 7,241 223 0 3,565 550 0 186 25,836 0 37,945 575 24,179 65,434 10,424 0 4,094 14,893 322 4,346 162,212 116,194,552 21,702,270 103,821,271 141,269,302 5,582,190 0 53,639,081 17,134,383 0 3,402,325 462,745,374 64,915,367 4,466,987 45,213,613 123,488,007 22,819,698 0 21,222,282 26,660,805 1,710,029 10,682,021 321,178,809 19,048,380 155,573,884 21,464,433 121,115,038 253,711,065 (43,458,676) 6,388,899 0 49,988,608 31,528,191 0 1,672,607 0 0 0 4,612,414 621,644,843 0 49,454,688 0 13,840,234 63,294,922 24,496,087 4,513,221 68,471,651 46,421,602 21,116,516 0 23,859,819 36,659,468 35,898 0 225,574,262 28,487,106 246,778,765 0 (104,380,201) 0 0 0 0 9,380,929 171,993,594 0 0 0 0 0 0 0 0 0 0 0 0 0