Table: 2018_quarter_1_complete_data_set_7_13_18 , 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 20181 01/01/2018 03/31/2018 Open San Francisco 04 0423 City/County Comparable Rural 415-206-8000 1001 POTRERO AVENUE SAN FRANCISCO 94110 SUSAN P. EHRLICH 397 324 305 901 187 1,059 1,500 20 0 410 184 0 50 4,311 0 7,407 906 5,625 7,888 250 0 3,983 607 0 399 27,065 0 38,797 717 26,202 63,504 11,251 0 4,598 14,950 316 4,027 164,362 134,211,872 22,827,136 111,513,004 164,364,333 6,668,671 0 61,871,612 24,843,846 0 7,964,203 534,264,677 72,771,835 4,318,826 47,151,895 124,935,220 26,618,891 0 20,489,971 28,357,082 1,711,896 14,806,463 341,162,079 32,125,414 177,018,572 22,056,105 129,880,151 277,183,624 (31,892,288) 23,438,893 0 51,392,239 37,373,892 0 1,674,636 0 0 0 5,363,648 725,614,886 0 11,903,659 0 8,249,899 20,153,558 27,577,061 4,684,220 55,841,373 22,105,345 9,063,778 0 28,501,239 22,158,121 34,291 0 169,965,428 16,186,195 233,833,700 0 24,870,050 0 0 0 0 72,078 152,811,049 0 0 0 0 0 0 0 0 0 0 0 0 0