Table: 2024_quarter_2_complete_data_set_10_30_2024 , 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
106380939 ZUCKERBERG SAN FRANCISCO GENERAL HOSPITAL & TRAUMA CENTER 20242 04/01/2024 06/30/2024 Open San Francisco 04 - West Bay 423 City/County Comparable Teaching 628-206-8000 1001 POTRERO AVENUE SAN FRANCISCO 94110 SUSAN P. EHRLICH 397 397 296 892 322 629 1748 42 0 275 192 126 43 4269 0 7578 2277 2915 10884 104 0 1295 738 637 174 26602 0 44476 1795 17849 106071 3984 0 1472 19584