Table: 2019_quarter_2_sum_of_four_quarters , fac_name like Q*

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
106281047 QUEEN OF THE VALLEY MEDICAL CENTER 20192 07/01/2018 06/30/2019 Open Napa 03 - North Bay 0407 Church Comparable None 707-252-4411 1000 TRANCAS STREET NAPA 94558 LARRY COOMES 208 148 125 3,251 348 447 1,197 0 0 166 1,102 11 63 6,585 0 15,906 1,538 2,173 5,430 0 0 691 4,549 52 255 30,594 0 68,474 6,400 2,803 26,874 0 0 7,881 49,005 408 5,359 167,204 353,846,997 46,390,709 39,515,172 114,997,499 0 0 19,461,451 106,985,452 1,049,811 5,606,068 687,853,159 314,162,328 37,795,188 18,894,855 133,889,500 0 0 28,092,355 256,012,798 4,290,677 17,567,062 810,704,763 10,723,427 582,830,957 65,489,833 29,664,349 202,284,731 0 0 0 38,771,908 252,273,478 0 17,338,826 0 0 0 5,035,199 1,204,412,708 2,620,008 21,481,938 0 4,256,089 28,358,035 81,898,480 20,994,312 27,310,450 66,683,197 0 0 8,565,650 111,927,258 0 5,123,902 322,503,249 7,754,446 268,188,890 15,928,098 6,406,227 0 0 0 0 9,600,123 196,214,005 0 0 0 0 0 0 0 0 0 0 22,789,529 24,414,898 30,982,182