Table: 2017_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 HOSPITAL 20172 07/01/2016 06/30/2017 Open Napa 03 0407 Church Comparable None (707) 252-4411 1000 TRANCAS STREET NAPA 94558 LARRY COOMES 208 153 125 3,325 299 497 1,126 0 0 116 1,185 6 65 6,619 0 17,597 1,171 2,315 5,440 0 0 442 4,820 18 209 32,012 0 55,672 4,258 2,625 24,174 0 0 4,321 39,874 244 5,282 136,450 353,548,586 34,273,256 38,373,624 98,005,831 0 0 12,336,597 104,301,120 988,159 3,702,554 645,529,727 227,448,378 25,142,904 14,038,867 104,700,961 0 0 16,298,040 218,193,860 1,497,667 12,456,712 619,777,389 7,951,899 501,523,198 53,687,142 40,701,102 170,049,107 0 0 0 25,413,385 207,848,471 0 9,576,444 0 0 0 8,742,211 1,025,492,959 1,514,965 23,940,665 0 3,119,127 28,574,757 75,146,859 7,149,140 10,803,292 55,502,304 0 0 3,200,104 114,411,017 0 2,176,198 268,388,914 8,490,997 272,431,266 12,252,890 8,112,935 0 0 0 0 14,653,656 203,609,621 0 0 0 0 0 0 0 0 0 0 10,132,976 2,613,270 13,434,219