Long-term Care Facility Integrated Disclosure and Medi-Cal Cost Report Data & Pivot Tables

Description

On an annual basis (based on individual Long-Term Care (LTC) facility fiscal year end), California licensed LTC facilities report detailed financial data on facility information, ownership information, patient days & discharges, Balance Sheet, Equity Statement, Cash Flows, Income Statement, Revenue by type and payer, Expense Detail, and Labor Detail. Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data items such as Patient Days, Revenue & Expense, and Revenue.

Resources

Name Format Description Link
Data Dictionary - 2024-current Full Page-Column-Line to Excel Crosswalk – Long-Term Care Annual Financial CSV Data Dictionary for https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/432e7056-c8d6-44b7-83af-2d0de350febf/download/ltc-adr-pcl-labels_2024.xlsx Open resource
Data Dictionary - 2019 Selected File - Long-Term Care Annual Financial Data - (August 2024) CSV Data Dictionary for https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/9f1e4a28-37d7-419e-b304-24c6b79238d6/download/rev-lafd-2019-aud-final-for-odp.xlsx Open resource
Data Dictionary - 2021 Selected File (Audited) - Long-Term Care Annual Financial Data (June 2025 Extract) CSV Data Dictionary for https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/57dbea9a-b916-4964-b715-3fff8d9677af/download/lafd2021_audited_final_for_odp.xlsx Open resource
Data Dictionary - 2013 Selected File - Long-Term Care Annual Financial Data CSV Data Dictionary for https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/66175fdc-02e5-4861-a84e-7eeae8a164a0/download/ltccalendaryear2013selected.xlsx Open resource
Data Dictionary - 2016 Selected File - Long-Term Care Annual Financial Data - (October 2019 Extract) CSV Data Dictionary for https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/6d768f90-6288-49ce-9fbd-1a318dae484c/download/lafd1216_aud_rev_finalselected-file.xlsx Open resource
Data Dictionary - 2020-2023 Full Page-Column-Line to Excel Crosswalk - Long-Term Care Financial Annual CSV Data Dictionary for https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/46c9e973-b549-45c1-b61e-977fc84a68e5/download/ltc-adr-pcl-labels_2020.xlsx Open resource
2018 - 2022 Trends - Pivot Table - Long-Term Care Annual Financial Data XLS ltc-financial-trend-pivot-18-22.xls Open resource
2019 - 2023 Trends - Pivot Table - Long-Term Care Annual Financial Data (September 2024 Extract) XLS ltc-financial-trend-pivot-19-23.xls Open resource
2001-2019 Full Page-Column-Line to Excel Crosswalk - Long-Term Care Financial Annual XLS ltc-adr-pcl-labels_2018.xlsx Open resource
2018 Selected File - Long-Term Care Annual Financial Data - (March 2022 Extract) XLS lafd_2018_audited.xlsx Open resource
2020 Complete Data Set (Audited) - Long-Term Care Annual Financial Data - Extracted 8/24/24 XLS ltc-complete-data-2020-audited.xlsx Open resource
2020 Complete Data Set (As Submitted)- Long-Term Care Annual Financial Data (January 2022 Extract) XLS ltc-complete-data-2020-sub-revised-jan22.xlsx Open resource
2017 - Pivot Profile - Long-Term Care Annual Financial Data (Revised July 2020) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2015 Selected File - Long-Term Care Annual Financial Data - (October 2017 Extract) XLS ltccalendaryear2015selected.xlsx Open resource
2024-current Documentation – Selected Data Set – Long-Term Care Annual Financial PDF data_file_documentation_selected_20242.pdf Open resource
All resource data ZIP long-term-care-facility-disclosure-report-data-w_8hzwt1.zip Open resource
2017 Selected File - Long-Term Care Annual Financial Data - (Revised July 2020) XLS lafd-1217-revised-2020_final_odp.xlsx Open resource
2022 Pivot Profile (As Submitted) - Long-Term Care Annual Financial Data (October 2023 Extract) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2012 Selected File - Long-Term Care Annual Financial Data - (October 2014 Extract) XLS lafd1212selectedrevisedoct2014.xlsx Open resource
2021 Complete Data Set (Audited) - Long-Term Care Annual Financial Data (June 2025 Extract) XLS ltc-complete-data-2021-audited-june-2025.xlsx Open resource
2021 Complete Data Set (As Submitted) - Long-Term Care Annual Financial Data (October 2022 Extract) XLS ltc-complete-data-2021-submitted-final.xlsx Open resource
2024-current Full Page-Column-Line to Excel Crosswalk – Long-Term Care Annual Financial XLS ltc-adr-pcl-labels_2024.xlsx Open resource
2020-2023 Full Page-Column-Line to Excel Crosswalk - Long-Term Care Financial Annual XLS ltc-adr-pcl-labels_2020.xlsx Open resource
2023 Complete Data Set (As Submitted) - Long-Term Care Annual Financial Data (September 2024 Extract) XLS ltc-complete-data-2023-submitted.xlsx Open resource
2020 - Pivot Profile (Audited Data) - Long-Term Care Annual Financial Data (July 2024) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2020 - Pivot Profile (As Submitted) - Long-Term Care Annual Financial Data (January 2022) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2020-2023 Documentation - Complete Data Set - Long-Term Care Annual Financial PDF 2020-current-ltc-complete-datafile-documentation.pdf Open resource
2015 Complete Data Set - Long-Term Care Annual Financial Data XLS ltc-financial-data-2015-complete-data-set.xlsx Open resource
2021 Selected File (As Submitted) - Long-Term Care Annual Financial Data (September 2022 Extract) XLS lafd-1221-submitted.xlsx Open resource
2021 Selected File (Audited) - Long-Term Care Annual Financial Data (June 2025 Extract) XLS lafd2021_audited_final_for_odp.xlsx Open resource
2020-2023 Documentation - Selected Data - Long-term Care Facility Annual Financial PDF lafd12current.pdf Open resource
2015 – Pivot Profile - Long-Term Care Annual Financial (October 2017) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2017 Complete Data Set (Audited)- Long-Term Care Annual Financial Data (May 2021 Extract) XLS ltc-complete-data-2017-audited.xlsx Open resource
2013 Selected File - Long-Term Care Annual Financial Data XLS ltccalendaryear2013selected.xlsx Open resource
2014 Complete Data Set - Long-Term Care Annual Financial Data XLS ltc-financial-data-2014-complete-data-set.xlsx Open resource
2016 Selected File - Long-Term Care Annual Financial Data - (October 2019 Extract) XLS lafd1216_aud_rev_finalselected-file.xlsx Open resource
All resource data ZIP long-term-care-facility-disclosure-report-data-14oo2f.zip Open resource
2023 Selected File (As Submitted) - Long-Term Care Annual Financial Data (September 2024 Extract) XLS lafd-2023-sub-for-odp.xlsx Open resource
2021 Pivot Profile (Audited) - Long-Term Care Annual Financial Data (June 2025 Extract) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2021 Pivot Profile (As Submitted) - Long-Term Care Annual Financial Data (September 2022 Extract) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2016 Complete Data Set (Audited)- Long-Term Care Annual Financial Data (May 2021 Extract) XLS ltc-complete-data-2016-audited.xlsx Open resource
2013 - Pivot Profile - Long-Term Care Annual Financial Data XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2018 - Pivot Profile - Long-Term Care Annual Financial Data (March 2022 Extract) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2023 Pivot Profile (As Submitted) - Long-Term Care Annual Financial Data (September 2024 Extract) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2001-2019 Documentation - Complete Data Set - Long-Term Care Annual Financial PDF 2001-2019-ltc-complete-datafile-documentation.pdf Open resource
2019 - Pivot Profile - Long-Term Care Annual Financial Data (August 2024) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2019 - Pivot Profile - Long-Term Care Annual Financial Data (January 2022) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2019 Selected File - Long-Term Care Annual Financial Data - (December 2020) XLS lafd-1219-aud-selected.xlsx Open resource
2019 Selected File - Long-Term Care Annual Financial Data - (August 2024) XLS rev-lafd-2019-aud-final-for-odp.xlsx Open resource
2018 Complete Data Set (Audited) - Long-Term Care Annual Financial Data (April 2022 Extract) XLS ltc-complete-data-2018-audited_april-2022.xlsx Open resource
All resource data ZIP long-term-care-facility-disclosure-report-data-22u4yta6.zip Open resource
2014 - Pivot Profile - Long-Term Care Annual Financial Data (October 2017 Extract) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2014 Selected File - Long-Term Care Annual Financial Data - (October 2017 Extract) XLS ltccalendaryear2014selected.xlsx Open resource
All resource data ZIP long-term-care-facility-disclosure-report-data-uv99w0_m.zip Open resource
2022 Selected File (As Submitted) - Long-Term Care Annual Financial Data (October 2023 Extract) XLS lafd-1222-sub-selected.xlsx Open resource
2020 Selected File (Audited Data) - Long-Term Care Annual Financial Data - (July 2024) XLS lafd1220-aud-final-to-post.xlsx Open resource
2020 Selected File (As Submitted) - Long-Term Care Annual Financial Data - (November 2021) XLS lafd-1220-sub-selected.xlsx Open resource
2019 Complete Data Set (Audited) - Long-Term Care Annual Financial Data - Extracted 1/13/25 XLS ltc-complete-data-2019-audited-extracted-011325.xlsx Open resource
2019 Complete Data Set (As Submitted)- Long-Term Care Annual Financial Data (December 2020 Extract) XLS ltc-complete-data-2019-submitted-extracted-dec-2020.xlsx Open resource
2024-current Documentation – Complete Data Set – Long-Term Care Annual Financial PDF ltc-adr_excel-full-db-documentation-2024-.pdf Open resource
2016 - Pivot Profile - Long-Term Care Annual Financial Data (October 2019) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2012 - Pivot Profile - Long-Term Care Annual Financial Data(December 2014 Extract) XLS Based on the selected data set, the pivot tables display summarized data on a Profile page and also provides charts on various data such as Patient Days, Revenue & Expense, and Revenue. Open resource
2022 Complete Data Set (As Submitted) - Long-Term Care Annual Financial Data (October 2023 Extract) XLS ltc-complete-data-2022-submitted-2nd-extract.xlsx Open resource
Pre-2012 Long-term Care Facility Integrated Disclosure and Medi-Cal Cost Report Data & Pivot Tables HTML Open resource
Accounting and Reporting Manual for California Long-Term Care Facilities HTML Open resource
Individual Facility Report Search (SIERA) HTML Financial Disclosure Report site, where you can view and save detailed financial disclosure reports submitted by California's 450 hospitals and 1,200 long-term care facilities. Open resource

Tags

Topics

Categories