Table: 2015_quarter_1_sum_of_four_quarters_rev_4_16
, fac_name like Q*
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 HOSP |
20151 |
04/01/2014 |
03/31/2015 |
Open |
Napa |
03 |
0407 |
Church |
Comparable |
None |
(707) 252-4411 |
1000 TRANCAS STREET |
NAPA |
94558 |
WALT MICKENS |
211 |
211 |
174 |
2,853 |
344 |
709 |
1,059 |
0 |
0 |
86 |
1,390 |
1 |
118 |
6,560 |
0 |
15,107 |
1,322 |
2,803 |
4,705 |
0 |
0 |
313 |
5,487 |
14 |
449 |
30,200 |
0 |
58,007 |
4,178 |
3,760 |
22,265 |
0 |
0 |
14,709 |
40,365 |
297 |
5,797 |
149,378 |
287,271,438 |
29,733,000 |
42,884,015 |
81,634,400 |
0 |
0 |
8,998,396 |
106,720,889 |
203,640 |
6,855,539 |
564,301,317 |
202,089,108 |
27,848,730 |
16,122,950 |
89,899,672 |
0 |
0 |
20,255,835 |
190,055,172 |
575,808 |
18,854,283 |
565,701,558 |
11,592,228 |
427,180,858 |
54,841,280 |
48,575,364 |
159,236,904 |
0 |
0 |
0 |
21,617,425 |
172,293,607 |
0 |
5,154,273 |
0 |
0 |
0 |
10,367,644 |
910,859,583 |
197,209 |
17,188,519 |
0 |
1,026,557 |
18,412,285 |
57,106,990 |
2,327,193 |
9,758,246 |
27,614,396 |
0 |
0 |
7,399,198 |
122,365,928 |
(3,144,404) |
14,128,030 |
237,555,577 |
9,824,005 |
257,081,488 |
7,775,316 |
1,307,902 |
0 |
0 |
0 |
0 |
0 |
209,163,000 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
13,996,610 |
5,408,793 |
0 |