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
33 2001-2019-ltc-complete-datafile-documentation.pdf https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/857957ed-9059-4033-98e6-0e8d47d6fe50/download/2001-2019-ltc-complete-datafile-documentation.pdf
53 lafd-1222-sub-selected.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/b8e56328-c555-48db-a181-25d1035509a5/download/lafd-1222-sub-selected.xlsx
53 lafd-1221-submitted.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/57dbea9a-b916-4964-b715-3fff8d9677af/download/lafd-1221-submitted.xlsx
53 ltc-complete-data-2020-sub-revised-jan22.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/11ae3e83-775c-4fc1-9ef3-b6d405bc2b15/download/ltc-complete-data-2020-sub-revised-jan22.xlsx
53 ltc-complete-data-2019-submitted-extracted-dec-2020.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/dcea9837-2722-40f2-8281-9aa866b0a0bb/download/ltc-complete-data-2019-submitted-extracted-dec-2020.xlsx
53 lafd1216_aud_rev_finalselected-file.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/6d768f90-6288-49ce-9fbd-1a318dae484c/download/lafd1216_aud_rev_finalselected-file.xlsx
53 ltc-financial-data-2015-complete-data-set.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/531dd786-8163-4c53-8766-4f9d52f47dee/download/ltc-financial-data-2015-complete-data-set.xlsx
53 ltc-financial-data-2014-complete-data-set.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/69c9794c-7ef3-4fe7-91f5-c1ab3d30958d/download/ltc-financial-data-2014-complete-data-set.xlsx
53 ltccalendaryear2013selected.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/66175fdc-02e5-4861-a84e-7eeae8a164a0/download/ltccalendaryear2013selected.xlsx
57 long-term-care-facility-disclosure-report-data-14oo2f.zip https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/74aa90d5-5b2e-4572-83ba-9c5b03af04a6/download/long-term-care-facility-disclosure-report-data-14oo2f.zip
33 lafd12current.pdf https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/5d8c2a00-88b4-43cb-8f16-b4a72e35212c/download/lafd12current.pdf
53 ltc-financial-trend-pivot-18-22.xls https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/023998f6-5da3-413c-bd4e-3fe16a468a6c/download/ltc-financial-trend-pivot-18-22.xls
53 ltc-complete-data-2017-audited.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/6281e8f3-8d5f-4264-b462-814289f9442e/download/ltc-complete-data-2017-audited.xlsx
53 lafd1212selectedrevisedoct2014.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/3f2edfd2-f845-4d65-ad38-3ea3f22f17d1/download/lafd1212selectedrevisedoct2014.xlsx
53 lafd-1219-aud-selected.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/9f1e4a28-37d7-419e-b304-24c6b79238d6/download/lafd-1219-aud-selected.xlsx
21 https://data.chhs.ca.gov/dataset/pre-2012-long-term-care-facility-integrated-disclosure-and-medi-cal-cost-report-data-pivot-tables
53 ltc-adr-pcl-labels_2018.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/03d208f4-4136-4331-9a20-9546f6206c87/download/ltc-adr-pcl-labels_2018.xlsx
33 2020-current-ltc-complete-datafile-documentation.pdf https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/526212ea-0648-4ed4-bfdd-2850e4fc537a/download/2020-current-ltc-complete-datafile-documentation.pdf
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/e0edc093-d152-4b92-8ad6-d7e3c8c313b5/download/ltc-financial-pivot-2016_revised2019.xls
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/ee127633-ca49-415a-b61b-da6834c79b98/download/ltcfinancialpivot2012-122014-extract.xls
53 ltc-complete-data-2022-submitted-2nd-extract.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/ef096e20-5182-45dd-9e43-19e1da19daa2/download/ltc-complete-data-2022-submitted-2nd-extract.xlsx
53 lafd-1217-revised-2020_final_odp.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/36611790-dd00-4cbf-879b-eaabc2e5d0cd/download/lafd-1217-revised-2020_final_odp.xlsx
53 ltc-complete-data-2016-audited.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/7c23f34f-af3b-4b2a-a5d3-aca097d44443/download/ltc-complete-data-2016-audited.xlsx
21 https://oshpd.ca.gov/data-and-reports/submit-data/financial-reporting/#ltc-manual
53 ltc-adr-pcl-labels_2020.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/46c9e973-b549-45c1-b61e-977fc84a68e5/download/ltc-adr-pcl-labels_2020.xlsx
53 lafd_2018_audited.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/0856b659-b8dc-4f2b-a2a6-8417c3ab0935/download/lafd_2018_audited.xlsx
53 ltc-complete-data-2021-submitted-final.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/3f8d5b71-1a4e-451a-ae74-2406c968cccd/download/ltc-complete-data-2021-submitted-final.xlsx
53 lafd-1220-sub-selected.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/d8fb89b0-1f27-4333-aef9-118548ad4d3d/download/lafd-1220-sub-selected.xlsx
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/11c9744a-c9ff-479d-a44d-ee35772a083f/download/ltc-financial-pivot-2017-revised-072020_odp.xls
53 ltc-financial-trend-pivot-19-23.xls https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/023998f6-5da3-413c-bd4e-3fe16a468a6c/download/ltc-financial-trend-pivot-19-23.xls
53 ltc-complete-data-2023-submitted.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/47bb8443-b568-41c9-a53f-60a5e71347cf/download/ltc-complete-data-2023-submitted.xlsx
53 lafd-2023-sub-for-odp.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/7637fd8a-fb8a-4e06-b039-056d9f18592a/download/lafd-2023-sub-for-odp.xlsx
53 lafd1220-aud-final-to-post.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/d8fb89b0-1f27-4333-aef9-118548ad4d3d/download/lafd1220-aud-final-to-post.xlsx
53 rev-lafd-2019-aud-final-for-odp.xlsx 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
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/904acb73-31f1-4579-95a5-cd764f90337f/download/ltc-financial-pivot-2019-audited2.xls
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/4f920b00-80e4-400f-a662-4adadbc3dd8a/download/ltc-financial-pivot-2020-submitted.xls
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/62008619-aafa-4a55-ac97-7b1d7f82bb9f/download/ltcfinancialpivot2015-102017-extract.xls
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/77f333c5-7093-4cf3-b263-ecba9353347b/download/ltc-financial-pivot-2021-submitted.xls
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/904acb73-31f1-4579-95a5-cd764f90337f/download/ltc-financial-pivot-2019-audited.xls
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/3dadc8cb-0732-4c8d-95a5-e3a03af79b27/download/ltc-financial-pivot-2022-submitted.xls
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/acd71a47-592d-4a81-a84b-9e0db3a46962/download/ltcfinancialpivot2014-102017-extract.xls
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/7f09191f-cef0-4092-bcdc-8110629b14af/download/ltc-financial-pivot-2018_audited.xls
21 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. https://siera.oshpd.ca.gov/FinancialDisclosure.aspx
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/823a77f7-8dcb-42a1-8a24-1eaf77ad8d6f/download/ltc-financial-pivot-2023-submitted.xls
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/4f920b00-80e4-400f-a662-4adadbc3dd8a/download/ltc-financial-pivot-2020-audited.xls
53 ltccalendaryear2015selected.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/19133706-4b13-44b4-8f4f-8508489685c4/download/ltccalendaryear2015selected.xlsx
53 ltccalendaryear2014selected.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/ad13fc17-486e-43d8-a293-1f2bd7a300c7/download/ltccalendaryear2014selected.xlsx
53 ltc-adr-pcl-labels_2024.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/432e7056-c8d6-44b7-83af-2d0de350febf/download/ltc-adr-pcl-labels_2024.xlsx
8 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 https://data.ca.gov/datastore/dictionary_download/144136c2-dd97-458d-9a1d-cfbe12c18b67
33 data_file_documentation_selected_20242.pdf https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/27298ade-534d-422c-bba9-faea7dced649/download/data_file_documentation_selected_20242.pdf
33 ltc-adr_excel-full-db-documentation-2024-.pdf https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/dd8de80a-bb8f-48f1-98b3-61804401675f/download/ltc-adr_excel-full-db-documentation-2024-.pdf
8 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 https://data.ca.gov/datastore/dictionary_download/eb006a50-8438-47da-83ca-7c75713eb0d8
53 ltc-complete-data-2021-audited-june-2025.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/3f8d5b71-1a4e-451a-ae74-2406c968cccd/download/ltc-complete-data-2021-audited-june-2025.xlsx
53 lafd2021_audited_final_for_odp.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/57dbea9a-b916-4964-b715-3fff8d9677af/download/lafd2021_audited_final_for_odp.xlsx
8 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 https://data.ca.gov/datastore/dictionary_download/934a9539-0619-498e-a454-27fcb3d298e1
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/77f333c5-7093-4cf3-b263-ecba9353347b/download/ltc-financial-pivot-2021-audited.xls
53 ltc-complete-data-2020-audited.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/11ae3e83-775c-4fc1-9ef3-b6d405bc2b15/download/ltc-complete-data-2020-audited.xlsx
53 ltc-complete-data-2019-audited-extracted-011325.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/dcea9837-2722-40f2-8281-9aa866b0a0bb/download/ltc-complete-data-2019-audited-extracted-011325.xlsx
8 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 https://data.ca.gov/datastore/dictionary_download/421cd3e9-993a-485e-95b5-90fe3befe2ac
53 ltc-complete-data-2018-audited_april-2022.xlsx https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/a0ec28b8-d09a-4ec4-b41e-99e6edc0748d/download/ltc-complete-data-2018-audited_april-2022.xlsx
8 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 https://data.ca.gov/datastore/dictionary_download/c17b5695-af9c-4825-a6c1-8063e2b618d0
8 Data Dictionary for https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/66175fdc-02e5-4861-a84e-7eeae8a164a0/download/ltccalendaryear2013selected.xlsx https://data.ca.gov/datastore/dictionary_download/aa777b14-75b8-4120-818d-e45690392aeb
53 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. https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/7daf1d87-9bef-4988-b63d-848022672471/download/ltcfinancialpivot2013.xls
57 long-term-care-facility-disclosure-report-data-22u4yta6.zip https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/a5805aa5-6238-4e73-94e8-85c11780a527/download/long-term-care-facility-disclosure-report-data-22u4yta6.zip
57 long-term-care-facility-disclosure-report-data-uv99w0_m.zip https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/b3eb8c1f-878c-4ae3-8378-0398b307ec73/download/long-term-care-facility-disclosure-report-data-uv99w0_m.zip
57 long-term-care-facility-disclosure-report-data-w_8hzwt1.zip https://data.chhs.ca.gov/dataset/70fcfed4-c9b8-4c13-8c5f-06591261cba4/resource/2f881a1d-38f9-4f18-a3bf-1c5118c6197c/download/long-term-care-facility-disclosure-report-data-w_8hzwt1.zip

Tags

  • ltc
  • expenses
  • net-patient-revenue-by-payer-source
  • department-of-health-care-access-and-information
  • ogi
  • income-statement
  • long-term-care
  • financial

Topics

Categories