Long-term Care Facility Integrated Disclosure and Medi-Cal Cost Report Data & Pivot Tables
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.
Data files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
All resource data | Download | ZIP | 08/11/23 |
Supporting files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
Individual Facility Report Search (SIERA) 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. | DATA | 08/11/23 | |
Accounting and Reporting Manual for California Long-Term Care Facilities | DATA | 08/11/23 | |
2020-Current Full Page-Column-Line to Excel Crosswalk - Long-Term Care Financial Annual | XLSX | 08/11/23 | |
2001-2019 Full Page-Column-Line to Excel Crosswalk - Long-Term Care Financial Annual | XLSX | 08/11/23 | |
2020-Current Documentation - Complete Data Set - Long-Term Care Annual Financial | PDF | 08/11/23 | |
2001-2019 Documentation - Complete Data Set - Long-Term Care Annual Financial | PDF | 08/11/23 | |
Documentation - Selected Data - Long-term Care Facility Annual Financial | PDF | 08/11/23 | |
2019 - 2023 Trends - Pivot Table - Long-Term Care Annual Financial Data (September 2024 Extract) | XLS | 09/25/24 | |
2023 Complete Data Set (As Submitted) - Long-Term Care Annual Financial Data (September 2024 Extract) | XLSX | 09/17/24 | |
2023 Selected File (As Submitted) - Long-Term Care Annual Financial Data (September 2024 Extract) | XLSX | 09/17/24 | |
2023 Pivot Profile (As Submitted) - Long-Term Care Annual Financial Data (September 2024 Extract) 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. | XLS | 09/17/24 | |
2022 Complete Data Set (As Submitted) - Long-Term Care Annual Financial Data (October 2023 Extract) | XLSX | 11/03/23 | |
2022 Selected File (As Submitted) - Long-Term Care Annual Financial Data (October 2023 Extract) | XLSX | 10/23/23 | |
2022 Pivot Profile (As Submitted) - Long-Term Care Annual Financial Data (October 2023 Extract) 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. | XLS | 10/23/23 | |
2021 Complete Data Set (As Submitted) - Long-Term Care Annual Financial Data (October 2022 Extract) | XLSX | 08/11/23 | |
2021 Selected File (As Submitted) - Long-Term Care Annual Financial Data (September 2022 Extract) | XLSX | 08/11/23 | |
2021 Pivot Profile (As Submitted) - Long-Term Care Annual Financial Data (September 2022 Extract) 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. | XLS | 08/11/23 | |
2020 Complete Data Set (As Submitted)- Long-Term Care Annual Financial Data (January 2022 Extract) | XLSX | 08/11/23 | |
2020 Selected File (Audited Data) - Long-Term Care Annual Financial Data - (July 2024) | XLSX | 07/20/24 | |
2020 - Pivot Profile (Audited Data) - Long-Term Care Annual Financial Data (July 2024) 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. | XLS | 07/20/24 | |
2019 Complete Data Set (As Submitted)- Long-Term Care Annual Financial Data (December 2020 Extract) | XLSX | 08/11/23 | |
2019 Selected File - Long-Term Care Annual Financial Data - (August 2024) | XLSX | 08/30/24 | |
2019 - Pivot Profile - Long-Term Care Annual Financial Data (August 2024) 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. | XLS | 08/30/24 | |
2018 Complete Data Set - Long-Term Care Annual Financial Data (April 2022 Extract) | XLSX | 08/11/23 | |
2018 Selected File - Long-Term Care Annual Financial Data - (March 2022 Extract) | XLSX | 08/11/23 | |
2018 - Pivot Profile - Long-Term Care Annual Financial Data (March 2022 Extract) 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. | XLS | 08/11/23 | |
2017 Complete Data Set (Audited)- Long-Term Care Annual Financial Data (May 2021 Extract) | XLSX | 08/11/23 | |
2017 Selected File - Long-Term Care Annual Financial Data - (Revised July 2020) | XLSX | 08/11/23 | |
2017 - Pivot Profile - Long-Term Care Annual Financial Data (Revised July 2020) 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. | XLS | 08/11/23 | |
2016 Complete Data Set (Audited)- Long-Term Care Annual Financial Data (May 2021 Extract) | XLSX | 08/11/23 | |
2016 Selected File - Long-Term Care Annual Financial Data - (October 2019 Extract) | XLSX | 08/11/23 | |
2016 - Pivot Profile - Long-Term Care Annual Financial Data (October 2019) 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. | XLS | 08/11/23 | |
2015 Complete Data Set - Long-Term Care Annual Financial Data | XLSX | 08/11/23 | |
2015 Selected File - Long-Term Care Annual Financial Data - (October 2017 Extract) | XLSX | 08/11/23 | |
2015 – Pivot Profile - Long-Term Care Annual Financial (October 2017) 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. | XLS | 08/11/23 | |
2014 Complete Data Set - Long-Term Care Annual Financial Data | XLSX | 08/11/23 | |
2014 Selected File - Long-Term Care Annual Financial Data - (October 2017 Extract) | XLSX | 08/11/23 | |
2014 - Pivot Profile - Long-Term Care Annual Financial Data (October 2017 Extract) 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. | XLS | 08/11/23 | |
2013 Selected File - Long-Term Care Annual Financial Data | XLSX | 08/11/23 | |
2013 - Pivot Profile - Long-Term Care Annual Financial Data 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. | XLS | 08/11/23 | |
2012 Selected File - Long-Term Care Annual Financial Data - (October 2014 Extract) | XLSX | 08/11/23 | |
2012 - Pivot Profile - Long-Term Care Annual Financial Data(December 2014 Extract) 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. | XLS | 08/11/23 | |
Pre-2012 Long-term Care Facility Integrated Disclosure and Medi-Cal Cost Report Data & Pivot Tables | HTML | 08/11/23 |