Table: 2019_quarter_2_complete_data_set_10_10_19 , 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 20192 04/01/2019 06/30/2019 Open San Francisco 04 - West Bay 0423 City/County Comparable Teaching 628-206-8000 1001 POTRERO AVENUE SAN FRANCISCO 94110 SUSAN P. EHRLICH 397 324 311 1,016 150 1,046 1,353 38 0 480 195 0 21 4,299 0 7,800 864 5,983 7,313 305 0 4,050 750 0 164 27,229 0 38,751 674 24,666 58,999 12,315 0 4,178 15,503 350 4,757 160,193 145,129,782 24,596,283 118,349,931 150,830,559 7,613,160 0 52,203,416 29,473,824 0 5,208,131 533,405,086 83,376,514 3,731,124 45,652,084 131,888,793 36,186,640 0 18,585,298 34,941,414 2,386,154 15,818,304 372,566,325 31,865,751 200,173,989 24,209,127 77,965,104 167,012,415 (36,613,949) 43,682,756 0 52,499,702 45,004,785 0 2,382,116 0 0 0 3,544,890 611,726,686 0 7,824,901 0 12,774,671 20,599,572 27,094,450 3,938,350 117,292,165 118,134,652 111,930 0 17,489,953 30,778,935 3,862 0 314,844,297 53,283,076 374,939,391 0 126,568,797 0 0 0 0 57,620 124,431,696 0 0 0 0 0 0 0 0 0 0 0 0 0