Pre-2012 Hospital Annual Financial Data - Selected Data & Pivot Tables

Description

On an annual basis (individual hospital fiscal year), individual hospitals and hospital systems report detailed facility-level data on services capacity, inpatient/outpatient utilization, patients, revenues and expenses by type and payer, balance sheet and income statement. Due to the large size of the complete dataset, a selected set of data representing a wide range of commonly used data items, has been created that can be easily managed and downloaded. The selected data file includes general hospital information, utilization data by payer, revenue data by payer, expense data by natural expense category, financial ratios, and labor information. There are two groups of data contained in this dataset: 1) Selected Data - Calendar Year: To make it easier to compare hospitals by year, hospital reports with report periods ending within a given calendar year are grouped together. The Pivot Tables for a specific calendar year are also found here. 2) Selected Data - Fiscal Year: Hospital reports with report periods ending within a given fiscal year (July-June) are grouped together.

Resources

Name Format Description Link
21 https://data.chhs.ca.gov/dataset/hospital-annual-financial-data-selected-data-pivot-tables
0 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
10 data-importing-instructions-for-excel.docx https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/34fcad07-7ef8-48b6-a586-c49d4b124d56/download/data-importing-instructions-for-excel.docx
53 cy-selected-file-hafd11revised1013.xlsx https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/f71cccc9-5927-4b1c-b9b5-ed4057014299/download/cy-selected-file-hafd11revised1013.xlsx
53 fy-selected-file-hafd1112-revised-1013.xlsx https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/8bf0b2d5-2227-4a8a-b941-70989db8ad0a/download/fy-selected-file-hafd1112-revised-1013.xlsx
53 hafd2011pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/19864eaa-e78c-40d0-9175-c12f676e2170/download/hafd2011pivot.xls
53 cy-selected-file-hafd10revised912.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/9e2449da-a03a-4743-ba1c-af4fa31fdbb7/download/cy-selected-file-hafd10revised912.xls
53 fy-selected-file-hafd1011-revised-912.xlsx https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/9e3bfac5-acc9-4e43-8f15-ef5448a2130c/download/fy-selected-file-hafd1011-revised-912.xlsx
53 hafd2010pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/e913dd01-1972-4e2c-bb93-4a07bb600d41/download/hafd2010pivot.xls
53 cy-selected-file-hafd09-revised911.xlsx https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/23ae8b1b-4700-41cf-90e6-2f86ad25b4e8/download/cy-selected-file-hafd09-revised911.xlsx
53 fy-selected-file-hafd0910-revised-911.xlsx https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/9787d182-fb5d-4048-bb29-b1d4b90dfd28/download/fy-selected-file-hafd0910-revised-911.xlsx
53 hafd2009pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/eae4947f-3db7-4f03-83cc-99d89a2b5266/download/hafd2009pivot.xls
53 cy-selected-file-hafd123108revised9-10.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/07c7b5fb-01dc-4a08-a5e4-1bb57319792c/download/cy-selected-file-hafd123108revised9-10.xls
53 fy-selected-file-hafd0809-revised-910.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/32ad7f37-3f27-42e2-91e0-39d84012bd6d/download/fy-selected-file-hafd0809-revised-910.xls
53 hafd2008pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/a8870d38-bd9a-4763-b258-5325d78d4b4e/download/hafd2008pivot.xls
53 cy-selected-file-hafd123107revised909.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/3b026828-8bf3-47b0-8d0d-b6e009060862/download/cy-selected-file-hafd123107revised909.xls
53 fy-selected-file-hafd0708-revised-909.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/43d9e2f2-a283-425d-8954-6f9cfc6d694b/download/fy-selected-file-hafd0708-revised-909.xls
53 hafd2007pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/7201f4f2-507b-4a1a-954d-aba43f1a2e9a/download/hafd2007pivot.xls
53 cy-selected-file-hafd-12-31-06revised-9-08.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/0bed9b78-9526-427c-834e-1d9ac565ea14/download/cy-selected-file-hafd-12-31-06revised-9-08.xls
53 hafd2006pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/1c15b40e-9337-4390-b4bf-68a46b9acd34/download/hafd2006pivot.xls
53 cy-selected-file-hafd12-31-05revised9-07.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/6a5f25c4-8924-467f-a959-27feda229208/download/cy-selected-file-hafd12-31-05revised9-07.xls
53 hafd2005pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/932d32b7-8056-4034-b434-eadf8f507636/download/hafd2005pivot.xls
53 cy-selected-file-hafd2004revised906.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/541bb079-5989-47a9-a05d-3d1ac42fb788/download/cy-selected-file-hafd2004revised906.xls
53 fy-selected-file-hafd0405-revised-906.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/b69f5f93-1f6e-4208-bd6f-9b46f8cbda88/download/fy-selected-file-hafd0405-revised-906.xls
53 hafd2004pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/0b6b6531-1b5a-4688-b889-7c17752601e6/download/hafd2004pivot.xls
53 cy-selected-file-hafd123103revised-905.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/a4406aff-6f13-4f1f-a7db-919d3807171b/download/cy-selected-file-hafd123103revised-905.xls
53 hafd2003pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/7f53ab64-29ec-4fa1-950f-529d73568747/download/hafd2003pivot.xls
53 cy-selected-file-hafd123102rev1004.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/1ae948ee-0142-41c5-9e39-a75c0c0a0620/download/cy-selected-file-hafd123102rev1004.xls
53 hafd2002pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/8e1f9291-a89b-4063-829d-efc8ced8e8e1/download/hafd2002pivot.xls
53 cy-selected-file-hafd2001revised-904.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/149da5cf-1c59-42bd-8504-53235aa3d02f/download/cy-selected-file-hafd2001revised-904.xls
53 fy-selected-file-hafd0102.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/a565364e-0457-4b57-9b17-440504bd324f/download/fy-selected-file-hafd0102.xls
53 hafd2001pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/8e685212-9959-4150-b3b5-725af86f7714/download/hafd2001pivot.xls
47 cy-selected-file-hafd-7199-062900-partial-year.txt https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/58f06dd2-e31b-44f8-a135-ad2400fea4cd/download/cy-selected-file-hafd-7199-062900-partial-year.txt
47 cy-selected-file-hafd-630-12312000-partial-year.txt https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/51e9a632-1828-4ea3-b141-87b25b4f1562/download/cy-selected-file-hafd-630-12312000-partial-year.txt
53 hafd2000pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/31cf99a1-5b09-48d8-bb23-b26e64cb578a/download/hafd2000pivot.xls
33 cy-selected-file-hafd9599doc-use-this-one.pdf https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/5bf5d940-fd75-4959-96a4-4c65b1db9869/download/cy-selected-file-hafd9599doc-use-this-one.pdf
33 cy-selected-file-hafd1299.pdf https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/5e6ef1d6-cd31-4a77-ae2e-969f53fa8b5d/download/cy-selected-file-hafd1299.pdf
47 cy-selected-file-hafd1299.txt https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/6e68e6fc-9ab8-4b60-a0a3-4d49a585e1f9/download/cy-selected-file-hafd1299.txt
53 hafd1999pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/5f37da14-6ce2-4ed3-a349-6d5b8f6713d3/download/hafd1999pivot.xls
47 cy-selected-file-hafd1998.txt https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/d2fab61a-db81-49e3-af83-14f00253d76e/download/cy-selected-file-hafd1998.txt
53 hafd1998pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/b59cc50c-016b-45a3-b95f-34b4dd13a3cb/download/hafd1998pivot.xls
47 cy-selected-file-hafd1997.txt https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/30906ab3-b69d-4dc4-888f-a9e06daea3fa/download/cy-selected-file-hafd1997.txt
53 hafd1997pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/6be71d83-0a2c-4698-8b33-bc69917ee4f4/download/hafd1997pivot.xls
47 cy-selected-file-hafd1996.txt https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/b41b791e-ce92-4cc0-b827-97a4a7884768/download/cy-selected-file-hafd1996.txt
53 hafd1996pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/b83c9b50-7184-4abe-8ff8-2fdc9151da53/download/hafd1996pivot.xls
47 cy-selected-file-hafd1995.txt https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/0376df45-ec98-4957-b294-d88cb2d48c33/download/cy-selected-file-hafd1995.txt
53 hafd1995pivot.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/c0c49fcd-01e2-4533-87d2-8a3ed88d6624/download/hafd1995pivot.xls
33 cy-selected-file-hafdocumentation-2000andafter.pdf https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/dce072e9-d624-4d70-b1c0-127e0a7d3b71/download/cy-selected-file-hafdocumentation-2000andafter.pdf
57 pre-2012-hospital-annual-financial-data-selected-data-pivot-tables-o8wsoik6.zip https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/c1183f1d-8b80-46fb-a562-478a18e07f94/download/pre-2012-hospital-annual-financial-data-selected-data-pivot-tables-o8wsoik6.zip
53 fy-selected-file-hafd0607-revised-908.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/8b081121-8510-434c-b240-716930b2c4eb/download/fy-selected-file-hafd0607-revised-908.xls
53 fy-selected-file-hafd0506-revised-907.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/699be01c-fad0-43f1-9457-7b5c9d81edac/download/fy-selected-file-hafd0506-revised-907.xls
53 fy-selected-file-hafd0203-revised-1004.xls https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/78f47de5-4eea-4ba7-9a3d-4fb1aeb13b37/download/fy-selected-file-hafd0203-revised-1004.xls
47 In July 2001, HCAI performed an extract of its hospital annual financial database for report periods ended January 1, 1995 through December 31, 1999, and produced updated data files which reflect all corrections made by HCAI audit staff and hospital representatives. Comparison of the previously released data files with the revised data files may not have a material effect on statewide aggregations, but may have a significant effect on the data for individual hospitals. *This documentation is applicable for the combined, five-year data file and each of the separate, one-year data files. It also applies to the selected data file which covers report periods ended July 1, 1999 to June 29, 2000. The file does not include all hospitals and represents the final annual financial data file produced in which managed care data are not reported separately. https://data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/db10e1dc-fde6-4f1d-9722-829980271f81/download/cy-selected-file-hafd9599.txt

Tags

  • fte
  • productive-hours
  • liabilities
  • expenses
  • uncompensated-care
  • alos
  • average-length-of-stay
  • department-of-health-care-access-and-information
  • discharges
  • beds
  • discharges-by-payer
  • revenue
  • ogi
  • equity
  • assets
  • hospital
  • labor
  • per-adjusted-patient-day
  • financial-ratios
  • cost-center
  • income-statement
  • net-income

Topics

Categories