Home

Dataset:

Name pre-2012-long-term-care-facility-integrated-disclosure-and-medi-cal-cost-report-data-pivot-tables
Updated 2024-08-29
CA Dataset link
Current True
Tables
1997_part_a_long_term_care_annual_financial_data     fac_no - varchar(9)
fac_name - varchar(40)
beg_date - varchar(8)
end_date - varchar(8)
day_per - varchar(7)
data_ind - varchar(8)
comparable - varchar(10)
county - varchar(6)
hsa - varchar(3)
hfpa - varchar(4)
lic_cat - varchar(7)
type_cntrl - varchar(14)
legal_org - varchar(14)
phone - varchar(13)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
mcal_pronum - varchar(9)
adminis - varchar(27)
related - varchar(7)
parent - varchar(41)
bed_end - varchar(7)
bed_avg - varchar(7)
day_totl - varchar(8)
occup - varchar(5)
admits - varchar(6)
dischs - varchar(6)
day_mcar - varchar(8)
day_mcal - varchar(8)
day_self - varchar(8)
day_oth - varchar(7)
day_sn - varchar(6)
day_ic - varchar(6)
day_md - varchar(6)
day_dd - varchar(6)
day_subacu - varchar(10)
day_subped - varchar(10)
day_tic - varchar(7)
day_hospic - varchar(10)
day_oth_rt - varchar(10)
nr_rt_totl - varchar(10)
nr_an_totl - varchar(10)
oth_op_rev - varchar(10)
tot_hc_rev - varchar(10)
tot_hc_exp - varchar(10)
net_frm_hc - varchar(10)
nonhc_net - varchar(9)
inc_tax - varchar(7)
ext_item - varchar(8)
net_income - varchar(10)
nr_rt_mcar - varchar(10)
nr_rt_mcal - varchar(10)
nr_rt_self - varchar(10)
nr_rt_oth - varchar(9)
nr_sn - varchar(7)
nr_ic - varchar(7)
nr_md - varchar(7)
nr_dd - varchar(7)
nr_subacu - varchar(9)
nr_subped - varchar(9)
nr_tic - varchar(6)
nr_hospic - varchar(9)
nr_oth_rt - varchar(9)
nr_an_mcar - varchar(10)
nr_an_mcal - varchar(10)
nr_an_self - varchar(10)
nr_an_oth - varchar(9)
nr_psupply - varchar(10)
nr_pt - varchar(7)
nr_pharm - varchar(8)
nr_lab - varchar(6)
nr_hmhlth - varchar(9)
nr_oth_an - varchar(9)
exp_sal - varchar(7)
exp_ben - varchar(7)
exp_other - varchar(9)
work_comp - varchar(9)
exp_sn - varchar(7)
exp_ic - varchar(6)
exp_md - varchar(7)
exp_dd - varchar(7)
exp_subacu - varchar(10)
exp_subped - varchar(10)
exp_tic - varchar(7)
exp_hospic - varchar(10)
exp_oth_rt - varchar(10)
exp_psuppl - varchar(10)
exp_pt - varchar(6)
exp_pharm - varchar(9)
exp_lab - varchar(7)
exp_hmhlth - varchar(10)
exp_oth_an - varchar(10)
exp_pom - varchar(7)
exp_hkp - varchar(7)
exp_ll - varchar(6)
exp_diet - varchar(8)
exp_ss - varchar(6)
exp_actv - varchar(8)
exp_insv - varchar(8)
exp_admn - varchar(8)
exp_dprec - varchar(9)
exp_lease - varchar(9)
exp_prptax - varchar(10)
exp_prpins - varchar(10)
exp_intppe - varchar(10)
exp_intoth - varchar(10)
exp_bdebt - varchar(9)
cur_asst - varchar(8)
asst_limtd - varchar(10)
net_ppe - varchar(8)
const_prog - varchar(10)
inv_oth - varchar(8)
intan_asst - varchar(10)
tot_asst - varchar(8)
cur_liab - varchar(8)
def_cred - varchar(8)
net_ltdebt - varchar(10)
equity - varchar(9)
liab_eq - varchar(8)
rel_rec_cr - varchar(10)
rel_rec_lt - varchar(10)
rel_pay_cr - varchar(10)
rel_pay_lt - varchar(10)
landimp - varchar(8)
bldgsimp - varchar(9)
lease_imp - varchar(9)
equipment - varchar(9)
tot_ppe - varchar(8)
acc_deprec - varchar(10)
mort_pay - varchar(8)
cap_lease - varchar(9)
bond_pay - varchar(8)
tot_ltdebt - varchar(10)
cur_mat - varchar(8)
cur_ratio - varchar(9)
acid_ratio - varchar(10)
days_ar - varchar(7)
ltd_asst - varchar(8)
debt_cov - varchar(8)
op_margin - varchar(9)
net_rtn_eq - varchar(10)
trnovr_opr - varchar(10)
asst_equty - varchar(10)
ppe_bed - varchar(7)
prdhr_mgt - varchar(9)
prdhr_gnp - varchar(9)
prdhr_rn - varchar(8)
prdhr_lvn - varchar(9)
prdhr_na - varchar(8)
prdhr_tsp - varchar(9)
prdhr_psy - varchar(9)
prdhr_oth - varchar(9)
prdhr_an - varchar(8)
prdhr_pom - varchar(9)
prdhr_hkp - varchar(9)
prdhr_ll - varchar(8)
prdhr_diet - varchar(10)
prdhr_ss - varchar(8)
prdhr_actv - varchar(10)
prdhr_insv - varchar(10)
prdhr_admn - varchar(10)
prdhr_totl - varchar(10)
tmp_hr_gnp - varchar(10)
tmp_hr_rn - varchar(9)
tmp_hr_lvn - varchar(10)
tmp_hr_na - varchar(9)
tmp_hr_psy - varchar(10)
tmp_hr_oth - varchar(10)
tmp_hr_tot - varchar(10)
sw_mgt - varchar(7)
sw_gnp - varchar(7)
sw_rn - varchar(7)
sw_lvn - varchar(7)
sw_na - varchar(7)
sw_tsp - varchar(7)
sw_psy - varchar(7)
sw_oth - varchar(7)
sw_anc - varchar(7)
sw_pom - varchar(7)
sw_hkp - varchar(7)
sw_ll - varchar(6)
sw_diet - varchar(8)
sw_ss - varchar(6)
sw_actv - varchar(8)
sw_insv - varchar(8)
sw_admn - varchar(8)
sw_totl - varchar(8)
tmp_pd_gnp - varchar(10)
tmp_pd_rn - varchar(9)
tmp_pd_lvn - varchar(10)
tmp_pd_na - varchar(9)
tmp_pd_psy - varchar(10)
tmp_pd_oth - varchar(10)
tmp_pd_tot - varchar(10)
emp_avg - varchar(7)
emp_trnovr - varchar(10)
emp_cont - varchar(8)
1997_part_b_long_term_care_annual_financial_data     fac_no - varchar(9)
fac_name - varchar(40)
beg_date - varchar(8)
end_date - varchar(8)
day_per - varchar(7)
data_ind - varchar(10)
comparable - varchar(10)
county - varchar(6)
hsa - varchar(3)
hfpa - varchar(4)
lic_cat - varchar(7)
type_cntrl - varchar(14)
legal_org - varchar(14)
phone - varchar(13)
address - varchar(30)
city - varchar(16)
zip_code - varchar(10)
mcal_pronum - varchar(9)
adminis - varchar(28)
related - varchar(7)
parent - varchar(40)
bed_end - varchar(7)
bed_avg - varchar(7)
day_totl - varchar(8)
occup - varchar(6)
admits - varchar(6)
dischs - varchar(6)
day_mcar - varchar(8)
day_mcal - varchar(8)
day_self - varchar(8)
day_oth - varchar(7)
day_sn - varchar(6)
day_ic - varchar(6)
day_md - varchar(6)
day_dd - varchar(6)
day_subacu - varchar(10)
day_subped - varchar(10)
day_tic - varchar(7)
day_hospic - varchar(10)
day_oth_rt - varchar(10)
gr_rt_totl - varchar(10)
gr_an_totl - varchar(10)
dfr_totl - varchar(8)
oth_op_rev - varchar(10)
tot_hc_rev - varchar(10)
tot_hc_exp - varchar(10)
net_frm_hc - varchar(10)
nonhc_net - varchar(9)
inc_tax - varchar(7)
ext_item - varchar(8)
net_income - varchar(10)
gr_rt_mcar - varchar(10)
gr_rt_mcal - varchar(10)
gr_rt_self - varchar(10)
gr_rt_oth - varchar(9)
gr_sn - varchar(8)
gr_ic - varchar(7)
gr_md - varchar(7)
gr_dd - varchar(7)
gr_subacu - varchar(9)
gr_subped - varchar(9)
gr_tic - varchar(6)
gr_hospic - varchar(9)
gr_oth_rt - varchar(9)
gr_an_mcar - varchar(10)
gr_an_mcal - varchar(10)
gr_an_self - varchar(10)
gr_an_oth - varchar(9)
gr_psupply - varchar(10)
gr_spsurf - varchar(9)
gr_pt - varchar(7)
gr_rt - varchar(7)
gr_ot - varchar(7)
gr_sp - varchar(7)
gr_pharm - varchar(8)
gr_lab - varchar(6)
gr_hmhlth - varchar(9)
gr_oth_an - varchar(9)
dfr_charit - varchar(10)
dfr_admin - varchar(9)
ca_mcare - varchar(8)
ca_mcal - varchar(7)
ca_other - varchar(8)
dfr_other - varchar(9)
exp_sal - varchar(7)
exp_ben - varchar(7)
exp_other - varchar(9)
work_comp - varchar(9)
exp_sn - varchar(7)
exp_ic - varchar(7)
exp_md - varchar(7)
exp_dd - varchar(7)
exp_subacu - varchar(10)
exp_subped - varchar(10)
exp_tic - varchar(7)
exp_hospic - varchar(10)
exp_oth_rt - varchar(10)
exp_psuppl - varchar(10)
exp_spsurf - varchar(10)
exp_pt - varchar(7)
exp_rt - varchar(6)
exp_ot - varchar(7)
exp_sp - varchar(6)
exp_pharm - varchar(9)
exp_lab - varchar(7)
exp_hmhlth - varchar(10)
exp_oth_an - varchar(10)
exp_pom - varchar(7)
exp_hkp - varchar(7)
exp_ll - varchar(6)
exp_diet - varchar(8)
exp_ss - varchar(6)
exp_actv - varchar(8)
exp_insv - varchar(8)
exp_admn - varchar(8)
exp_dprec - varchar(9)
exp_lease - varchar(9)
exp_prptax - varchar(10)
exp_prpins - varchar(10)
exp_intppe - varchar(10)
exp_intoth - varchar(10)
exp_bdebt - varchar(9)
cur_asst - varchar(8)
asst_limtd - varchar(10)
net_ppe - varchar(8)
const_prog - varchar(10)
inv_oth - varchar(8)
intan_asst - varchar(10)
tot_asst - varchar(8)
cur_liab - varchar(8)
def_cred - varchar(8)
net_ltdebt - varchar(10)
equity - varchar(8)
liab_eq - varchar(8)
rel_rec_cr - varchar(10)
rel_rec_lt - varchar(10)
rel_pay_cr - varchar(10)
rel_pay_lt - varchar(10)
landimp - varchar(8)
bldgsimp - varchar(9)
lease_imp - varchar(9)
equipment - varchar(9)
tot_ppe - varchar(8)
acc_deprec - varchar(10)
mort_pay - varchar(8)
cap_lease - varchar(9)
bond_pay - varchar(8)
tot_ltdebt - varchar(10)
cur_mat - varchar(8)
cur_ratio - varchar(9)
acid_ratio - varchar(10)
days_ar - varchar(7)
ltd_asst - varchar(8)
debt_cov - varchar(8)
op_margin - varchar(9)
net_rtn_eq - varchar(10)
trnovr_opr - varchar(10)
asst_equty - varchar(10)
ppe_bed - varchar(7)
prdhr_mgt - varchar(9)
prdhr_gnp - varchar(9)
prdhr_rn - varchar(8)
prdhr_lvn - varchar(9)
prdhr_na - varchar(8)
prdhr_tsp - varchar(9)
prdhr_psy - varchar(9)
prdhr_oth - varchar(9)
prdhr_an - varchar(8)
prdhr_pom - varchar(9)
prdhr_hkp - varchar(9)
prdhr_ll - varchar(8)
prdhr_diet - varchar(10)
prdhr_ss - varchar(8)
prdhr_actv - varchar(10)
prdhr_insv - varchar(10)
prdhr_admn - varchar(10)
prdhr_totl - varchar(10)
tmp_hr_gnp - varchar(10)
tmp_hr_rn - varchar(9)
tmp_hr_lvn - varchar(10)
tmp_hr_na - varchar(9)
tmp_hr_psy - varchar(10)
tmp_hr_oth - varchar(10)
tmp_hr_tot - varchar(10)
sw_mgt - varchar(7)
sw_gnp - varchar(7)
sw_rn - varchar(7)
sw_lvn - varchar(7)
sw_na - varchar(7)
sw_tsp - varchar(7)
sw_psy - varchar(7)
sw_oth - varchar(7)
sw_anc - varchar(7)
sw_pom - varchar(7)
sw_hkp - varchar(7)
sw_ll - varchar(6)
sw_diet - varchar(8)
sw_ss - varchar(6)
sw_actv - varchar(8)
sw_insv - varchar(8)
sw_admn - varchar(8)
sw_totl - varchar(8)
tmp_pd_gnp - varchar(10)
tmp_pd_rn - varchar(9)
tmp_pd_lvn - varchar(10)
tmp_pd_na - varchar(9)
tmp_pd_psy - varchar(10)
tmp_pd_oth - varchar(10)
tmp_pd_tot - varchar(10)
emp_avg - varchar(7)
emp_trnovr - varchar(10)
emp_cont - varchar(8)
1998_long_term_care_annual_financial_data     fac_no - varchar(9)
fac_name - varchar(40)
beg_date - varchar(8)
end_date - varchar(8)
day_per - varchar(7)
data_ind - varchar(10)
comparable - varchar(10)
county - varchar(6)
hsa - varchar(3)
hfpa - varchar(4)
lic_cat - varchar(7)
type_cntrl - varchar(14)
legal_org - varchar(14)
phone - varchar(13)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
mcal_pronum - varchar(10)
adminis - varchar(29)
related - varchar(7)
parent - varchar(40)
bed_end - varchar(7)
bed_avg - varchar(7)
day_totl - varchar(8)
occup - varchar(6)
admits - varchar(6)
dischs - varchar(6)
day_mcar - varchar(8)
day_mcal - varchar(8)
day_self - varchar(8)
day_oth - varchar(7)
day_sn - varchar(6)
day_ic - varchar(6)
day_md - varchar(6)
day_dd - varchar(6)
day_subacu - varchar(10)
day_subped - varchar(10)
day_tic - varchar(7)
day_hospic - varchar(10)
day_oth_rt - varchar(10)
gr_rt_totl - varchar(10)
gr_an_totl - varchar(10)
dfr_totl - varchar(8)
oth_op_rev - varchar(10)
tot_hc_rev - varchar(10)
tot_hc_exp - varchar(10)
net_frm_hc - varchar(10)
nonhc_net - varchar(9)
inc_tax - varchar(7)
ext_item - varchar(8)
net_income - varchar(10)
gr_rt_mcar - varchar(10)
gr_rt_mcal - varchar(10)
gr_rt_self - varchar(10)
gr_rt_oth - varchar(9)
gr_sn - varchar(8)
gr_ic - varchar(7)
gr_md - varchar(7)
gr_dd - varchar(7)
gr_subacu - varchar(9)
gr_subped - varchar(9)
gr_tic - varchar(7)
gr_hospic - varchar(9)
gr_oth_rt - varchar(9)
gr_an_mcar - varchar(10)
gr_an_mcal - varchar(10)
gr_an_self - varchar(10)
gr_an_oth - varchar(9)
gr_psupply - varchar(10)
gr_spsurf - varchar(9)
gr_pt - varchar(7)
gr_rt - varchar(7)
gr_ot - varchar(7)
gr_sp - varchar(7)
gr_pharm - varchar(8)
gr_lab - varchar(6)
gr_hmhlth - varchar(9)
gr_oth_an - varchar(9)
dfr_charit - varchar(10)
dfr_admin - varchar(9)
ca_mcare - varchar(8)
ca_mcal - varchar(8)
ca_other - varchar(8)
dfr_other - varchar(9)
exp_sal - varchar(7)
exp_ben - varchar(7)
exp_other - varchar(9)
work_comp - varchar(9)
exp_sn - varchar(7)
exp_ic - varchar(7)
exp_md - varchar(7)
exp_dd - varchar(7)
exp_subacu - varchar(10)
exp_subped - varchar(10)
exp_tic - varchar(7)
exp_hospic - varchar(10)
exp_oth_rt - varchar(10)
exp_psuppl - varchar(10)
exp_spsurf - varchar(10)
exp_pt - varchar(7)
exp_rt - varchar(6)
exp_ot - varchar(7)
exp_sp - varchar(6)
exp_pharm - varchar(9)
exp_lab - varchar(7)
exp_hmhlth - varchar(10)
exp_oth_an - varchar(10)
exp_pom - varchar(7)
exp_hkp - varchar(7)
exp_ll - varchar(6)
exp_diet - varchar(8)
exp_ss - varchar(6)
exp_actv - varchar(8)
exp_insv - varchar(8)
exp_admn - varchar(8)
exp_dprec - varchar(9)
exp_lease - varchar(9)
exp_prptax - varchar(10)
exp_prpins - varchar(10)
exp_intppe - varchar(10)
exp_intoth - varchar(10)
exp_bdebt - varchar(9)
cur_asst - varchar(8)
asst_limtd - varchar(10)
net_ppe - varchar(9)
const_prog - varchar(10)
inv_oth - varchar(8)
intan_asst - varchar(10)
tot_asst - varchar(9)
cur_liab - varchar(8)
def_cred - varchar(8)
net_ltdebt - varchar(10)
equity - varchar(9)
liab_eq - varchar(9)
rel_rec_cr - varchar(10)
rel_rec_lt - varchar(10)
rel_pay_cr - varchar(10)
rel_pay_lt - varchar(10)
landimp - varchar(8)
bldgsimp - varchar(9)
lease_imp - varchar(9)
equipment - varchar(9)
tot_ppe - varchar(9)
acc_deprec - varchar(10)
mort_pay - varchar(8)
cap_lease - varchar(9)
bond_pay - varchar(8)
tot_ltdebt - varchar(10)
cur_mat - varchar(8)
cur_ratio - varchar(9)
acid_ratio - varchar(10)
days_ar - varchar(7)
ltd_asst - varchar(8)
debt_cov - varchar(9)
op_margin - varchar(9)
net_rtn_eq - varchar(10)
trnovr_opr - varchar(10)
asst_equty - varchar(10)
ppe_bed - varchar(7)
prdhr_mgt - varchar(9)
prdhr_gnp - varchar(9)
prdhr_rn - varchar(8)
prdhr_lvn - varchar(9)
prdhr_na - varchar(8)
prdhr_tsp - varchar(9)
prdhr_psy - varchar(9)
prdhr_oth - varchar(9)
prdhr_an - varchar(8)
prdhr_pom - varchar(9)
prdhr_hkp - varchar(9)
prdhr_ll - varchar(8)
prdhr_diet - varchar(10)
prdhr_ss - varchar(8)
prdhr_actv - varchar(10)
prdhr_insv - varchar(10)
prdhr_admn - varchar(10)
prdhr_totl - varchar(10)
tmp_hr_gnp - varchar(10)
tmp_hr_rn - varchar(9)
tmp_hr_lvn - varchar(10)
tmp_hr_na - varchar(9)
tmp_hr_psy - varchar(10)
tmp_hr_oth - varchar(10)
tmp_hr_tot - varchar(10)
sw_mgt - varchar(7)
sw_gnp - varchar(7)
sw_rn - varchar(7)
sw_lvn - varchar(7)
sw_na - varchar(7)
sw_tsp - varchar(7)
sw_psy - varchar(7)
sw_oth - varchar(7)
sw_anc - varchar(7)
sw_pom - varchar(7)
sw_hkp - varchar(7)
sw_ll - varchar(6)
sw_diet - varchar(8)
sw_ss - varchar(6)
sw_actv - varchar(8)
sw_insv - varchar(8)
sw_admn - varchar(8)
sw_totl - varchar(8)
tmp_pd_gnp - varchar(10)
tmp_pd_rn - varchar(9)
tmp_pd_lvn - varchar(10)
tmp_pd_na - varchar(9)
tmp_pd_psy - varchar(10)
tmp_pd_oth - varchar(10)
tmp_pd_tot - varchar(10)
emp_avg - varchar(7)
emp_trnovr - varchar(10)
emp_cont - varchar(8)
1999_long_term_care_annual_financial_data     fac_no - varchar(9)
fac_name - varchar(40)
beg_date - varchar(8)
end_date - varchar(8)
day_per - varchar(7)
data_ind - varchar(10)
comparable - varchar(10)
county - varchar(6)
hsa - varchar(3)
hfpa - varchar(4)
lic_cat - varchar(7)
type_cntrl - varchar(14)
legal_org - varchar(14)
phone - varchar(13)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
mcal_pronum - varchar(9)
adminis - varchar(30)
related - varchar(7)
parent - varchar(40)
bed_end - varchar(7)
bed_avg - varchar(7)
day_totl - varchar(8)
occup - varchar(8)
admits - varchar(6)
dischs - varchar(6)
day_mcar - varchar(8)
day_mcal - varchar(8)
day_self - varchar(8)
day_oth - varchar(7)
day_sn - varchar(6)
day_ic - varchar(6)
day_md - varchar(6)
day_dd - varchar(6)
day_subacu - varchar(10)
day_subped - varchar(10)
day_tic - varchar(7)
day_hospic - varchar(10)
day_oth_rt - varchar(10)
gr_rt_totl - varchar(10)
gr_an_totl - varchar(10)
dfr_totl - varchar(8)
oth_op_rev - varchar(10)
tot_hc_rev - varchar(10)
tot_hc_exp - varchar(10)
net_frm_hc - varchar(10)
nonhc_net - varchar(9)
inc_tax - varchar(7)
ext_item - varchar(8)
net_income - varchar(10)
gr_rt_mcar - varchar(10)
gr_rt_mcal - varchar(10)
gr_rt_self - varchar(10)
gr_rt_oth - varchar(9)
gr_sn - varchar(8)
gr_ic - varchar(7)
gr_md - varchar(8)
gr_dd - varchar(7)
gr_subacu - varchar(9)
gr_subped - varchar(9)
gr_tic - varchar(6)
gr_hospic - varchar(9)
gr_oth_rt - varchar(9)
gr_an_mcar - varchar(10)
gr_an_mcal - varchar(10)
gr_an_self - varchar(10)
gr_an_oth - varchar(9)
gr_psupply - varchar(10)
gr_spsurf - varchar(9)
gr_pt - varchar(7)
gr_rt - varchar(7)
gr_ot - varchar(7)
gr_sp - varchar(7)
gr_pharm - varchar(8)
gr_lab - varchar(6)
gr_hmhlth - varchar(9)
gr_oth_an - varchar(9)
dfr_charit - varchar(10)
dfr_admin - varchar(9)
ca_mcare - varchar(8)
ca_mcal - varchar(7)
ca_other - varchar(8)
dfr_other - varchar(9)
exp_sal - varchar(7)
exp_ben - varchar(7)
exp_other - varchar(9)
work_comp - varchar(9)
exp_sn - varchar(7)
exp_ic - varchar(6)
exp_md - varchar(7)
exp_dd - varchar(7)
exp_subacu - varchar(10)
exp_subped - varchar(10)
exp_tic - varchar(7)
exp_hospic - varchar(10)
exp_oth_rt - varchar(10)
exp_psuppl - varchar(10)
exp_spsurf - varchar(10)
exp_pt - varchar(6)
exp_rt - varchar(6)
exp_ot - varchar(6)
exp_sp - varchar(6)
exp_pharm - varchar(9)
exp_lab - varchar(7)
exp_hmhlth - varchar(10)
exp_oth_an - varchar(10)
exp_pom - varchar(7)
exp_hkp - varchar(7)
exp_ll - varchar(6)
exp_diet - varchar(8)
exp_ss - varchar(6)
exp_actv - varchar(8)
exp_insv - varchar(8)
exp_admn - varchar(8)
exp_dprec - varchar(9)
exp_lease - varchar(9)
exp_prptax - varchar(10)
exp_prpins - varchar(10)
exp_intppe - varchar(10)
exp_intoth - varchar(10)
exp_bdebt - varchar(9)
cur_asst - varchar(8)
asst_limtd - varchar(10)
net_ppe - varchar(9)
const_prog - varchar(10)
inv_oth - varchar(8)
intan_asst - varchar(10)
tot_asst - varchar(9)
cur_liab - varchar(8)
def_cred - varchar(8)
net_ltdebt - varchar(10)
equity - varchar(9)
liab_eq - varchar(9)
rel_rec_cr - varchar(10)
rel_rec_lt - varchar(10)
rel_pay_cr - varchar(10)
rel_pay_lt - varchar(10)
landimp - varchar(8)
bldgsimp - varchar(9)
lease_imp - varchar(9)
equipment - varchar(9)
tot_ppe - varchar(9)
acc_deprec - varchar(10)
mort_pay - varchar(8)
cap_lease - varchar(9)
bond_pay - varchar(8)
tot_ltdebt - varchar(10)
cur_mat - varchar(8)
cur_ratio - varchar(9)
acid_ratio - varchar(10)
days_ar - varchar(7)
ltd_asst - varchar(8)
debt_cov - varchar(9)
op_margin - varchar(9)
net_rtn_eq - varchar(10)
trnovr_opr - varchar(10)
asst_equty - varchar(10)
ppe_bed - varchar(7)
prdhr_mgt - varchar(9)
prdhr_gnp - varchar(9)
prdhr_rn - varchar(8)
prdhr_lvn - varchar(9)
prdhr_na - varchar(8)
prdhr_tsp - varchar(9)
prdhr_psy - varchar(9)
prdhr_oth - varchar(9)
prdhr_an - varchar(8)
prdhr_pom - varchar(9)
prdhr_hkp - varchar(9)
prdhr_ll - varchar(8)
prdhr_diet - varchar(10)
prdhr_ss - varchar(8)
prdhr_actv - varchar(10)
prdhr_insv - varchar(10)
prdhr_admn - varchar(10)
prdhr_totl - varchar(10)
tmp_hr_gnp - varchar(10)
tmp_hr_rn - varchar(9)
tmp_hr_lvn - varchar(10)
tmp_hr_na - varchar(9)
tmp_hr_psy - varchar(10)
tmp_hr_oth - varchar(10)
tmp_hr_tot - varchar(10)
sw_mgt - varchar(7)
sw_gnp - varchar(7)
sw_rn - varchar(7)
sw_lvn - varchar(7)
sw_na - varchar(7)
sw_tsp - varchar(7)
sw_psy - varchar(7)
sw_oth - varchar(7)
sw_anc - varchar(7)
sw_pom - varchar(7)
sw_hkp - varchar(7)
sw_ll - varchar(6)
sw_diet - varchar(8)
sw_ss - varchar(6)
sw_actv - varchar(8)
sw_insv - varchar(8)
sw_admn - varchar(8)
sw_totl - varchar(8)
tmp_pd_gnp - varchar(10)
tmp_pd_rn - varchar(9)
tmp_pd_lvn - varchar(10)
tmp_pd_na - varchar(9)
tmp_pd_psy - varchar(10)
tmp_pd_oth - varchar(10)
tmp_pd_tot - varchar(10)
emp_avg - varchar(7)
emp_trnovr - varchar(10)
emp_cont - varchar(8)
2000_part_a_long_term_care_annual_financial_data     fac_no - varchar(9)
fac_name - varchar(40)
beg_date - varchar(8)
end_date - varchar(8)
day_per - varchar(7)
data_ind - varchar(8)
comparable - varchar(10)
county - varchar(6)
hsa - varchar(3)
hfpa - varchar(4)
lic_cat - varchar(7)
type_cntrl - varchar(14)
legal_org - varchar(14)
phone - varchar(13)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
mcal_pronum - varchar(9)
adminis - varchar(30)
related - varchar(7)
parent - varchar(40)
bed_end - varchar(7)
bed_avg - varchar(7)
day_totl - varchar(8)
occup - varchar(6)
admits - varchar(6)
dischs - varchar(6)
day_mcar - varchar(8)
day_mcal - varchar(8)
day_self - varchar(8)
day_oth - varchar(7)
day_sn - varchar(6)
day_ic - varchar(6)
day_md - varchar(6)
day_dd - varchar(6)
day_subacu - varchar(10)
day_subped - varchar(10)
day_tic - varchar(7)
day_hospic - varchar(10)
day_oth_rt - varchar(10)
gr_rt_totl - varchar(10)
gr_an_totl - varchar(10)
dfr_totl - varchar(8)
oth_op_rev - varchar(10)
tot_hc_rev - varchar(10)
tot_hc_exp - varchar(10)
net_frm_hc - varchar(10)
nonhc_net - varchar(9)
inc_tax - varchar(7)
ext_item - varchar(8)
net_income - varchar(10)
gr_rt_mcar - varchar(10)
gr_rt_mcal - varchar(10)
gr_rt_self - varchar(10)
gr_rt_oth - varchar(9)
gr_sn - varchar(8)
gr_ic - varchar(7)
gr_md - varchar(7)
gr_dd - varchar(7)
gr_subacu - varchar(9)
gr_subped - varchar(9)
gr_tic - varchar(6)
gr_hospic - varchar(9)
gr_oth_rt - varchar(9)
gr_an_mcar - varchar(10)
gr_an_mcal - varchar(10)
gr_an_self - varchar(10)
gr_an_oth - varchar(9)
gr_psupply - varchar(10)
gr_spsurf - varchar(9)
gr_pt - varchar(7)
gr_rt - varchar(7)
gr_ot - varchar(7)
gr_sp - varchar(6)
gr_pharm - varchar(8)
gr_lab - varchar(6)
gr_hmhlth - varchar(9)
gr_oth_an - varchar(9)
dfr_charit - varchar(10)
dfr_admin - varchar(9)
ca_mcare - varchar(8)
ca_mcal - varchar(7)
ca_other - varchar(8)
dfr_other - varchar(9)
exp_sal - varchar(7)
exp_ben - varchar(7)
exp_other - varchar(9)
work_comp - varchar(9)
exp_sn - varchar(7)
exp_ic - varchar(6)
exp_md - varchar(7)
exp_dd - varchar(7)
exp_subacu - varchar(10)
exp_subped - varchar(10)
exp_tic - varchar(7)
exp_hospic - varchar(10)
exp_oth_rt - varchar(10)
exp_psuppl - varchar(10)
exp_spsurf - varchar(10)
exp_pt - varchar(7)
exp_rt - varchar(7)
exp_ot - varchar(6)
exp_sp - varchar(6)
exp_pharm - varchar(9)
exp_lab - varchar(7)
exp_hmhlth - varchar(10)
exp_oth_an - varchar(10)
exp_pom - varchar(7)
exp_hkp - varchar(7)
exp_ll - varchar(6)
exp_diet - varchar(8)
exp_ss - varchar(6)
exp_actv - varchar(8)
exp_insv - varchar(8)
exp_admn - varchar(8)
exp_dprec - varchar(9)
exp_lease - varchar(9)
exp_prptax - varchar(10)
exp_prpins - varchar(10)
exp_intppe - varchar(10)
exp_intoth - varchar(10)
exp_bdebt - varchar(9)
cur_asst - varchar(8)
asst_limtd - varchar(10)
net_ppe - varchar(9)
const_prog - varchar(10)
inv_oth - varchar(8)
intan_asst - varchar(10)
tot_asst - varchar(9)
cur_liab - varchar(8)
def_cred - varchar(8)
net_ltdebt - varchar(10)
equity - varchar(9)
liab_eq - varchar(9)
rel_rec_cr - varchar(10)
rel_rec_lt - varchar(10)
rel_pay_cr - varchar(10)
rel_pay_lt - varchar(10)
landimp - varchar(8)
bldgsimp - varchar(9)
lease_imp - varchar(9)
equipment - varchar(9)
tot_ppe - varchar(9)
acc_deprec - varchar(10)
mort_pay - varchar(8)
cap_lease - varchar(9)
bond_pay - varchar(8)
tot_ltdebt - varchar(10)
cur_mat - varchar(8)
cur_ratio - varchar(9)
acid_ratio - varchar(10)
days_ar - varchar(7)
ltd_asst - varchar(8)
debt_cov - varchar(9)
op_margin - varchar(9)
net_rtn_eq - varchar(10)
trnovr_opr - varchar(10)
asst_equty - varchar(10)
ppe_bed - varchar(7)
prdhr_mgt - varchar(9)
prdhr_gnp - varchar(9)
prdhr_rn - varchar(8)
prdhr_lvn - varchar(9)
prdhr_na - varchar(8)
prdhr_tsp - varchar(9)
prdhr_psy - varchar(9)
prdhr_oth - varchar(9)
prdhr_an - varchar(8)
prdhr_pom - varchar(9)
prdhr_hkp - varchar(9)
prdhr_ll - varchar(8)
prdhr_diet - varchar(10)
prdhr_ss - varchar(8)
prdhr_actv - varchar(10)
prdhr_insv - varchar(10)
prdhr_admn - varchar(10)
prdhr_totl - varchar(10)
tmp_hr_gnp - varchar(10)
tmp_hr_rn - varchar(9)
tmp_hr_lvn - varchar(10)
tmp_hr_na - varchar(9)
tmp_hr_psy - varchar(10)
tmp_hr_oth - varchar(10)
tmp_hr_tot - varchar(10)
sw_mgt - varchar(7)
sw_gnp - varchar(7)
sw_rn - varchar(7)
sw_lvn - varchar(7)
sw_na - varchar(7)
sw_tsp - varchar(7)
sw_psy - varchar(7)
sw_oth - varchar(7)
sw_anc - varchar(7)
sw_pom - varchar(7)
sw_hkp - varchar(7)
sw_ll - varchar(6)
sw_diet - varchar(8)
sw_ss - varchar(6)
sw_actv - varchar(8)
sw_insv - varchar(8)
sw_admn - varchar(8)
sw_totl - varchar(8)
tmp_pd_gnp - varchar(10)
tmp_pd_rn - varchar(9)
tmp_pd_lvn - varchar(10)
tmp_pd_na - varchar(9)
tmp_pd_psy - varchar(10)
tmp_pd_oth - varchar(10)
tmp_pd_tot - varchar(10)
emp_avg - varchar(7)
emp_trnovr - varchar(10)
emp_cont - varchar(8)
2000_part_b_long_term_care_annual_financial_data     fac_no - varchar(9)
fac_name - varchar(40)
beg_date - varchar(8)
end_date - varchar(8)
day_per - varchar(7)
data_ind - varchar(10)
comparable - varchar(10)
county - varchar(15)
hsa - varchar(3)
hfpa - varchar(4)
lic_cat - varchar(7)
type_cntrl - varchar(14)
legal_org - varchar(14)
phone - varchar(13)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
mcal_pronum - varchar(9)
adminis - varchar(28)
related - varchar(7)
parent - varchar(40)
bed_end - varchar(7)
bed_avg - varchar(7)
day_totl - varchar(8)
occup - varchar(6)
admits - varchar(6)
dischs - varchar(6)
day_mcar - varchar(8)
day_mcal - varchar(8)
day_self - varchar(8)
day_mgd - varchar(7)
day_oth - varchar(7)
day_sn - varchar(6)
day_ic - varchar(6)
day_md - varchar(6)
day_dd - varchar(6)
day_subacu - varchar(10)
day_subped - varchar(10)
day_tic - varchar(7)
day_hospic - varchar(10)
day_oth_rt - varchar(10)
gr_rt_totl - varchar(10)
gr_an_totl - varchar(10)
dfr_totl - varchar(8)
oth_op_rev - varchar(10)
tot_hc_rev - varchar(10)
tot_hc_exp - varchar(10)
net_frm_hc - varchar(10)
nonhc_net - varchar(9)
inc_tax - varchar(7)
ext_item - varchar(8)
net_income - varchar(10)
gr_rt_mcar - varchar(10)
gr_rt_mcal - varchar(10)
gr_rt_self - varchar(10)
gr_rt_mgd - varchar(9)
gr_rt_oth - varchar(9)
gr_sn - varchar(8)
gr_ic - varchar(7)
gr_md - varchar(8)
gr_dd - varchar(7)
gr_subacu - varchar(9)
gr_subped - varchar(9)
gr_tic - varchar(6)
gr_hospic - varchar(9)
gr_oth_rt - varchar(9)
gr_an_mcar_ip - varchar(13)
gr_an_mcar_op - varchar(13)
gr_an_mcal_ip - varchar(13)
gr_an_mcal_op - varchar(13)
gr_an_self_ip - varchar(13)
gr_an_self_op - varchar(13)
gr_an_mgd_ip - varchar(12)
gr_an_mgd_op - varchar(12)
gr_an_oth_ip - varchar(12)
gr_an_oth_op - varchar(12)
gr_psupply - varchar(10)
gr_spsurf - varchar(9)
gr_pt - varchar(7)
gr_rt - varchar(7)
gr_ot - varchar(7)
gr_sp - varchar(7)
gr_pharm - varchar(8)
gr_lab - varchar(7)
gr_hmhlth - varchar(9)
gr_oth_an - varchar(9)
dfr_charit - varchar(10)
dfr_admin - varchar(9)
ca_mcare - varchar(8)
ca_mcal - varchar(8)
ca_mgd - varchar(8)
ca_other - varchar(8)
dfr_other - varchar(9)
exp_sal - varchar(7)
exp_ben - varchar(7)
exp_other - varchar(9)
work_comp - varchar(9)
exp_sn - varchar(7)
exp_ic - varchar(6)
exp_md - varchar(7)
exp_dd - varchar(7)
exp_subacu - varchar(10)
exp_subped - varchar(10)
exp_tic - varchar(7)
exp_hospic - varchar(10)
exp_oth_rt - varchar(10)
exp_psuppl - varchar(10)
exp_spsurf - varchar(10)
exp_pt - varchar(6)
exp_rt - varchar(6)
exp_ot - varchar(6)
exp_sp - varchar(6)
exp_pharm - varchar(9)
exp_lab - varchar(7)
exp_hmhlth - varchar(10)
exp_oth_an - varchar(10)
exp_pom - varchar(7)
exp_hkp - varchar(7)
exp_ll - varchar(6)
exp_diet - varchar(8)
exp_ss - varchar(6)
exp_actv - varchar(8)
exp_insv - varchar(8)
exp_admn - varchar(8)
exp_dprec - varchar(9)
exp_lease - varchar(9)
exp_prptax - varchar(10)
exp_prpins - varchar(10)
exp_intppe - varchar(10)
exp_intoth - varchar(10)
exp_bdebt - varchar(9)
cur_asst - varchar(8)
asst_limtd - varchar(10)
net_ppe - varchar(8)
const_prog - varchar(10)
inv_oth - varchar(8)
intan_asst - varchar(10)
tot_asst - varchar(8)
cur_liab - varchar(8)
def_cred - varchar(8)
net_ltdebt - varchar(10)
equity - varchar(9)
liab_eq - varchar(8)
rel_rec_cr - varchar(10)
rel_rec_lt - varchar(10)
rel_pay_cr - varchar(10)
rel_pay_lt - varchar(10)
landimp - varchar(8)
bldgsimp - varchar(9)
lease_imp - varchar(9)
equipment - varchar(9)
tot_ppe - varchar(8)
acc_deprec - varchar(10)
mort_pay - varchar(8)
cap_lease - varchar(9)
bond_pay - varchar(8)
tot_ltdebt - varchar(10)
cur_mat - varchar(8)
cur_ratio - varchar(9)
acid_ratio - varchar(10)
days_ar - varchar(7)
ltd_asst - varchar(8)
debt_cov - varchar(8)
op_margin - varchar(9)
net_rtn_eq - varchar(10)
trnovr_opr - varchar(10)
asst_equty - varchar(10)
ppe_bed - varchar(7)
prdhr_mgt - varchar(9)
prdhr_gnp - varchar(9)
prdhr_rn - varchar(8)
prdhr_lvn - varchar(9)
prdhr_na - varchar(8)
prdhr_tsp - varchar(9)
prdhr_psy - varchar(9)
prdhr_oth - varchar(9)
prdhr_an - varchar(8)
prdhr_pom - varchar(9)
prdhr_hkp - varchar(9)
prdhr_ll - varchar(8)
prdhr_diet - varchar(10)
prdhr_ss - varchar(8)
prdhr_actv - varchar(10)
prdhr_insv - varchar(10)
prdhr_admn - varchar(10)
prdhr_totl - varchar(10)
tmp_hr_gnp - varchar(10)
tmp_hr_rn - varchar(9)
tmp_hr_lvn - varchar(10)
tmp_hr_na - varchar(9)
tmp_hr_psy - varchar(10)
tmp_hr_oth - varchar(10)
tmp_hr_tot - varchar(10)
sw_mgt - varchar(7)
sw_gnp - varchar(7)
sw_rn - varchar(7)
sw_lvn - varchar(7)
sw_na - varchar(7)
sw_tsp - varchar(7)
sw_psy - varchar(7)
sw_oth - varchar(7)
sw_anc - varchar(7)
sw_pom - varchar(7)
sw_hkp - varchar(7)
sw_ll - varchar(6)
sw_diet - varchar(8)
sw_ss - varchar(6)
sw_actv - varchar(8)
sw_insv - varchar(8)
sw_admn - varchar(8)
sw_totl - varchar(8)
tmp_pd_gnp - varchar(10)
tmp_pd_rn - varchar(9)
tmp_pd_lvn - varchar(10)
tmp_pd_na - varchar(9)
tmp_pd_psy - varchar(10)
tmp_pd_oth - varchar(10)
tmp_pd_tot - varchar(10)
emp_avg - varchar(7)
emp_trnovr - varchar(10)
emp_cont - varchar(8)
2011_long_term_care_annual_financial_data_october_2014_extract    
2011_pivot_table_long_term_care_annual_financial_data    
Sources
1997-part-a-documentation-long-term-care-annual-financial-data.pdf  -   
1997-part-b-documentation-long-term-care-annual-financial-data.pdf  -   
1998-documentation-long-term-care-annual-financial-data.pdf  -   
1999-documentation-long-term-care-annual-financial-data.pdf  -   
2000-documentation-part-a-long-term-care-annual-financial-data.pdf  -   
2000-documentation-part-b-long-term-care-annual-financial-data.pdf  -   
2000-pivot-table-long-term-care-annual-financial-data.xls  -   
2001-documentation-long-term-care-annual-financial-data.pdf  -   
2001-long-term-care-annual-financial-data.xls  -   
2001-pivot-table-long-term-care-annual-financial-data.xls  -   
2002-documentation-long-term-care-annual-financial-data.pdf  -   
2002-long-term-care-annual-financial-data.xls  -   
2002-pivot-table-long-term-care-annual-financial-data.xls  -   
2003-documentation-long-term-care-annual-financial-data.pdf  -   
2003-long-term-care-annual-financial-data.xls  -   
2003-pivot-table-long-term-care-annual-financial-data.xls  -   
2004-documentation-long-term-care-annual-financial-data.pdf  -   
2004-long-term-care-annual-financial-data.xls  -   
2004-pivot-table-long-term-care-annual-financial-data.xls  -   
2005-documentation-long-term-care-annual-financial-data.pdf  -   
2005-long-term-care-annual-financial-data.xls  -   
2005-pivot-table-long-term-care-annual-financial-data.xls  -   
2006-documentation-long-term-care-annual-financial-data.pdf  -   
2006-long-term-care-annual-financial-data.xls  -   
2006-pivot-table-long-term-care-annual-financial-data.xls  -   
2007-documentation-long-term-care-annual-financial-data.pdf  -   
2007-long-term-care-annual-financial-data-revised-october-2011.xls  -   
2007-pivot-table-long-term-care-annual-financial-data.xls  -   
2008-documentation-long-term-care-annual-financial-data.pdf  -   
2008-long-term-care-annual-financial-data-revised-october-2011.xls  -   
2008-pivot-table-long-term-care-annual-financial-data.xls  -   
2009-documentation-long-term-care-annual-financial-data.pdf  -   
2009-long-term-care-annual-financial-data-revised-october-2012.xls  -   
2009-pivot-table-long-term-care-annual-financial-data.xls  -   
2010-documentation-long-term-care-annual-financial-data.pdf  -   
2010-long-term-care-annual-financial-data.xls  -   
2010-pivot-table-long-term-care-annual-financial-data.xls  -   
2011-documentation-long-term-care-annual-financial-data.pdf  -   
post-2011-long-term-care-facility-integrated-disclosure-and-medi-cal-cost-report-data-pivot-tables.html  -   
2000-part-a-long-term-care-annual-financial-data.txt  -   
2000-part-b-long-term-care-annual-financial-data.txt  -   
1999-long-term-care-annual-financial-data.txt  -   
1998-long-term-care-annual-financial-data.txt  -   
1997-part-a-long-term-care-annual-financial-data.txt  -   
1997-part-b-long-term-care-annual-financial-data.txt  -   
datapackage.json  -   
1997-part-a-long-term-care-annual-financial-data.csv  -  Table: 1997_part_a_long_term_care_annual_financial_data   Fails: 13
1997-part-b-long-term-care-annual-financial-data.csv  -  Table: 1997_part_b_long_term_care_annual_financial_data   Fails: 13
1998-long-term-care-annual-financial-data.csv  -  Table: 1998_long_term_care_annual_financial_data   Fails: 13
1999-long-term-care-annual-financial-data.csv  -  Table: 1999_long_term_care_annual_financial_data   Fails: 13
2000-part-a-long-term-care-annual-financial-data.csv  -  Table: 2000_part_a_long_term_care_annual_financial_data   Fails: 13
2000-part-b-long-term-care-annual-financial-data.csv  -  Table: 2000_part_b_long_term_care_annual_financial_data   Fails: 13
2011-long-term-care-annual-financial-data-october-2014-extract.xlsx  -  Table: 2011_long_term_care_annual_financial_data_october_2014_extract   Updated: 2025-10-11
2011-pivot-table-long-term-care-annual-financial-data.xlsx  -  Table: 2011_pivot_table_long_term_care_annual_financial_data   Updated: 2025-10-11
Updated